First, thanks for continuing to support TablePress! It’s a great plugin.
I have an application I’m building for a client, who will be maintaining a table containing a bunch of text (that includes single quotes, double quotes and other special characters). They’ll be maintaining it in Excel, and periodically uploading it to WordPress, replacing the current table with an updated one.
I originally started building this app in WP-Tables Reloaded, and the CSV file I was using seemed to load fine. Now, with TablePress, it bombs routinely. The only application seems to create the proper escape sequences is if I load the spreadsheet file into MySql, and export to CSV for Excel. However, I’ve tried creating CSV files using the following other permutations, none of which work with my data file:
— Microsoft Excel 2003 on XP
— Microsoft Excel 2007 on Windows 7
— Open Office 3.3 on Windows 7
— Microsoft Excel 2008 on Mac
The client is a non-profit with old computers: still running Windows XP and Excel 2003. Ideally, I’m hoping you can make that combo work. I’m happy to send you samples of files from all of these spreadsheet systems that bomb TablePress (as well as the one that’s OK) if you’d like.
- The topic ‘Problems parsing CSV file’ is closed to new replies.