Home > Importing Data > Attribute Linking Import

Attribute Linking Import

 

Overview

This file allows existing attributes to be linked to existing areas using a standard Comma Delimited file.

 

You must be able to provide a CSV file in the format as indicated below. It may be necessary to seek technical advice in order to create your file in the format that RMS requires.

 

Sample File - In Progress

Important InformationEdit section

  • To link Areas and Attributes using this method, they both must exist in RMS.
  • Areas can be imported using the Area/Room Import.
  • Attributes must be configured manually using RMS.
  • The file to be imported must be in a comma delimited CSV format.
  • The name of the file must be attributes.csv
  • Microsoft Excel is able to save using a CSV format that should match these requirements.
  • The fields within this file must not contain commas
  • RMS is able to determine whether the first record is a header record or not, thus it is not necessary to strip the header record (field names) prior to the import

Field Order - All fields must not contain commasEdit section

Order Field Name Field Type Required Unique Max Charaters RMS Equivalent
1 Area Alpha Numeric Y N 50 Exact Area Name (in RMS)
2 Attribute Alpha Numeric Y N 50 Exact Attribute Name (in RMS)
You must to post a comment.
Last modified
20:18, 17 Oct 2014

Tags

Classifications

This page has no classifications.
For support assistance with this article, click once on the Live Support image below
 
btn_LS_on.png