<< Click to Display Table of Contents >> Navigation:  Regla Getting started > Administration > File administration > Import files > File appearance and type > File appearance > Customers

The customer list needs to have the following fields in this order:

1.Customer no.

2.Name

3.Address

4.Zip code

5.City

6.Country

7.Phone

8.Cell phone

9.Email

10.Discount

11.Invoice in email (0=no/1=yes)

12.Email for invoices

13.Payment manner (1-8) (see here). If you would like to register with payment manner 7, first you need to register claim settings under Sales> Admin>Claims settings (Please refer to Sales Manual for more details)

 

 

The system allows the first line of the file to contain column titles if the corresponding checkbox is checked.

 

All data imported into the system goes through the same error checking process. It works as the data is entered manually into the system. Therefore, the same rules mentioned apply for all the fields.

 

Social security number is used as the customer’s ID and therefore it needs to be unique.

If the customer does not have Icelandic social security number the social security number can be maximum 20 characters digits and/or letters.

 

The zip code needs to be an Icelandic one that contains three digits.  If the address is non-Icelandic the zip code should be 999.  List of valid zip codes is given in chapter 12.3.1.

 

City is not mandatory except the address is non-Icelandic. It is always recommended to include the city in any cases.

 

It is important that the country is correct, since the system will use Iceland as the country if the country given is not recognized.  A list of all countries the system recognizes is given in the country chapter.

 

The entered email address needs to be a valid one (i.e. id, @ sign and domain), for example, regla@regla.is.

 

Discount needs to be a digit between 0 and 100.

 

Example of a customer line:

 

 9912345678;Jón Jónsson;Milligata 11;Dúfnahólar 11;101;Reykjavík;Ísland;5555555;5555554;regla@regla.is;10;1;regla2@regla.is;NM;4

 9912345678;Jón Jónsson;Milligata 11;;101;Reykjavík;Ísland;5555555;5555554;regla@regla.is;10;1;regla2@regla.is;;4;