operations:db_ncedc:nsmp_ir
Maintaining NSMP Instrument Responses
- Hardware: ----------- + Sensor class file: 1.- Run 'mv "name".stbl /home/dcmgr/responses/NSMP/Hardware/"name".stbl'. + Preamplifier class file: 1.- Run 'mv "name".ptbl /home/dcmgr/responses/NSMP/Hardware/"name".ptbl'. - Spreadsheet: -------------- + To update the NSMP instrument responses: 1.- Go into /home/dcmgr/responses/NSMP/. 2.- Generate and retrieve new spreadsheet. 3.- Run 'csvDiff.csh "old spreadsheet" "new spreadsheet"' to create the file 'sta.updated' (or edit manually the file with the sites that have been updated). 4.- Run 'Update_NSMP.csh "NSMP Spreadsheet (.csv) File" sta.updated' with the latest version of the spreadsheet. 5.- Take a look at 'error.NSMP.log."NSMP Spreadsheet (.csv) File"' to see if any errors occured. Forward the errors to Lisa (lschleicher@usgs.gov). Also run GetError.csh to find any HT population errors. (This program generates HT as well as IR information) 6.- Run '$ORACLE_HOME/sqlplus /nolog @Update_Sensor_Names.sql'. 7.- Run '$ORACLE_HOME/sqlplus /nolog @FixNet_Id.sql'. Note: If anything goes wrong in the incremental population, you can always edit the 'Version' file and set it up to '1900/01/01' for example. You can then run 'Update_NSMP.csh' with the last version of the spreadsheet to populate all the completed channels. - Refresh the Cosmos tables: cd /home/dcmgr/responses/Cosmos/txt2xml/ ./Build_NSMP.csh "nsmpYYYYMMDD" cd .. ./Update_NSMP.csh grep ORA *.log $ORACLE_HOME/sqlplus /nolog @Update_DB.sql - Regenerate the products accordingly.
operations/db_ncedc/nsmp_ir.txt · Last modified: 2023/10/25 11:39 by stephane