finaljustice
Board Regular
- Joined
- Oct 6, 2010
- Messages
- 175
Hello,
I have never imported or worked with XML files and I am now having to do so. My current situation is, I have a list of about 1.000 XML files that I would like to Import to Excel to make a Database.
I did figure out through research and trial and error how to import the XML files into excel and using one of the xml files to Map the importation. What I realised is that there are two "mappings" that are required but that only differ in ONE field name.
To illustrate what I mean, these XML files are invoices and these invoices have only 1 field that differ in name but are basically the same thing. This field would be the equivalent of the "social security number for people" and the other would be a "social security number for companies".
Now if I use a XML (invoice) as a mapping example and that invoice was of a Company, when importing the XML bunch the companies invoice's will be imported correctly but for people all other field will be imported correctly but I would not get the social security number of these people which I also need.
Is there a way in excel to configure this mapping, how it is done? Is there a tool I could use to create a map which I could basically just add this one other field in another column.
I have never imported or worked with XML files and I am now having to do so. My current situation is, I have a list of about 1.000 XML files that I would like to Import to Excel to make a Database.
I did figure out through research and trial and error how to import the XML files into excel and using one of the xml files to Map the importation. What I realised is that there are two "mappings" that are required but that only differ in ONE field name.
To illustrate what I mean, these XML files are invoices and these invoices have only 1 field that differ in name but are basically the same thing. This field would be the equivalent of the "social security number for people" and the other would be a "social security number for companies".
Now if I use a XML (invoice) as a mapping example and that invoice was of a Company, when importing the XML bunch the companies invoice's will be imported correctly but for people all other field will be imported correctly but I would not get the social security number of these people which I also need.
Is there a way in excel to configure this mapping, how it is done? Is there a tool I could use to create a map which I could basically just add this one other field in another column.
