About Capaho Data Manager
Capaho Data Manager is a freestanding SQL database management tool designed to provide the full power of SQL database management through an intuitive, easy to use graphical user interface. It is fully self-contained, creating and managing its own database files.
Capaho Data Manager allows a person with no knowledge of Sequential Query Language to fully manage their data, while also providing power users with a query tool to manage their files by manually entering SQL commands in the traditional manner.
Creating a Database
To create a new database, click on the Add Database button on the Data Manager panel to bring up the new data window.
Enter a name for the new database as well as the name of the first table for the database and the first column for the table.
Database, table and column names cannot contain spaces, so any spaces entered into those fields will be replaced with the underscore “_” symbol in the database file.
Any type of data can be stored in any data cell, so it is not necessary to specify a column type. An initial value can also be provided for the first cell of the first row of the first column, or it can be left blank.
To import a Capaho Data Manager database file created on a different computer, or a backup copy of a database file from the backup folder, select Import from the File menu.
Then select an appropriate database file from the file manager window.
Adding a Table
To add a table to an existing database, click on the Add Table button on the Data Manager panel to bring up the new data window.
Enter a name for the new table and the first column for the table. An initial value can also be provided for the first cell of the first row of the first column, or it can be left blank.
Adding a Column
To add a column to an existing table, click on the Add Column button on the Data Manager panel to bring up the new data window. If the new column will contain pictures or files, use the Import button to select a picture or file for the Initial Value of the new column.
Select a picture or file to import from the file manager window.
If a picture is imported, a thumbnail of the picture will appear in the column cell. If a file is imported, the file name will appear in the column cell.
Adding a Row
To add a new row to an existing table, click on the Add Row button on the Data Manager panel to add a new row directly under the last row.
Editing a Cell
In order to reduce the risk of accidentally deleting or damaging data, cells are locked by default. To add data to a new row (or edit existing data) it is first necessary to unlock the cells.
An individual cell can be unlocked by right-clicking in the cell, then selecting Unlock Cell from the popup menu. This will open the Text Editor for editing the cell data.
Clicking the Edit button on the Text Editor will put the text field in edit mode.
As an alternative to unlocking individual cells, the global cell lock tool on the Data Manager panel can be used to unlock all of the cells in the table.
CAUTION: Leaving the global cell lock tool set to unlocked increases the risk of accidentally deleting or overwriting existing data.
After unlocking the cell(s). Click in the desired cell to open it for editing.
Clicking the View button on the Text Editor will put the text field in read-only mode.
Binary data cannot be edited, however, so if the cell contains picture or file data, an error message will be returned if you attempt to edit it. Binary data must be deleted from the cell first before the cell can be opened for editing.
If the cell is to contain a picture or file, right-click in the cell to open the popup menu, then select the Import File option to import a file or picture into the cell, or the Paste Picture option to paste a picture into the cell from the clipboard.
After adding or editing cell data, use the Save Changes or Cancel Changes buttons to either save or cancel the new data. Clicking on Save Changes will replace the existing data in the database with the new data from the cell. Clicking on Cancel Changes will delete the changes from the cell and reload the existing data from the database.
Managing Data
A variety of options are available for managing the data in individual cells. Right-clicking on a cell brings up the popup menu for the cell. The menu options for a given cell will vary depending on the type of data it contains and whether it is locked or unlocked.
Show Clipboard will display the current contents of the clipboard if it contains text or pictures.
Unlock Cell will unlock the cell for editing.
Export File will open a file management window that will allow the data contained in the cell to be exported as a file.
Import File will open a file management window that will allow you to import a file or picture into the cell.
Copy will copy the cell data to the clipboard.
Paste Picture will paste a picture into the cell if one is present on the clipboard.
Delete Cell Data will delete the current cell data. This option does not appear if the cell is empty.
Open in Text Editor will display the cell text in a separate window, where it can be read, edited or printed.
Show Data Type will display information about the cell and the data it contains, in addition to how much system memory the selected table is using. If the cell contains an imported file, the file name will also be displayed.
Column Position will open a control window that will allow you to change the order of the columns by dragging the column names to the desired position.
If the cell contains picture data, the popup menu will contain the following options:
Open File will open a stored file in the default application associated with its file extension. This option will not appear if the cell does not contain file data.
Open in Picture Viewer will display the stored picture (or the first page of a PDF file) in a separate window where it can be viewed or printed. This option will not appear if the cell does not contain picture data.
If a locked cell is blank or the column contains only numeric data, Increment and Time Stamp functions will appear in the popup menu:
Cell Up will increase the numeric value contained in the selected cell by one from the value contained in the preceding cell.
Cell Down will decrease the numeric value contained in the selected cell by one from the value contained in the preceding cell.
Column Up will increase the numeric value contained in each cell of the column by one from the value contained in the first cell.
Column Down will decrease the numeric value contained in each cell of the column by one from the value contained in the first cell.
Abbreviated Date will insert the current date in abbreviated notation.
Long Date will insert the current date in long notation.
Long Time will insert the current time in long notation.
Short Date will insert the current date in short notation.
Short Time will insert the current time in short notation.
SQL Timestamp will insert an SQL timestamp.
The popup menu for an unlocked cell displays additional options related to editing:
Using the Report Tool
Data displayed in the table data section of the main panel can be viewed in a print preview style window by clicking on the Report button, where it can be viewed or printed.
The Printer Resolution (DPI) setting can be used to adjust the printer resolution at the time of printing from 72 DPI up to the maximum supported by the printer. Depending on the printer, any number less than the maximum resolution may default to 72 DPI.
If one or more rows are selected, only the selected row(s) will appear in the report window. If a column header is pressed, only the data in that column will appear in the report window. If a column header is pressed and one or more rows are selected, only the data in the selected cells in that column will appear in the report window.
Sort by Column
The data displayed in the Table Data listbox can be sorted by column by pressing on the desired column header and then pressing the Sort button on the main panel. Clicking on the Sort button more than once will alternately sort by ascending and descending order. The arrow displayed in the column header during a sort indicates the direction of the sort.
Using the Query Tool
The Query Tool allows key word searches of the text stored in a table and gives power users the ability to manage data using Sequential Query Language.
To search for specific text, simply enter the search term in the text box and click Query. If the Match Cell option is selected, only cells that contain matching text will display.
If the Match Row option is selected, the entire row will be displayed for cells that contain matching text.
If the Report button is clicked following a key word search, only the matching data will be displayed.
Advanced Query (SQL Query)
Checking the Advanced checkbox on the Query Tool panel changes it from a simple search tool to an SQL command line, allowing for Sequential Query Language to be used.
Clicking on the Refresh button on the Main Panel following a query will clear the query results and reload the table data from the database. If an advanced SQL query was used, any changes made to the table data will be reflected.
Encrypted Database Files
Database files containing sensitive information can be encrypted and access restricted with a password. Encrypted database files appear with a closed padlock next to their names and will not display any data unless a valid password is supplied.
Select a database to encrypt and then click on the Encrypt button on the main panel to encrypt the selected file.
Enter a password of at least four characters to be used for the encrypted database file in the password field.
After clicking on the Encrypt button in the password window you will be asked to confirm the password by entering it again.
After the password has been entered correctly a second time the database file will be encrypted.
To unlock an encrypted database, enter the correct password in the prompt window that appears when the database file is selected and click Go.
An encrypted but unlocked database file will appear with an open padlock next to the database file name. It will remain unlocked until Data Manager is closed. To lock the database file manually, right-click on the database file name and select Lock from the popup menu. Repeating the encrypt procedure with a new password will lock the file and change its password.
The data contained within an encrypted but unlocked database file can be managed as usual, but file management operations cannot be performed on an encrypted database file itself. To rename or delete an encrypted database file, it must first be unencrypted and Data Manager must be restarted before proceeding.
To decrypt an encrypted file, click the Encrypt button on the main panel, enter the password in the password prompt, then click the Decrypt button. This will completely decrypt the file and remove its password.
Attaching a Database
It is possible to attach the tables of one database to another database, combining the data into a single database, by clicking on the Attach Database button in the main panel.
In the Attach Database Files panel, specify the source database for the tables to be combined, and the target database that will receive the tables from the source. If the source database and the target database both contain tables with the same name,
a table conflict will result. Selecting the Do nothing option will prevent tables in the target database from being overwritten by tables of the same name from the source database.
Selecting the Replace target data option will cause tables in the target database to be overwritten by tables of the same name from the source database.
Clicking the Go button on the Attach Database Files panel will result in the tables from the source database being attached to the target database.
Renaming a Table
To rename an existing table, select the table to be renamed and click the Rename Table button on the main panel.
Enter a new name for the table in the New Data panel.
Database Backup & Restore
Database files can be backed up to a subdirectory of the data folder by selecting Backup Database Files from the File menu. All databases listed in the Database List of the main panel will be backed up.
To retrieve a backup file, select Import Database from the File menu, then navigate to the backup directory located inside the data directory located in the DMDBFiles directory in the application data or application support folder for the user account on the computer.
Deleting a Database
To delete a database, select the database to be deleted, then click the Delete Database button on the main panel.
Click Delete on the confirmation box to delete the selected database.
Renaming a Database
To rename a database, select the database to be renamed, then click the Rename Database button on the main panel.
Enter the new name for the database in the New Data panel.
Deleting a Table
To delete a table, select the table to be deleted, then click the Delete Table button on the main panel.
Renaming a Column
To rename a column, select the column to be renamed, then click the Rename Column button on the main panel.
Enter the new name for the column in the New Data panel.
Deleting a Row
To delete a row, select the row to be deleted, then click the Delete Row button on the main panel.
To delete a column, select the column to de deleted by clicking on its title bar, then click the Delete Column button on the main panel.
Data Manager Preferences
The Data Manager Preferences Panel can by accessed by clicking on Preferences in the Settings menu in Windows or the application menu in OS X.
The Backdrop setting allows you to add, change or remove a backdrop for the Main Panel.
Preset backdrops can be selected from the drop down menu. Clicking on the Set button sets the backdrop on the Main panel to provide a preview. To use your own image for the backdrop, click the Import button, then choose an image file to import.
If the imported file is larger than the main panel, the picture will be scaled to fit. If it is smaller than the main panel, it will be tiled.
The Background Color setting allows you to set, change or remove a background color for the Main Panel.
Clicking on the Change button under Background Color will bring up the color picker for the OS on which Data Manager is running.
Clicking on the Set button for Background Color will set the color for a preview.
The Text Color setting allows you to change the text color of the labels on the Main Panel.
Clicking on the Change button under Text Color will bring up the color picker for the OS on which Data Manager is running.
Clicking on the Set button for Text Color will set the color for a preview.
The two checkboxes at the bottom of the Settings panel set the backup options for database files. To automatically backup the database files each time Data Manger is started, enable the checkbox next to that option.
To automatically delete backup files after a specified number of days, enable the checkbox next to that option and specify the number of days to keep backup files before they are deleted.
To permanently save any changes made in the Panel Settings, click the Save button.
File Menu
Import Database - Import a database file made with Data Manager on another computer or from the backup folder into the data folder
Export Database - Copy a database file from the data folder to another location
Vacuum Database - Removes empty space and unused indexes left behind after data is deleted, reducing the size of the database file.
Backup Database Files - Back up the current database files to the backup folder
File Cleanup - Delete backup files that are older than the time period specified in the Preferences Panel
Quit - Quit the Data Manager application
Edit Menu
Cut - Cuts the selected text from the active text field and copies it to the clipboard
Copy - Copies the selected text in the active text field to the clipboard
Paste - Pastes text from the clipboard to the active field
Delete - Deletes the selected text from the active field
Select All - Selects all text in the active field
Settings (Windows & Linux)
Data Manager (Mac OS X)
Preferences - Opens the Preferences Panel
Window - Lists all open Data Manager windows.
Help
Help - Opens the help file in the default PDF reader
About - Information about the Data Manager application
Notes
The database functions in Capaho Data manager are based on SQLite. Information on SQLite query commands and syntax can be found at http://sqlite.org.
Capaho Data Manager, this help file, and all text and graphics that accompany this application are copyrighted materials and may not be copied or redistributed without the express written consent of Capaho International, LLC.
Copyright © 2010 Capaho International, LLC All Rights Reserved
