Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to use xmlSax format in a script.
With "xmlSimple" the syntax i use works, but when I replace xmlSimple with xmlSax the script fails.
lnkValue:
LOAD value,
label,
seq,
dflt,
%Key_admin_5D61A36D8297C46F // Key to parent table: codif/admin
FROM C:\data\admin.20130925\10_ref_spec_NCG.001.xml (XmlSimple, Table is [codif/admin/ref_spec_NCG/lnkValue]);
admin:
LOAD xmlns:xsi,
xmlns,
[ref_spec_NCG/spec_NCG] as spec_NCG,
[ref_spec_NCG/label],
%Key_codif_4EADC4DCBD4A1192, // Key to parent table: codif
%Key_admin_5D61A36D8297C46F // Key for this table: codif/admin
FROM C:\data\admin.20130925\10_ref_spec_NCG.001.xml (XmlSimple, Table is [codif/admin/ref_spec_NCG]);
Source xml is :
<?xml version="1.0" encoding="UTF-8"?>
<codif xmlns="http://codif.darty.fr" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://codif.darty.fr http://codif.darty.fr/schemas/codif.xsd"
source="PCM" reference="init" issued="2013-09-25T14:00:00.0Z">
<admin xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http://codif.darty.fr/admin">
<ref_spec_NCG>
<spec_NCG>CHAR</spec_NCG>
<label>CHARNIERE</label>
<lnkValue>
<value>CHAR?</value>
<label>CHARNIERE INCHANGEE</label>
<seq>1</seq>
<dflt>0</dflt>
</lnkValue>
<lnkValue>
<value>D</value>
<label>CHARNIERE A DROITE</label>
<seq>2</seq>
<dflt>1</dflt>
</lnkValue>
<lnkValue>
<value>G</value>
<label>CHARNIERE A GAUCHE</label>
<seq>3</seq>
<dflt>0</dflt>
</lnkValue>
</ref_spec_NCG>
</admin>
<admin xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http://codif.darty.fr/admin">
<ref_spec_NCG>
<spec_NCG>CLE</spec_NCG>
<label>SERRURE OPTIONNELLE</label>
<lnkValue>
<value>N</value>
<label>SANS SERRURE</label>
<seq>1</seq>
<dflt>1</dflt>
</lnkValue>
<lnkValue>
<value>O</value>
<label>AVEC SERRURE</label>
<seq>2</seq>
<dflt>0</dflt>
</lnkValue>
</ref_spec_NCG>
</admin>