Misc Manager Topics

Backup, Restore and Script Functions

The OpenBase Manager provides some tools for transferring database information to and from a bulk saved ASCII format. The Backup to ASCII and Restore from ASCII functions are accessed from the Action menu or icon. These functions transfer all information in the database including archived Objects and BLOBs. While it does save user account information, the ASCII format does not record table permissions. Another method to backup your databases is to copy the .db bundle.

Also included on the Action menu is a function for executing OpenISQL scripts. These can either be schema upgrade scripts generated by the Editing the Database Schema panel or it can be an ASCII file with a list of OpenISQL commands.

Import Tabular Data

Tabular Import gives you the ability to import flat files of delimited data into relational database structures. Its simplest application is to import a single file into a single table. However, you may want to take a single file and apply the values across a set of tables. Records in matching tables are automatically created and/or joined as needed.

To bring up the Tabular Import Window, select Import Tabular Data from the Action menu or icon.

The first step is to choose a delimited file (delimited by tabs or other characters). Please use the editor of your choice to remove any header information at the top of the file.

Figure 23: Import Setup Options

The next step is to choose the column and row delimiter that you are using in your data file as well as other options. Choosing the wrong delimiter could result in import errors.

To bring up the Setup window click the setup button at the bottom of the Tabular Import Window.

Figure 24: TabularImportWindow

Choose a primary table as a starting point for importing your data. If you are importing data into multiple tables across a one-to-many relationship, you may want to choose the "many" table as the primary table. Records in the "one" part of the relationship will automatically be created or matched as needed.

The Import Window allows you to drag attributes from your attribute list on the left onto the columns of the table on the right. Doing this matches the table column attributes with the columns of data in your file.

You can open related tables by clicking on the triangles. When you drag and drop attributes from related tables you automatically create joins in the import.

Click on the Import button to import the data.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License