Operating principles (Standard connector)
The CSV and XML files to be imported must be in the proper format:
CSV file
The sent file must comply with the WOEXTPROVIDER_1.0 standard norm provided for this purpose in CARL Source.
This standard describes the following record types:
| CSV file example |
Copy the code
|
|---|---|
WOEXTPROVIDER;DUB003;DUB003;DOMAIN1;2020-04-03 00:00:00;PROVIDER1;LIMONEST; fire door inspection;OK;2020-04-03 00:00:00;2020-04-03 00:00:00 OBSEXTPROVIDER;BARCODE11;BOOKMARK11;EQPTREFVENDOR11;NOK;2020-04-01 00:00:00;MATERIALCODE11;2020-04-01 00:00:00;OBSERVATIONID11;SERIALNUMBER11;LOCATIONCODE11;LOCATIONOBS11;true;REGULATIONITEM111;REGULATIONITEM211;REGULATIONITEM311;REGULATIONITEM411 OBSDESC;OBSDESCRIPTION11; PRECONIZATION;PRECONIZATION11; OBSEXTPROVIDER;BARCODE12;BOOKMARK12;EQPTREFVENDOR12;RES;2020-04-01 00:00:00;MATERIALCODE12;2020-04-01 00:00:00;OBSERVATIONID12;SERIALNUMBER12;LOCATIONCODE12;LOCATIONOBS12;true;REGULATIONITEM112;REGULATIONITEM212;REGULATIONITEM312;REGULATIONITEM412 OBSDESC;OBSDESCRIPTION12; PRECONIZATION;PRECONIZATION12; |
|
XML file
The sent file must comply with the WOEXTPROVIDER integration object provided for this purpose in CARL Source.
This object is based on the following record types:
| XML file example |
Copy the code
|
|---|---|
<?xml version="1.0" encoding="UTF-8" ?> <entities externalSystem="EXTSYS-STD" exchangeInterface="WOEXTPROVIDER_XML_IN"> <WOExtProvider> <woextprovider_workId>int: 11769309372021L / report: 11769309372021L001TCTH001#1</woextprovider_workId> <woextprovider_workCode /> <woextprovider_workDomain>THERMIQUE</woextprovider_workDomain> <woextprovider_requestDate>2021-06-01 15:16:54</woextprovider_requestDate> <woextprovider_provider>APAVE</woextprovider_provider> <woextprovider_site>C.L.J.T.</woextprovider_site> <woextprovider_workDescription>THERMIQUE - VERIFICATION DES INSTALLATIONS DE CHAUFFAGE, VM</woextprovider_workDescription> <woextprovider_workComment>Site: C.L.J.T. / Address: / Post code: 75017 / Town: PARIS<br/> Customer ref.: / Name Client:</woextprovider_workComment> <woextprovider_workDateBegin>2021-04-08 00:00:00</woextprovider_workDateBegin> <woextprovider_workDateEnd>2021-04-08 00:00:00</woextprovider_workDateEnd> <woextprovider_materialCode /> <woextprovider_boxMainCode /> <woextprovider_boxLocationCode /> <woextprovider_reports> <reportExtProvider> <reportextprovider_nom_rap>11769309372021L001TCTH001</reportextprovider_nom_rap> <reportextprovider_rap_date_premiere_diffusion>-- 00:00:00</reportextprovider_rap_date_premiere_diffusion> <reportextprovider_nom_rapport>117693.09.37.21.L.001.TCTH.001.PDF</reportextprovider_nom_rapport> </reportExtProvider> </woextprovider_reports> <woextprovider_observations> <obsExtProvider> <obsextprovider_barCode /> <obsextprovider_bookMark>Obs. N° 1</obsextprovider_bookMark> <obsextprovider_eqptRefVendor>Réseau combustible/Examen documentaire/Dossier technique</obsextprovider_eqptRefVendor> <obsextprovider_evaluation>3</obsextprovider_evaluation> <obsextprovider_firstyearObservation>2020-01-01 00:00:00</obsextprovider_firstyearObservation> <obsextprovider_materialCode /> <obsextprovider_obsDate>2021-04-08 00:00:00</obsextprovider_obsDate> <obsextprovider_observationDescription> <description>Dossier technique/à l accueil/Dossier technique/Document non présenté</description> </obsextprovider_observationDescription> <obsextprovider_observationId>342072074</obsextprovider_observationId> <obsextprovider_preconization> <description /> </obsextprovider_preconization> <obsextprovider_serialNumber /> <obsextprovider_locationCode /> <obsextprovider_locationObs>à l'accueil</obsextprovider_locationObs> <obsextprovider_recurrent>true</obsextprovider_recurrent> <obsextprovider_regulationItem1 /> <obsextprovider_regulationItem2 /> <obsextprovider_regulationItem3 /> <obsextprovider_regulationItem4 /> </obsExtProvider> </woextprovider_observations> </WOExtProvider> </entities> |
|
Manual import
Inspection reports are imported manually from the Work order function via the Import inspection reports action.
Automatic import
In this mode, no display through the HMI will be provided.
The jobs are then programmed through an Automatic job to be declared in the system module.
An automatic job must be created and configured for each Service Provider.
The class associated with automatic job is called: PROVIDCTRLIMPORTJOB.
The automatic job is based on an external system with the WOEXTPROVIDER_IN interface (for files in XML format) or WOEXTPROVIDER_IN_CSV (for files in CSV format) and a connection point.
The file (CSV or XML) must be included in the directory linked to the connection point associated with the service provider (CARL Source server, internal SFTP or directly pointing to the service provider's SFTP).
This job is configured through these settings: