<< Click to Display Table of Contents >> Navigation:  General > Import data

The function Import can be started from the Bookkeeping menu.

Comma separated files and Excel files can be imported.

 

User rights

A user needs the proper rights to execute an import.

Import rights can be given per import type.

Some import types require additional rights, similar to those needed for the corresponding screens.

 

Location import file

Select at "Location import file" the file that needs to be imported.

Only the first sheet of an Excel file will be used for import data.

The left-screen will show the first line of the import file.

All column values found in this line are displayed in rows.

 

Type of import

Mill7 has different kinds of import:

- Assets

- Balance codes

- Cases

- Chart of accounts

- Companies and Persons

- Cost centres

- Exchange rates

- Investors        

- Journal entries

- Participants

- Portfolio stock

- Portfolio stock rates

- Portfolio transactions

- Rename chart of accounts

- Table codes

- Time registrations

- Users

 

Depending on the type of import, specific Mill7 fields will appear.

These fields can be assigned to a field in the import file by pressing the "<<" button.

A Mill7 field that is assigned will disappear from the list of available fields.

By using the ">>" button the assignment of a field will be removed and the field will become available again.

All settings made in this screen are saved per import type for future imports.

 

Import data

The result will be displayed in the second tab page "Importdata" after pressing button "Next".

Here, the decimal sign and date format used in the import file can be set.

Default, the decimal sign and date format follows the Windows settings.

 

For some import types additional settings can be made:

 

Exchange rates:

Besides the date format and decimal sign, the date and reference currency must be set.

 

Portfolio transactions:

Before making the proposal it is necessary to connect the transactions codes used in the import with a Mill7 code. This can be done in the same way as assigning the import fields to a Mill7 field.

The value in the Mill7 field Bookkeeping should be equal to the company name in Maintenance > Company data.

 

Portfolio stock rates:

Besides the date format and decimal sign, the date of all rates must be set.

 

Proposal import

After making the correct setting, the result is displayed in the Proposal import tab by pressing the Next button.

Possible errors in the data will be mentioned in the status column.

If an import line in the proposal contains value "OK", the line can be imported in Mill7.

 

An Excel report of the proposal screen can be created by using the Print button.