Import file for customer data
Customer data can be imported to the NetSim database via an ASCII file in a fixt format.
All data belonging to a customer (a record in the import file) is given in one and the same row, and all fields have to be separated by the character ¤ (ASCII character no. 164).
Every record (row) must contain 29 fields. If the last field Memo and the field separator ¤ are omitted between the 24th and the 25th field, the value 0 is recorded in the Memo field. The fields must be entered in the sequence shown in Figure 1 below. There must be a value in fields marked NOT NULL. Other fields can be left blank.
In fields with data type VARCHAR2, alphanumeric text strings can be entered with a maximum number of characters as stated in ( ). In fields with data type NUMBER, only numerical characters can be entered with a maximum number of characters as stated in ( ). NUMBER(15,3) means that 15 digits can be entered in the field, of which 3 are decimals. NUMBER(2) means that figures between 0 and 99 will be accepted. See also section Input data in general below.
Example, Figure 1:
2250¤12250¤ACME AB¤Kv Bofinken 4¤Trastvägen 3, Solna¤2250¤LA102¤LA102¤1¤22¤7¤37¤1700¤2007-09-02¤256¤1.222¤191¤0¤3368¤0¤50¤46¤0¤0¤New customer¤¤¤¤¤
Import customer data to NetSim databas
Update nodes with consumption from customer data
Customer data field description
Summing of customer data to node