MySQL import of XML
Date: Sat, 18 Jul 2015 19:47:27 +0200
Message-ID: <55aa9130$0$295$14726298_at_news.sunsite.dk>
I have converted a pdf to XML - see truncated version:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE pdf2xml SYSTEM "pdf2xml.dtd">
<pdf2xml producer="poppler" version="0.24.1">
<page number="1" >
<text top="836" >DatNum</text>
<text top="836" > 1/53</text>
<text top="47" >Manual:</text>
<text top="59" >Code:</text>
<text top="71" >Revision No:</text>
<text top="104" >CHAPTER</text>
<text top="104" >CODE</text>
<text top="104" >PAGE</text>
... zipped ...
<text top="800" >01SEP14</text>
<text top="812" > GENERAL</text>
</page>
<page number="2" >
<text top="47" >CHAPTER</text>
<text top="47" >CODE</text>
... zipped ...
<text top="251">03JUN15</text>
<text top="251">CHG</text>
</page>
</pdf2xml>
I need the value/content of
- page number - top number - text.
so...:
mysql> CREATE TABLE clist ( number INT, top INT, text VARCHAR(40) ); Query OK, 0 rows affected (0,06 sec)
Then I picked this up from
http://stackoverflow.com/questions/5491056
mysql> LOAD XML LOCAL INFILE '/home/me/xml/CheckList_MOD_9.xml'
INTO TABLE clist(number, top, text);
Query OK, 0 rows affected (0,01 sec)
Records: 0 Deleted: 0 Skipped: 0 Warnings: 0
No error messages but also no imported data.
What am I doing wrong? Received on Sat Jul 18 2015 - 19:47:27 CEST