PDF Form to XML. How to handle invoice detail lines

[Former Community Member]

I am using LC Designer 7.x on a PDF form that has a submit button that loads a ColdFusion MX7 page that will save the XML in a MS SQL 2005 XML field.

My source of confusion is how to handle the invoice detail lines on the PDF invoice form.

The XML that I want is

5 All Season Tires
400.02


A car with 5 wheels
20400.00


My question is how do I setup the form fields to do this.
What I did prior to XML was have fields whose name included the line number and store them as FDF.
eg
description01 amount01 description02 amount02
But that will not work, or I dont know how to translate that to the desired XML.

Any thoughts you might have would be appreciated.

Thanks
Archie Campbell

[Former Community Member]

Archie,



You want to create a subform called "invoiceLine" which you've set to repeat for each data item using the Binding tab of the Object palette. This subform must be contained within another (e.g. "invoiceLines") whose content is set to be "Flowed" on the Subform tab of the Object palette. So your object hierarchy looks like:

  invoiceLines = subform with flowed content

    invoiceLine = subform repeated for each data item

      description

      amount

Rob Gabbard

Cardinal Solutions Group

www.cardinalsolutions.com