Altova User Support Forum

Welcome Guest

IMPORTANT:
this is not a Support Forum! Experienced users might answer from time to time questions posted here. If you need a professional and reliable answer, or if you want to report a bug, please contact Altova Support instead.

Altova User Forums » Product/Technology Discussions » Import/Export » XML to Access - only one record shown in table

XML to Access - only one record shown in table

Options · View

Previous Topic · Next Topic

snuroo

Posted: Friday, April 20, 2012 9:54:23 AM

Rank: Newbie

Joined: 4/20/2012
Posts: 1
Location: London

Apologies if I'm in the wrong place here - very new to XML spy. I have an xml file and want to convert to flat structure. Have tried exporting from XML spy to Access but getting 64 bit problems. Then tried direct import from Access and file imports ok but table only returns one row - the last record in my XML file. Any idea how to get all records? I really want to have a table with just 'Page url' and 'name confirmed'. Below is sample from the xml file and snapshot of output table in access. Thanks in advance if anyone can help.

Code:

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE Response SYSTEM "G:\Users\sb42kg\Species Conservation Assessment Officer\Projects\GSPC\GSPC target 2\1997_red_list\1997_red_list.dtd">
<Response xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <PageID>31085322</PageID>
  <ItemID>97383</ItemID>
  <PageUrl>http://www.biodiversitylibrary.org/page/31085322</PageUrl>
  <ThumbnailUrl>http://www.biodiversitylibrary.org/pagethumb/31085322</ThumbnailUrl>
  <FullSizeImageUrl>http://www.biodiversitylibrary.org/pageimage/31085322</FullSizeImageUrl>
  <OcrUrl>http://www.biodiversitylibrary.org/pageocr/31085322</OcrUrl>
  <PageTypes>
      <PageType>
          <PageTypeName>Text</PageTypeName>
      </PageType>
  </PageTypes>
  <PageNumbers>
      <PageNumber>
          <Prefix>Page</Prefix>
          <Number>1</Number>
      </PageNumber>
  </PageNumbers>
  <Names>
      <Name>
          <NameBankID>446539</NameBankID>
          <NameFound>Isoetaceae</NameFound>
          [color=red][b]<NameConfirmed>Isoetaceae</NameConfirmed>[/b][/color]
      </Name>
      <Name>
          <NameBankID>2644401</NameBankID>
          <NameFound>Isoetes</NameFound>
          <NameConfirmed>Isoetes</NameConfirmed>

snuroo attached the following image(s):

island

Posted: Monday, April 23, 2012 4:41:10 AM

Rank: Newbie

Joined: 10/28/2002
Posts: 1,283
Location: AT

Hi,

a) I would suggest using Mapforce to map the xml to a database.

b) I cannot see enough of your xml file. I would suggest attaching it here.

learnk12

Posted: Monday, February 3, 2014 9:23:40 AM

Rank: Guest

Joined: 12/13/2005
Posts: 0

island wrote:

Hi,

a) I would suggest using Mapforce to map the xml to a database.

b) I cannot see enough of your xml file. I would suggest attaching it here.

Thank you island, useful tips!

Users browsing this topic

guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Use of the Altova User Forum(s) is governed by the Altova Terms of Use.

Email this topic

Watch this topic

Normal

Threaded

user forum