GDV-VU

This adapter can be used to read and convert data in GDV text format.

Two options are available.

Conversion of files in GDV ASCII format to XML files
Conversion of XML files to files in GDV ASCII format

In addition, the adapter can be used to adjust the date fields and the decimal number fields in the GDV file.

Date fields

GDV date fields can be 8, 6, 4 or 2 characters long and are converted to an ISO date format by the adapter as follows:

	GDV format	ISO format	Example		Note
8	12102022	TT-MM-JJJJ	12102022	12-01-2022	Even incomplete dates like 00002008 are converted to the appropriate format 00-00-2008.
6	092022	MM-JJJJ	092022	09-2022
4	1022	MM-JJ	1022	10-22022	Even incomplete dates like 0000 are converted to the corresponding format 00-00.
2	14	TT	14	14

Note:

When converting XML to GDV format, the data in ISO format is adapted to the length of the GDV field. If the date in ISO format is longer than the GDV field, the date will be shortened. For example, if an ISO date 2022-03-24 is converted to a GDV field with a length of 4 characters, a date 0322 is inserted and the days of the original format are ignored.

Decimal number fields

GDV decimal number fields consist of the length of the total number and the number of decimal places. This means, for example, that when converted to XML format, a number field with length "4" and two decimal places becomes 54.34.

Number of decimal places	GDV content	Converted value
4, 3	1000	1.000
6, 5	001000	0.01000
4, 2	1200	12.00
1, 0	1	1
2, 0	01	1
4, 0	1234	1234
7, 7	1234567	0.1234567

Note

When converting XML to GDV format, the numbers are adapted to the length of the GDV field. If a field in XML format is shorter than the length defined for the GDV field, the numbers are supplemented with preceding blanks.

Properties

Operation

Determines which operation the adapter executes

Possible values:

GDV to XML: Converts the GDV data into an XML format.
XML to GDV: Converts the XML data into a GDV format.
Get supported sets: Displays all available "sets" of the selected GDV format.

Parameters

formattedXmlValues

Defines the formatting of the date and number fields during import/export

Possible values:

Active: All GDV numbers and date fields are adapted as described. GDV_Date will be converted to an ISO date. GDV-NumField is converted to an integer or decimal number as defined in the data type.
Inactive: Data in the target document is taken over as in the source document, which means that the data in the XML document must already be in GDV format.

trimXmlValues

Defines whether spaces are deleted before or after the output value. Which spaces are deleted depends on the alignment. This does not apply when an XML file is imported.

Possible values:

Active: Blank spaces in the output values are deleted. The deletion of the blanks depends on the set alignment - this means that only those blanks are deleted which are on the undefined side (unaligned).
Inactive: The blank spaces are left in the output file.

createHeaderFooter

Defines whether a header and footer are created in the output file with the values <Vorsatz> and <Nachsatz>.

Possible values:

Active: Vorsatz and Nachsatz are created in the XML or GDV file.
Inactive: The elements Vorsatz and Nachsatz are not created in the XML or GDV file.

gdvVersion

Defines with which GDV version the data will be imported/exported. Displays the selected GDV version

Possible values:

2009 – GDV-Version 2009
2013 – GDV-Version 2013
2015 – GDV-Version 2015
2018 – GDV-Version 2018

Status values

`1`	The operation was executed successfully.
`-1`	The operation failed due to a technical error.

Output

Depending on the selected adapter operation, an XML document or a GDV document is output.

The XML to GDV operation generates a GDV file if the input data is correct.

If the input data is incorrect, an XML file with errors is output.