Home > Importing Data > Category Import

Category Import

Overview

This file allows the import of Categories 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 - categories.csv

Important InformationEdit section

  • The file to be imported must be in a comma delimited CSV format.
  • The name of the file must be categories.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 Characters RMS Equivalent
1 ShortDesc Alpha Numeric Y Y 50 Short Description
2 LongDesc Alpha Numeric N N 4000 Long Description
3 GLCode Alpha Numeric N N 30 G/L Acc Code
4 Property Name Alpha Numeric Y N 50 Property Name

 

You must to post a comment.
Last modified
09:33, 15 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