File Exchanges
 
About file exchanges 
Step 1: Choice of services 
Step 2: Depositing files 
Step 3: Follow-up and downloading of response files (how to download response files) 
   
   
     

 

 

 

 

 

 

About file exchanges
 

 Do you have large volumes of credit limit requests to deal with?
 Does your directory include more than 1,500 companies?
 Do you wish to receive electronic files for new notifications of responses to your credit limit requests, Euler Hermes France decisions and updates to your directory?

The file exchanges service allows you to save time managing your credit insurance policy. Access to the service depends on the features of your policy, and it handles data relating to your operations both in France and in export markets.

If you manage a group of policies, you may find information about it by accessing the Multi-policy BFE (Batch File Exchange) "EPL Multicontrats" help.

Build your personalised files and pick up your response files from EOLIS in 3 steps:
Step 1 : choose and personalise the services that you wish to use.
Step 2 : deposit/request files relating to the services selected in step 1.
Step 3 : monitor the status of your requests and pick up your response files after processing.

Step 1: Choice of services

 

Click on "Choice of services" from the "Exchange of Files" menu to build the panel of services that you wish to have available yourself. The services offered depend on the type of policy you have and handle data relating to your operations both in France and in export markets.

1. Select the desired services:

Credit limit requests * : Using a file, you can initiate/update your outstanding balances on buyers either by EulerID or by another identifier associated with your customer references. 

List of latest decisions ** : Receive (in the form of files) a list of the latest limit positions from Euler Hermes Crédit France relative to your contract. 

New application responses: Receive daily (in the form of files) new responses from Euler Hermes Credit France (responses to outstanding credit limit requests, partial or total withdrawals, buyer reviews).

Credit Limit deletions * : Carry out simultaneously several requests of removal by depositing (in the form of file) the list of the customers’ Siren numbers. Select in the personalization menu the service called “New credit limit answers” to obtain (in the form of file) the answers to your credit limit requests as soon as there are underwritten.

Directory (updates)* : Create and update your Directory by depositing (in the form of file), a list of companies indentified by Siren number. This service allows you to add or delete several customers from your Directory.

Directory (list) ** : Receive (in the form of files) a list of the companies registered in your Directory. An "LC" indicates that a company is on the Ground up Client List.

Ground up Client List: Receive every month (in the form of file) the list of companies saved in your directory that entered or exited the Ground-up Client List during the period. This service improves your customer portfolio for free.

* These services require a request file to be deposited.
** For these, EOLIS offers you either an on-request subscription or an automatic subscription with a frequency that you select. For on-request subscriptions, you must always then make a file receipt request, as selecting the service alone is not sufficient.

2. Validate your selection to proceed to step 2.

Step 2: Depositing files
 

Click on “Credit limit requests”, “Limits deletion” or “Directory update” from the “Exchange of Files” menu to deposit the corresponding files. The Excel formatting files need to be downloaded in order to deposit files on EOLIS. You are advised to save these files onto your workstation and then enter the data before reconnecting to EOLIS to deposit them. The services offered depend on the type of policy you have and process only data relating to your operations in France and in export markets.

Depositing a credit limit request file 
Depositing a limit deletion request file
Depositing a directory update file

Depositing a credit limit request file:

1. Click on "Credit limit requests" from the "Exchange of Files" sub-menu.

2. Select the desired type of request: Request by identifier.

3. Create, format and save your file on your workstation:
Your file must be in a predefined format (type, order and content of the columns) in order to be properly interpreted by our information system. This is a tool to assist with input which will tell you how to build your files and check data consistency. 

Click on "Create your file " to download the Excel "AGRDEM_EHFRANCE_EN.xls" working file onto your workstation to enable you to build your credit limit request file in the appropriate format. 

Open the "AGRDEM_EHFRANCE_EN.xls", file, where the first page gives details of the procedure to be followed and opens an EOLIS tool bar. Click on "Open a blank pre-formatted file” in the EOLIS tool bar.

Have the necessary information available and fill in the table. 

You can make your credit limit requests by entering the following elements:
Policy number
Euler-ID
country code
Identifier type
Identifier value
Your customer references
Amount Requested
Comments
Credit period

Only the Identifier type, Identifier value, Amount requested and Currency columns are mandatory.

Click on "Check data format" in the EOLIS tool bar to check data consistency.

Click on "Save" in the EOLIS tool bar to save the "AGRDEM.txt" file in text format. The Excel formatting macro will convert the Excel file into a text format file that EOLIS can interpret.

4. Depositing your file:
click on "Browse" to deposit the "AGRDEM.txt" file on EOLIS.
validate to deposit your file.
NB: The ".txt" file extension is essential in order for our system to be able to use the file. 

Depositing a limit deletion request file

1. Click on "Limit deletions "in the "Exchange of files"sub-menu.

2. Create, format and save you file on your workstation:
Your file must be in a predefined format (type, order and content of the columns) in order to be properly interpreted by our information system. This is a tool to assist with input which will tell you how to build your files and check data consistency.

Click on "Create your file " to download the Excel "AGRSUP_EHFRANCE_EN.xls" working file onto your workstation to enable you to build your limit deletion request file in the appropriate format.

Open the "AGRSUP_EHFRANCE_EN.xls", file, where the first page gives details of the procedure to be followed and opens an EOLIS tool bar. Click on "Open a blank pre-formatted file” in the EOLIS tool bar.

Have the necessary information available and fill in the table.

You can make your limit deletion requests by entering the following elements:
Policy number
Euler-ID
Country code
Identifier type
Identifier value
Your customer references


The identifiers entered must adhere to this format to be recognised by our services.

Only the Identifier type and Identifier value columns are mandatory.

Click on "Check data format" in the EOLIS tool bar to check data consistency.

Click on "Save" in the EOLIS tool bar to save the "AGRSUP.txt" file in text format. The Excel formatting macro will convert the Excel file into a text format file that EOLIS can interpret.

3. Depositing your file:
Click on "Browse" to deposit the "AGRSUP.txt" file on EOLIS.
Validate to deposit your file.
NB: The ".txt" file extension is essential in order for our system to be able to use the file.

Depositing a directory update file:

1. Click on "Directory update" from the "Exchange of files" sub-menu.

2. Select the desired type of request: Addition or removal from directory.
If you wish to both add and remove companies from your directory, then you have to deposit two files, one file of additions and one of removals.

3. Create, format and save your file on your workstation:
Your file must be in a predefined format (type, order and content of the columns) in order to be properly interpreted by our information system. This is a tool to assist with input which will tell you how to build your files and check data consistency.

Click on "Create your file" to download the Excel "REPERT_IN_EHFRANCE_EN.xls" working file onto your workstation to enable you to build your credit limit request file in the appropriate format. 

Open the  "REPERT_IN_EHFRANCE_EN.xls", file, where the first page gives details of the procedure to be followed and opens an EOLIS tool bar. Click on "Open a blank pre-formatted file” in the EOLIS tool bar.

Have the necessary information available and fill in the table:
Policy number
Euler-ID
Country code
Identifier type
Identifier value
Your customer references

Click on "Check data format" in the EOLIS tool bar to check data consistency.

Click on "Save" in the EOLIS tool bar to save the "REPERT_IN.txt" file in text format. The Excel formatting macro will convert the Excel file into a text format file that EOLIS can interpret.

4. Depositing your file
Click on "Browse" to deposit the "REPERT_IN.txt"  file on EOLIS.
Validate to deposit your file.
NB: The ".txt" file extension is essential in order for our system to be able to use the file.

Etape 3 : Monitoring and download of response files (how to download response files)
  Click on “Monitoring and download of response files” from the “File Exchanges” menu. A table shows the following:
Your requests, subscriptions and deposited files.
The status of your requests – response files are available at least one working day later (minimum).
Response files for you to download 

How to download response files:

1. Save the Excel formatting files onto your workstation these files enable you to download files in a format which is directly useable:
Click on the links below with the right-hand button of your mouse then select the Save target as… option (you are invited to download these tools so as to be able to jump directly to step 3 below for subsequent downloads).

1AGRREP_EHFRANCE_EN.xls to download new response notifications

 1AGRLIS_EHFRANCE_EN.xls to download the list of latest decisions

 1REPERT_OUT_EHFRANCE_EN.xls to download responses to your directory preparation files

 1LCMAJ_EHFRANCE_EN.xls to download the list of companies in your directory that have been added to or removed from the 1st euro customer list

 1REPLIS_EHFRANCE_EN.xls to download your directory list

2. Save your response file on your workstation by clicking on the +J or *L icons in the monitoring and download table (see below for meanings of icons used).

3. Open the Excel formatting filecorresponding to the type of response file that you wish to download from EOLIS (see step 1) and click on the + "Open response file" option in the EOLIS tool bar.

4. View the response file and save it in this format on your workstation.

Meaning of icons used:

+J

Click to open the file of processed requests.

*L

Click to open the file of requests that could not be processed (wrong format, missing field(s), input errors, etc.). In such circumstances, you are requested to complete and/or modify the file of unprocessed requests and deposit it onto EOLIS for reprocessing. 

+J/*L

You have already downloaded this file.

X

Click on this icon to cancel a pending request. You do not have the option to cancel requests once processing has started.

The status of your requests:

Pending

Your request is awaiting processing. You may cancel it if so desired by clicking on X.

Cancelled

You have cancelled a pending request.

Outstanding

You request is being processed.

You request is being processed.

Your request has been processed with no errors, and you can download the file of processed requests* by clicking on +J.

Error

Some rows in the request file could no be processed.  Only unprocessed rows are found in the response file* that you can download and correct by clicking on *L.

* NB : to receive responses to your limit requests, subscribe to the "New response notifications” service. You will then receive one or more response files, as Euler Hermes France makes its decisions.