Export to Excel does not work correctly

HRZ_UniBi · Mar 17th, 2011, 12:17 AM

Hello!

I have currently running Formtools 2.0.5 with export manager 1.0.3.

1.) When I select "Excel" as output format, I don't get an Excel file, but the created file contains only a HTML-formatted table.
2.) CSV export is not visible/selectable
3.) German Umlauts are destroyed. Typically they are entered in the forms as letters and correctly stored in the database as letters. When exporting they are exported in the wrong encoding.

Is there a small incompatibility with 2.0.5?

With regards,

Peter.

lukeadamis · Apr 16th, 2011, 1:12 PM

I am having the same issue. Is this a bug? Or can we do something about it?

Thanks,
Luke

godt09 · (This post was last modified: Apr 17th, 2011, 5:24 PM by godt09.)

This may or may not be related, but when I export as csv, I get a .htm file, although xls exports OK, or indicates it is an xls file, which I can open. But when I try to import that xls file into Google docs, it is an invalid file.

I'm getting an error file generated in the /export manager directory which throws up this error, apparently when I try to export:

PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_sqlite.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_sqlite.so: undefined symbol: sqlite3_libversion in Unknown on line 0

Is this informative?

godt09 · (This post was last modified: Apr 17th, 2011, 7:54 PM by godt09.)

Deleted the module, removed the files, uploaded fresh copy, and same result. csv file exports as .htm. xls file somehow invalid.

HRZ_UniBi · Apr 17th, 2011, 10:56 PM

Hello!

Thanks, for the information, that I'm not alone with my problem. That doesn't help at the moment, but it show me, that I'm not a complete idiot... ;-)

With regards,

Peter.

godt09 · Apr 18th, 2011, 6:15 PM

Doing a bit of poking around with this error message: my server people ask me this:

"With FormTools, is there options with regards to the logging method? I believe when it is on debug/lower level logs, it will pickup the PHP warning, (which is a bug between sqlite and later of version of PHP, even if the module itself is working)."

Nothing in config.php. Where else to look?

godt09 · May 4th, 2011, 9:27 PM

I exported a form submission as csv, which is where I get an .htm file. Renamed it as .csv and it opens Ok as a spreadsheet. This is clearly a different issue to opening an xls file though.

joomlacreative · May 4th, 2011, 9:37 PM

Why don't you change the extension CSV to xls or xlsx when save it on your desktop or any other folder.

godt09 · May 5th, 2011, 2:24 AM

(May 4th, 2011, 9:37 PM)joomlacreative Wrote: Why don't you change the extension CSV to xls or xlsx when save it on your desktop or any other folder.

Yes. You are right. I'm looking to do both though. Trying to cover a range of user experience, whilst minimising hand holding/support. I'd also like to export an html file, rather than display it. Going to have to delve into Smarty.

HRZ_UniBi · Aug 19th, 2011, 5:58 AM

Hello!

One other problem is, that CSV means comma separated values but Excel has difficulties with importing/accepting files with comma as separator. A great idea would be to have a chance to modify this (i.e. to set it to semicolon, which is good for Excel). Alternatively OpenOffice/LibreOffice works really good with the files, but has also problem when finding a separator as field text, because it's not surround by quotes.

To solve my problem for most of the users, I told them to use HTML-Export (which is in fact almost the same as Excel - just look into the files) and import this into Excel or LibreOffice.

With regards,

Peter.

P.S.: When I have a little bit of time (and silence around me) I'll go to 2.1.x and see what's with the export there...

FORUMS