Skip to end of metadata
Go to start of metadata

NB "all tables export" also creates a time-stamped backup copy of the database file, and "Screen Element join table export" also creates a time-stamped copy of the screen element join table file.

Page Index
Quick Links

Exporting Manually from the Server

To export all tables (.csv files) to Candidates

Scripts > Export > Export - All Tables to Candidates (Server access only)

To export Screen Element join table to Candidates

Scripts > Manage Scripts > Export - Screen Element Join Table to Candidates (Server access only)

Exporting Manually using Remote Access

To export all tables (.csv files) to Candidates

  1. run script _export_tables_ with a local directory as a parameter e.g., "filemac:/Macintosh HD/Database Exports/"
  2. WebDAV files to userexperience.oceanobservatories.org/database-exports/Candidates

To export Screen Element join table to Candidates

  1. run script _export_jt_ScreenElement_ScreenElement_ with a local directory as a parameter e.g., "filemac:/Macintosh HD/Database Exports/"
  2. WebDAV files to userexperience.oceanobservatories.org/database-exports/Candidates

Automatic Exports

The _export_timer_ script is automatically scheduled to be run every 15 minutes when the database file is opened by the OPS account on the server. It exports:

Frequency Export contents Destination
Nightly (3-4 am) All reports database-reports
Nightly (3-4 am) All tables database-exports/Nightly
Nightly (3-4 am) All tables database-exports/Hourly
Every call Screen Element join table database-exports/Hourly

database-exports Folders

Export or promotion to Candidates or Stable requires human-in-the-loop decision and action.

Folder Purpose
Stable Most tested export. Used to load ion-beta.
Candidates Export being tested. Used to load ion-alpha.
Nightly Automatic nightly export of all tables.
Hourly Automatic nightly export of all tables, augmented by frequent updates of Screen Element join table.
Auto delete of exports
The following has been added to /etc/cron.daily/tmpwatch on userexperience to auto delete exports

Hourly - keep 1 day

Nightly - keep 30 days

Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.