XML File into Database MYSQL
Posted: Sun Sep 11, 2005 11:21 am
feyd | Please use
p.s. sorry for my bad english i am from austria
feyd | Please use
Code: Select all
andCode: Select all
tags where approriate when posting code. Read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]
I have an XML File and want to put it into an MYSQL Database...
The Problem is that the XML File has more Tables...
I have found the Tool NAVICAT but this tool create only ONE Table and inserts the data...
The problem ist that for example the Regions or the Genres are with only 1 entry in the database !?!?
For this two i need an extra table...
Please help , ist there any tool out there that can handle this XML File into Database?!?!?!
Example -- the Tag Regions or Genres has mor than one element:Code: Select all
<?xml version="1.0" encoding="us-ascii"?>
<!-- DVD Profiler Version 2.4.0 Collection Export -->
<!-- Exported: 10.09.2005 15:23:20 -->
<Collection>
<DVD>
<ID>000019112004.5</ID>
<UPC>000019-112004</UPC>
<ProfileTimestamp>2004-11-25 06:48:01</ProfileTimestamp>
<Title>Heavenly Creatures</Title>
<SortTitle>Heavenly Creatures</SortTitle>
<Description>SFT Ausgabe</Description>
<Regions>
<Region>2</Region>
<Region>1</Region>
</Regions>
<Discs>
</Discs>
<CollectionType>Owned</CollectionType>
<CollectionNumber>33</CollectionNumber>
<Locks>
<Entire>False</Entire>
<Covers>False</Covers>
<Title>False</Title>
<Cast>False</Cast>
<Crew>False</Crew>
<DiscInformation>False</DiscInformation>
<Overview>False</Overview>
<Regions>False</Regions>
<AudioSubtitles>False</AudioSubtitles>
<Genres>False</Genres>
<SRP>True</SRP>
<Studios>False</Studios>
</Locks>
<ProductionYear>1994</ProductionYear>
<Released>2004-11-19</Released>
<RunningTime>95</RunningTime>
<CaseType>Keep Case</CaseType>
<Genres>
<Genre>Drama</Genre>
<Genre>Action</Genre>
</Genres>p.s. sorry for my bad english i am from austria
feyd | Please use
Code: Select all
andCode: Select all
tags where approriate when posting code. Read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]