Create a load file
Files that are to be imported into RamBase must have comma separated value (CSV) format. The first row of the file is header information. These values must be in upper case letters. The rest of the file consists of records that will be imported. Semicolon (;) must be used as data separator in both the header row and in the data rows. There are no requirements regarding the order of the columns.
Example:
ACCOUNT;ST;NAME
100001;4;Hatteland Computer AS
100002;4;The Hatteland Group AS
See separate topics for each archive, where possible fields to be loaded are listed and explained.
Important information regarding creation of load files
The fields within a load file must be separated with semicolons.
Make sure that all dates are written in the format yyyy.mm.dd (Example: 2015.04.29)
Use full stop (.) as a decimal separator (Example: 3.14)
Do not use thousand separator (1000, not 1 000)
Phone numbers and fax numbers can only contain numbers, and +. (Example: +4712345678, not (+47) 123 45 678)
E-mail addresses must be valid.
EXTID (former identification) has to be unique within one archive.
If there is a text in a field that contains a semicolon, the text must be a quoted string (Example: "123test;101")
There must not be any blank spaces before or after a value in a field.
When loading custom fields, "UDF_" must be added at the beginning of the value. (Example: For a custom field called TestField, UDF_TestField must be used as column header.)