Export Files with Metadata

lukbut · January 12, 2016, 4:27pm

I need to export files stored in Plone, including the metadata which was assigned to them, for them to be used in a separate CMS. Can anyone recommend a technique or program to achieve this?

I was using Enfold Desktop to access the Plone file system to attempt to export the files, but the volume of metadata is too large to consider manually migrating it.

zopyx · January 12, 2016, 4:44pm

Here is some example code for getting an idea how to access Plone content for the purpose of an migration export.

github.com

zopyx/zopyx.plone.migration/blob/master/zopyx/plone/migration/exporter.py

################################################################
# Poor men's Plone export
# (C) 2013, ZOPYX Ltd, D-72074 Tuebingen
################################################################

###############################################################################
# The purpose of this export script is to export AT-based content
# into a more generic format that can be used by an importer script
# for re-import into a Plone 4 site.
#
# Usage:
# bin/instance run exporter.py --path /path/to/<plone_id>--output <directory>
#
# The exporter will create a self-contained directory with the exported
# data unter <directory>/<plone_id>. The directory will contain
# two INI files contents.ini and structure.ini  that describe
# the hierarchy structure of the exported site and exported contents.
# The metadata and real content of each object is stored within the
# content subfolder. This directory will contain on file per exported
# content object. The filename is determined by the original UID

This file has been truncated. show original

Possibly you can do the same using Transmogrifier...or you write a custom script using plone.api yourself (perform a catalog search for 'File', get hold of the related File object and use the Archetypes field API for getting hold of binary data and metadata (my script is doing the same).

-aj

agitator · January 13, 2016, 9:03am

Have you had a look at https://pypi.python.org/pypi/collective.jsonify?
With that, you get a JSON representation of each content object with all the metadata.

lukbut · January 23, 2016, 3:17pm

Thanks for the tip - I'm very new to Plone; any chance you can tell me where I should place this code and how I can invoke it to run on the Plone implementation?

lukbut · January 23, 2016, 3:18pm

Thanks, I'm trying this out. I'll let you know how I get on. I need to migrate all the content to SharePoint, so I will need to design some sort of script which parses this JSON representation of these files into SharePoint friendly format. Do you know of any scripts which can be used for this purpose?

zopyx · January 23, 2016, 3:31pm

may help you to interact with Sharepoint over the broken-by-design SOAP API.

-aj

zopyx · January 23, 2016, 3:32pm

Also check out the Sharepoint REST API

https://msdn.microsoft.com/en-us/library/office/jj860569.aspx

-aj