Bonjour à tous !
Je fais face actuellement à quelques difficultés au niveau de l’extraction des données à travers des fichiers XML pour créer une base de données sous forme d’un tableau excel (idéalement). Qu’est ce que vous me conseiller sachant que je n’ai aucune formation préalable à la programmation (sauf un peu de VBA).
Ci-dessous un exemple de l’un de mes documents XML.
Merci d’avance !
********************************************************************
<?xml version="1.0" encoding="UTF-8"?>
<register-document xmlns="http://www.epo.org/register" date-produced="20120222" dtd-version="1.0" lang="en" produced-by="RO" status="APPLICATION DEEMED TO BE WITHDRAWN">
<bibliographic-data country="EP" id="EP89203325P" lang="en" status="APPLICATION DEEMED TO BE WITHDRAWN">
<publication-reference change-gazette-num="1990/28">
<document-id lang="en">
<country>EP</country>
<doc-number>0377259</doc-number>
<kind>A1</kind>
<date>19900711</date>
</document-id>
</publication-reference>
<classifications-ipcr change-gazette-num="1990/28">
<classification-ipcr id="CLASSIFICATION_8757">
<text>C08F8/30, C08C19/22, C08G69/00</text>
</classification-ipcr>
</classifications-ipcr>
<application-reference change-gazette-num="1990/28">
<document-id>
<country>EP</country>
<doc-number>89203325</doc-number>
<date>19891228</date>
</document-id>
</application-reference>
<language-of-filing>en</language-of-filing>
<priority-claims change-gazette-num="1990/28">
<priority-claim kind="national" sequence="1">
<country>NL</country>
<doc-number>19890000001</doc-number>
<date>19890102</date>
</priority-claim>
</priority-claims>
<parties>
<applicants change-gazette-num="N/P">
<applicant app-type="applicant" designation="all" sequence="1">
<addressbook>
<name>DSM N.V.</name>
<address>
<address-1>Het Overloon 1</address-1>
<address-2>6411 TE Heerlen</address-2>
<country>NL</country>
</address>
</addressbook>
<nationality>
<country/>
</nationality>
<residence>
<country/>
</residence>
</applicant>
</applicants>
<applicants change-gazette-num="1992/13">
<applicant app-type="applicant" designation="all" sequence="1">
<addressbook>
<name>DSM N.V.</name>
<address>
<address-1>Het Overloon 1</address-1>
<address-2>NL-6411 TE Heerlen</address-2>
<country>NL</country>
</address>
</addressbook>
<nationality>
<country/>
</nationality>
<residence>
<country/>
</residence>
</applicant>
</applicants>
<applicants change-gazette-num="1990/28">
<applicant app-type="applicant" designation="all" sequence="1">
<addressbook>
<name>STAMICARBON B.V.</name>
<address>
<address-1>Mijnweg 1</address-1>
<address-2>NL-6167 AC Geleen</address-2>
<country>NL</country>
</address>
</addressbook>
<nationality>
<country/>
</nationality>
<residence>
<country/>
</residence>
</applicant>
</applicants>
<inventors change-gazette-num="1990/28">
<inventor sequence="01">
<addressbook>
<name>Koning, Cornelis Eme</name>
<address>
<address-1>Parkstrasse 18</address-1>
<address-2>NL-6436 EL Schinnen</address-2>
<country>NL</country>
</address>
</addressbook>
</inventor>
<inventor sequence="02">
<addressbook>
<name>Fayt, Roger Michel André</name>
<address>
<address-1>Route du Condroz 144</address-1>
<address-2>B-4121 Neuville</address-2>
<country>BE</country>
</address>
</addressbook>
</inventor>
<inventor sequence="03">
<addressbook>
<name>Van de Vondervoort, Elisabeth Wilhelmina Maria</name>
<address>
<address-1>Aldenhoven 6</address-1>
<address-2>NL-6093 HB Heythuysen</address-2>
<country>NL</country>
</address>
</addressbook>
</inventor>
<inventor sequence="04">
<addressbook>
<name>Van Geenen, Albert Arnold</name>
<address>
<address-1>Merkelbeekerstrasse 82</address-1>
<address-2>NL-6441 KM Brunssum</address-2>
<country>NL</country>
</address>
</addressbook>
</inventor>
<inventor sequence="05">
<addressbook>
<name>Teysie, Philippe</name>
<address>
<address-1>Avenue du Bois Imperial du Rognac 85</address-1>
<address-2>B-4121 Neuville</address-2>
<country>BE</country>
</address>
</addressbook>
</inventor>
</inventors>
</parties>
<designation-of-states change-gazette-num="1990/28">
<designation-pct>
<regional>
<region>
<country>EP</country>
</region>
<country>AT</country>
<country>BE</country>
<country>CH</country>
<country>DE</country>
<country>ES</country>
<country>FR</country>
<country>GB</country>
<country>IT</country>
<country>LI</country>
<country>NL</country>
<country>SE</country>
</regional>
</designation-pct>
</designation-of-states>
<invention-title change-gazette-num="1990/28" lang="en">Acyllactam-functional compounds and polylactam block copolymers derived therefrom</invention-title>
<invention-title change-gazette-num="1990/28" lang="fr">Composés fonctionnels d'acyllactames et polymères séquencés de polylactames ainsi obtenus</invention-title>
<invention-title change-gazette-num="1990/28" lang="de">Acyllactam-funktionsfähige Verbindungen und daraus hergestellte Polylactam-Blockpolymere</invention-title>
<dates-rights-effective>
<request-for-examination change-gazette-num="1992/28">
<date>19901212</date>
</request-for-examination>
<first-examination-report-despatched>
<date>19920526</date>
</first-examination-report-despatched>
</dates-rights-effective>
<references-cited>
<citation cited-phase="search" id="cit_53049" office="EP">
<patcit url="http://worldwide.espacenet.com/textdoc?DB=EPODOC&IDX=EP0241100&CY=EP">
<document-id>
<country>EP</country>
<doc-number>0241100</doc-number>
</document-id>
</patcit>
<category>A</category>
</citation>
<citation cited-phase="search" id="cit_53050" office="EP">
<patcit url="http://worldwide.espacenet.com/textdoc?DB=EPODOC&IDX=EP0194362&CY=EP">
<document-id>
<country>EP</country>
<doc-number>0194362</doc-number>
</document-id>
</patcit>
<category>A</category>
</citation>
<citation cited-phase="search" id="cit_53051" office="EP">
<patcit url="http://worldwide.espacenet.com/textdoc?DB=EPODOC&IDX=EP0134616&CY=EP">
<document-id>
<country>EP</country>
<doc-number>0134616</doc-number>
</document-id>
</patcit>
<category>A</category>
</citation>
<citation cited-phase="search" id="cit_53052" office="EP">
<patcit url="http://worldwide.espacenet.com/textdoc?DB=EPODOC&IDX=EP0156079&CY=EP">
<document-id>
<country>EP</country>
<doc-number>0156079</doc-number>
</document-id>
</patcit>
<category>A</category>
</citation>
<citation cited-phase="search" id="cit_53053" office="EP">
<patcit url="http://worldwide.espacenet.com/textdoc?DB=EPODOC&IDX=US3136738&CY=US">
<document-id>
<country>US</country>
<doc-number>3136738</doc-number>
</document-id>
</patcit>
<category>A</category>
</citation>
<citation cited-phase="search" id="cit_53054" office="EP">
<patcit url="http://worldwide.espacenet.com/textdoc?DB=EPODOC&IDX=DE1258604&CY=DE">
<document-id>
<country>DE</country>
<doc-number>1258604</doc-number>
</document-id>
</patcit>
<category>A</category>
</citation>
</references-cited>
<date-application-deemed-withdrawn change-gazette-num="1993/14">
<date>19921006</date>
</date-application-deemed-withdrawn>
<search-reports-information>
<search-report-information change-gazette-num="1990/28" declaration-of-no-search="not-determined" office="EP" search-type="national">
<search-report-publication>
<document-id lang="en">
<country>EP</country>
<doc-number>0377259</doc-number>
<kind>A1</kind>
<date>19900711</date>
</document-id>
</search-report-publication>
</search-report-information>
</search-reports-information>
</bibliographic-data>
<procedural-data>
<procedural-step id="RENEWAL_21647" procedure-step-phase="undefined">
<procedural-step-code>RFEE</procedural-step-code>
<procedural-step-text step-text-type="STEP_DESCRIPTION">Renewal fee payment</procedural-step-text>
<procedural-step-text step-text-type="YEAR">03</procedural-step-text>
<procedural-step-date step-date-type="DATE_OF_PAYMENT">
<date>19911212</date>
</procedural-step-date>
</procedural-step>
<procedural-step id="STEP_PFEE_4746" procedure-step-phase="examination">
<procedural-step-code>PFEE</procedural-step-code>
<procedural-step-text step-text-type="STEP_DESCRIPTION">Additional fee for renewal fee</procedural-step-text>
<procedural-step-text step-text-type="YEAR">04</procedural-step-text>
<procedural-step-date step-date-type="DATE_OF_DISPATCH">
<date>19921231</date>
</procedural-step-date>
<time-limit time-limit-unit="months">06</time-limit>
</procedural-step>
<procedural-step id="STEP_PROL_7530" procedure-step-phase="examination">
<procedural-step-code>PROL</procedural-step-code>
<procedural-step-text step-text-type="STEP_DESCRIPTION">Language of the procedure</procedural-step-text>
<procedural-step-text step-text-type="procedure language">en</procedural-step-text>
</procedural-step>
<procedural-step id="STEP_ADWI_1157" procedure-step-phase="examination">
<procedural-step-code>ADWI</procedural-step-code>
<procedural-step-text step-text-type="STEP_DESCRIPTION">Application deemed to be withdrawn</procedural-step-text>
<procedural-step-text step-text-type="STEP_DESCRIPTION_NAME">reply to the communication from the examining division not received in time</procedural-step-text>
<procedural-step-date step-date-type="DATE_EFFECTIVE">
<date>19921006</date>
</procedural-step-date>
<procedural-step-date step-date-type="DATE_OF_DISPATCH">
<date>19921106</date>
</procedural-step-date>
<gazette-reference>
<gazette-num>1993/14</gazette-num>
<date/>
</gazette-reference>
</procedural-step>
<procedural-step id="STEP_EXRE_6511" procedure-step-phase="examination">
<procedural-step-code>EXRE</procedural-step-code>
<procedural-step-text step-text-type="STEP_DESCRIPTION">Communication from the examining division</procedural-step-text>
<procedural-step-date step-date-type="DATE_OF_DISPATCH">
<date>19920526</date>
</procedural-step-date>
<time-limit time-limit-unit="months">04</time-limit>
</procedural-step>
</procedural-data>
<events-data>
<dossier-event event-type="new" id="EVT_126283">
<event-date>
<date>19900526</date>
</event-date>
<event-code>0009012</event-code>
<event-text event-text-type="DESCRIPTION">Publication in section I.1 EP Bulletin</event-text>
<gazette-reference>
<gazette-num>1990/28</gazette-num>
<date>19900711</date>
</gazette-reference>
</dossier-event>
</events-data>
<events-data>
<dossier-event event-type="new" id="EVT_126284">
<event-date>
<date>19910108</date>
</event-date>
<event-code>0009171</event-code>
<event-text event-text-type="DESCRIPTION">Request for examination filed</event-text>
<gazette-reference>
<gazette-num>1991/09</gazette-num>
<date>19910227</date>
</gazette-reference>
</dossier-event>
</events-data>
<events-data>
<dossier-event event-type="new" id="EVT_126285">
<event-date>
<date>19920131</date>
</event-date>
<event-code>0009199APPR</event-code>
<event-text event-text-type="DESCRIPTION">Change - applicant</event-text>
<gazette-reference>
<gazette-num>1992/13</gazette-num>
<date>19920325</date>
</gazette-reference>
</dossier-event>
</events-data>
<events-data>
<dossier-event event-type="new" id="EVT_126286">
<event-date>
<date>19920521</date>
</event-date>
<event-code>0009185</event-code>
<event-text event-text-type="DESCRIPTION">First examination report</event-text>
<gazette-reference>
<gazette-num>1992/28</gazette-num>
<date>19920708</date>
</gazette-reference>
</dossier-event>
</events-data>
<events-data>
<dossier-event event-type="new" id="EVT_126287">
<event-date>
<date>19930216</date>
</event-date>
<event-code>0009183</event-code>
<event-text event-text-type="DESCRIPTION">Application deemed to be withdrawn</event-text>
<gazette-reference>
<gazette-num>1993/14</gazette-num>
<date>19930407</date>
</gazette-reference>
</dossier-event>
</events-data>
</register-document>
********************************************************************************
Merci !
FORUM HardWare.fr
