Skip to Content
avatar image
Former Member

Converting smartform output into CSV format.

Hi guys,

I am having an requirement to convert output coming from smartform into csv format. But as i debugged further i found that some of the content is coming from adobe form. The data coming in adobe form i have converted to csv by using gui_download, but the format coming in adobe form i.e. Name, City, Address etc fields these fields also i have to populate in output excel. Please Help me out.

Add comment
10|10000 characters needed characters exceeded

Further commenting has been locked.
  • Get RSS Feed

2 Answers

  • Nov 07, 2017 at 11:55 AM

    So, for "Converting Adobe form output into CSV format", assuming the Adobe form has been generated via ADS, you have to create a program in 3 steps:

    • Extract the XML data out of the Adobe form.
    • Parse the XML data and generate the CSV file

    To extract the XML data, you may use the demo program FP_PDF_TEST_03 (it will download the XML as a file on your desktop).

    To parse the XML data, you have several ways: from scratch (the XML is a string of characters), XML transformation, iXML (class CL_IXML, ...), sXML reader (classes CL_SXML_*_READER, ...)

    Whatever the technology you choose for parsing the XML data, you'll need to decide how the fields will be mapped to the CSV file (which data of the form to which column of the CSV).

    It's easier to generate the content of the CSV file from scratch (values separated by ',' or ';' depending on the Windows regional settings).

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 07, 2017 at 06:34 PM

    Sorry but this approach makes just as much sense as trying to get a whole orange out of orange juice. You don't need any form in the middle. Just get the data and get it into a file.

    Add comment
    10|10000 characters needed characters exceeded

    Further commenting has been locked.