Excel to XML File - Page 3

jimr381 · 13-Jun-2008, 11:39 AM **#31**

Ok I will attach them, I am just a little caught up in work at the moment.

computerman29642 · 13-Jun-2008, 11:46 AM **#32**

That's fine. I just want to see what you did differently.

slurpee55 · 13-Jun-2008, 12:13 PM **#33**

Just to give some feedback - I had to convert Excel data to XML a lot previously (thanks goodness that contract expired!) and found the Save As option practically useless, for MS insists on adding a lot of junk to the schema.
However, once I had it built (and rebuilt and rebuilt - the customer kept changing the specs) I found Excel a very easy program for this task - just apply the schema to the data.

computerman29642 · 13-Jun-2008, 12:18 PM **#34**

What do you mean by apply the schema to the data? I have tried many things, but I keep geeting the error "The data is not exportable".

jimr381 · 13-Jun-2008, 02:33 PM **#35**

Send me a mail message with your email address and I will e-mail the data to you.

computerman29642 · 13-Jun-2008, 03:25 PM **#36**

I have sent my email through a PM.

jimr381 · 13-Jun-2008, 03:50 PM **#37**

Can you post for me what fields marry to what from the XSD to the Excel file please? I randomly mapped what I thought was right which worked, but I want to verify before I send you anything.

computerman29642 · 13-Jun-2008, 04:05 PM **#38**

I really wish I could do that for you. I am reading through a 60 page document now trying to match the fields together. That is why I was hoping that I would be able to just move the fields from the XSD to an empty Excel file, and just copy/paste when it is time to send the data.

jimr381 · 13-Jun-2008, 04:18 PM **#39**

The excel file that I have now has certain fields setup. I just need to know what the columns are called in Excel and what they match up to in the XSD file.

computerman29642 · 13-Jun-2008, 04:23 PM **#40**

I am not fully sure right now. The Excel file I attached is not a full file. I will end up needing all the fields within the XSD file. I am not sure right now all of the fields in Excel that match the fields from the XSD. I am reading through a document from the client trying to figure that out now.

jimr381 · 13-Jun-2008, 04:24 PM **#41**

OK after you open up the Schema you will want to drag the fields from the pane on the right to the corresponding Excel field on the left. You will want to work from the left to the right in the Excel spreadsheet and then click on the "Export to XML" on the XML toolbar.

If you see multiple blue boxes around the data then it did not group them together well, so you will want to do it again.

computerman29642 · 13-Jun-2008, 04:27 PM **#42**

Does every field in the XSD have to be used within a group? I will give that a shot.

computerman29642 · 13-Jun-2008, 04:30 PM **#43**

I followed your instructions, but when I clicked the export option from the XML menu, I got the attached error message.

jimr381 · 13-Jun-2008, 04:41 PM **#44**

Can you give me a screenshot or email me one with what the data looks like when you have assigned the fields to it. There should be one big blue box surrounding all the fields after you assign them to the Excel data.

computerman29642 · 13-Jun-2008, 04:59 PM **#45**

I have attached a screenshot as you requested.

Search
Search in:
Show Threads Show Posts
Advanced Search

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)