Local database settings

Octobox Designer ›› Panels ›› Databases panel ››
Parent Previous Next

Local Database Profile


Define the type and location of a local database.



Database Settings



Path

Full path of the local database file.


Edit

Click the edit button to open a pop-up showing the content of the local database.


Browse

Click the browse button to navigate to the folder and file to use as local database.



Description

Description of the database.


Delimiter

Delimiter used in the database to separate the fields.

Default value: ;


First line are labels

When checked, the first line contains the label of the columns.

Default value: checked


Fuzzy search

When checked, fuzzy matching is performed yielding more results but lower performance.


Ignore case

When checked, ignore upper and lower case writing of text.


Ignore spaces

When checked, ignore spaces in the values of the fields when comparing with the text on the document.


Ignore characters

Enter the characters to ignore in the values of the fields and the text before comparing.


Unique Id column

Select from the list the column that uniquely identifies a record. This is used to help identifying duplicates in validation.


Selected columns

Select only the columns that are used in locators and validation rules to reduce memory usage.


Columns preview

From the selected database file the first 20 rows are shown with the field names as column headers.


Save

Click the save button to save the settings.


Save as

Click the save as button to save the settings under a new name.


Cancel

Click the cancel button to close the window and return to the list of local databases.