Home
|
Handy Finance
|
Handy Service
|
Paranoid Security Hack
|
Handy Service is a sales and shopping software for Palm OS handhelds.
Desktop program for Handy Service allows:
Instant desktop is also available. It allows to pick new orders from multiple Palms automatically in real-time.
You can get DAO here
Attention! By installing this program you completely accept terms of license agreement (see License.txt).
Launch HandyServiceDesktopSetup.exe file to install Handy Service Desktop. Then use Handy Service Desktop icon to launch program (may be located in program menu, desktop or quick launch bar).
The number of retails/services you can export in demo version is limited.
The following text shortly describes the main features of the program. To get more details read please manual for Palm version of Handy Service.
Prices:
Please, visit our site, http://handysolution.com/hsp.htm, to order full version.
Updates for 1.x versions are free.
After purchase you will receive full support and full versions.
After starting you will see some tab sheets (pages) and main menu. The first page, "Import/Export" is intended for data exchange with "Handy Service for Palm", other pages allows to edit and navigate tables. From "Orders" page you can see taken orders. The active page will be remembered between sessions and the program will start at last active page. There are hints for most of controls, use menu "View \ Show hints" to enable or disable hints.
From menu you can call help, export report for transactions and change secondary settings. Any primary and secondary settings will be remembered after exiting. Hold a "Shift" key during program starting if you want to bypass restoring of program settings. Hold a "Shift" key during program exiting if you want to avoid saving of program settings.
This page is intended for data exchange with "Handy Service for Palm" using PalmDesktop. There are two modes of exchange, automatic and manual. You can switch between them using "Select an exchange type" bar.
"Import" and "Export" buttons allows to perform data importing and exporting actions. From menu "View \ Import/Export confirmations" you can enable or disable confirmations for these actions. Use "Clear all tables" button if you want to clear all your desktop data.
An automatic mode allows you to select any PalmDesktop user to exchange data with. If there is no PalmDesktop installed, this mode will be disabled. Once the user is selected, the program remembers it as one of primary setting. Before data importing it is recommended to synchronize your handheld device. After data exporting you need to synchronize too. In automatic mode you can choose a "View \ Import at startup" option. When this option is active the Handy Service data importing from selected user will be performed at every program startup.
In manual mode you need to exactly specify the folders for data exchange, the importing folder and the exporting folder. You may type (or paste) the path in corresponding box or use a browse button to bring directory tree. In this mode you need to manually install exported .pdb files from corresponding folder.

On this page you can view orders, taken from Palm. You may select which orders to view, all orders, active or closed. Also you may print bill or export data to Excel (csv) file, both for single order or for all selected orders.

You can save selected files to Excel for further processing. There are few file types that you can save to: text file, two kinds of csv files (comma and semicolon-separated values) and tsv (tab-separated value) file. csv files can be accepted by Excel. You may choose one, which is more appropriate to your local settings.
List of orders and list of items for all orders are placed separately. After them items, grouped by orders, are placed.
Each item for the list of items on all orders is marked by order date, order number and client name. So you can make advanced reports in Excel, like:
The key idea to create such reports is to use columns sorting and range selection. For example to see profit for each of goods, we have to sort items by goods name, then select cells from "Profit" column, which are in front of required goods (after sorting same goods are grouped together) and we will see sum of selected columns in status bar. By selecting "Amount" cells, we will see total amount of particular goods.
Each page is intended for editing (or viewing) one particular table or two related tables. Typical page may include following controls.
On this page you can additionally save goods list to Excel (csv) file or to load goods list from Excel (csv) file. All related info, like exist/service mark, prices, categories, is preserved.

Filters are placed on upper panel and consist from checkboxes and popup lists. Checkbox allows to disable or to enable filter. Popup list allows to select filter value. For example if it is filter for category, then you can select "first dishes", and related table will display only first dishes.
Filters are nice autofilling tool. For example, if filter activated for "first dishes", then each new product (or subcategory) will be automatically assigned to first dishes.
Tables are placed at the center of the page and allow entering and editing data. Cells can contain checkboxes, text fields, popup lists and memo fields. Memo fields can't be edited in table, and they are placed at the bottom of table as a separate field.
If table has related table, then data in related table will be automatically updated when navigating main table. Secondary tables are placed lower than main tables.
Navigation bars are placed at the bottom of page. They allows to navigate table, add and delete records, undo changes and refresh table. Each table has its own navigation bar, linked at the bottom of table.
The source code for "Handy Service Desktop" can be opened for third party developers in order to allow customize it for any needs. For example to integrate it in restaurants software systems or make connections with desktop budgeting software. Also we can accept moderate customizations both for palm and desktop exactly for you needs. Fell free to contact us.
"Handy Service Desktop" is created using KaDAO, pdbmake, palmdump and Borland C++ Builder 5.
KaDAO is Kiril Antonov's Data Access Objects components for Delphi and Borland C++ Builder, kiril@pari.bg, http://delphi.pari.bg. KaDAO is fully freeware and its source is open. There is no need to use BDE! As for me, it is more convenient than ADO. Also there are much more powerful commercial components KaDAO Deluxe for serious projects and for enterprise use.
pdbmake and palmdump are free programs with open source for parsing and creating Palm's database (.pdb) files. The author is John Walker, http://www.fourmilab.ch. This is an easy and fast way to exchange with Palm without writing complicated conduits.