Exporting Datastores

Exporting DataStores to AirTable

Datastore is extremely outdated and buggy. Because of this we consider Datastore to be end of life. This means no more bug fixing, or further development. But never fear, there is built in functionality to export Datastore as an Excel file or exporting directly to AirTable.

1. You can create a Free AirTable Account or a paid Team or Business Account. ANR IT does not provide AirTable accounts, so it is up to your organization to set up a paid account.

2. Log in to AirTable. Add a Base.

3. Navigate to an existing Site Builder Site with existing Datastore.

4. Click on Datastores link the left hand navigation.

5. Click on the Data Button for the Datastore you want to export.

6. Click on the Export Data to AirTable link.

7. If you are logged in to AirTable you should be able to click on the Authorize AirTable Button.

8. Click on the Authorize AirTable Button, and you'll get taken to a page titled UC ANR Sitebuilder Integration is requesting AirTable Access.

9. Click on Add a Base. The Integration page will show the Bases you have access to. Choose the appropriate Base.

10. Click Grant Access.

11. You are redirected back to the DataStore / AirTable export page. Click on the Export my Data

12. If the data already exists, you will see an orange button labeled Export My Data & Confirm Data Append. Otherwise you'll see "Datastore has been exported to Airtable"