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

• 1. Backup Projects
• 2. Airtable Bases
• 3. Data Folder
• 4. Attachments Folder
• 5. Individual Backup Dates - In Data Folder
• 6. Backup CSV Files
• 7. Meta JSON Files
• 8. Airtable Records in Your CSV
• Full Folder Structure

1. 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

NAME FORMAT

BackupProjectName_InternalID

2. Airtable 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.

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

NAME FORMAT

AirtableBaseName_InternalID

3. Data Folder

Each Airtable Base folder contains a Data folder and Attachments folder

The Data folder contains your CSV files of your Tables in each Airtable base

Backups Project > Airtable Base > Data Folder + Attachments Folder

4. Attachments Folder

The Attachments folder contains folders of each Table. Inside each Table folder are the Attachments inside that specific Table.

NAME FORMAT

AirtableAttachmentFieldID_RecordID_InternalAttachmentID.ExtensionType

5. Individual Backup Dates - In Data Folder

Inside the Data Folder, On2Air Backups creates a new Backup Folder for each Backup. Each Backup is labeled as the Date of the Backup and contains CSV files of the data backed up on that date.

NAME FORMAT

BackupDate_InternalID

6. Backup CSV Files

Inside of each Backup folder are the CSV Files containing the data of each Table in your Airtable base on the Date is was backed up.

NAME FORMAT

TableName.csv

7. Meta JSON Files

Inside the Individually dated Backups will also be a Meta.json file. This contains all the structure and meta data of your Base at the time of the backup. Use the tutorial below to learn how to view the Meta.json file inside of On2Air Backups

8. Airtable Records in Your CSV

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'
)

Full Folder Structure

Backup Project Name > Each Airtable Base Folder

Each Airtable Base Folder > Data Folder > Individually Dated Backups Folder > CSV Data Files + Meta.json File

                          > Attachments Folder > Table Folders > Individual Attachments