Web app to capture dive logs and upload them to the cloud. The app is written specifically for BSAC Dive Managers who need to capture and submit dive logs to their Diving Officer. It allows offline capture of dive logs, and upload once internet is available again. Dive logs can be automatically sent to an upload target, such as an online spreadsheet or an email address, so that your Diving Officer can review and analyse the logs.
Several common upload targets are supported by default, and it should be fairly straightforward to add other services. Here's an example of uploading to spreadsheet on Google Drive.
The app can be used at https://cdot.github.io/DiveLog, or you can clone your own copy and host it yourself. It should work in any browser that supports HTML5.
- Visit the host website to open the app in your browser.
- (Optional, first time only) click on the gear icon in the bottom right and paste the upload key that your system administrator or Diving Officer has given you (you can do this any time before you upload).
- Enter your dives. You can enter as many as you like, they will be recorded locally.
- When you have internet again, click "Upload" to upload your recorded dive logs. You can can add several different upload targets if you need to, depending on your what your club(s) use.
The upload function is configured from an "upload key" that you give to users. This is a |-separated key string that may have many components, depending on the requirements of the store implementation. The first component is always the name of the upload target type, e.g. DriveSheet or PostCSV or MailTo. The remaining components differ for each different type.
Append to a spreadsheet on Google Drive.
(Technobabble: Unfortunately Google makes this more clumsy than it should be, due to the constraints of OAuth and CORS. We have to use Cloudflare as a proxy.)
- In the browser, log in to Google Drive as the user who is going to own the spreadsheet.
- Create the spreadsheet. Select Extensions -> Apps Script and paste the content of DriveSheet_AppScript.js
- Deploy - New deployment - Web App, Execute as Me, Anyone has access
- Copy the appscript deployment ID e.g.
AKffhgkY4a1umthcAfpkHoaeksPWtAT-q4KBZa5SJVHKyXF-MYZfk8KeDqrn8CjJkMuFIteband keep it safe.
- Log in to your Cloudflare account (Start for Free if necessary)
- Create a "Hello World!" worker
- Click "Edit code" and paste the content of
src/DriveSheet_CloudflareWorker.js - Deploy the worker. Copy the cloudflare deployment ID e.g.
sheet-proxy-d909.myusername.workers.dev. - Make a key for sharing with your users in the format
DriveSheet|<cloudflare ID>|<appscript ID>e.g.
DriveSheet|sheet-proxy-d909.myusername.workers.dev|AKffhgkY4a1umthcAfpkHoaeksPWtAT-q4KBZa5SJVHKyXF-MYZfk8KeDqrn8CjJkMuFIteb
By default the data will be uploaded to the first sheet in the spreadsheet where the App Script is deployed. You can optionally add a spreadsheet id and a sheet name to the key if you want to control this: DriveSheet|<cloudflare ID>|<appscript ID>|<spreadsheet ID>|<sheet name>.
You can compose mail for sending the logs. The key format is MailTo|<mail recipient(s)> where <mail recipient(s)> is a comma-separated list of email addresses who will be sent the mail. The rows in the log can either be formatted as comma-separated values (CSV, the default) or as a fancy text table (add |tab to the end of the key).
If you have your own server you can POST to the server to upload CSV data. The key format is PostCSV|<endpoint URL>|<username>|<password> e.g. PostCSV|https://my.server/uploadDiveLogs|myuser|secret. The repository includes a trivial node.js implementation of a suitable server in PostCSVServer.js.
There is an untried implementation for uploading to en Excel sheet on OneDrive, written by ChatGPT. It might work, but you will probably need a similar proxy approach as used for Google Drive to avoid issues with OAuth.
DiveLog was created for use by member clubs of the British Sub-Aqua Club (BSAC) by Crawford Currie. At time of writing the author is a member of BSAC but is not affiliated in any other way.
If you like this application and find it useful, you can buy me a coffee.
DiveLog is distributed under the terms of the GNU General Public License (GPL) version 3.
