Programming the mapping table | IBM WORKPADC3 specification

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 companion.

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 for IBM WorkPad 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.

All rows related to template are selected

4. From the Edit menu, choose Copy.

Page 204

Creating a Custom Expense Report

Image 212

IBM WORKPADC3 manual Programming the mapping table

Contents

Handbook for WorkPad c3 PC Companion Copyright Disclaimer and Limitation of Liability Contents Using Your Basic Applications Advanced HotSync Operations Communicating Using Your CompanionSetting Preferences for Your Companion Appendix B Frequently Asked Questions Appendix a Maintaining Your Companion Appendix C Creating a Custom Expense Report Appendix D Non-ASCII Characters for Login ScriptsWarranty and Other Product Information Handbook for the WorkPad c3 PC Companion About This Book About This Book Getting to know your WorkPad c3 companion What is a WorkPad c3 companion?Chapter Upgrade information System requirementsMinimum requirements Optional equipment WorkPad c3 components Locating front panel controls Using the onscreen contrast control Using the backlight Reset button Locating back panel componentsSide channels IR port Chapter Recharging the battery With Palm Desktop for IBM WorkPad, you can do the following Palm Desktop software for IBM WorkPadViewing data while in the cradle Installing Palm Desktop for IBM WorkPad Using your companion with another PIM Tapping and typing Tap with the stylus to get things done Icons Abc Elements of the companion interfaceMenu bar Opening applications Using menus Graffiti menu commands Choosing a menu Displaying online tips CommandThree ways to enter data Onscreen keyboard Graffiti writing Press the Memo Pad application button Tap New Using Palm Desktop for IBM WorkPad Importing data Customizing your companion Tap a month Tap the current date Using Graffiti writing to enter data Writing Graffiti characters Lift stylus here Start stroke at heavy dot Graffiti tips Graffiti alphabet Writing capital letters Writing numbersCaps Shift Caps Lock Number Graffiti numbersWriting punctuation marks Writing symbols and extended characters Additional Graffiti punctuation Additional non-English characters Writing accented charactersAccent strokes Navigation strokes Graffiti ShortCutsMove cursor right Move cursor left Next Field Address Book only Entry ShortCut Using the onscreen keyboard Using your computer keyboard Importing data Chapter Entering Data in Your WorkPad c3 Companion Using the Applications Launcher Switching between applicationsSelecting applications Categorizing applications Changing the Applications Launcher display Choosing preferences Installing and removing applications Installing add-on applications Chapter Installing games Removing applications Removing Palm Desktop for IBM WorkPad Security, you can do the following Assigning a passwordSecurity Changing or deleting a password Locking your companion Recovering from a forgotten password Using Your Basic Applications Date Book, you can do the following Overview of basic applicationsDate Book Address Book Address Book, you can do the following To Do List To Do List, you can do the following Memo Pad CalculatorMemo Pad, you can do the following Calculator, you can do the following Expense Expense, you can do the following Editing records Common tasksCreating records Entering text Edit menu Deleting records Other ways to delete recordsKeyboard Graffiti Help Purging records Exchanging and updating data HotSync operations Performing a HotSync operation for the first time Using Your Basic Applications Default categories Categorizing records Tap Edit Categories Tap New To rename a category Finding records Looking up Address Book records Using Find Using Phone Lookup Phone Lookup tips Looking up names to add to expense records Sorting lists of records Making records private Hiding private records Tap the Applications icon Tap Security Tap Hide Attaching notes Choosing fonts Application-specific tasks Scheduling an event Tap the time of an event To schedule an event for another day Tap a blank area on the screen to deselect the untimed event Setting an alarm for an event Rescheduling an event Scheduling repeating or continuous events Changing the Date Book view Tap the Week View button Spotting event conflicts Working in Month View Date Book menus, preferences, and display options Record menu Options menu Using Your Basic Applications Preferences Book Creating an Address Book entry Selecting types of phone numbers Next Field Changing Address Entry details Address Book menus Record menus Options menus Book Setting priority Checking off a To Do List item Changing To Do List item details Setting a due date To Do Show Options To Do List menus Show Due DatesShow Priorities Categories Reviewing memos Memo Pad menus Pad Recent Calculations Calculator Calculator menusAbout Tap the Applications icon Tap Expense Tap New Changing the date of an Expense item Entering receipt details Customizing the Currency pick list Defining a custom currency symbol Show Options Sort byDistance Show currency Transferring your data to Microsoft Excel Creating or printing an expense report Using expense report templates Using Your Basic Applications Expense menus Record menu Options menu Communicating Using Your Companion Setting up Mail on the desktop Mail, you can do the following Default SynchronizeFiles Desktop Viewing e-mail items Synchronizing Mail with your E-Mail applicationOpening the Mail application on your companion Creating e-mail items Displaying full header information To create an e-mail item Chapter Looking up an address Adding details to e-mail items Setting a priority Sending a blind carbon copy Adding a signature to your e-mail item Requesting confirmations Storing e-mail to be sent laterEditing unsent e-mail Draft e-mail Filing e-mail Deleting e-mail Removing e-mail from the Deleted folder Folders Purging deleted e-mailMessage List options Date column Sorting the Message ListSender Subject Send Only HotSync optionsAll Unread Creating special filtersFilter Ignoring or receiving e-mail IgnoreMessages Containing Defining filter strings High-priority e-mail Truncating e-mail items Mail menus Message menus Beaming information Tips on beaming information Selecting HotSync setup options Advanced HotSync Operations When Palm Always availableAvailable only Desktop for IBM Serial Port Speed Customizing HotSync application settings Chapter Conducting a HotSync operation via modem Preparing your computer Modem Setup StringPreparing your companion To prepare your companion for a modem HotSync operation Selecting the conduits for a modem HotSync operation Performing a HotSync operation via a modem Connecting to your company’s dial-in serverConducting a HotSync operation via a network To prepare your computer for a network HotSync operation Using File Link Creating a user profile To create a user profile To use a profile for the first-time HotSync operation Viewing preferences Preferences screens, you can do the following Buttons preferences Pen preferences Beam Data BacklightTurn Off & Lock HotSync buttons preferences Digitizer preferencesFormats preferences Country default Time, date, week start, and numbers formats General preferences Auto-off delayCradle settings System, alarm, and game sounds Beam Receive Modem preferences Selecting a service Network preferences and TCP/IP software Entering a user name Entering a password Adding telephone settings Entering a prefix Disabling Call Waiting Using a calling card Connecting to your service Creating additional service templates Adding detailed information to a service template Idle timeout Defining primary and secondary DNS IP address Creating a login script Wait ForSend Send CR Deleting a service template Network preferences menu commands TCP/IP troubleshootingService menu Options menu Displaying expanded Service Connection Progress messages Adding a DNS number Owner preferences ShortCuts preferences Creating a ShortCut Editing a ShortCut Deleting a ShortCut Setting Preferences for Your Companion Appendix a Caring for your companion Battery considerations Resetting your companion Performing a soft reset Performing a hard reset Appendix a Maintaining Your Companion Software installation problems ProblemSolution Appendix B Operating problems Problem Solution Tapping and writing problems Application problems HotSync problems Frequently Asked Questions Appendix B Frequently Asked Questions Beaming problems Recharging problems Password problems Before You Call for Service Getting Help, Service, and InformationHardware Warranty Summary Product Registration and Getting Help by Telephone Getting Customer Support and ServicePurchasing Additional Services Country Name United States Frequently Asked Questions Appendix C About mapping tables Customizing existing sample templates Determining the layout of the Expense Report Labels Sections Analyzing your custom Expense Report Programming the mapping table Table with four sections Creating a Custom Expense Report Page Using applications other than Microsoft Excel Expense file detailsTrips Trip Carriage return and line feed Appendix DUse of char Literal characters Warranty Other Product Information Product warranties IBM U.K. Statement of Warranty IBM Warranty For MachinesExtent of Warranty Part 1 General Terms Items Not Covered by Warranty Warranty Service Production Status Limitation of Liability IBM U.K. Statement Of Warranty Part 2 Country-unique Terms Asia Pacific EUROPE, Middle EAST, Africa Emea Page North America Part 1 General Terms Items Not Covered by Warranty Production Status Asia Pacific EUROPE, Middle EAST, Africa Emea Page South AFRICA, NAMIBIA, BOTSWANA, Lesotho and Swaziland Limi Year 2000 Readiness and Instructions Electronic Emissions Notices TrademarksFederal Communications Commission FCC Statement IBM WorkPad Canadian ICES-003 Statement Statement of Conformity UL/CSA Statement Page Index Index See also PIM Digitizer 14, 154 Index Index Index PIM See also Deleting Index Index