When exporting data from MetaLocator, the system creates a single CSV file which can be opened in Excel or similar database programs. Occasionally it can be helpful to customize the column names and ordering to align with an external system.
When exporting data, a list of Formats is available. These formats are a collection of Field Mapping Rules which instruct MetaLocator how to assemble the export file.
To create a custom export format, a Field Mapping Rules must be created for each column in the desired custom export spreadsheet.
Managing Field Mapping Rules
Click Citations, then Field Mapping as shown below:
Click New in the upper right toolbar to create a new rule. One rule must be created for each field (column) in the resulting export file.
The field mapping form is shown below:
- Label: This is the label that will be used for the column name in the resulting export file.
- System Field: This is the MetaLocator field that will be included in the column as the value for each row.
- Description: This field is for notes and does not affect the output.
- Provider: This is the name of the export format as shown in the drop-down list of available formats shown on the export screen above. The provider name must be exactly the same for each field in a custom format. For example, use "Custom" for the provider name for each field in your custom format.
- Start Hours Only: If the data follows the MetaLocator structured hours format, check this box to extract only the opening hours from the value found in the System Field selected. The System Field in this case should always be an hours-type field.
- End Hours Only: If the data follows the MetaLocator structured hours format, check this box to extract only the closing hours from the value found in the System Field selected. The System Field in this case should always be an hours-type field.
- Weekday: Select the weekday which should be selected when outputting hours data. The System Field in this case should always be an hours-type field.
- Ordering: The numerical ordering of the field in the resulting export file. The first field in the export spreadsheet should have ordering set to 1, the second 2 and so forth.