The data-import module allows you to import the bookkeeping data using a CSV (komma-separated values) or a Microsoft Excel file. If it's an Excel file, it is an advantage if the data is contained in a table. It isn't mandatory but it simplifies the selection of the fields.
The imported bookkeeping data is stored in the database for usage when analysis reports are generated.
The import modules works with data-import templates: these are definitions of previous data imports that have been saved for future usage. A data-import template contains the field definitions of an import file format.
This means that a template that was created for a specific file import format will only work with files in that same format.
Most of the time, you'll create the import definition the first time and the re-use it as a template for all later imports.
The import module is presented as a wizard with different steps:
In the first step, you can select a previously stored template or create a new template. Select the template (if there is one) in the top selection list or type a name for the new template in the textbox below the selection list.
This step only matters if you're importing a CSV file or an Excel file where the data isn't contained in a table. There are 2 settings:
Upload the file for analysis: the file data is not imported in this step. Rather, it is analysed to extract the column headers that will be used in the next step.
The file is temporarily stored on the server, ready for import once the last step is completed.
In this step, you'll have to indicate in which column the import routine can find it's data in the data file. An asterisk (*) indicates the mandatory fields.
These are the fields that can be imported:
In this step you can choose to store the current import definition as a template, so that you can re-use it for later imports.
Click finish to start the import.
Once imported, you can download the imported transactions via the Bookkeeping > Transactions menu option.