Are you having trouble with the xlsx? Or the CSV?
Edit: can you provide an example? A typo of field in your form, that causes errors on the export? Because I’ve just tried a textarea field, and entered both <return>’s and semi-colons. And both work like they are supposed to. As an XLSX and as a CSV. I had my doubts about the CSV, but it actually renders that out perfectly.
-
This reply was modified 7 years, 7 months ago by
Doeke Norg. Reason: asking for more info
Thanks Doeke.
I extract in csv. After the carriage return or semicolon in the extraction, the data is in the next column.
The CSV fields are split by a comma (,) and not a semi-colon. So that should be happening. Are you importing the csv into excel?
Also, the fields values are wrapped within double quotes (“) to prevent leakage to the next column.
An example:
"Field 1","Field 2", "Field 3"
"Name; 1", "Name;
2", "Name 3"
If you save this as a CSV, It contains 2 rows, even though there is a return in there.
The example above is how the plugin should be exporting the data.
But please don’t import a CSV to Excel, as Excel is notoriously incapable of handling CSV’s. Just download the .xlsx. It should be better 🙂 I’ve tried importing to Google Drive, and just used the “Automatic” selection, and that works as expected.
perfect, I’m waiting for the hosting to enable the xlsx extraction library.
Another thing, how come in all the extractions (different form) I have the first 5 empty lines?:-(
Even if I create new forms
thank’s!
Not sure. They shouldn’t. And as I just tested with a new form, there’s only a row for the field names.
Do you have any hooks that interact with the plugin? Or are you using just Gravity Forms with the plugin out of the box?
Maybe some other plugin is interfering. Could be loads of things to be honest. But out of the box this doesn’t happen.
I hope your hosting provider enables the needed stuff soon, so you can enjoy the xlsx file 🙂 (What library are you missing, just out of curiosity?
Hello! sorry for the long absence 🙁
Xlsx files always give me problems opening and I asked the administrator of the server (I’m in local) to check php-zip to see if so we solve. Do you say I’m resolving? In the meantime, can I try anything else?
When I open the file it tells me that the format is not valid.
Thank you and good day
Hi @paolonuzzi86,
I resolved the issue because of inactivity for more than a week, and because the original question was ‘resolved’ or not really an issue.
I had someone else last week who had the same problem, but the solution also was server related, and not plugin related. He solved his issue, but couldn’t tell me what is was.
I’m sorry I can’t do more. It can be loads of things to be honest, but if it’s server related I really can’t help.
Hope you get this resolved server side, and if you have a solution; please let me know!
