Was this option taken away or is it a specific form issue? I'm trying to import data from Excel into a fillable Form and this seems to be the easiest solution as the Exported XML file from the form is not mappable into Excel which prevents me from pulling the excel data into the form.
Or am I attacking this in the worst way possible?
FYI, I am using Adobe Acrobat XI Pro to import into the form.
If you can save your data in a CSV file you can also save it as XML, because CSV is a two dimensional method to save data, and this method Excel also supports for XML files (import and export).
Correct you can do it this way, but the way it's setup doesn't allow for easy data entry from actual excel data I would like to apply to PDF fillable form. Also trying to fill out the fillable form for multiple data entries.
If I export the XML and then map for which data I want to pull in, Excel throws errors for lists in lists, etc. See below. Yet I can import the XML into Excel. So I can never get the excel data back to PDF.
As I said before, export from Excel won't work when you have nested repeatable elements in your XML. It's because Excel only supports two dimensional data structures but your XML structure is multi dimensional. There is not way to fix this in Excel, I'm afraid.
But, you can use XSLT to transform your XML structure when exporting from or importing in your form. Here's a sample:
I'm using Altova XMLSpy to create XML schemes (XSD) and XSLT stylesheets to modify XML data the way I need.
As shown in the linked sample above, the XFA form uses a XML scheme and transforms all the imported/exported data with XSLT.