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:
- Unzipping the file
- Converting the text file to a CSV file, compliant with the PostgreSQL bulk load format
- Loading the CSV file into the database by using the stored procedure import_catalog.
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
Hint: The password for the import user can be found in the keypass file.