search

qatrackplus / qcpump

QCPump is an extensible utility for extracting data from various sources (databases, filesystem etc) and moving it to other locations. The primary use of QCPump is currently for extracting data from SNC Daily QA3 databases (Firebird & Atlas) and uploading it to QATrack+ via QATrack+'s API.
MIT License
6 stars 3 forks source link

qcpump for FFF beams with new DQA3 sql database #5

Closed dean-wilkinson closed 2 years ago

dean-wilkinson commented 2 years ago

In the process of testing qcpump with the SQL DQA3 v1.06 database I came across a feature in the new database which is different from the previous Firebird SQL database for measuring QA beam flatness on a FFF beam.

In the SQL version of the database, rather than measuring QA flatness for FFF beams it reports a different parameter BSC (beam shape constancy - see screenshot attached). This value resides in a different column to QA Flatness in the DQA3_TREND table in the DB schema and the reported QA Flatness value is 0.00 which is what comes across with the qcpump. If i have interpreted correctly, the BSC value column is RESULTS_BCS2 in the DQA3_TREND table in the SQL database.

Is it possible to modify the QC pump code to point to this BSC parameter in the table for FFF beams?

BSC_DQA3 )

randlet commented 2 years ago

Hi @dean-wilkinson, thanks for the heads up on that! I added all the bsc{1,2,3} columns for the next release (being released shortly).

randlet commented 2 years ago

Resolved in 84e9f1ddd09cd3d

dean-wilkinson commented 2 years ago

Thanks Randy! Fantastic that it is already available in the next release :)