hilfeKonv.html

Data conversion

Configuration is only necessary if import/export from a customer's data record format is required.

It is possible to carry out data conversion so that customer-specific files can be imported/exported. This is based on so-called "comma-separated ASCII files", which almost all databases/spreadsheets allow as import/export filters.
A conversion table is created here, from which the in-converter and the out-converter take their information for the conversion of the files.

Importing (sending) host data records through the in-converter:

1. First select field separators and text separators or enter them manually,
   e.g. "12345";"12";"123"
   ; = field separator "= text separator
   The text separator can be deactivated by entering a blank as text separator.
2. A customer file can be loaded via Host data records - Load as a test.
   If the setting of the field and text separators is correct, the data records are displayed correctly in the host data record table from field: 1 ... field: x.
   The table can be cleared again via Host data records - Remove.
3. Now the host data fields are assigned to the MP data fields.
   To do this, select a data field that is to be assigned. You can click either in a data field of the host data record table (if this is loaded), the conversion table or the MP data record table to select a field. Then a conversion dialog opens.
4. A host data field with start position and length can be assigned to an MP data field in this way. The start position indicates which position in the data field is to be the start. The length indicates how many characters from the start position onward are to be transferred to the MP data field.
   If host data records are loaded, the section of the host data field that is to be transferred to the MP data field is marked blue in the preview.
5. When the conversion dialog has been confirmed with OK, the data field in question is given a color in all 3 tables as an indication of assignment.
6. If not all the data fields marked "optional=false" in the table were assigned, a warning message is displayed indicating that in this case a conversion during importing is not permitted. The conversion at send is automatically deactivated.

Exporting (reading) MP data records through the out-converter:

1. Set the field and text separators as under point 1) above.
2. Define the assignment of host data fields to the MP data fields as in point 3) above.
   For the export process it is not absolutely necessary for all data fields marked "optional =false" to be entered. Host data fields that are not defined are output with an empty text field.
3. The setting of start position and length is irrelevant for exporting.
4. If a host data field is assigned to more than one MP data field, a warning message is displayed indicating that in this case a conversion of the data at read-out is not possible. The conversion at read-out is automatically deactivated.
5. If the Apply button in the navigation bar is pressed although an MP data field has been assigned to more than one host data field, a warning message is displayed with the data fields that still have to be defined. The conversion at read-out is automatically deactivated.

The setting which determines whether a conversion is to be carried out at Send and/or Read is defined under

File transfer - Send - Read .
Home page