This function is only of use to those persons wanting to read files arising from the ADONIX ENTERPRISE V3™ import module, or to write files destined for the same module: the import/export formats used by this module are different to those used by Sage X3, therefore this is a coding translation function that is used to describe the correspondence between an Sage X3 import/export template and a V3 template, but also to give the default values to fill the fields that are not present in the original template.

The organization of the ADONIX ENTREPRISE V3 import/export template is identical to that of Sage X3 when a single level of information is present in the template, and in this case, the import setup serves essentially to define the correspondences. On the other hand, the ADONIX ENTREPRISE V3 header/line template can be described by the following organizational structure:

Field groups (header table)

 

Line field groups (first line)

Line field groups (2nd line)

...

Line field groups (Nth line)

SL

Logic separator

LS

 

Field groups (header table)

 

...

 

 

 

 

 

 

 

 

 

 

This organizational structure is founded on the fact that a header is followed by the lines repeated up to the end of the record, defined by a logic separator (frequently, this is a group of characters ***), used to re-write either a new header record or a second level detail line group.

On the other hand in the Sage X3 template, the data group organization is defined with the help of mandatory group identifiers once more that one level of records exists:

Header identifier

Field groups (header table)

 

Line identifier

Line fields (1st line)

...

Line identifier

Line fields (Nth line)

LS

Header identifier

Field groups (header table)

 

...

 

 

 

 

 

 

 

 

 

 

In addition, in ADONIX ENTERPRISE, certain templates (in particular the entries template) only have lines and do not have a header (the header information being repeated). In this case, it is necessary in order that the Sage X3 template can be used, to define on which fields to make the break (in this case, the document number: when it changes, the entry is changed).

The V3 import setup is used in this way to define the code translations between the V3 and X3 templates. These transcriptions are used to read a data file created with a V3 template, then to re-write it in such a fashion that it can be read by the X3 import template.

The V3 import function is then used to translate the filed by basing them on a template of this type.

Prerequisites

See also Refer to documentation Implementation

Screen management

Header

Defined in the header tab are a code, a title description and an Active flag in the form of a checkbox.

Code (field CODE)

Used to identify the conversion rules to allow the import of an export file generated under Adonix ENTERPRISE v3.
Description (field INTIT)

Use this field to assign a description to each record.
Active (field ENAFLG)

Select this check box to activate the current record.

Disabled records keep their content and setup but cannot be used by recalling their code:

  • On other records such as documents and settings
  • On mass processes

The authorizations for a given function can prohibit the creation of an active record. In this case, the check box is disabled by default. It can only be modified by an authorized user or through a signature workflow.

Tab General

This tab is used to define the general setups for the transfer and describes the structure of the data sets to transcode.

Once the code of the import-export template is entered, the various groups of data found in the final export template are displayed in the grid Break.

It is important to define a break field number associated with these groups (only the last group does not require one). In fact this is used to write on which field the record break is made, when a single record defines the input of several line levels. This is the case for the ADONIX FINANCE V3 entries for example. Indeed, in the entries template, the header information is repeated on all the lines, and it is necessary, to specify the level (1 to N) in which the document number field is found so that the split can be made between the different documents. From this, the distribution of header and line information is defined simply by their level, a break in the field as well as the identifier defining when moving to the next document.

When the information is organized in a header and line in the same way as the V3 input template and the X3 output template, the break field can normally be taken as the first. The break will be defined in the second page by entering the group separator used in the V3 template at the separator '/' level of the X3 import template.

Block number 1

Import/export templates (field MODELE)

Indicate the code of the template Export-importation x3. The file v3 will be converted in order to be able to be imported by this template.

File to convert

field TYPV3
File to convert (field FILV3)

Used to indicate the path for the v3 file that must be converted to the x3 format.
File format (field CODDBA)

Destination file

field TYPX3
Destination file (field FILX3)

Used to indicate the path for the file converted in to the X3 format that can be imported by the standard import template.

Grid Break

Code (field FLGREC)

Code identifying the current group in the import-export template.
Level (field FLGLEV)

Overlapping of the current group in the import-export template.
Table (field FLGFIL)

The name of the table corresponding to the current group of data in the import-export template.
Break field (field FLGV3)

Indicate the number of the line of the report template which makes it possible to make the out of stock one if a record v3 corresponds to several Company level.

Example: Under FIRM v3, the file WRITINGS contains at the same time information of header and lines. In X3, the template of standard importation of the entries, distinguishes a level for the header and another for the lines. It will thus be necessary to indicate the number of the field PART of the report template to make it possible to distinguish the header and the number from field NUMECT for the lines.

In the case of the conversion of a template on several levels, the last level is regarded as that of the detail and this field is empty. Under Adonix UNDERTAKEN, this level is generally marked by "***".

Tab Lines

Displayed in this tab, for the X3 template fields, is the corresponding V3 template field number, not forgetting:

The numbers starting with 1 and reference the start of a data group

  • If a header and line structure in V3 corresponds with an identical structure in X3, the characters that make up the separator for a data group must be defined (in general, its "***") next to the "/" character placed at the header of the group, and numbering must be restarted from 1.
  • it is possible to make conditional the fact that a field is taken into account. This is done thanks to the condition column, which is used, if it is verified, to cause the transfer of the source field to the target field. It will be seen that the current field value is found in a variable named VALUE, which is always alphanumeric.
  • it is also possible to define a default value for the field, in the appropriate column. This value can make reference to a field currently being imported (VALUE variable). For example, if this VALUE field contains at the start a number with two decimals, but without separators, it is possible to transcode this amount by dividing it by 100, using the initialization formula val(VALUE)/100.

In this way, for example, imagine that the V3 export template is composed of a header and lines separated by the 3 *** characters, and that the X3 template is composed of a group named E, level 1 and group L, level 2. Imagine that the V3 file header fields named A,B,C must be taken in the order B,C, followed by a field containing the date, and field A, and that the E, F, G fields are picked up in the order E, G, F, G being multiplied by 100. The following grid is obtained in the General tab,

Code

Level 

Table

Break field

E

1

Header table

1

L

2

Line table

 

The Lines tab displays the following data:

Code

File 

Field

Comment

V3 field

Condition

Initialization

E

Header table

/

 

 

 

 

E

Header table

B

B field

2

 

 

E

Header table

C

C field

3

 

 

E

Header table

D

D field

 

 

date$

E

Header table

A

A field

1

 

 

L

Line table

/

 

***

 

 

L

Line table

E

E field

1

 

 

L

Line table

G

G field

3

 

val(VALUE)*100

L

Line table

F

F field

2

 

 

Grid Fields

Code (field TYP)

Define the code for the X3 import template group.
File (field FIL)

Define the table involved in the X3 import.
Field (field FLD)

Define the first involved by the X3 import.
Comment (field COM)

Title associated with the previous code.
Field no. (field ZON)
Condition (field COND)

If the condition is not verified, the field will be empty.

In the case of the import of entries with analysis, the filling of the fields SEC(0) to SEC(9) which correspond to the analytical dimensions necessitate the utilisation of the axis number field and it is necessary to use the syntax X=Y, where X is the field number.

Example :

1 CODSEC = dimension code.

2 AMOUNT

3 QTY

4 TYPSEC = axis number.

5 NUMECT = entry number.

6 NUMLIG = Line number of general entry.

In the X3 conversion template,

GACCENTRYA ANALIG.

GACCENTRYA CCE(0) 1 serves to recuperate the contents of the field CODSEC v3 4=1 (*).

GACCENTRYA CCE(1) 1 serves to recuperate the contents of the field CODSEC v3 4=2 (**).

GACCENTRYA CCE(2) 1 serves to recuperate the contents of the field CODSEC v3 4=3 (***).

GACCENTRYA QTY 3 serves to recuperate the contents of the field QTY v3 4=1 (*).

GACCENTRYA AMTCUR 2 serves to recuperate the contents of the field MONTANT v3.

* when the field 4 (typsec) = 1, it is recuperated in CCE (0).

** when the field 4 (typsec) = 2, it is recuperated in CCE (1).

*** when the field 4 (typsec) = 3, it is recuperated in CCE (2).
Initialization (field INIT)

Indicate a value or expression as the default value for this field.

Mandatory field (field OBLIG)
Table number (field NUMTAB)

Specific Buttons

Execution

Used to execute a transcoding of the V3 import.

This button is used to copy the record definition from or to another folder.

Block number 1

field OBJET
field CLES

Block number 2

From folder (field DOSORG)

Use this field to define the folder from which the record will be copied. The possible syntaxes are described in the Dedicated appendix.
All folders (field TOUDOS)

Use this option to copy the record to all the folders defined in the dictionary (ADOSSIER table of the current solution).
To folder (field DOSDES)

Use this field to define the folder to which the record will be copied. The possible syntaxes are described in the Dedicated appendix.