Creating a database from a template

Database templates contain standard components. Creating a database from a template reduces the time that is taken, and ensures that databases for a specific task are created consistently.

Procedure

To create a new database from a template:
  1. Ensure that you are logged into iBase, but have no databases open.
  2. Select File > New Database.
  3. Click the Template tab.
  4. Select a template. Click View if you want to see the entity types, link types and fields in the template.
    Note: You can also create a template from a different database, and use that template instead. For more information, see Creating a template from an existing database.
  5. Click the Configuration tab, and select the database type.
  6. Click the Details tab, and enter the name of the database and some information about the purpose of the database or its contents.
  7. Click the Advanced tab, and enter the details:
    OptionDescription
    Database Identifier

    Optionally, enter a short string of text in the Database Identifier box. Do this if you want to identify entity and link records as belonging to this database. This database identifier is only necessary if you plan to perform operations outside iBase on records taken from different databases.

    Attention: The use of a database identifier has an impact on performance since the database identifier is appended to the record identifier on every record.
    Extra Detail Field for Audit Log Type the name of a field (in this database) in the Extra Detail Field for Audit Log box if you want the audit log to record the value of this field when recording actions that affect records.
    Soft Delete Turn on the Soft Delete checkbox if you want to use a two-stage process for deleting records. With Soft Delete turned off, all delete operations take place immediately. If the Soft Delete checkbox is turned on, all Delete commands mark records for deletion and make those records unavailable for most analysis, but do not delete the records.
    Read Only Turn on the Read Only checkbox if you want to make the entire database read-only, and prevent any changes to records. Users can still create sets, queries, and other folder objects.
    Security Classification Codes / Case Control Determines whether the database uses Standard Security Classifications or restricts information based on specific cases. If you select Standard (SCC), you can additionally opt to Restrict SCC lists to accessible items only. Turn on this option to restrict any lists of Security Classification Codes to accessible ones only. This setting applies when you add or edit a record that includes an SCC list.
    First Day of Week

    Displays the first day of the week as set for this database. This defaults to <System>, which is Sunday for Microsoft Access databases. For SQL databases, this is derived from the current locale as set on your machine or via the locale ID of the SQL Server machine.

    You should only need to change this if the locale on the SQL Server machine is different to your local machine or you are working with statistics and you want your week to start on a different day.

    Note: The start day of the week may affect calculations on dates and date parts.
  8. Click OK to create the database with the settings you have chosen.