Forums

Backup table

hcharris 27 Jan, 2012
I love this extension and this is in no way a criticism. I offer it in the hope that others will benefit and that it helps the developer.

I created a form with one table where users could enter data. I wanted to download the data and use it as input to a Word mailmerge.

I tried the download in both formats: csv and Excel. In both cases, some rows were corrupted. I was able to find that in the corrupted rows, the user had pressed the "Enter" key several times. Removing those "Enters" cleaned up the file for those rows.

As a workaround, I used the SQL2Excel extension by Joomla-R-Us to download the same table. It worked without the corruption.

As I said, I still think this is a great extension. I have gotten used to the navigation in V4 and I bought the book for the previous version. Thank you for a great extension.
GreyHead 27 Jan, 2012
Hi hcharris,

Just for clarity, you are posting in the CFv4 forum but I think you are talking about CFv3? CFv4 doesn't have an Excel export - only CSV. It also has settings for optional separators and quotes which may get round this problem.

Bob
hcharris 27 Jan, 2012
Thanks, Bob. You are correct about the versions. I am actually running both on different websites. Right now I need a break ... things are beginning to run together.
This topic is locked and no more replies can be posted.