WHAT IT'S USED FOR:
Element/Text is a column that takes one of two options depending on what you entered in the Data Type column.
oIf the Data Type field is 'Imported' then this field requires an 'element' – which means you enter the column heading from your import spreadsheet.
oIf your Data Type is 'Static Text' then this field requires the common text to be entered into the field in Vernon CMS. (Text may be written text, a date, or a System ID for an Authority Term.)
Data Type |
Element/Text |
|
Imported |
Element |
Select Imported when you are importing data into a Vernon CMS field from your spreadsheet. Enter the column heading from your import spreadsheet into the Element field exactly as it appears in your spreadsheet (you can cut and paste into this field). |
Static Text |
Text |
Select Static Text if you have data that is the same for all of your Import records, for example – if all records being imported belong to the same Department, or have the same Accession Date. All Static Text data entered in the Element/Text field must be entered between quotes. This enables you to include spaces in your data. For example, if you want to add a note to a text field you can include spaces, e.g. " Record altered via XML Import".
If importing Static Text into an Authority Controlled field, use the System ID of the appropriate term to ensure an exact match. For example, if the System ID of the Department is 1, this can be specified in the Element/Text field as "1" (including the quotes). You can use Static Text to clear data from single-valued fields. To clear a field, enter "%EMPTY%" in the Element/Text field and select Replace in the Replace/Append field. Note that this option can not be used on multi-value fields. |
Advanced XML
XML elements consist of a start tag and an end tag. They may contain text, comments, or other elements. Specify here the element containing text that you wish to import. If there are multiple instances of the same element you can further qualify it (if you wish) with an attribute. Note that the name of the element must appear exactly as it does in the XML i.e. the spelling must be the same. If the element appears as follows:
<family_name>Knight</family_name>
The Element filler should be specified as family_name (including the underscore).
WHERE TO FIND IT:
The Field Mapping page of the XML Import Configuration Window.
HOW TO USE IT:
Element/Text is a text field. Just key in data, or copy it into the field from another source.
