Bonjour,

j'ai plusieurs .JOB et je cherche a savoir si je peux importer ce genre de fichier sur une base de données sql

exemple lecture d'un fichier .JOB mode texte  :

<JOB><SN>DS02C01ES101793</SN><VREM>D2AS1-05-05</VREM><VBASE>D2DS1-10</VBASE><JID>DS_00097</JID><TM>PDI test</TM><IDTM>4</IDTM><TLOC>PDI</TLOC><IDTLOC>1</IDTLOC><BTYP>EFB</BTYP><BOER>Original battery</BOER><IDBOER>0</IDBOER><BLOC>In vehicle</BLOC><IDBLOC>1</IDBLOC><BCAR>835</BCAR><BCARO>760</BCARO><BSTD>EN</BSTD><IDBSTD>7</IDBSTD><BFUNC>Main battery</BFUNC><IDBFUNC>1</IDBFUNC><JPR>0.00</JPR><SNB></SNB><DBR>3.45</DBR><DCAE>727</DCAE><DATE>04/25/2023</DATE><TIME>10:24:52</TIME><CR></CR><CADR></CADR><CZIP></CZIP><CTEL></CTEL><PN></PN><IDGRES>1</IDGRES><GRES>Good</GRES><GRESST>1</GRESST><DBAD>-</DBAD><VIN>VR3UPHNEKP5038098</VIN><BKCODE>BK-R7300E-8</BKCODE><BKSCAN>VR3UPHNEKP5038098 BK-R7300E-8 </BKSCAN><MK>PEUGEOT</MK><MD>208 (P21)</MD><YE>2022</YE><BAC>575643N01</BAC><OCV>12.78</OCV><DAH>79.90</DAH><DIT>1</DIT><NPC>0</NPC><CDPC>0</CDPC><DSOC>91</DSOC><DSOH>95</DSOH><DRC>151</DRC><DBV>12.78</DBV><DBT>19.59</DBT><CODE>WB319-4</CODE><CWK>A1A4A5A7A5A4A2A4A5A5A5A6A5A6A5A5E6A65DA7A4A532A5A5A5A5A5A5A5F71D39E4421212E7D626E9E4A5A5A5A5C380F5E0F0E2E0EAF1A5A5A5A597959D858DF597948CA5A5A5A5A5A5A5A5A5A5A5A5A597959797A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A542A2A1BCA1A5AFBD91A5A4A4A4A5A5A5FEA5FAA5A5A55BA1BAA632A5D221F9E5DA53D19AA5A5A5A5C1C1FAA5C1A5C1A5C1A5E56A3AE7289402E7338BCC9AF2E796949C8891FFA5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5909290939196EB9594A5A5E7EE88F792969595E0889DA5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5A5</CWK></JOB>

je n'est que deux items a récupérer sur ce fichier pour les mettre sur ma base de données :

•  <VIN>VR3UPHNEKP*******</VIN>
•  <GRES>Good</GRES>

Bonjour,

Oui utiliser le langage de son choix, extraire les données intéressantes et les ajouter dans la base de données.

Voulez-vous un code tout fait ?