Home › Forums › Quform WordPress › Form export problem
- This topic has 6 replies, 2 voices, and was last updated 8 years, 11 months ago by tomputor.
- AuthorPosts
- April 1, 2015 at 9:51 pm #14835tomputorParticipant
I have a text area on a form for invoice information. User enter the information using the enter key for newlines. This breaks the csv. This is clearly visible when you open the csv file in notepad!
As a possible solution I installed the Quform Excel export plugin, but this results in an error opening the export in Excel. (did unblock)
Attached are both the csv and xls export files
Attachments:
You must be logged in to view attached files.April 2, 2015 at 10:34 am #14845AllySupport StaffYou don't have permission to view this content. Please log in or register and then verify your purchases to gain access.
April 17, 2015 at 1:42 pm #15037tomputorParticipantNot working using the import wizard with UTF-8, comma and double qutes settings. When I open the csv file in notepad I clearly see that newline characters are present. Lines of data are scattered over multiple lines if the user used the enter key while inputting text in a text area field.
I see the same thing happening when opening the export in excel before importing. There is no way Excel will read this file correctly because the convert text to data works per line.
I open end the csv file in notepad++ and did a search and replace all ‘/r/n’
to one space and the file imports correctly into Excel.Since it is my client who makes the exports for following up event registrations, I need this to work without manipulating the csv after export. Can you direct me to the place where I can add something like str_replace(‘/r/n’,’ ‘,$linetoexport);
Regards,
TomApril 20, 2015 at 2:52 pm #15062AllySupport StaffYou don't have permission to view this content. Please log in or register and then verify your purchases to gain access.
April 20, 2015 at 6:50 pm #15068tomputorParticipantHi Ally,
I changed the code and it works fine!
How can I make this stick when updating?Regards,
TomApril 21, 2015 at 2:41 pm #15086AllySupport StaffYou don't have permission to view this content. Please log in or register and then verify your purchases to gain access.
April 27, 2015 at 1:36 pm #15155tomputorParticipantWorked!
- AuthorPosts
- You must be logged in to reply to this topic.