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 ).