Custom Views Import
Custom Views can be imported into Xurrent using UTF-8 or UTF-16LE encoded comma-separated values (CSV) or tab-separated values (TSV) files.
The following columns can be included in a Custom Views import file:
- ID
- Source
- Source ID
- Disabled
- Name
- Reference
- Record Type
- State
- Search Phrase
- Search Fields
- Metadata Fields
- Filters
CSV Example
"ID",Source,Source ID,Disabled,Name,Reference,Record Type,State,Search Phrase,Search Fields,Metadata Fields,Filters
,,,0,T-Codes,t_codes,CustomCollectionElement,,,"",reference;#SAP System,"custom_collection|transaction_codes|0
#SAP System|sap_co;sap_bi|0"
,4me,123456,0,Printers,printers,Ci,active,laserjet,label;name;systemID;assetID;serial_nr;site_location,status;supplier,product|153|0
Notes on Syntax
- Fields in the “Search Fields” and “Metadata Fields” columns are separated using
;
. - Custom fields are referenced by their
name
attribute, starting with a#
, for example#SAP Systems
. - If a custom view has multiple filters in the “Filters” column, these filters are separated using line breaks.
- Each filter in the “Filters” column is 1 line composed of
<name>|<value>|<negated>
. Here:- If it is a custom filter, the
<name>
of the custom filter is prefixed with a#
, for example#SAP System
. - If the filter
<value>
has multiple elements, these are separated using;
. - If the filter
<value>
elements are references to records, these are represented using the unique value of these records, as explained in Relating to Another Record.- In the special case that the unique value of a record starts with
$
, the unique value is prefixed with an extra$
.
- In the special case that the unique value of a record starts with
<negated>
indicates whether the filter is negated (is versus is not) and has the value 0 (is) or 1 (is not).
- If it is a custom filter, the