The Hyundai item catalog, provided as a simple DAT file, must be periodically update/imported into the database schema xthyundai. The import is done by the following steps:
- Converting the DAT 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/importHyundaiCatalog.sh -f /tmp/art-hyd.dat
Hint: The password for the import user can be found in the keypass file.