CESL1410 will check the CalCOFI Line and Station number on the sample form when [Save] is selected. It uses the lat & lon to calculate the correct Line & Station and compares it to the values on the form. The user will be prompted to click 'Yes' to correct the error, 'No' to ignore the error, or 'Cancel' to abort the Save process and hand-enter or double-check value correctness.

ERDDAP is installed and working on siocalcofi.ucsd.edu. The hydrographic database is being built using Bullzip Access to Postgresql utility. It is a very slow process compared to Bullzip's Access to MySQL utility. But since it is working, I am building a database with multiple tables instead of the standard web-version two tables - cast & bottle. I hope this will allow users to query the database more effectively.

The slowness of database building is due to the 844109 hydrographic records. Bullzip Access to Postgresql only seems to create two tables before the session times-out. It may be a siocalcofi.ucsd.edu server setting disconnecting. At least it works.

I have already created a database that duplicates the original hydrographic database. So I hope to have both online tomorrow provided, now that I am using postgresql instead of MySQL, my datasets.xml will work.

My original attempts to connect ERDDAP to MySQL using com.jdbc.mysql.Driver did not work. I considered mariadb as well but now that postgresql is up, running, and populating, I am hopeful ERDDAP will serve the datasets using org.postgresql.Driver as authored by LD.

CESL v1410 checks the Line & Station number before saving using the Line & Station derived from the latitude and longitude. If either Line or Sta are incorrect, CESL will prompt the user to auto-correct the fields before saving the sample log & files. Selecting "Yes" will change the incorrect value and continue saving & printing; "Cancel" cancels the saving, allowing the user to edit the form before re-saving; selecting "No" continues the save process, ignoring the error.

I've added a datacode checker for sta.csvs & t.csvs to DECODR's CSV tab. Give it a try and let me know how it works. It will backup the original files up to the bak subdir as usual.

What it does:
Changes the Sigma-theta datacode (StDC; col 61) to match Salt datacode (SDC; col 21)
Changes the Potential T datacode (PoTSDC; col 69) to match Salt datacode (SDC; col 21)
Changes the DynHt datacode (DyHDC; col 72) to match Salt datacode (SDC; col 21)
Changes the SVA datacode (SVADC; col 75) to match Salt datacode (SDC; col 21)

Changes the OxSat datacode (OxSDC; col 65) to match Oxygen datacode (SDC; col 26)

Optional via checkbox
Change the Oxygen umole/Kg datacode (OxMDC; col 85) to match O2 datacode (ODC; col 26)

DECODR counts how many depth records it changes. If you want to know how many records are corrected for a particular station, run it on the individual station. If one bottle record has multiple code corrections, the tally will still be one. Not the total datacodes changes for that depth record.

Selective column editor is not saving the columns properly - fixed. Both All Column and Selective Column sta.csv editing is working properly in SEaptv06.exe.