Home > Importing Data > Area/Room Import

Area/Room Import

 

Overview

This file allows the import of Areas or Rooms from a standard Comma Delimited file into the RMS system.

 

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 - areas.csv

Important InformationEdit section

  • Areas can only be imported after Categories have been imported or manually configured in RMS.
  • The file to be imported must be in a comma delimited CSV format (Field Delimiter).
  • If a data field within this file contain commas, it should be surrounded with "double quotes" (Text Delimiter).
  • Microsoft Excel is able to save using a CSV format that should match these requirements.
  • 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 Category Alpha Numeric Y N 50 Exact Category Name (in RMS)
2 Name Alpha Numeric Y Y 25 Room / Site Code or Name
3 LongDescription Alpha Numeric N N Unlimited Long Description
4 Length Numeric N N 7 Length
5 Width Numeric N N 7 Width
6 Addr1 Alpha Numeric N N 50 Address Line 1
7 Addr2 Alpha Numeric N N 50 Address Line 2
8 Addr3 Alpha Numeric N N 50 Address Line 3
9 Town Alpha Numeric N N 50 Town
10 State Alpha Numeric N N 20 State
11 PostCode Alpha Numeric N N 15 Postcode 
12 StatsEnabled Yes/No Field N N 1 Statistics (On by default)

Once the Areas have been imported you may also wish to review the following pages to add additional information:

Attribute Linking Import

RV Length Linking Import

RV Type Linking Import

You must to post a comment.
Last modified
11:35, 17 Dec 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