Backup Folder Structure and File Name Convention in On2Air Backups

On2Air Help Center > On2Air Backups Start a free trial

Here’s how your files and attachments are structured and labeled inside your storage drive with On2Air Backups

In this tutorial

• Backups and Backup Projects
• Bases
• Tables
• Records
• Attachments

Backups and Backup Projects

Each Backup scenario you create in On2Air Backups is a Backup Project. You can add a single or multiple Airtable bases to a Backup Project.

Here’s an example of a Backup Project named Company Data that contains multiple Airtable bases that are backed up.

The main folder in your storage drive is the name of your Backup Project in On2Air Backups

Bases

Once inside the Backups Project folder in your storage drive, you’ll see a list of all the Airtable bases in your Backups project.

Bases are labeled by the Base name and the internal On2Air database ID

BaseName_InternalID

JSON Files

You’ll also see a latest_sync.json file

The JSON file contains data about your backup such as date backed up, number of bases, tables, attachments internal IDs, updated date, and other data.

Tables

Inside each Airtable Base folder are CSV files for each Table in your Base.

They are labeled:

TableName.csv

Depending on your storage system, you may need to download them to your device to view as a CSV.

Records

Each Airtable record will be a row in your CSV.

Most field types are displayed just like they are in your Airtable base. However, there are a few that display differently.

Linked Records - These will be displayed as a Record ID to ensure proper mapping of each unique linked record

• To “visualize” a Linked Record value, add a Lookup field in your base for each Linked Record field to view the name of the linked record

Attachments - You’ll see the auto-generated Airtable URL of each attachment. Attachment URLs in a single field are separated by a comma (,)

Dates - Dates are represented as YYYY-MM-DDTHH:MM:SS.SSS

• To “visualize” a standard format date, add a Formula field in your base that uses the SET_TIMEZONE and DATETIME_FORMAT operator
• See all Timezone options
• See all DATETIME_FORMAT options

DATETIME_FORMAT(
  SET_TIMEZONE(
    Created, 'America/Los_Angeles'),
  'MM-DD-YYYY h:mm A'
)

Attachments

Inside each Table folder is a folder labeled attachments for all the attachments in that specific folder. Attachments are exported in the same file format they are in our Airtable base.

Attachments are labeled in the following format in their respective folder

Attachments naming convention:

<field_id>_<record_id><attachment_id>_<modified_attachment_name>.<ext>