3Com Palm V Organiser Instructions Manual

							Appendix B Page 203
My organizer 
displays the message 
“Waiting for sender” 
when it’s near my 
computer’s infrared 
port.nYour computer’s infrared port may be 
set to search automatically for the 
presence of other infrared devices. Do 
the following to turn off this option:
1. In the Windows taskbar, click Start.
2. Choose Settings, and then choose 
Control Panel.
3. Double-click Infrared.
4. Click the Options tab.
5. Deselect the option Search for and 
provide status for devices in range.
6. Click Apply and OK.
nIf you are using Windows 98, move 
your organizer away from the 
computer’s infrared port. 
						

							Page 204  Frequently Asked Questions
Beaming problems
Recharging problems
ProblemSolution
I cannot beam data to 
another Palm 
Computing platform 
handheld.nConfirm that your organizer and the 
other Palm V organizer are between ten 
centimeters (approximately 4) and one 
meter (approximately 39) apart, and 
that the path between the two 
handhelds is clear of obstacles. Beaming 
distance to other Palm Computing 
platform handhelds may be different.
n  Move your organizer closer to the 
receiving handheld.
When someone 
beams data to my 
organizer, I get a 
message telling me it 
is out of memory.n  Your organizer requires at least twice 
the amount of memory available as the 
data you are receiving. For example, if 
you are receiving a 30K application, you 
must have at least 60K free.
nPerform a soft reset. See “Performing a 
soft reset” in Appendix A for more 
information.
ProblemSolution
When I place my 
Palm V organizer in 
the cradle, the cradle 
light does not go on.nConfirm that your organizer is well 
seated in the cradle.
nConfirm that your recharger cable is 
properly connected to the back of the 
cradle’s serial (COM) port connector 
that plugs into your computer.
nConfirm that your recharger is plugged 
into an AC outlet that has power. 
						

							Appendix B Page 205
Password problems
ProblemSolution
I forgot the 
password, and my 
organizer is not 
locked.You can use Security to delete the 
password, but your organizer deletes all 
entries marked as private. However, if you 
perform a HotSync operation before you 
delete the password: the HotSync process 
backs up all entries, whether or not they are 
marked private. Then, you can follow these 
steps to restore your private entries:
1. Use the Palm Desktop software and 
the cradle or infrared communica-
tion to synchronize your data.
2. Tap Forgotten Password in Security 
to remove the password and delete 
all private records.
3. Perform a HotSync operation to syn-
chronize your data and restore the 
private records by transferring them 
from your computer to your 
organizer.
I forgot the password 
and my organizer is 
locked.nIf you assign a password and lock your 
organizer, you must perform a hard 
reset to continue using your organizer. 
See “Performing a hard reset” in 
Appendix A for more information. 
						

							Page 206  Frequently Asked Questions
Technical support
If, after reviewing the sources listed at the beginning of this appendix, 
you cannot solve your problem, contact your regional technical 
support office by e-mail, phone, or fax. 
Before requesting support, please experiment a bit to reproduce and 
isolate the problem. When you do contact support, please be ready to 
provide the following information:
nThe name and version of the operating system you are using
nThe actual error message or state you are experiencing
nThe steps you take to reproduce the problem
nThe version of organizer software you are using and available 
memory
To find version and memory information:
1. Tap the Applications icon  . 
2. Tap the Menu icon  . 
3. Tap App, and then tap Info.
Note:Thousands of third-party add-on applications have been 
written for the Palm Computing platform. Unfortunately, we 
are not able to support such a large number of third-party 
applications. If you are having a problem with a third-party 
application, please contact the developer or publisher of that 
software.
4. Tap Version to see version numbers, and tap Size to see the amount 
of free memory in kilobytes. 
						

							Appendix C Page 207
Appendix C
Creating a Custom 
Expense Report
This section explains how to modify existing Expense application 
templates and how to create your own custom expense report 
templates for use with the Expense application.
Note:This section assumes that you are familiar with Microsoft 
Excel or a similar spreadsheet application. If you are not 
familiar with Microsoft Excel, consult your company’s 
Information Services department or another experienced user.
About mapping tables
Before creating or modifying an Expense template, it’s important to 
understand the function of the Palm™ Desktop software Expense 
application. In simple terms, the Expense application is designed to 
move Expense data from your Palm V™ organizer into a Microsoft 
Excel spreadsheet. Each Expense item stored in your organizer 
represents a group of related data. You can associate the following 
data with an expense item:
nCategorynPayment Currency
nDatenVendor
nExpense TypenCity
nAmountnAttendees
nPayment MethodnNote
When you perform a HotSync
® operation between your organizer and 
Palm Desktop software on your computer, the Expense data is stored 
on your computer (in a file named Expense.txt). When you open the 
Expense application in Palm Desktop software, an Excel macro starts, 
and populates an expense template with your data based on the rules 
specified in a spreadsheet file named Maptable.xls. 
The Maptable.xls file is an editable spreadsheet that functions as a 
“mapping table.” The function of the mapping table is to guide the 
Excel macro in extracting the Expense data. The mapping table tells 
the Excel macro how large the spreadsheet is and provides the data-
cell layout of the Excel template used for the Expense Report. 
						

							Page 208  Creating a Custom Expense Report
Customizing existing sample templates
Four sample Expense Report templates come with Palm Desktop 
software. These templates are stored in the Template folder (which is 
in the same folder as the Palm Desktop software application). 
If the layout of one (or more) of these templates is appropriate for your 
reporting needs, you can easily customize the templates with your 
company name and other information.
To customize a sample Expense Report template:
1. Make a backup copy of the contents of the Template folder.
2. Double-click the name of the sample template you want to modify 
to open it in Microsoft Excel.
3. Make any changes that you want to the names (or other 
information) in the sample template.
Important:Do not insert rows or columns in the sample template. 
Doing so changes the way your Expense data maps to the 
template and causes errors. If you want to move the cells 
to a different location or add or delete rows or columns, 
you have to make changes to the Maptable.xls file.
Note:You can insert your own company logo without changing 
the Maptable.xls file. If you change the file name, 
however, you need to make a corresponding change in 
the Maptable.xls file.
You can also rename cells without changing the 
Maptable.xls file, provided that the expense type 
corresponds to your organizer data. For example, you can 
change “Snack” to “Munchies,” and then all items 
entered on your organizer as “Snack” map to the cell(s) 
labeled “Munchies.” 
						

							Appendix C Page 209
4. From the File menu, choose Save As.
5. Click the Save as type drop-down list and choose Template (*.xlt).
6. Navigate to the Template folder (in the Palm Desktop software 
directory).
Note: If you do not need to change the Maptable.xls file, save the 
template file with its original file name (e.g., Sample2.xlt).
If you do need to change the Maptable.xls file, give your modified 
template a unique name. Be sure to use the .xlt file suffix, which 
defines the file as a Microsoft Excel template.
7. Click Save to save your modified template and make it available 
for future use.
Note:If you need to modify the Maptable.xls file, you must do this 
before you can use the modified template with your Expense 
data. To modify the Maptable.xls file for your new template, 
see “Programming the mapping table”  later in this appendix. 
Read all of the sections of this appendix before making changes to the 
Maptable.xls file.
Determining the layout of the Expense Report
This section describes the layout considerations for the Expense 
Report and explains the terms used for creating the report. 
Labels
There are two kinds of labels that you need to define for your report: 
day/date and expense type. Each kind of label can be either Fixed or 
Variable. A Fixed label means that the label always appears as a header 
at the beginning of a row or column. If a label is not Fixed, it is 
variable.
For example, a list table of expenses could have variable labels in the 
rows for day/date, and variable labels in the columns for expense 
type. In this case, neither day/date or expense type information 
would be “fixed” (as a header). Instead, the date and expense type 
information would be filled into the cells of the spreadsheet as 
appropriate.
Examples of both Fixed and Variable labels appear in the sample 
expense templates.  
						

							Page 210  Creating a Custom Expense Report
Sections
A Section is an area of the report that has common formatting. It is 
common for an Expense report to have more than one Section. For 
example, the following sample Expense Report named Sample3.xlt 
contains several Sections.
Because your Expense data maps to row and column areas of your 
final report, different Sections require different definitions for the data 
mapping. To create additional Sections with different mapping, you 
create corresponding additional lines to the mapping table file named 
Maptable.xls. This procedure is explained later in this appendix.
If a section contains cells for prepaid (company paid) expenses, you 
need to create an additional line in the mapping table for “prepaid.” 
This will count as an additional section in the mapping table. The only 
data that differs in the prepaid section (from the non-prepaid section) 
is the row/column numbers for the expense type.
Section 1 
(not prepaid)
Section 2 
(prepaid)
Section 3  
						

							Appendix C Page 211
Analyzing your custom Expense Report
If you already have a custom Excel expense report, you can use it with 
a modified mapping table. However, before you can create a 
Maptable.xls file that corresponds to your custom Expense Report, 
you must first analyze the characteristics of your report. 
Perform the following before you begin a custom mapping table:
nPrint a copy of your custom expense report. Activate the Row and 
Column Headings option in the Sheet settings of the Page Setup 
command. This enables you to quickly determine the size of the 
Section(s), as well as the numbers for the start rows and columns.
nOn the printed copy, identify the data Sections. A Section is an 
area of data with common row and column formatting. A yellow 
highlighter marking pen can make it easy to see the Sections as 
you work with programming the mapping table. Your custom 
Expense Report can contain any number of Sections, and the same 
data can be repeated in any Section.
nOn the printed copy, identify the type of Labels that apply to each 
Section. Each Section can have only one kind of Fixed or Variable 
Label for rows. Likewise, each Section can have only one kind of 
Fixed or Variable Label for columns.
nPlace a copy of your custom Expense Report in the Template 
folder (in the Palm Desktop software directory). Change the file 
name so it has the file extension .xlt (which defines it as a Microsoft 
Excel template). Make a note of the exact file name so it can be 
defined in the mapping table file. 
						

							Page 212  Creating a Custom Expense Report
Programming the mapping table
Once you have analyzed the components of your custom Expense 
Report, you can program the mapping table to fill the report with data 
from the organizer.
To program a new custom mapping table:
1. Open a copy of the Maptable.xls file in Microsoft Excel. 
Note:This file is located in the same folder as the Palm Desktop 
software application. Make a backup copy of this file before 
you make your modifications.
2.
Mapping a new template. Scroll to where you find the name of the 
original template that you chose for your modifications. The name 
of the template will appear in column B of the Maptable.xls file, 
next to the cell highlighted in green that reads “Template Name:”. 
If you did not modify an existing template, move to any table in the 
Maptable.xls file. 
3. Select all the rows associated with the template name. To select the 
rows, click and drag on the row numbers (left side), so they appear 
highlighted.
4. From the Edit menu, choose Copy.
All rows 
related 
to 
template 
are 
selected