Regla Getting started > Administration > File administration > Import files > File appearance and type > File appearance

Subscription entries list has to have the following field in this order:

1.Subscription category name

2.Customer id

3.Product name or product number

4.Recipient id

5.Unit price

6.Valid to date

7.Invoice entry text

8.Invoice entry quantity

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

All data that is imported to the system will go through the same error checking process as when data is entered manually into the system. Thus the same rules mentioned will be applied for all the fields.

Subscription category name must be the name of an existing subscription category.

Social security number is used as the customer’s and recipients’ ID and therefore it needs to be unique. If the customer or a recipient does not have Icelandic social security number the social security number can be maximum 20 characters digits and/or letters. The customer ID is required but the recipient is not (if recipient is not given, it will be the same as the customer).

The product will be identified by its exact product name or exact product number. Thus this field is required.

Unit price is not required but if it exists it must be a number equal to or greater than zero. If it does not exist, the system will retrieved it automatically from the existing product list.

Valid to date is not required. If it exists it must be a valid date in the future.

The invoice entry text is not required. If exists it will be used as text for invoice entries created by the subscription entry.

The invoice entry quantity is required and it must be a valid number greater than zero.

Examples of subscription entry lines:

Magazine 1;9905685829;The Magazine;;29;31.12.2013;Text;1

Magazine 1;9905675789;The Magazine;9906932979;;;Text;1