Integration: Import/Export

The Integration: Import/Export link contains links for exporting OpenAir account data and batch data.

Exporting Account Data

You can export all of your account data in a comma- or tab-delimited text file format. You can also export account data in MySQL format, so you can then import it to a MySQL database.

Additional export options include exporting your Account specific WSDL and XSD schema files.

To export account data in text format:

Note:

This process creates a MySQL file for the version of MySQL currently in use by OpenAir. The currently supported version is named on the Export data as MySQL file screen. The exported MySQL file can be imported into a MySQL database where queries and reports can be run against it.

1. Go to Administration Global Settings > Account and click Integration: Import/Export.

2. In the Import/Export screen, click the All data in text format link.

3. In the Choose which tables to exclude list, select any tables to exclude from the text file.

   Tip:

   If you only want to include a small number of tables, first click Select all to exclude all tables, and then select the tables you want to include. In addition, audit trail information can increase the table size significantly. If you do not need audit trail information, select the “Suppress the audit field data” option, which may significantly reduce the size of the generated file, and generate results more quickly.

   Warning:

   Larger tables, such as assign_by_day, booking_by_day, schedule_by_day, and user_tag_by_day, for example, are excluded from text exports. These tables can be exported using the Automatic Backup Service (ABS). For more information, see Automatic Backup Service.

4. Select which text delimiter you want to use in the file. Text files can be comma- or tab-delimited, or you can select a regional setting CSV list separator.

5. Select the data layout format:

   • Column titles in first row — text file includes column titles for your data in the first row of the text file

   • No titles in data — the text file only includes data, and does not include column titles

6. Select a new line format. You can use Windows, Macintosh, or UNIX new line format.

7. Select the Suppress the audit field data option if applicable.

8. Click Export. OpenAir will create a ZIP file containing the generated data.

   

9. Click the Click here link to download the ZIP file with your data.

   

To export account data in MySQL format:

1. Go to Administration Global Settings > Account and click Integration: Import/Export.

2. In the Import/Export screen, click the All data in MySQL format link.

3. In the Choose which tables to exclude list, select any tables to exclude from the MySQL file.

   Tip:

   If you only want to include a small number of tables, first click Select all to exclude all tables, and then select the tables you want to include. In addition, audit trail information can increase table sizes by a significant amount. If you do not need audit trail information, select the “Suppress the audit field data” option, which may significantly reduce the size of the generated file, and generate results more quickly.

   Warning:

   Some tables, such as by_day, are excluded from MySQL exports. These tables can be exported using the Automatic Backup Service (ABS). For more information about ABS, see Automatic Backup Service.

4. Click Export. OpenAir will create a ZIP file containing the generated data.

   

5. Click the Click here link to download the ZIP file with your data.

   

Exporting Your Account-Specific WSDL

You can export the WSDL specific to your account, which includes custom fields configured on your account. Account administrators and users with the Export data role permission and relevant access can use a short URL to download the file automatically.

To export your Account specific WSDL:

1. Go to Administration Global Settings > Account and click Integration: Import/Export.

2. In the Import/Export screen, click the Account specific WSDL link. Your account-specific WSDL will open in your browser.

Exporting the XSD Schema Files

Use this feature to export the XSD schema files without the need to contact OpenAir Customer Support.

To export the XSD schema files:

1. Go to Administration Global Settings > Account and click Integration: Import/Export.

2. In the Import/Export screen, click the XSD schema files link. OpenAir will create a ZIP file containing the generated data.

3. Click the Click here link to download the ZIP file with your data.