Import kits

Application Import data allows for importing selected data from the system knowledge store, for example as an .xml file, with the use of a service called Business Integration Service (BIS). Such data can be exported from the system to a file with the use of Export data application, and then, after applying changes, imported to the same or another (e.g., newer) system.

This article contains procedures for using the Import data application in the context of the data regarding kits.

General information

In the Comarch ERP Enterprise system, kits allow for combining items.

There are two types of data exchange:

  • data exchange between existing Comarch ERP Enterprise systems
  • data import from an earlier system version to its newer version

This article contains information regarding the process of importing kits from a previous system version. Detailed description of data exchange between the Comarch ERP Enterprise system can be found in documents Import data and Export data.

[Indicator] If the user is not sure about which format is suitable for the import file, the best solution is to use the application for creating an exemplary kit and export that kit in required format and with required template attributes. Such exemplary file can be used as a template for generated import files.[/indicator]

The conditions that must be fulfilled when importing country data and procedures regarding the work with the Import data application are presented in the following chapters:

  • Data import
  • Attributes necessary for the import

Data import

Preconditions:

  • availability of filter for business object: cisag.app.general.obj.Kit, which contains attributes to export.
  • the user must possess a file previously exported from another Comarch ERP Enterprise environment

To import kit data, it is necessary to:

1. Open Import data application.

2. In the identification pane of the application, in the Filter filed, with the use of the [Value assistant] button, select KIT filter (business entity: cisag.app.general.obj.Kit)

Note
If in the filters searched by the user, the system does not found required business object, then, with the use of [Search] button, in the docked window, it is necessary to search the given area and then save the filter as a new one.However, it must be remembered that the set of available filters does not contain all business units, but only part of them as predefined values. Other business units must be searched and saved as a new filter.

3. In the work pane, predefined attributes to be imported are selected. At this stage, it is possible to mark additional attributes.

4. Click on the [Import data] button on the standard toolbar.  Batch application Import data is opened.

5. In the Import data application, it is necessary to:

  • in Source file field, select the source file which is supposed to be imported and from the system knowledge store it is necessary to:
    • select the file type. The following file extensions are available:
      • XML (*.xml)
      • Comma separated values (*.csv)
      • UNICODE text (*.xls)
      • JSON (*.json)
  • select processing queue in the Batch settings tab 
  • configure processing settings at own discretion, e.g., define system’s behavior in case of an error or change application server

6. Click on the [In batch] button.

Attributes necessary for the import

To import a file from a previous system version, it is necessary to define at least the following attributes for each business entity:

  • identification attributes (business key)

[Indicator] Business key is the attribute number for the Kit object. Main key is the technical identifier (specified as GUID), generated automatically during the import. [/indicator]

  • mandatory fields

Below, a table with attributes can be found:

Attribute/Relation Description Notes
OrganizationalUnit Organization Optional
Item Item Mandatory, alternatively, through an item line it is also possible to specify Guid
type Structure Optional, default value: Variable
priceDetermination Price determination Optional, default value: Components
printComponents Components printout on external documents Optional, default value: False

Attributes related to components belonging to kits:

Attribute/Relation Description Notes
sequence Numeration Mandatory, must be greater than 0
Item Item Mandatory, can be also specified through Guid
quantity Quantity Mandatory, must be greater than 0
validFrom Valid from Optional, default value: current date
validUntil Valid until Optional, default value: maximal system date
Example

Example of import file in XML format for a kit with two components:

<?xml version=”1.0″ encoding=”UTF-8″?>

<semiramis xmlns=”com.cisag.app.general.obj.Kit”

xsi:schemaLocation=”com.cisag.app.general.obj.Kit Kit.xsd”

created=”2005-12-12T14:28:07.983Z” locale=”en-USXMLSchemaCompliant”

xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance”>

 <Kit xmlns=”com.cisag.app.general.obj.Kit”>

 <Item>KITITEM</Item>

 <Details>

 <Item>10010</Item>

 <quantity>10.000000</quantity>

 <sequence>10</sequence>

 </Details>

 <Details>

 <Item>10020</Item>

 <quantity>20.000000</quantity>

 <sequence>20</sequence>

 </Details>

 </Kit>

</semiramis>

Example

Example of a file in XML format with all handled attributes:

<?xml version=”1.0″ encoding=”UTF-8″?>

<semiramis xmlns=”com.cisag.app.general.obj.Kit”

xsi:schemaLocation=”com.cisag.app.general.obj.Kit Kit.xsd”

created=”2005-12-12T14:28:07.983Z” locale=”en-USXMLSchemaCompliant”

xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance”>

 <Kit xmlns=”com.cisag.app.general.obj.Kit”>

 <OrganizationalUnit>SALORG</OrganizationalUnit>

 <Item>KITITEM</Item>

 <type>VARIABLE</type>

 <priceDetermination>COMPONENTS</priceDetermination>

 <printComponents>true</printComponents>

 <Details>

 <Item>10010</Item>

 <quantity>10.000000</quantity>

 <sequence>10</sequence>

 <validFrom>2005-11-30T23:00:00.000Z</validFrom>

 <validUntil>2005-12-31T23:00:00.000Z</validUntil>

 </Details>

 <Details>

 <Item>10020</Item>

 <quantity>20.000000</quantity>

 <sequence>20</sequence>

 <validFrom>2005-09-20T22:00:00.000Z</validFrom>

 <validUntil>4712-12-31T00:00:00.000Z</validUntil>

 </Details>

 </Kit>

</semiramis>

 

Czy ten artykuł był pomocny?