Hi Guys. I'm hoping somebody will be able to help. I'm loading a program which ready XML as it's config file.

The XML looks like this
Code:
<?xml version="1.0" encoding="utf-8" ?> <Mappings xmlns="http://awebsite.comMappingsSchema.xsd"> <!-- UI Strings --> <Text> <MainLabel>Select the Category and Type of the scanned document from the dropdowns below</MainLabel> <FormTitle>Generic Validation</FormTitle> <CategoryLabel>Category:</CategoryLabel> <TypeLabel>Type:</TypeLabel> <SubTypeLabel>Sub-type:</SubTypeLabel> </Text> <Category name="LIVE"> <Type name="DOC"> <Field name="Reference" value="6" /> <Field name="DOCTITLE" value="name"/> </Type> <Type name="HEALTH"> <Field name="Reference" value="1" /> <Field name="DOCTITLE" value="HealthLet"/> </Type> </Category> </Mappings>
It works well, and the program displays these choices in a select menu. If you choose LIVE another menu appears and you can choose from DOC or HEALTH. The selection is exported into either location 6 or 1. Does this make sense?

The problem is that there are LOTS! of categories to do. It can be done by hand but will take an age!

I tried searching to convert these into a XML schema for excel to export these. It mapped fine, but then wouldn't export stating the information was denormalized and that it had lists of list.

I looked into this and as far as I can see the Child? of the Node? is the
Code:
<Field name="Reference"/>
which is causing the problem.

So I tried the following.

Code:
<?xml version="1.0" encoding="utf-8" ?> <Mappings xmlns="http://awebsite.com/MappingsSchema.xsd"> <!-- UI Strings --> <Text> <MainLabel>Select the Category and Type of the scanned document from the dropdowns below</MainLabel> <FormTitle>Generic Validation</FormTitle> <CategoryLabel>Category:</CategoryLabel> <TypeLabel>Type:</TypeLabel> <SubTypeLabel>Sub-type:</SubTypeLabel> </Text> <Category name=DOC"> <Type name="DOCTITLE"> <Field name="Reference" value="6" /> <Field name="Wisdom Document Title" value="FISS CLSUM"/> </Type> <Type name="HEALTH"> <Field name="Reference" value="1" /> <Field name="Wisdom Document Title" value="FAM CHRON"/> </Type> </Category> </Mappings>
But this caused an error.

I also wonder if the Schema needed changing on the
Code:
<Mappings xmlns="http://awebsite.com/MappingsSchema.xsd">
However I have been to the website and that file doesn't exist
(I have changed the website domain for security reasons)

Is there anybody who could help. It would be much appreciated.

Kind regards