|
<< Click to Display Table of Contents >> Navigation: General > Import data |
The function Import can be started from the Bookkeeping menu.
Excel files and CSV files can be imported.
User rights
A user needs the proper rights to perform 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.
For Excel files with multiple sheets, select the sheet containing the data.
The left side of the screen will display the contents of the first data row as import fields.
Expect to see the column headers when they are included in the file, and otherwise, values that must be imported.
Type of import
Mill7 has different kinds of import.
- Assets
- Cases
- Users
Depending on the type of import, specific Mill7 fields will appear on the right.
Available Mill7 fields can be assigned to import fields by pressing the "<<" button.
On assigning, a Mill7 field will disappear from the available fields list.
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
After pressing the Next button, the result will be displayed on the second tab called Importdata.
Here, the decimal sign and the date format used in the import file can be set.
By default, the decimal sign and date format follows the Windows user 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 transaction codes used in the import with a Mill7 code.
This can be done in the same manner as assigning the import fields to Mill7 fields.
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 for 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.