Last modified by Admin on 2022/04/04 00:07

<
From version < 5.1 >
edited by Anca Luca
on 2018/02/25 12:30
To version < 6.1 >
edited by Anca Luca
on 2018/02/25 13:24
>
Change comment: There is no comment for this version

Summary

Details

ExtensionCode.ExtensionClass[0]
Description
... ... @@ -1,1 +1,26 @@
1 -Application to exports a list of documents from the wiki to a spreadsheet format (currently csv but other formats could be added). The list of documents and the columns of the spreadsheet to export are customizable and the columns can be read from document objects.
1 +The application allows to export documents from a wiki to a Spreadsheet format, including the attachments of the documents. In version 1.0 only CSV format is available.
2 +
3 +After installation, go to DocumentsExporter.WebHome page in order to find and use the tool. Note that, by default, view rights on this space are only given to the XWikiAdminGroup, so that only admins can access the tool by default.
4 +
5 +The documents to export are configured using a [[HQL request>>Extension.Query Module]], while the columns to export are a comma separated list of columns in the following format:
6 +
7 +* doc.<fieldname> represent metadata of the document itself (e.g. doc.content, doc.title, doc.author),
8 +* <classname>:<fieldname> represent fields of the specified class,
9 +* <fieldname> represent fields from any class in the document (the value in the first object that has a property with the specified fieldname will be exported).
10 +
11 +For example, to configure the export of all the blog articles, this configuration could be used:
12 +
13 +[[[[image:Selection_041.png||style="border: 1px solid black;"]]>>attach:Selection_041.png]]
14 +
15 +Clicking on "export" will export a zip with one ##export.csv## file containing one line per exported document and folders with the attachments of the exported documents, one for each line having attachments.
16 +
17 +[[[[image:Selection_042.png||style="border: 1px solid black;"]]>>attach:Selection_042.png]]
18 +
19 +Note that the previsualisation of the results does not display the full result as exported but only //the list of documents that would be exported//.
20 +
21 +The export.csv file will contain, for each exported field, 2 columns: the display value and the value stored in the database (for properties for which the display is scripted this can be important). Also, for all the large string properties (textareas or document content), both stored value (in wiki syntax) and rendered value (in XHTML) will be exported. This option can be configured on the export screen. Values of multivalued properties will be concatenated using the separator configured in the export configuration.
22 +The separator used for the csv is ##,## (comma) and the text delimiter is the ##"## (double quote).
23 +
24 +[[[[image:Selection_043.png||style="border: 1px solid black;"]]>>attach:Selection_043.png]]
25 +
26 +Export configurations can be stored and reused, the index of all stored configurations is displayed on the homepage of the application in DocumentsExporter.WebHome.

Get Connected