The Import data application makes it possible to import data to the system from other environments and previous system versions. Regarding activities related to the production process, it allows importing bills of resources. Data may be imported through the following file formats: XML, CSV, XLS.

The application is composed of:

• Header – it allows the user to adjust basic import settings
• Work pane – it makes it possible to select specific attributes for an import operation

Header

The application header contains the following buttons:

• [..] → [New…] – it allows initiating a new data import operation
• [..] → [Duplicate] – it allows duplicating an existing import operation
• [Export XML schema] – it exports an import schema in the XML format
• [Export WSDL schema] – it exports an import schema in the WSDL format
• [Import data] – it runs a data import operation

The Import data dialog window allows the user to define import settings.

Parameters tab

On this tab, the user can define an import source and specify the action in case of an error.

Batch settings tab

On this tab, the user can define import process data. In the Processing queue required field, it is necessary to select a task processing queue.

Fields available in the application header:

• Filter – it makes it possible to select data to be imported. In the case of production resources, it is necessary to select the filter:
  • PRODUCTIONPLAN
• Business entity (non-editable) – it is assigned automatically after the filter is selected: cisag.app.production.obj.ProductionPlan
• Language setting – it determines the number of languages of imported data:
  • Monolingual – it stores imported descriptions in a single language By default, it is the language of the user interface.
  • Multilingual – it imports descriptions in multiple languages.
• Transformation file – it is a transformation standard file for XLST files (which converts and transforms documents). If it is not specified, transformation is not carried out during an import operation.
• Authorization to be used – it defines the requirement to have relevant authorizations when using a defined filter:
  • Not necessary – authorizations are not required
  • Mandatory – authorizations are required
• Data recipient – it saves in the operation log the import recipient data entered in the dialog window
• Inteded use – it saves in the operation log the aim of a given operation entered in the dialog window
• Description – it is an additional filter name, used to facilitate searching
• Database (non-editable) – a database to which data is imported. The system always imports data to the database to which the user is currently logged in.
• Time format:
  • Compact form – time data in the source file is encoded in a way that is compatible with the system
  • Normalized form – time data in the imported file is broken down into components (date, time, time zone) and presented in a composite manner
• Import processing (non-editable):
  • Generic – import through the generic function for entities without a defined controller
  • Through controller – import for entities with a defined controller, i.e. a data processing type

Work pane

The work pane makes it possible to select attributes to be imported.

Data import process

In order to import data, it is necessary to:

• Click the [..] button
• The dialog window Find: Business entities and parts will be displayed
• In the Name field, it is necessary to enter the following values:
  • For bills of resources – ProductionPlan
• Accept the entry with the [Accept] button
• By default, the filter described above should display
• Select filter attributes. At this stage, if necessary, it is possible to adjust required import attributes. More information may be found in the article Import item characteristic classifications.
• Select the [Import data] button available in the standard toolbar. The Import data dialog window will open.
• Once data in the dialog window is defined, accept it with the [In batch] button that initiates the data import operation.