...

When the NLPG Importer runs a log file will be written to the Logs sub folder where the Python script resides e.g. C:\Python\NLPG Importer\Logs.

Installation & Configuration

...

The NLPG Importer requires PyGreSQL, the PostgreSQL module for Python, which may be installed from the following location http://www.pygresql.org/. PyGreSQL is an open-source Python module that interfaces to a PostgreSQL database.

...

First install and configure the NLPG Importer Importer by doing the following:

• Step 1 - Extract the contents of the supplied zip file & create the folders for the NLPG Importer
• Step 2 - Create the database and add the database scripts
• Step 3 - Configure Settings

...

Files received from the NLPG hub will be copied, by the customer, into a processing folder (Pending) and an archive folder (Archive). The importer will then process each file in order of datestamp (oldest first). Once a file has been successfully processed it will be placed into a Completed folder.

The NLPG Importer will iterate through the file line by line and will copy the contents of the line into one of four separate csv files.

...

The Unique Identifiers for each record type are as follows:-

A Data Share connection to each of the four views in the NLPG Postgres database will need to be created in iShare Studio.

...