Please enable JavaScript to view this site.

The XML Cross Reference Details are generated when you Import your XML file. If you have used 5=View then you will only be able to view these details but if you have used 9=Work with XML then you will be able to configure the XML Cross References you wish to use in your print program. XML elements that have already been configured will have their XML Element details highlighted in the list.

How it Works

Output can be grouped by Label and is printed in Label order so if you want address information at the top start your label with “A”. Note: The combination of Label and Field/Key must be unique.

When writing the information to the spooled file the Field/Key entries will be used as the Headings for the data. All of the Headings (prefixed *H) for a Label will be written out for each line before the Details (prefixed *D) are written. If you don’t want Headings to be printed for a Line then enter an “N” in the Prt H (Print Heading) on ANY of the entries and no heading will be printed. You may only want headings for Loop lines say. Note: If the Field/Key is greater in length than the Field Length then it will be truncated to the Field Length.

The Label Line and Position entries are for you to specify where, within your Label, you wish to output the data on the spooled file. The Line number is relative to the Label so each Label output will start at Line 1. If you start at Line 2 then a Blank line (prefixed *B) will be written, before Line 2, to the spooled file; or you could miss out a line i.e. 1, 2, 3, 5, 6 and a Blank line will be written before Line 5. Blank lines will only be written at Detail level NOT Header. Note: These entries can only be left blank if you are specifying a Record Flag of ‘C’ = Complete/Close entry or an ‘F’ = First line of new Document and then this information will not be output to the spooled file. If no ‘C’ or ‘F’ is specified then these both default to 1. Label Position is the start position, on the selected Line, for the data on the spooled file.

The Field Length entry is the actual length of the OUTPUT field that you want to be output. In this way it is possible to right justify the numeric entries, which are left justified in the XML. Note: At present it is up to you to make sure that your data doesn’t overlap on the final spooled file i.e. no validation on the maintenance program.

The Record Flag is used in a couple of ways:

1.For XML files that contain information for more than one Document (i.e. several Invoices, Orders in one XML) then you need to have a record Flag set to an ‘F’ to denote the First line of a new Document. This ‘F’ can only appear once and must occur before any other Labels in your XML. Note: If your XML only ever contains one Document then no F entry is required.

2.For elements that appear more than once in the XML (like a Loop in CPPD) then you should have record Flag set to a ‘C’ for Complete/Close in order that the program knows that this is the last entry before the repeat. Note: For elements that only appear once then this is not required.

If you want to right justify numeric entries then you need to specify a number of Decimals, even if it is only 0. You can also change the number of decimals, i.e. if your input has 2 but you only want 1 then you can specify 1. Currently the numeric data is written out using EDTCDE = ‘L’ (Decimal point and - sign). Make sure you have a field length long enough to cater for the edited output. Note: Headings for numeric fields will also be right justified.

Find...

You can use this function to search through the XML Elements for a particular string. Enter the string and then press F16=Find to search the XML. If a match is found the cursor will be positioned to the first instance and all matches will be highlighted with the XML Element entry positioned to show the match.

Options

Select one of the following options:

5=View XML Element

View the entire XML element.

Entries

Ref

This is the unique internal Cross Reference that has been generated for the XML Element.

Label ID

If you wish to print the value of an XML element then you must give it a Label ID. You may use the same Label ID more than once but the combination of Label ID and Field/Key must be unique. If you had several XML elements containing say the Invoice Address details then you would use the same Label ID for each Cross Reference but a different Field/Key. Note: Output is sorted by Label ID. See Examples below for details.

Field/Key

Enter a unique Key for a Label ID. This information will be output as a Heading for your data unless suppressed by entering an 'N' in the Prt H entry.

F/C (Record Flag)

The Record Flag is used in a couple of ways:

1.For XML files that contain information for more than one Document (i.e. several Invoices, Orders in one XML) then you need to have a record Flag set to an ‘F’ to denote the First line of a new Document. This ‘F’ can only appear once and must occur before any other Labels in your XML. Note: If your XML only ever contains one Document then no F entry is required.

2.For elements that appear more than once in the XML (like a Loop in CPPD) then you should have record Flag set to a ‘C’ for Complete/Close in order that the program knows that this is the last entry before the repeat. Note: For elements that only appear once then this is not required.

Label Lin

The Label Line number is relative to the Label so each Label output will start at Line 1. If you start at Line 2 then a Blank line (prefixed *B) will be written, before Line 2, to the spooled output; or you could miss out a line i.e. 1, 2, 3, 5, 6 and a Blank line will be written before Line 5. Blank lines will only be written at Detail level NOT Header. Note: Leaving this entry blank will default to 1 unless you are specifying a Record Flag of ‘C’ = Complete/Close entry or an ‘F’ = First line of new Document as you may not want this information output to the spooled file.

Label Pos

The Label Position is the start position, on the above Label Line, for the data on the spooled file. Note: Leaving this entry blank will default to 1 unless you are specifying a Record Flag of ‘C’ = Complete/Close entry or an ‘F’ = First line of new Document as you may not want this information output to the spooled file.

Fld Len

The Field Length entry is the actual length of the OUTPUT field that you want to be output. In this way it is possible to right justify the numeric entries, which are left justified in the XML. If your XML data is greater than the length specified it will be truncated. Values 1 - 182.

No. Dec

This is where you can specify a number of decimals for numeric output.  Values 1 - 5 or blank. Note: Specifying a number of decimals means the data will be right justified on your output.

Prt H (Print Heading)

If you don’t want Headings to be printed for a Line then enter an “N” here on ANY of the entries and no heading will be printed. You may only want headings for Loop lines for instance.

XML Element

The XML element details. By default the first characters of the XML element are displayed. If you press F11=Alt XML View then the last characters of the XML element are displayed.

Examples

For example if you wish to extract an Invoice Address & a Delivery Address to print side by side but you don't need field Headings and you want a space before i.e. start at Line 2:

Example Address output

Ref

Label ID

Field/Key

F/C

Label Lin

Label Pos

FLD Len

No. Dec

Prt H

XML_010

ADD

Inv Name


2

1

35

 

N

XML_011

ADD

Inv Add


3

1

30

 

N

XML_012

ADD

Inv Street


4

1

30

 

N

XML_013

ADD

Inv Town


5

1

20

 

N

XML_014

ADD

Inv County


6

1

20

 

N

XML_015

ADD

Inv Post


7

1

10

 

N

....




 

 

 

 


XML_067

ADD

Del Name


2

50

35

 

N

XML_068

ADD

Del Add


3

50

30

 

N

XML_069

ADD

Del Street


4

50

30

 

N

XML_070

ADD

Del Town


5

50

20

 

N

XML_071

ADD

Del County


6

50

20

 

N

XML_072

ADD

Del Post


7

50

10

 

N

or the details relating to a recurring Invoice Line where you would like the Headings to print and leaving a space between each entry:

Invoice Lines

Ref

Label ID

Field/Key

F/C

label Lin

Label Pos

FLD Len

No. Dec

Prt H

XML_019

ITEM

Seq


2

1

3

 


XML_020

ITEM

QTY


2

5

3

0


XML_021

ITEM

Desc


2

9

30

 


XML_022

ITEM

Weight


2

41

10

2


XML_024

ITEM

Rate


2

53

10

2


XML_026

ITEM

Currency


2

67

3

 


XML_027

ITEM

Amount


2

72

10

2


XML_028

ITEM

End

C

 

 

 

 


Function keys

F3=Exit

Exits the Work with XML Cross Reference Details screen and returns to the Work with XML Cross References, without updating.

F5=Refresh

Refreshes the list of XML Cross Reference Details

F10=Update

Update the XML table with your changes.

F11=Alt XML View

Toggle between showing the first or last characters of the XML element.

F12=Previous

Exits the Work with XML Cross Reference Details screen and returns to the Work with XML Cross References, without updating.

F16=Find

Highlights all of the XML Elements that contain the string you have entered in the Find... entry.

Page Up

Scrolls up through the list

Page Down

Scrolls down through the list