Wiki

Case Status
Register Log In

Wiki

 
How to Create the InsurerIDLis…
  • RSS Feed

Last modified on 7/8/2019 9:38 PM by User.

How to Create the InsurerIDList.txt file for the RapidBatchUpdate process

These instructions are for internal use only.

This only applies to the RTA list. The ELPL list is only stored and available online so does not need a download process

1. Download the a2a_rapid_insurer_index_table_production_v??.xls (RTA) from http://www.claimsportal.org.uk/en/developers/rta-insurer-index-table/

2. Copy the data from columns B,C,D and E (InsurerName, ContactName, raPIdInsuereID, raPIdInsurerName) into another sheet - exclude the headers

3. Sort by the raPIdInsurerId and raPIdInsurerName columns. (Columns C and D in new sheet)

4. Create a formula in the free column after raPIdInsurerName =CONCATENATE(A1,"|",B1,"|",C1,"|",D1) to create a pipe (|) delimited column. Copy the formula in all rows that contain the data

5. Copy and save this pipe delimited column to the text file InsurerIDList.txt in the cManager\System folder

6. Create a Header Record at the top of the file as follows:-

HEADER|xx|dd/mm/yyyy|HEADER

where xx = version number (with leading zeros - eg. 01)

dd/mm/yyyy date Insurer List Updated

Eg. HEADER|72|28/02/2013|HEADER

7. Upload the file to http://www.derbydatabases.com/cManager/InsurerIDList_RTA.txt 

Eg. u62164718@home357282810.1and1-data.host/cManager/InsurerIDList_RTA.txt