search

Synthoid / ExportSheetData

Add-on for Google Sheets that allows sheets to be exported as JSON or XML.
MIT License
236 stars 46 forks source link

JSON Delete same words #84

Closed David-Grass-Feria closed 3 years ago

David-Grass-Feria commented 5 years ago

Hello sir. Thanks for your amazing plugin. When i create a json file, it will delete same words and use only one. You can see in the image which i send. This Main Section table have 17 rows. JSON give me only 9. I think it because, the same words "Title","Comp"..... Can i fix this`? gitup-json

Synthoid commented 5 years ago

JSON doesn’t support multiple fields with the same name in the same object. I would move the duplicate fields to new rows then export a sheet array. That should export your data intact.

David-Grass-Feria commented 5 years ago

Okay thanks sir. I think the best way is, i will buy your standard product first. If works, then i can update to full version. 1 Question: In which folder export your plugin the json file?

Am Samstag, 23. März 2019 schrieb Chris notifications@github.com:

JSON doesn’t support multiple fields with the same name in the same object. I would move the duplicate fields to new rows then export a sheet array. That should export your data intact.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/Synthoid/ExportSheetData/issues/84#issuecomment-475822432, or mute the thread https://github.com/notifications/unsubscribe-auth/APYYRWEHyIWgFBTsM4xMQVYJIcdhpqoZks5vZXQ6gaJpZM4cAZky .

Synthoid commented 5 years ago

Export Sheet Data is totally free. There is no trial or standard version. You have full access to its feature set by installing it.

The exported JSON file will be in the same folder as the original spreadsheet. If you do not have access to that folder on Drive, the file will instead be placed in your root Drive folder.

David-Grass-Feria commented 5 years ago

Ahh sorry sir, you are from gitup :) I think it wars a other support for the plugin hehe I fix that, i made a space before and it works. I have a other question: All fields are „input type name“. Can i change some fields with „ input type file“ ? Maby with a code before..

Am Samstag, 23. März 2019 schrieb Chris notifications@github.com:

Export Sheet Data is totally free. There is no trial or standard version. You have full access to its feature set by installing it.

The exported JSON file will be in the same folder as the original spreadsheet. If you do not have access to that folder on Drive, the file will instead be placed in your root Drive folder.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/Synthoid/ExportSheetData/issues/84#issuecomment-475823154, or mute the thread https://github.com/notifications/unsubscribe-auth/APYYRfV5dWmSQtPxFQzToC2q8JSas8z3ks5vZXX5gaJpZM4cAZky .

Synthoid commented 5 years ago

You should be able to just rename the field to “file” instead of “name” and reexport the data.

If you want some rows to have a “name” field and others to have a “file” field, you can have two fields named “name” and “file” and enable the “Ignore empty cells” option. Then just populate the appropriate fields in each row. The empty cells will not be included in the exported data for each row.

David-Grass-Feria commented 5 years ago

Chris, you are great :) I will test next day. In the future i would like automated export. If it possible, you create a script for that and i will pay for this. Let me know :)

Am Samstag, 23. März 2019 schrieb Chris notifications@github.com:

You should be able to just rename the field to “file” instead of “name” and reexport the data.

If you want some rows to have a “name” field and others to have a “file” field, you can have two fields named “name” and “file” and enable the “Ignore empty cells” option. Then just populate the appropriate fields in each row. The empty cells will not be included in the exported data for each row.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/Synthoid/ExportSheetData/issues/84#issuecomment-475825586, or mute the thread https://github.com/notifications/unsubscribe-auth/APYYRY0kRKAXwBPzBOPhc9jFu-nCTPbCks5vZXwvgaJpZM4cAZky .