JSON to CSV converter

[wellemut]

Usecase

In order to Test FairSync with new Databases, which REST-APIs are not yet implemented in FairSync (dont have a Mapper yet) I need to convert the the Data, which I get as Json file, into CSV, where I am able to rename colums, add values and missing colums (short description, copyright...) and bring it to the standanard-format to import in FairSync

Example-Data workshops.json

Solution

• Microsoft excel is the easiest and most powerful quickfix-solution to get json into csv: https://superuser.com/questions/1772379/how-to-import-json-data-into-excel-columns thanks @qknight
• Also this creates acceptable results, similar to excel: https://data.page/json/csv creates too many lines. one entry has as many lines as it has hashtags.
• https://konklone.io/json/ creates too many colums (each hashtag has one colum)
• Our Final goal would be to be able to directly import json files and define it in mappers.

Others solutions work less

• https://www.convertcsv.com/json-to-csv.htm
• https://csvjson.com/json2csv (does not delete json commands)
• https://yourgpt.ai/tools/json-to-csv

Much Better solution

_

du solltest am besten die DB IDs erhalten und die daten dann via REST interface ziehen
und auf keinen fall via CSV oder json
also wenn es um partnerprojekte wie we-change geht
imoprts sind ok, wenn eine stadt z.b. dir eine liste an laeden gibt oder so

_

• -> REST Anbindung programmieren! Build API-Json Fetcher (first manual) #55