File Import

Importing Files

The er can be used to manually import files. It can be customized, but as standard it can read a simple Article Master Data csv files, which can be stored from for example Excel and to import standard SHARK XML files.

Open from the main menu Files -> Import.

Import File

Step 1 - Open the File Importer

Step 2 - Choose a file to import

Step 3 - Choose the format of the file

Select from the list of file mappings.

There is one predefined mapping, this is Master Data with 2 columns defined:

  1. Article Number
  2. Article Description

Configure Your Own Importer

It is possible to configure your own importer. For a full configuration, it requires some knowledge of the database, but existing mappings can relative easy be modified.

Example

Example of a file mapping from a CSV file.

Here the parameter “FileName” is replaced by the current name of the imported file (%FileName%).

The “ItemCount” is read from column 17 of the CSV file (starting from 1).

“OrderTypeID” is set to a fixed value “302” and not read from the file.

Modify an existing Importer

Column Mapping

Possible values in the mapping table:

Parameter Description
%LineNumber%  
%Id%  
%FileName% The current file name.