...
We do not want to append new data to old, nor recreate container records that have previously been made.
4. Prepare the input file(s).e
Typically several text files are received with the columns shown below.
- Date formatting was once controlled to "yyyy-mm-dd hh24:mi:ss"; but these days is more likely to be "mm/dd/yyyy hh:mi:ss am".
- If initials for
measured_by
were omitted, supply some based on the email traffic.
The CSV files have content in this order. If CSV files were not provided--transform them to this format. The CSV file is expected to contain ASCII, not Unicode.
Code Block |
---|
NAME,MASS,MEASURED_BY,MEASURED_ON 18285,20.4705,tg,7/25/2014 11:56:09 AM 18286,20.4557,tg,7/25/2014 12:37:56 PM STND,20.001,,7/25/2014 12:41:13 PM ... |
If When multiple files were are provided, recommend combining combine them into a single file. Apply these changes
- If the files received do not have the above format, revise to match the pattern.
...
- The file is expected to be ASCII, not Unicode.
- Remove any records where NAME='STND'. We do not insert containers based on check standards.
- Remove any empty records resulting from empty lines.
Remove any (resent | prior duplicate) records. Shouldn't be any. But do check.
Note Verify that the lowest container number (in the NAME column) is greater in the CSV file than for any container record already in the shipboard LIMS (LIMSJR). Run the LORE > Moisture and Density > MAD Containers report for a open-ended time range to see the last batch of containers.
- Date formatting was once controlled to "yyyy-mm-dd hh24:mi:ss"; but these days is more likely to be "mm/dd/yyyy hh:mi:ss am".
- If initials for
measured_by
were omitted, supply some based on the email traffic or other records in the file.
Export the cleaned list of containers to container.csv
. This file should be checked into Subversion for future referencehttps://build.ship.iodp.tamu.edu/svn/wapps/Database/DbScript/containers
Please indicate beaker range in the Subversion the log message the beaker range that it contains.
5. "Import Data..." using SQLDeveloper
...