+ Reply to Thread
Results 1 to 3 of 3

XML - Importing multiple files does not work

  1. #1
    Registered User
    Join Date
    08-09-2011
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    5

    XML - Importing multiple files does not work

    Grateful for any help. I've already posted on this topic but this thread covers a different issue. I need to collect the data from a number of XML files into one worksheet.

    I've tried using the online help to import to do this but it keeps giving me an error message. I've tried using the mapping but when importing multiple files it will only load one of the three!

    The steps so far:

    I imported an .xsd schema to form the XML Map.

    I then dragged a section from the XML Map to the main spreadsheet.

    Using Data > XML > Import I then selected the three different files using CTRL and then Import.

    One file populates the mapped fields and but the other two are listed in an error box with the message:

    "No data was imported or only some of the data was imported"

    Any suggestions on how to resolve this?

  2. #2
    Registered User
    Join Date
    08-09-2011
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: XML - Importing multiple files does not work

    I had a look at the online help and it nearly answers my questions.

    By default, existing data in a mapped range will be overwritten when you import data. Follow these steps if you want to append new data to the existing data when you import data:
    Select a cell in the mapped range.
    On the List toolbar, click XML Map Properties.
    Click Append new data to existing XML lists and then click OK
    .
    Unfortunately when I do this those options are greyed out!

    Is it something I need to do with the source schema?

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-31-2011
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: XML - Importing multiple files does not work

    I have this exact same problem so would be interested to know if you found a solution.

    One option is to merge your three XML file into one and wrap them within a new element, then update your XSD file accordingly.

    I have 260+ XML files so merging them isn't an option for me unfortunetly.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1