[computerman29642]

I have determined that the errors that are occurring are coming from the repeating objects/data. If I eliminate the repeating objects/data, then I am able to export the Excel data to XML just fine.

[slurpee55]

You should be able to have repeating data, just not repeating field names unless they are organized as subsets (e.g. <company name> could repeat under the set of <clients>). If it was a listing of transactions, the same company name could show up multiple times. Or your company name could show in every set.

[computerman29642]

Right now I have a design of something like this.....

<Test1>
<CompanyName>ME<CompanyName/>
<Company Type>Resell<CompanyType/>
</Test1>

<Test2>
<Client>
<CompanyName/>
<CompanyType/>
</Client>
</Test2>

[slurpee55]

You should have a standard pattern across your tests, so that even if there is no data for <client>, insert "None" in there.

[computerman29642]

Originally Posted by slurpee55

You should have a standard pattern across your tests, so that even if there is no data for <client>, insert "None" in there.

Would I just type "None" in the start(<) and end (/>) brackets?

[computerman29642]

If I attach a sample file, would you see if you could get it to work properly in Excel?

[slurpee55]

Be glad to try...

[computerman29642]

I have attached a sample file. I really appreciate the help. I have been working on this for weeks.

For some reason, I am unable to get the file to upload.

[slurpee55]

try zipping it....

[computerman29642]

I tried zipping the file. I keep getting an "Upload of file" error.

[slurpee55]

Hmmm, send me an email via my profile and I will respond...

[computerman29642]

Email has been sent.

[slurpee55]

and replied to!

[computerman29642]

I have determined that it is the repeating objects/data that is causing the errors in Excel. I keep getting the follwoing two errors....

"List of lists"

"A mapped element's relationship with other elements cannot be preserved."

Does anyone know how to fix these errors?