-
mikkelkingAsked on November 15, 2020 at 4:19 PM
It looks like you have changed the format of the data export. I had written code to unpack from the previous format - is there a setting for me to revert to that format?
Part of the reason for this is that the export is missing some data - previously some data was in the file as JSON (which had multiple rows). The new table export only has one row
Cheers
Mike
JSON format:
New format:
I could possibly try to parse this text, but a comma in the data will throw it out. Please help me here
-
Vanessa_TReplied on November 15, 2020 at 9:44 PM
I assume this is the form you are referring to, https://form.jotform.com/202254489320048. I tried to download your submissions both in Excel and CSV and both in the old Submissions page and the new Tables page but was not able to replicate the JSON format.
Can you please explain in detail where are you exporting the data? Please share a screencast/screenshot whenever possible.
How-to-Post-Screenshots-to-Our-Support-System (Note: Email Attachment Is Not Supported)
-
mikkelkingReplied on November 18, 2020 at 12:19 AM
Yes, the form is correct
The above images are screenshots (from Excel) illustrating the problem. In previous times (like a week or two ago), my downloaded XLSX file included responses that were in JSON format, but rendered as a text string. Excel doesn't know how to handle this, so it just displays it as a string. I wrote some code to unpack this data, and it was fine.
There is a new feature in your system, Tables, which is new, and has changed the way data is exported to Excel
This week I did a download of the XLSX file again, and noticed that the export format has changed. Instead of the JSON format, it now provides the data as a kind of CSV, but the problem is, the users have typed commas into their responses, so the CSV format doesn't work, as the data doesn't get split properly.
-
Vanessa_TReplied on November 18, 2020 at 1:52 AM
As mentioned previously, I actually also tried to download using the old Submissions page and in which case, I was not able to get the JSON format you have shown, as such, I cannot attribute that the issue is on the new Tables page.
Nevertheless, since I also could not recall if the Configurable List's data was exported in JSON format previously, I have forwarded this to our backend team for confirmation as well as to ask them if it will be possible to make it JSON encoded again.
Please note that we cannot guarantee any timeframe for tickets sent to our backend team, however, rest assured you will be notified here once we get any update.