Export database as csv not containing the correct json data

💬 App Building
1

  • Goal: Exporting a table in the database as csv to reimport into the staging environment is not possible. The reason is that json data exported from the table resolves a an: -> t
    in the export and not the json data is actually in the cell. t -> stands for true in the csv export. Importing the data into staging database the gives me an json error since the json is an string with the value -> t and not the actually json data.

  • Steps: Go to the database. Klikk the arrow down on the table and and export CSV. The table needs to have json data in it. Reimport the data back into the staging database with the same schema as the production database.

2

Have not tested this out myself, but did you try getting that data into a table in the app and then downloading it from there? You have an option of selecting JSON and CSV from there.

3

Yes that works,I have exported json data from an table before. The bug is related to the database export.

4

Thanks for reporting this bug @Christian_Ostrem! I was able to repro it and log it internally. I'll be in touch with any updates.

5

This should be fixed in one our upcoming releases. Please let me know if you're still seeing this issue!

6

I am getting this issue yet.
I just tried export table data to csv. But the json value is empty.
How can I solve this?

7

Hello @Luan_Nascimento,

Can you share a screenshot of the table with the export script and the CSV?

Not sure why that isn't working as it looks like the the ticket was finished. Potentially might be due to a delay in the update to our live cloud version of the app.

Are you self hosted or on the cloud?

8

It's solved with new release. Now I can export the JSON data correctly.

1 Like
9

Great to hear the new updated solved the issue!

For anyone self hosted you should update to the current version of 3.182.0 and for cloud users you should be all set :+1: