Metadata File Settings 


SPListX will create metadata files based on the following options given below.

1.

The Metadata File Settings step appears as shown below:

2.

Specify the Metadata file location using the options below:

a.     Store metadata file(s) in this location: Specify a folder path where the selected list items metadata are to be exported. You can also Click browse ('...') button to launch folder browser dialog.

b.    Store metadata file(s) in the respective list / library folder location in the file system: - This option will export the metadata file in the selected file format into the respective list folder locations where the physical documents/ files are exported.

Note: Ensure that the user context used to run the SPListX export process has sufficient permissions to create, edit and delete folders and files in the specified export path.

3.

Specify the Metadata file options using the options below:

a.     Create a metadata file for each list/library: This option will export the metadata for the entire list/library in a single file.

b.    Create metadata file for each list item/file: This option will export separate metadata file for each list item or file.

4.

When you select Create a metadata file for each list/library option, SPListX creates the metadata file using the List name.

To create a unique metadata file name, click the (...) button placed next to the metadata file name textbox. Metadata file name dialog appears as shown below:

Construct metadata file name with the available built-in macros provided in the dialog. Click OK to close the dialog. The file name will be created in the name format / syntax entered in the dialog.

5.

When you select Create metadata file for each list item/file option, SPListX creates the metadata file using the Item name.

To create a unique metadata file name, click the (...) button placed next to the metadata file name textbox. Metadata file name dialog appears as shown below:

Construct metadata file name with the available built-in macros provided in the dialog. Click OK to close the dialog. The file name will be created in the name format / syntax entered in the dialog.

* Note: ViewName macro is applicable only for View based export. SPListX will substitute the name of the processed view wherever applicable.

In view based export,

For list / library entries and for files / folders within them, it appends the view name.

For file / folder entries provided for export, it appends "All Items" instead of the view name.

e.g., List of features in SPListX_All Items.xlsx

6.

Specify the Metadata file format using the options below:

a.    CSV

b.     XSLX

c.     XML*

d.    XML with DTD*

7.

If the metadata file already exists in the destination location, choose from any one of the following options:

a.    Overwrite: This option will overwrite the existing metadata file.

b.     Append: This option will append the new metadata to the existing metadata file. The new metadata will be shown in the new sheet with the name of current timestamp in XLSX file.

8.

You can specify a new metadata custom format based on the column name when generating the metadata file. The format specified here overrides the application level template defined in Metadata Format Template tool. Also, you can specify new column names to use when generating the metadata file in the file system location. To use this feature, click the Edit button. A Customize Metadata Format Dialog appears as shown below:

9.

Specify SharePoint column name in the Column Name textbox and select its type from the available Column Type from combo box. Click button to load the available fields. Select format from the available fields. If you want to rename the SharePoint column name when exporting to the metadata file, provide a new name in the New Column Name text box. For example, a SharePoint column named 'Area' in the source SharePoint list can be customized and renamed as 'Location' when creating the metadata file during the export operation.

 

Click to add the SharePoint column name and its format in the custom metadata format list.

Click to remove the SharePoint column name from the custom metadata format list.

 

10.

Click Next to proceed.


* Note:

XML file format

SPListX generates an XML file using the name format / syntax in the metadata file name in the stated metadata file location with the metadata information.

XML with DTD

SPListX uses Document Type Definition (DTD) syntax to define the document structure of the XML metadata file. This declaration has been introduced primarily to support large XML metadata files, minimize memory footprint when working with large XML files and improve metadata file throughput. XML metadata files are split into multiple text files and stored in a folder location that is constructed using the name in the metadata file name. An XML file is created using the metadata filename specified by the user in the stated metadata file location. When you click the XML file, the text files in the folder are re-grouped using the DTD file to form a single XML file.