Custom Views Import

Custom Views can be imported into R-Service 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"
,R-Service,123456,0,Printers,printers,Ci,active,laserjet,label;name;systemID;assetID;serial_nr;site_location,status;supplier,product|153|0

download CSV

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 $.
- <negated> indicates whether the filter is negated (is versus is not) and has the value 0 (is) or 1 (is not).