MySQL<\/a> – partly because of the ease of loading from .csv files.
\nHowever, please don’t ask me for support on these products – I’m not that much of an expert.<\/p>\nWith Excel, you’ll need to insert field names in the top line of the spreadsheet, when save as an Excel file.
\nI used the following headings when using Excel:
\n[code lang=”dos”]Sequence DiveNo Dive_date Time_Down Series Dive_in_series Dive_time Surface_Interval Maximum_depth Average_depth Sample_rate_ 1 Computer_ID Personal_Information Sample_Rate_2 Gas_Model Altitude Personal_Mode Profile Location Dive_Site Weather Visibility Air_temperature Water_temperature Water_temperature_at_max Buddy1 Dive_leader Boat Tank Capacity Unknown1 Working_pressure Start_pressure End_pressure SLE_Consumption Unknown2 Dive_type Dive_school GPS Buddy Custom5 Weight NitroxO2Pct OLF OTU1CNS2[\/code]<\/p>\n
Note that the fields “Dive_type”,” Dive_school”,”GPS”,”Buddy” and “Custom5” are the 5 custom fields on the Dive Tab.
\nIt looks like there’s just the one format in SDM 1.6, but some of the “Unknown” fields may be used by other computer models. If you have input on this, please email me.<\/p>\n
I use the following script to build the table (called “divelog”) in MySQL (having set up a database called “divelogs”):
\n[code lang=”sql”]
\nDROP TABLE IF EXISTS `divelogs`.`DiveLog`;
\nCREATE TABLE `divelogs`.`DiveLog` (
\nSequence varchar(200),
\nDiveNo varchar(200),
\nDive_date date,
\nTime_Down varchar(200),
\nSeries varchar(200),
\nDive_in_series varchar(200),
\nDive_time_Seconds float,
\nSurface_Interval_Seconds float,
\nMaximum_depth varchar(200),
\nAverage_depth varchar(200),
\nSample_rate_1 varchar(200),
\nComputer_ID varchar(200),
\nPersonal_Information varchar(200),
\nSample_Rate_2 varchar(200),
\nGas_Model varchar(200),
\nAltitude varchar(200),
\nPersonal_Mode varchar(200),
\nProfile varchar(200),
\nLocation varchar(200),
\nDive_Site varchar(200),
\nWeather varchar(200),
\nVisibility varchar(200),
\nAir_temperature varchar(200),
\nWater_temperature varchar(200),
\nWater_temperature_at_max varchar(200),
\nBuddy1 varchar(200),
\nDive_leader varchar(200),
\nBoat varchar(200),
\nTank varchar(200),
\nCapacity varchar(200),
\nUnknown1 varchar(200),
\nWorking_pressure varchar(200),
\nStart_pressure varchar(200),
\nEnd_pressure varchar(200),
\nSLE_Consumption varchar(200),
\nUnknown2 varchar(200),
\nDive_type varchar(200),
\nDive_school varchar(200),
\nGPS varchar(200),
\nBuddy varchar(200),
\nCustom5 varchar(200),
\nWeight varchar(200),
\nNitroxO2Pct varchar(200),
\nOLF varchar(200),
\nOTU1CNS2 varchar(200)
\n) ENGINE=InnoDB DEFAULT CHARSET=latin1;
\n[\/code]<\/p>\n
… then load the data through this script :
\n[code lang=”sql”]
\ndelete from divelogs.divelog;
\nLOAD DATA INFILE ‘[put your full path in here]My Documents\/My DataFiles\/Divelogs.csv’
\nREPLACE
\nINTO TABLE divelogs.divelog
\nFIELDS
\nTERMINATED BY ‘,’
\nOPTIONALLY ENCLOSED BY ‘”‘
\nESCAPED BY ‘|’
\nLINES
\nTERMINATED BY ‘\\n’;
\nALTER TABLE `divelogs`.`divelog`
\nADD COLUMN `Dive_Time` TIME AFTER `OTU1CNS2`;
\nALTER TABLE `divelogs`.`divelog`
\nADD COLUMN `Surface_Interval` TIME
\nAFTER `OTU1CNS2`;
\nupdate divelogs.`DiveLog`
\nset Dive_Time =
\ncast(
\n(cast((Dive_Time_Seconds \/ 3600) as UNSIGNED) * 10000) +
\n(cast((mod(Dive_time_Seconds , 3600) \/ 60) as UNSIGNED) * 100 +
\nmod(Dive_time_Seconds, 60)
\n) as TIME) ,
\nSurface_Interval =
\ncast(
\n(cast((Surface_Interval_Seconds \/ 3600) as UNSIGNED) * 10000) +
\n(cast((mod(Surface_Interval_Seconds , 3600) \/ 60) as UNSIGNED) * 100 +
\nmod(Surface_Interval_Seconds, 60)
\n) as TIME)
\n[\/code]
\n… The last two segments convert SDM’s “seconds” based fields into TIME type fields<\/p>\n
Don’t forget to test the connection.<\/p>\n","protected":false},"excerpt":{"rendered":"
Well, it’s fairly straightforward in principle, if you’ve played with relational databases . Export the data from SDM, load it into an ODBC \/ JDBC data source, then access it from JAlbum. The Dive number is used as the key; this is attached to the photos as a structured keyword in Elements (I’ll explain that […]<\/p>\n","protected":false},"author":3,"featured_media":0,"parent":24,"menu_order":1,"comment_status":"closed","ping_status":"open","template":"","meta":{"_mi_skip_tracking":false},"_links":{"self":[{"href":"https:\/\/muttznutz.net\/muttzblog\/wp-json\/wp\/v2\/pages\/25"}],"collection":[{"href":"https:\/\/muttznutz.net\/muttzblog\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/muttznutz.net\/muttzblog\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/muttznutz.net\/muttzblog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/muttznutz.net\/muttzblog\/wp-json\/wp\/v2\/comments?post=25"}],"version-history":[{"count":0,"href":"https:\/\/muttznutz.net\/muttzblog\/wp-json\/wp\/v2\/pages\/25\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/muttznutz.net\/muttzblog\/wp-json\/wp\/v2\/pages\/24"}],"wp:attachment":[{"href":"https:\/\/muttznutz.net\/muttzblog\/wp-json\/wp\/v2\/media?parent=25"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}