This is a script which imports content into Plone. it reads json files which represent exported content and zexps.
Unfortunately the sample files are from a private project so I need to find a way to sanitize that data.
The json format is from a "collective.jsonify" export.
So we have decided to use serializer and deserializer for content import and export in zope architect.
Prior experience and a working helper script with Serializers/Deserializers would be highly appreciated.
Also I'm exploring about "Json to CSV conversion". Suggest some good libraries and ideas to start with.
So you have a way of serializing the content, meaning the content gets exported as serialized JSON.
The challenge is with taking that serialized JSON and importing it back into a site. Or to put it another way, the deserializing is the missing link for getting imports working.
I was just summarizing by saying what your current problem relates to..... "suitable import code".
plone.restapi serializer serializes single content objects into JSON, JSON can be read into Python dictionary with built-in json module, Python dictionary can be written into a CSV with built-in csv library (also StringIO is needed to write CSV into a memory instead of a real file):