CARL Source offers a certain number of csv interfaces as standard.

Here are some examples of import files accepted by these interfaces.

Importing events with the EVENT_IN_CSV interface and a csv file

version="1.0" encoding="UTF-8
exchangeInterface;EVENT_IN_CSV;externalSystem;EXT_SYST_CSV;timezone;Europe/Paris;language;fr_FR;
EVENT;2009-12-05 16:30:00;;MACHINE1;STOP;Machine 1 is stopped;
EVENT;2010-01-07 16:32:14;BUILD1;;LEAK;Water leak found in building 1;

Header

• If the connection point is a handler of the "Filtered single file" type , the interface code and the external system code are required. Otherwise, these codes are optional.
• If the time zone (timeZone) is not indicated, the system considers the dates to be defined in GMT.
• "Language" tag:
  • If this tag is not specified, the data will be loaded in the main language.
  • The accepted values correspond to the codes in the LANGUAGE value list. If the specified value does not exist, the "Language is not available" error will be returned.
  • The value is based on a codeLangue_codePays format (e.g. en_GB). If only the language code is specified, the first value in the LANGUAGE list starting with this language code will then be considered.
  • If the specified value is different from the application's main language (applicationLanguage), the data will then be loaded into the main table and in the translation table, if any.

Importing WRs with the MR_IN_CSV interface and a csv file

exchangeInterface;MR_IN_CSV;externalSystem;EXT_SYST_CSV;language;fr_FR;
MR;WR1;WR1;Work request for car 666CSI69;HIGH;MARTIN;STOP;2010-02-24 09:48:38;true;;;DUPONT;2010-02-24 09:48:38;ZONE-C;PARK-01;666CSI69;SITE1;true;true;text 1;text 2;;;;;;;;;;;33.25;;2001-06-21 01:02:03;;;;;true;20;
MRDESCRIPTION;<p> Starting problem:</p> <p>Smoke comes out of the hood</p>;
MRSTATUS;REQUEST;DUPONT;2009-12-31 23:00:00;

The prefix of the lines is the name of the record in the exchange standard.
Entities are referenced by their code as indicated in the fields of the exchange standard, in the form ::code; see Creating an exchange standard.

Column WR1 is repeated, so the same file can be used:

• If the WR already exists, it will be updated (MR::code),
• If the WR does not exist and a code needs to be assigned to the new WR (mr::code).