The FCA item catalog, provided as a zipped file, must be periodically update/imported into the database schema xtfca. The import is done by the following steps:

1. Unzipping the file
2. Converting the text file to a CSV file, compliant with the PostgreSQL bulk load format
3. Loading the CSV file into the database by using the stored procedure import_catalog.

Before importing the new catalog, the following steps must be done:

* Open the EXCEL file. Select all, copy and paste it in Notepad++. Now it should be a tab separated file with headers.
* Gzip the file and upload it to the database server.
* run the importFcaCatalog.sh script

The following shell script allows to automate these steps and can be simply called like followed:

/opt/ses/bin/importFcaCatalog.sh -f /var/tmp/TARIF700.gz