home *** CD-ROM | disk | FTP | other *** search
- SideKick for PM Utilities
- -------------------------
-
- Table of Contents
- -----------------
-
- I. Overview
-
- II. Installation
-
- III. PB - Phonebook Insert Utility
-
- IV. TP - Time Planner Annual Event Insert Utility
-
-
-
- I. Overview
- ------------
-
- PB: Inserts any existing Paradox table into a SideKick
- Phonebook table. You may insert data into an
- existing Phonebook table or create a new one.
-
- TP: Inserts a list of user entered annual events into an
- existing Time Planner table for a specified number of
- years.
-
- *** NOTE: SAVE COPIES OF YOUR SideKick Phonebook and Time Planner
- tables, before using either of these utilities.
-
-
- II. Installation
- -----------------
-
- Copy all of the files from the \SKSAMPLE directory on your
- Installation/Sample Tables Disk into a directory on your hard
- disk. Launch Paradox OS/2 or Paradox 2.0 using this directory as
- your working directory and run the "sksetup" script.
-
- Type Script/Play "sksetup"
-
- The SideKick for PM applications will be prepared for use.
-
-
- III. PB - Phonebook Insert Utility
- -----------------------------------
-
- To use the PB application play the script named "pb".
-
- Type Script/Play "pb"
-
- This script allows you to take any Paradox table and insert it
- into a SideKick Phonebook table. The Phonebook table contains a
- fixed structure, and cannot be modified.
-
- Screen 1:
-
- You are prompted to enter the name of the SideKick Phonebook
- table you wish to add the data. Type in the table name if it is
- in the current directory. Type in the full pathname if it is in
- another directory. Paradox checks the structure to see if it is
- a valid SideKick Phonebook structure. If the structure is
- invalid, you are returned to the prompt.
-
- If the tablename does not exist, the program asks you if you want
- to create a new SideKick Phonebook table. If you respond with a
- "Y", a table is created under the specified name with the correct
- SideKick Phonebook table structure. If you respond with a "N",
- you are returned to the prompt.
-
- Next, you are prompted to enter the name of the Paradox table you
- wish to insert. You may use the full pathname or just the table
- name if it is in the current directory. If the table does not
- exist, you are returned to the prompt. If a valid table name is
- entered, Screen 2 is displayed.
-
- (Note: You cannot add a SideKick Phonebook table to itself).
-
-
- Screen 2:
-
- You see a table with four fields. The first two fields are the
- field names and field types of a SideKick Phonebook table. The
- next two fields are the field names and field types of the table
- you wish to insert. The cursor is always in the Field Name
- field. You can type in a field name or press <F1> to see a list
- of fields in the Paradox table.
-
- When <F1> is pressed, you may select the field to insert with the
- highlight bar, and press enter. The corresponding field type is
- automatically filled in. Make sure that at least one entry is
- made in one of the first four SideKick fields. These four fields
- make up the primary index for the file and must contain at least
- one entry to avoid a key violation.
-
- The SideKick Phonebook table has all alphanumeric fields. The
- Paradox table can have fields of any data type. If a longer
- field is inserted into a shorter SideKick Phonebook field, a
- warning message tells you that characters may be truncated upon
- the transfer of information.
-
- Press <F2> when you have finished matching fields from one table
- to the other. You are asked if you are done entering data.
- Respond with a "Y" or "N". "N" returns you to editing the table,
- while "Y" initiates the insertion of the data. The program
- performs the necessary steps to convert and transfer the data
- into your SideKick Phonebook table. When the processing is
- complete, the updated SideKick Phonebook table is displayed on
- the screen.
-
-
-
-
- IV. TP - Time Planner Annual Event Insert Utility
- --------------------------------------------------
-
- To use the TP application play the script "tp".
-
- Type Script/Play "tp"
-
- This script inserts a list of annual events into the SideKick
- Time Planner. You can specify a starting year and ending year,
- and TP inserts the annual event for each year within the
- specified range.
-
-
- Screen 1:
-
- You are prompted to enter the name of the SideKick Time Planner
- table to which you wish to add the events. You MUST choose an
- existing valid Time Planner tablename. This application DOES NOT
- allow you to create a new Time Planner table. Type in the
- tablename if it is in the current directory. Type in the full
- pathname if it is in another directory. The filename for a Time
- Planner table must have the letter A as the last letter, i.e.
- PLANS00A, CALENDRA, XXXXXXXA (a maximum of 8 characters in total)
- are all valid table names.
-
-
- Paradox checks the structure to see if it is a valid SideKick
- Time Planner structure. If the structure is invalid or if the
- tablename does not exist, you are returned to the prompt.
-
- Next, you are prompted to enter the range of years in which you
- wish to add your annual events. The minimum year is 1900 and the
- maximum year is 2099. Press <Esc> if you have made an error or
- press <Enter> to continue.
-
- NOTE: If you add events for many years, the size of your Time
- Planner table increases significantly. Therefore, only enter
- date ranges including years that are necessary and appropriate
- for your purposes.
-
- Screen 2:
-
- You see a table with seven fields
-
- Month
- Day
- Icon Type
- Alarm
- Description
-
- For each annual event, fill in the first five fields where
- appropriate. You MUST enter a complete valid date (month and
- day). Leap year dates are not allowed (i.e. 29 Feb).
-
- The Month value may contain any value from 01 to 12. The Day
- value may contain any value from 01 to 31. In both cases, the
- leading zero is necessary for the numbers 01 - 09.
-
- In the Icon Type field, press the <F1> key to bring up a list of
- available Icon Types. Select the appropriate Icon Type with the
- highlight bar and press enter. You must make a selection from
- this list and cannot make up your own icon type.
-
- Placing a "Y" in the Alarm field, schedules an alarm to go off at
- 12:00 noon on the day of the annual event. Placing an "N" in the
- Alarm field or leaving it blank does not set an alarm for that
- event.
-
-
- Press <F2> when you have finished entering events. You are asked
- if you are done entering data. Respond with a "Y" or "N". "N"
- returns you to editing the table, while "Y" initiates the
- insertion of the annual events. The program performs the
- necessary steps to insert the annual events into your SideKick
- Time Planner table. When the processing is complete, the updated
- SideKick Time Planner table is displayed on the screen.