Exporting records

Using the export feature introduced in edu-sharing 5.0, records of any type can be exported as CSV or JSON files for different search queries.

The CSV format is best suited for analysis, e.g. for diagrams, because it can be imported by common spreadsheet programs.

The JSON format is recommended if other software or programs want to further process the data.

In CSV files, a loss of information may occur in multi-value fields, which does not occur in JSON due to the element structure.

Performing an export

To create an export, log in as system administrator and switch to the admin tools. Then select the Browser option.
Here you will find an option "Download as file" in addition to the possibility to export the data as a list.

After selecting the option, further setting options appear.

In order to make the start easier, we have provided examples of typical exports in the area below.

Examples

Export of all objects of the system including basic metadata

Lucene-Query

CODE

TYPE:"ccm:io"

Properties

CODE

parent::cm:name
cm:name
cclom:title
cm:creator
cm:created
cm:modifier
cm:modified
cclom:general_keyword

Export of all created contents of a special user (e.g. for information)

Lucene-Query

CODE

@cm\:creator:"admin" OR @cm\:modifier:"admin"

Properties

CODE

sys:node-uuid
cm:name
cclom:title
cm:creator
cm:created
cm:modifier
cm:modified
cclom:general_keyword
ccm:comment_content
ccm:collection_feedback_data

Export of all tagged contents (In Collections) of a special user (e.g. for information)

Lucene

CODE

ASPECT:"ccm:collection_io_reference" AND (@cm\:creator:"admin" OR @cm\:modifier:"admin")

Properties

CODE

parent::cm:title
cm:name
cclom:title
cm:creator
cm:created

Export of all comments written so far including their authors and the respective object names

Lucene-Query

CODE

TYPE:"ccm:comment"

Properties

CODE

parent::cm:name
cm:creator
cm:created
ccm:comment_content

Export of submitted collection feedback including the respective collection names

Because collection feedback is a configurable set of options, only one JSON object is returned as feedback.

Lucene-Query

CODE

TYPE:"ccm:collection_feedback"

Properties

CODE

parent::cm:title
cm:creator
cm:created
ccm:collection_feedback_data