Imports of items, customers and suppliers in our software.

Via the main menu, in the Administration group, click on Imports

You can import external data into the tables:

* Suppliers
* Customers
* Items

This is to save you valuable time if you had a description of your data in another format.

Warning! If the import instructions defined in the support are not strictly adhered to, you could have an inconsistent database, see unusable!

This tool comes only in order to save you time recopying an existing database, please still devote the time necessary for its proper functioning.

The import will be from a flat file text or CSV.

You are free to choose the field separator (for csv files it is the semicolon (;) for text files it is often a tab).

You may also specify the decimal separator used and indicate if the file contains a title line (it should try to avoid import).

The easiest way is to start with an Excel file (or open office calc), or are you paste content into the notepad, or you save the file in CSV format.

You do not have to move all the columns in your file, but specify no column in the import window next to the respective areas. Always it is possible to reposition the initial column values by clicking on the button 'reinitialize ".

* Select the table you want to fill with the data in your file by selecting the appropriate tab (items, suppliers, customers)
* Check "Skip the first line" if it contains the column headings, to avoid import
* Select the column separator (; for CSV, tab or other)
* Select the decimal separator
* Enter the column numbers corresponding to values in your file, if the information is not in your file, type 0
* Click on "import".

The data required, optional, controlled or generated automatically follow the same rules as when creating manual, see the relevant chapters for more details.