![]() |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
MobileDB Lite
users must utilize a MobileDB converter
to create MobileDB databases or download
existing MobileDB databases from the Internet. There is
no difference between MobileDB Lite and MobileDB databases. MobileDB Tools and ConvertersThere are many MobileDB tools and converters available for both PC and Macintosh. The most popular and most useful converters, are Handmark's own MobileDB-PC, MobileDB-Excel, and MobileDB-FileMaker. These tools allow you to create MobileDB databases on your PC or Mac then install them on your Palm OS device. Most of these tools also allow you to open the backup MobileDB databases from your Palm OS device (in your c:\palm\<username>\backup directory) to edit or export as a comma separated file. You can find a list of all MobileDB tools at and detailed descriptions at http://www.handmark.com/products/mobiledb.html There are a growing number of pre-developed, generic-content MobileDB databases available for your use. Check out the Handmark database archive to find those of interest to you. The MobileDB database archive is available at http://www.mobiledb.com. Remember - if
you have created a database that other MobileDB users may be interested
in, please send it to us so we can make it available for other users.
The database submission instructions are available at http://www.mobiledb.com. UsageStart upTo begin using Handmark MobileDB, simply tap the appropriate icon on your application screen. Enter your product serial number on the serial number screen and you're ready to use MobileDB. Until you purchase a product serial number, you can only use the application for 15 days. When first installed,
the MobileDB application will launch into the database list view.
If you previously exited the application while in a database, the
same database will be opened automatically on the next start up.
This allows you to access the same database repeatedly without having
to reselect the database. Database List ViewThe database list view allows you to select an action to perform, a database on which to perform the action, create a new database, or view the status (locked, location, database size, and so on) of each database. Select the category at the top right of the screen to view the databases in that category. To open a database for viewing or editing, tap Open, then tap the database name in the database list. The database appears and you will see the 'Record List' view with the database name at the top of the window. To categorize a database, tap Info, then tap the database you want to categorize. Tap the Category box and select an existing category or create a new category. When databases are stored on a memory card, they will only be visible in the "All" and "Undefined" categories To beam a database, tap Beam, then tap the database name that you want to beam. The application searches for another PalmOS device, then beams the database and the other unit, asking the recipient if they would like to "Accept" the database. Once the database has been beamed, the action selection will returns to the default, "Open." Keep in mind, that the "receiving" device must have MobileDB or MobileDB Lite already installed in order to access the MobileDB database. If necessary, you can beam the other user MobileDB or MobileDB Lite through the "Beam" menu option available on the Palm OS applications menu. To delete a database, tap Delete, then tap the database you want to remove. If you have the MobileDB Application Preference, "Confirm Database Delete" checked then a confirmation dialog box appears. If you do not have the "Confirm Database Delete" checked then the database is automatically deleted with no confirmation. We suggest that you keep the "Confirm Database Delete" checked unless you need to quickly delete a lot of databases. To create a new database, tap the 'New' button from the database list view, enter the desired database name, and tap 'OK'. The 'Field Definitions' view will pop up to enter the field names and data types for the database. Enter each name as you would like them to appear in the database (minus the colon) and leave the rest of the field names blank. Select the data type for each field. Note - selecting the proper data type for your data will ensure maximum flexibility and consistency when using the filter and sort functions. To view the database sizes, on the Display DB Size drop-down list at the top of the database list view tap By # Records to display the number of records in each database or By Kbytes to display the space (in kilobytes) that each database takes up on your Palm OS device. Due to the overhead required to determine the sizes each time the database list view refreshes, we suggest that you keep the selection at Don't Display until you need to display the size of the databases. To view
the lock status of all databases make sure the MobileDB
Application Preference, "Show Lock Icons" is checked.
This displays a lock icon for each database in the database list
view. If the database is locked (requires a password to access)
then the lock icon is "closed" or "locked."
Otherwise, the lock icon is "open". Keep
in mind, that a locked database only hides the data from view on
the Palm OS device. The database is not encrypted and the data can
be accessed with any MobileDB tool, converter, or even a generic
ASCII text viewer (like Memo Pad). You should not store any highly
sensitive information in a locked MobileDB database. For more information
see Locking MobileDB Databases. To view the location (handheld or card) status of all databases, make sure the MobileDB Application Preference, "Show Location Icons" is checked. This displays a location icon to the left of each database name in the database list view. Databases on the handheld display a rectangular representation of a handheld device. Databases on the card display a representation of a memory card with an angled bottom edge. Show Lock Icons has precedence over Show Location Icons in the database list view. If Show Lock Icons is selected, Location Icons will not be displayed. You can also select the MobileDB Application Preferences by tapping the menu button and selecting 'Preferences.' For more information on the application preferences, see MobileDB Application Preferences. To change the MobileDB header and row color, select Colors from the Options menu. Tap the Pick button next to Header or Row and then select the desired color from the color picker by tapping on the appropriate square. ClickOK to exit the Pick Colors dialog and OK in the Color preferences to apply the changes. Header and row colors are global and are not database specific. The row color you pick will alternate with white in the MobileDB database list and record list views. Since text in MobileDB is black and cannot be changed, dark colors, such as dark blue or black, may make it difficult or impossible to read the data in the colored rows. We suggest using lighter colors for best readability. Storing and Using Databases on a Memory Card With the release of MobileDB4, it is now possible to store and view your MobileDB databases on Memory Stick or SD/MMC memory cards on devices that support VFS (Virtual File System). If your device supports storing MobileDB data on expansion cards, the database location will be displayed in the database list view if Show Location Icons is selected in the Preferences. If your device does not support VFS, this preference will not be available and the icons will not be displayed. To move a database from internal memory to the memory card, tap the location icon to the left of the database that you wish to move (databases on the handheld display a handheld icon and databases on the card display a card icon). The Move Database dialogue will appear - "[Database] is currently located on the device. Would you like to move it to the card?" To move the database to the card, tap "Yes" you will see a dialogue noting, "Moving [database] to the card" and the location icon will change from the Handheld icon to the Card icon. To move a database from the memory card to internal memory, tap the location icon to the left of the database that you wish to move. The Move Database dialogue will appear - "[Database] is currently located on the card. Would you like to move it to the device?" To move the database to the handheld, tap "Yes" you will see a dialogue noting, "Moving [database] to the device" and the location icon will change from the Card icon to the Handheld icon. MobileDB databases and records that are stored on the memory card can be accessed and viewed in the same manner as databases that are stored on the handheld, but they are available in read-only format. If you try to make a change to a database that is stored on the card, you will receive a dialog notifying you, "The selected operation requires the database be moved from the expansion card to the device. Do you wish to continue?" Tap "OK" and the database will be automatically moved to the handheld and you can edit the database as normal. By checking the "Move database back to the expansion card when complete" box, the database will automatically be moved back to the card once you tap "done" to return to the database list view. IMPORTANT NOTE: Due to current format limitations, database categories are NOT retained when the database is moved from the Palm OS device to the card. If you have assigned category information to your database, it will be permanently lost when the database is moved to the card. NOTE: Databases stored on the memory card cannot be searched using the Global Find. Record List ViewScrolling Up or Down Records - The record list view allows you to display up to 10 records in the database at any one time. Use the scroll bar to navigate up and down the records in the database. Note: the record number indicator at the bottom of the screen (example: 735 of 890) displays the record number at the top of the screen. Since the application will not scroll past the last record location at the bottom of the screen, you will never see "890 of 890". You can scroll up or down a single record by tapping the up and down arrows at the top or bottom of the scroll bar. To page up or down either tap the scroll bar above or below the indicator or use the hard up or down keys on your Palm OS device. Scrolling Left or Right - If there are more than two fields in each record of your database then you can use the left or right arrows at the bottom-right of the screen to scroll through the "fields" or "columns" of the database. The first field of the record remains static and will not move while the other fields scroll left and right. It is extremely important to create an optimal field width setting in order to keep the field widths small enough so the left and right scroll works correctly. See Modifying Field Width for more information. Also, keep in mind that if the Use Hard Keys for Scrolling preference is set in the MobileDB application preferences, you can use the Address Book and To Do hard keys on your Palm OS device to scroll the fields left and right in the second column. This allows for single handed navigation of the entire database. Selecting a Record - To select a record, simply tap the record and the record is highlighted, then navigate to the screen displaying the details of the record. MobileDB displays the record details in read-only format. Creating
a New Record -
To create a new record, press the "New" button at the
bottom left of the screen. This will display the editable view of
the details and allow a user to add the details of the new record.
The new record will be sorted properly in the new database.
Exit - To return to the database list view, tap Done. Menu Functions Database Record Options Record Details View / EditWhen selecting a record, there are two views that may be displayed, View Record or Edit Record. The default view displayed is determined by the 'On select, go to Edit View' preference in the Database Info. If the user needs frequent view access and occasional edit access then we suggest that this preference be unchecked so the record view is the default view. HINT - Minimize the length of your field names in order to maximize the space available for the record details on these screens. For instance change the field name "Description" to "Desc" to free up that much more screen space for your record details! Record View
- The record view screen allows the user to view the
detailed information of the record selected from the record list.
If the
record details do not fit on a single screen then the user can use
the up/down arrows at the bottom of the screen or the hard up/down
buttons on the palm to navigate up or down the record details. Once
the end of the record is reached, the use of those same buttons
will "jump" to the top of the next record (up or down)
in the record list. Record Edit - The record edit view enable users to edit the detailed information of each record. If the record details do not fit on a single screen then the user can use the up/down arrows at the bottom of the screen or the hard up/down buttons on the palm to navigate up or down the record details. Once the end of the record is reached, the use of those same buttons will "jump" to the top of the next record (up or down) in the record list. Editing the field information is dependent on the data type selected. For text and number field types simply place the cursor in the field then edit with graffiti input, keyboard input, or the standard cut, copy, paste, and undo. For a date or time field types tap the field box and a date or time selection screen will appear. For a checkbox just tap the checkbox to select or unselect it. Tap the down arrow on a list type and select the list item. When done editing either press the "Done" button or use the up/down arrows or buttons to move to another record. Your data will be saved automatically if you move to another record. To delete the record, tap the 'Delete' button and the record will be deleted and the application will return to the record list view. If you have the 'Confirm Record Delete' set in the application preferences you will also be warned that the record will be deleted once the 'Delete' button has been tapped. If you chose to cancel the changes that were made to the record since you entered the 'Edit Record' screen, tap the 'Cancel' button and the application will return to the 'Record List' with no changes saved. This will only cancel the changes made to the current record you are editing. Any changes made to other records will not be canceled. Menu Commands Record Edit Options
MobileDB Application PreferencesYou can easily access application preferences from either the database list view or the record list view. Simply tap MobileDB Preferences on the Options menu in either the database list view or the record list view. These preferences are for the entire application and are not dependent on the database selected. Use Hard Keys For Scrolling - if checked, the Address Book and To Do hard keys on your Palm OS device will act as left and right scroll navigation buttons in the database list view. This allows for single-handed navigation of the entire database. The up and down buttons always work in the record list and record view and edit screens, regardless of this setting. Confirm Record Delete - if checked, this will cause the application to pop up the 'Are You Sure' dialog after the user requests to delete a record. This may be unchecked if the user needs to quickly delete a lot of records in the database, however, we strongly suggest that the user keep this option checked during normal operation. Confirm Database Delete - if checked, you will be prompted to confirm a database removal before it is permanently deleted. This can be unchecked if you need to quickly delete several databases, however, we strongly suggest you keep this option checked during normal operation. Left Hand Mode - If checked, the scroll bar will be moved to the left side of the screen. Show Lock Icons - If checked, lock icons are displayed on the database list indicating whether or not each database is locked. If you do not use database locking, then we suggest that this remain unchecked for a "clean" database list interface. Show Location Icons - If checked, the current location of the database, handheld, or card, is displayed to the left of the database name. NOTE - Show Lock Icons has precedence over Show Location Icons in the database list view. If Show Lock Icons is selected, Location Icons will not be displayed. (more info)
Database InfoYou can easily access and change the database preferences in the record list view. Simply tap Info... on the Database menu. Note that these preferences only effect the currently selected database, so you will need to set individual preferences for each database. Title - allows you to modify the database title. Records - displays the number of records in the selected database. Size - displays the size of the selected database. Updated - displays the date and time of most recent changes to the selected database. PW Protection - None indicates database is not password protected. Read only indicates password is required to modify the database. Lock indicates database will request password on selection. On Select, go to Edit View If this is checked, the application will go to the record edit view to edit the record when a record is selected in the record list view. If this is unchecked then the application will go to the record view screen when a record is selected. We recommend that this remain unchecked for databases where the user requires quick view access and occasional edits/updates to the data. Backup Database at Hotsync - if this is checked then a backup is automatically created during the Hot Sync application, placing it in the backup directory of your Palm user directory on your PC or Mac. On the PC, it is generally the c:\palm\<username>\backup directory. You can then use this backup to convert to a comma separated file for further editing on the PC or Mac. NOTE: Unless there is some reason why you do not want the database backed up to your machine, this should always be selected. It does not create a new backup each time you use the Hot Sync application, only if changes have been made to the database since the last backup was created. Search on Global Find - If this is checked then the database is searched when the you perform a Palm OS "Find". Large databases may slow the Palm OS find feature, so we suggest that this only be checked on databases that you would like to search when performing a PalmOS find. Databases on expansion cards cannot be searched using Global Find. Display Dates in Long Format - If this is checked then the dates in utilizing the date field types will be displayed as MMM DD, YYYY instead of the default view MM/DD/YY
Sorting
Records
Filter Records You can also choose to combine multiple filters as an 'and' requiring a match on all the filters or 'or' which just requires a match on one filter. If you already a filter on the current database then you'll have the option to apply the filter over the current filter (filtered rec's) or all the records in the database. Once you have
entered your filter criteria, tap OK to start the filter, and Cancel
to cancel the filter. Find
Records Print
Records
MobileDB has 7 data type choices. Selecting the proper data type for your data will ensure maximum flexibility and consistency with the filter and sort functionions. The choices are text, number, list, checkbox, date, time, sequence. To change the data type of a field select a the data type from the list to the right of the entry field. Depending on the data type, an option popup dialog may appear. To change the field name of the field, simply edit the field name. HINT - Minimize the length of your field names (labels) in order to maximize the space available on the record view/edit screens. For instance change the field name "Description" to "Desc" to free up that much more screen space for your record details! To move a field
in the database, select the field and use the menu command "Fields->Move
Field Up" "Fields->Mobile Field Down". To Insert
a field, select the field that you would like to come after
the
new field and select "Fields->Insert Field". To add
a field to the end of the field list, select the menu command "Fields->Add
Field". To delete a field, select the field and select the
menu command "Delete Field" from the "Fields"
menu. Once any changes are made, it may take a moment to make the
changes in every record in the database.
NOTE: This "lock" simply hides the database from view in the MobileDB application. If someone is interested enough in this information, they can simply hotsync your palm and view the database on the PC using an ASCII viewer or any MobileDB converter. DO NOT PLACE ANY SENSITIVE INFORMATION IN THIS APPLICATION WITH THE ASSUMPTION THAT "LOCKING" IT WILL SECURE THE INFORMATION. You should use an encrypted database application (like PDA SAFE ID) in order to secure sensitive information.
To change the category of the database, simply tap the category box and select a category. Remember that categories are NOT retained for databases moved to the memory card. Version 4.0 Version 3.0 Version 2.1 Version 2.0
Handmark Company Information Check
out more great Palm OS titles at the
Handmark web site.
PLEASE READ THIS LICENSE CAREFULLY BEFORE USING HANDMARK SOFTWARE. BY USING THE HANDMARK SOFTWARE, YOU AGREE TO BECOME BOUND BY THE TERMS OF THIS LICENSE IF YOU DO NOT AGREE TO THE TERMS OF THIS LICENSE, DO NOT USE THE HANDMARK SOFTWARE. The Handmark software ("Software") provided along with this License, is licensed, not sold, to you by Handmark Software Incorporated ("Handmark") for use only under the terms of this License, and Handmark reserves any rights not expressly granted to you. You own the media on which the Software is recorded, but Handmark and its licensors retain ownership of the Software itself. 1. License. This License allows you to: (a) Use one
copy of the Software on a single computer at a time To "use" the
Software means that the Software is either loaded in the temporary
memory of a computer or installed on the permanent memory of a computer.
You may install the Software on a common storage device which is
accessible by multiple computers, provided that if more computers
have access to the common storage device than the number of licensed
copies of the Software, you must have some software mechanism which
locks-out any concurrent users in excess of the number of licensed
copies of the Software and additional license is not needed for
the one copy of Software installed on the common storage device
accessed by multiple computers) 2. Restrictions. The Software contains trade secrets in its human perceivable form and, to protect them, you may not REVERSE ENGINEER, DECOMPILE, DISASSEMBLE OR OTHERWISE REDUCE THE SOFTWARE TO ANY HUMAN PERCEIVABLE FORM YOU MAY NOT MODIFY, ADAPT, TRANSLATE, RENT, LEASE, LOAN OR CREATE DERIVATIVE WORKS BASED UPON THE SOFTWARE OR ANY PART THEREOF 3. Termination. This License is effective until terminated This License will terminate immediately without notice from Handmark or judicial resolution if you fail to comply with any provision of this License Upon such termination you must destroy the Software, all accompanying written materials and all copies thereof, and Sections 5, 6 and 7 will survive any termination 4. Limited Warranty. Handmark warrants for a period of ninety (90) days from your date of purchase that the Software as provided by Handmark will substantially conform to Handmark's published specifications for the Software Handmark's entire liability and your sole and exclusive remedy for any breach of the foregoing limited warranty will be, at Handmark's option, replacement of the media (if any), refund of the purchase price (based on fair market value of the Software) or repair or replacement of the Software. THIS LIMITED WARRANTY IS THE ONLY WARRANTY PROVIDED BY HANDMARK AND HANDMARK AND ITS LICENSORS EXPRESSLY DISCLAIM ALL OTHER WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO IMPLIED WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE WITH REGARD TO THE SOFTWARE AND ACCOMPANYING WRITTEN MATERIALS. BECAUSE SOME JURISDICTIONS DO NOT ALLOW THE EXCLUSION OR LIMITATION OF IMPLIED WARRANTIES, THE ABOVE LIMITATION MAY NOT APPLY TO YOU. 5. Limitation of Remedies and Damages. IN NO EVENT WILL HANDMARK OR ANY OF THE LICENSORS, DIRECTORS, OFFICERS, EMPLOYEES OR AFFILIATES OF ANY OF THE FOREGOING BE LIABLE TO YOU FOR ANY CONSEQUENTIAL, INCIDENTAL, INDIRECT OR SPECIAL DAMAGES WHATSOEVER (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF BUSINESS PROFITS, BUSINESS INTERRUPTION, LOSS OF BUSINESS INFORMATION AND THE LIKE), WHETHER FORESEEABLE OR UNFORESEEABLE, ARISING OUT OF THE USE OF OR INABILITY TO USE THE SOFTWARE OR ACCOMPANYING WRITTEN MATERIALS, REGARDLESS OF THE BASIS OF THE CLAIM AND EVEN IF HANDMARK OR A HANDMARK REPRESENTATIVE HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. Handmark's liability to you for direct damages for any cause whatsoever, and regardless of the form of the action, will be limited to the greater of $500 or the money paid for the Software (based on fair market value of the Software) that caused the damages. THIS LIMITATION WILL NOT APPLY IN CASE OF PERSONAL INJURY ONLY WHERE AND TO THE EXTENT THAT APPLICABLE LAW REQUIRES SUCH LIABILITY BECAUSE SOME JURISDICTIONS DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CON-SEQUENTIAL OR INCIDENTAL DAMAGES, THE ABOVE LIMITATION MAY NOT APPLY TO YOU. 6. General. This License will be construed under the laws of the State of Missouri, except for that body of law dealing with conflicts of law If any provision of this License shall be held by a court of competent jurisdiction to be contrary to law, that provision will be enforced to the maximum extent permissible, and the remaining provisions of this License will remain n full force and effect If you are a U S Government user then the Software is provided with "RESTRICTED RIGHTS" as set forth in subparagraphs (c) (l) and( 2) of the Commercial Computer Software Restricted Rights clause at FAR52227-19 o sub paragraph (c) (1) (ii) of the Rights in Technical Data and Computer Software clause at DFARS 52 277-7013, as applicable Manufacturer Handmark, Incorporated 105 East 5th Street, Suite 201, Kansas City, MO 64106. MobileDB
Serial Number Evaluation
and Registration Unregistered use of MobileDB after the 15-day evaluation period is in violation of U.S. and international copyright laws. Distribution
Send comments and requests about this information to info@handmark.com or visit the Handmark web site at: http://www.handmark.com/
|
|