That way users can visually see the field names and placement within the actual form, all of which could help them follow the structure of the config file a lot better.
AQUASTUDIO EXPORT DATA TO EXEL PDF
I think it would be a great thing to include/package the PDF form you used to generate the XFDF and format the config file. But like you mentioned, your utility includes filters to sort the data, so it's basically the same slice of pie at the end of the day. I'm just used to seeing data append at the bottom since that's how Excel does it when you Map Fields (working with XML data). That being said, appending to the top of the list isn't a huge problem. The fact that your utility allows the user to select an existing Excel doc is a huge advantage over the Acrobat process in that Acrobat basically generates the Excel doc for you, and the user is stuck with appending data through some other means (i.e. Thus, it wouldn't work for XML but that's OK, its still a great utility for workign with AcroForms. In XFDF the field name is listed following field name = "" and the value is contained in a separate element. In XML the data element contains the field name and the value is listed thereafter:
Now that I recall, there is a slight difference between XFDF and XML If it would only need a few tweaks to be made to work for you (like having a configuration option that says where to append the new data rows instead of always inserting them at row two) then let me know and I'll see what I can do. I hope that this utility can be useful to you but I have a suspicion, purely based on the fact that you're using Livecycle, that your needs might be a bit more complex than it can handle. The idea of appending into the second row is to place the new data somewhere easy to find for a quick visual check (or any immediate manipulation you want) as Excel can very easily sort them to your liking once you are happy with the loaded rows.
AQUASTUDIO EXPORT DATA TO EXEL CODE
The code expects an existing Excel file with one row of headers (which are used as column names when mapping between the XFDF field names and Excel) and inserts data into the second row of the first sheet, shifting the existing data down - so: Yes, it does append data to an existing file that can have as much pre-existing data in it as you like. but also more if you need to load several at once. Yes, the file open dialogue for the XFDF files will allow you to select only one file.
So if the Livecycle data file's XML looks like that then it should work but my quick trawl through the Livecycle documentation this morning indicates that it may not work as it stands. The code expects the fields and values in the XFDF file(s) to be in the format: I haven't looked at the spec for the data files out of Livecycle XFA so I don't know how similar they are. The import uses the data file portion in XFDF format.
0 kommentar(er)
