Expand my Community achievements bar.

Need help with Xml Schema

Avatar

Level 2

Hi,

I've designed a form, but the fields in it aren't associated with a XML schema.

When I merge the data into a single xml file and then import it into excel, it says that there is no schema associated with these files and it arranges the values in a preset order, which isn't what I want.

How do i set up an Xml Schema?

Thanks,

Prashant.

2 Replies

Avatar

Former Community Member

To set up schema binding you might want to take a look at this

http://www.adobe.com/devnet/livecycle/articles/using_xml_schema.html

There are lots of software to create schemas, some will allow you to infer the schema based on data. Heres an online one;

http://www.flame-ware.com/products/xml-2-xsd/

I'm not sure if this will fit your needs though, it sounds that your problem is with excel, you might need to somehow associate the xml with the schema from within excel. Unfortunately I have no idea how thats done

Hope that helped,

Billy

Avatar

Level 1

I have the same problem, and there seems to be no answer/support in this area.

The links provided no longer function.

Anyone else have any suggestions?

Need to be able to collect data from a livecycle or acro form and then BATCH compile the data into a spreadsheet in a specific format, not just rows of data. How would you go about doing this? I don't mind designing a form around this, if that is what it takes. It would be better if I could "map" an existing form to present the way I want within excel.