Contact Support


    Area Import

    Information on the requirements for the Area Import in RMS.

    Import Information

    • Categories must be setup or imported in RMS prior to attempting an Area import.
    • 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.


    Field Order

    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 50 Area / 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)
    13 Spare1 Alpha Numeric N N 100 Area Spare Field
    14 Spare2 Alpha Numeric N N 20 Area Spare Field
    15 Spare3 Alpha Numeric N N 20 Area Spare Field
    16 Spare4 Alpha Numeric N N 20 Area Spare Field
    17 Spare5 Alpha Numeric N N 20 Area Spare Field
    18 Spare6 Alpha Numeric N N 20 Area Spare Field
    19 Spare7 Alpha Numeric N N 20 Area Spare Field
    20 Spare8 Alpha Numeric N N 20 Area Spare Field
    21 Spare9 Alpha Numeric N N 20 Area Spare Field
    22 Spare10 Alpha Numeric N N 20 Area Spare Field
    23 Client Description Alpha Numeric N N 50 Area Client Description
    24 Max Occupancy Numeric N N 7 Max Area Occupancy

     

    Sample File

    Area Import.csv

    Was this article helpful?

    Send Feedback

    Can’t find what you’re looking for?

    Contact Support