I've magaed to download and get the links set up and can see all the tables from my Joomla database with this tool. Unfortunately when I drag the tables over they are all empty. Have double checked all the tables and they are all working but nothing in the excel add in.

Anyone else have issues with Joomla?

Hi

Seems like that issue is related to Excel in general (not something that is caused by the addin as such) when working with MYSQL datetime data type. I use the addin against the MYSQL Joomla database a good bit and there should be no issues (except that it is slow but that is being fixed..).

The tables have data but the problem field data type is causing the query to fail (and shows up as 0 records...). If a table does not have any fields of the DateTime type you should be able to query them without any workaround. Also, if you just dont include the fields of the datetime type in your query - you wont need a workaround.


Basically, if you try to import datatime format from MYSQL directly into excel there is a problem.

To get around it you need to CONVERT the fields involved.

Here is an example that works against the joomla modules table..

This query will return 0 records

Code:

Select jos_modules.checked_out_time From jos_modules

This is the same query with a CAST To get around the problem with the Datetime data type. In this example, the checked out time is converted to DATE. If you wanted both the DATE And TIME - you could use CHAR as a workaround..

Code:

Select Cast(jos_modules.checked_out_time As DATE) From jos_modules

Please let me know if this makes sense. Also, as an FYI, this is the same behaviour if you build your own VBA macros etc to work against MSQL. Please let me know how it goes. Thanks, Al

Hiya everyone.

FYI, there is a better example of this situation on the new site

http://www.sqldrill.com/excel/sql/969172-sql-query.html#post3455247

Thanks
Al