CPC 3775_logger

Python utility to read the output from a TSI CPC3775 and optionally upload data to a PostgreSQL database.

The script requests the 1 second buffer from the CPC, timestamps it and saves it to a file. Optionally, it can send data to a database.

Modules required

• pyserial
• psycopg2
• time
• subprocess

Usage

The settings are specified in the settings.txt file which should look like:

/dev/ttyUSB0
/home/logger/datacpc3775/
local,0
user=datauses password=l3tme1n host=penap-data.dyndns.org dbname=didactic port=5432
408,409,1
## Only the first lines are processed.
1 <SERIAL PORT ADDRESS>
2 <DATA SAVE PATH>
3 <local|database for storage>,<COMPRESS DATA? (1 = YES)>
4 <DATABASE CONNECTION STRING>
5 <DATABASE INSERT IDs>

There are two scripts to run:

• logger_main.py. This is the main logging script and the one that interacts directly with the CPC. It must be run manually and it will continue to run until stopped by ^C. The outputs from this script are one datafile named YYYYMMDD.txt with the 1 second data and a SQL/inserts.sqlwith the SQL statements to update the database with the 1 minute average data.
• upload_batch_sql.py. This is the database updater and it it recommended to be run as a cron job every 5 to 10 minutes. Sample cron job:

*/5 * * * * /home/logger/cpc3775/logger_main.py >> /home/logger/log

Modules required

• pyserial
• psycopg2
• time

For details contact Gustavo Olivares

License

Please refer to the license file