Overview
   Help with Help

Fig 2-1

The eSchool help viewer with its three areas

      Test Hyperlink
   Copyright Notice

Pocket eSchool
   A Tour of Student Forms

Tab 2-1

Some Pocket eSchool Student Forms

   A Tour of Teacher Forms

Tab 2-2

Some Pocket eSchool Teacher Forms

   A Tour of Course Forms

Tab 2-3	Some Pocket eSchool Course Forms
Tab 2-4	Some Pocket eSchool Room Forms

   A Tour of Bus Forms

Tab 2-5

Some Pocket eSchool Bus Forms

   A Tour of Statistics

Tab 2-6

Showing Statistics Tables

   Selecting Records

Tab 2-7	Searching data grids using the built-in methods
Tab 2-8	Searching with My Order Prebuilt Order Sets
Tab 2-9	An example of a Pocket eSchool Query
Tab 2-10	Using Pocket eSchool's Cross Reference Data Grids

   Navigation Basics

Tab 2-11

Using Pocket eSchool's Toolbar Icons

   Picture Sizes
   Building Queries

Tab 2-12	Examining an existing Pocket eSchool Query
Tab 2-13	Building a New Pocket eSchool Query

   Adding contacts and contact data

Tab 2-14

Adding some contact data

   Management
      Adding user-defined data items

Tab 2-15

Adding User Data Items

      Adding user-defined data forms

Tab 2-16

Adding and Using User-defined Data Forms

      Setting Tap Link and Cycle Order

Tab 2-17

Setting the Tap Link and Cycle Order

      Security

Tab 2-18

Using Pocket eSchool's security features

Installing Pocket eSchool
   Installing on a Palm

Fig 3-1	Initiating the download from the Pocket eSchool web site
Fig 3-2	The File Download message box -- click on Save
Fig 3-3	Selecting the Desktop as a destination for the download
Fig 3-4	Windows Explorer with the newly added disk and the K: disk selected
Fig 3-5	The icon on the Desktop for the Pocket eSchool demo palm.exe file
Fig 3-6	Double-clicking on the Pocket eSchool demo Palm.exe file prompts for the Unzip to folder
Fig 3-7	The WinZip completion message, showing that 289 files were unzipped.
Fig 3-8	The card now containing the eschool folder with the pictures and temp subfolders
Fig 3-9	The temp folder contains data and program files
Fig 3-10	The update program in the k:\palm\launcher\ folder
Fig 3-11	The Palm display showing the esUpdate program.
Fig 3-12	The esUpdate program showing its Update Ram button
Fig 3-13	The completion message after the files have been copied to the Palm's ram
Fig 3-14	The All Menu, showing all programs, including Pocket eSchool
Fig 3-15	The Pocket eSchool main menu after a successful installation

   Installing on a Pocket PC

Fig 3-16	Initiating the download from the Pocket eSchool web site
Fig 3-17	The File Download message box -- click on Save
Fig 3-18	Selecting the Desktop as a destination for the download
Fig 3-19	Microsoft's ActiveSync window, showing that ActiveSync is active and connected.
Fig 3-20	The icon on the Desktop for the Pocket eSchool demo ppc.exe file
Fig 3-21	Double-clicking on the Pocket eSchool demo ppc.exe file prompts for the Unzip to folder
Fig 3-22	Accessing the Setup.exe file in the c:\es\pes_ppc folder.
Fig 3-23	One of several Installation screens that make up the installation process
Fig 3-24	Windows Explorer, showing some of the program files installed on the Pocket PC
Fig 3-25	Windows Explorer, showing some of the data files installed on the Pocket PC
Fig 3-26	The Pocket PC's Today Screen and its Start menu item
Fig 3-27	The Programs screen, showing various program icons and program names
Fig 3-28	Pocket eSchool's main menu on the Pocket PC
Fig 3-29	Pocket eSchool's dropdown main menu on the Pocket PC
Fig 3-30	Pocket eSchool's main menu on the Palm
Fig 3-31	Pocket eSchool's dropdown main menu on the Palm
Fig 3-32	Tapping the keyboard icon, on the lower right, to launch the software keyboard
Fig 3-33	Selecting the input options on the Pocket PC

   Installing on a PC

Fig 3-34	Initiating the download from the Pocket eSchool web site
Fig 3-35	The File Download message box -- click on Save
Fig 3-18	Selecting the Desktop as a destination for the download
Fig 3-37	The icon on the Desktop for the Pocket eSchool demo win.exe file
Fig 3-38	Double-clicking on the Pocket eSchool demo win icon launches the Pocket eSchool setup wizard
Fig 3-39	Verifying that the install folder is c:\Program Files\Pocket eSchool
Fig 3-40	Finding the Pocket eSchool program in the Programs menu
Fig 3-41	The Pocket eSchool icon on the desk top after dragging it from the Program menu
Fig 3-42	The Windows version of Pocket eSchool's main menu

Installing eSchool PDA Edition
   Downloading eSchool PDA Edition

Fig 4-1	The Customer Login link on the Pocket eSchool Web Site Home Page
Fig 4-2	The EADS Customer Login page
Fig 4-3	The EADS File Download/Upload Page
Fig 4-4	The File Download dialogue box.
Fig 4-5	The Save As dialogure box with the Desktop selected
Fig 4-6	The eschool_pda_install_cd.exe file on the desktop

   Installing on a Single Computer

Fig 4-7	The WinZip Self-Extractor dialogue box, showing the unzip destination
Fig 4-8	Showing the contents of the c:\es\install folder
Fig 4-9	First dialogue box; choose Continue
Fig 4-10	Name and Organization Information dialogue box
Fig 4-11	The eSchool PDA Edition Setup dialogue box
Fig 4-12	The last Setup Dialogue box
Fig 4-13	The Validation Failure message
Fig 4-14	Selecting the activation record text data in the email from EADS
Fig 4-15	The yellow smiley icon used to launch eSchool
Fig 4-16	The activation confirmation message
Fig 4-17	eSchool's Login form
Fig 4-18	eSchool's request for this station's location
Fig 4-19	The eSchool PDA Edition menus and tool bars

   eSchool File Locations and Your Data

Fig 4-20	The c:\es folder, its subfolder, files, and the eschool.ini file
Fig 4-21	The File Menu showing the Restore Data... Menu item
Fig 4-22	The expanded c:\es\ship folder
Fig 4-23	Accessing the "Help\System Information" menu
Fig 4-24	The eSchool System Status form, showing update and file statuses; the encrypted contents of the eschool.ini file
Fig 4-25	Viewing and editing the plain text version of the eschool.ini file
Fig 4-26	The Form Launcher with the System Creation/Setup form selected and launched
Fig 4-27	Selecting the source for creating your school's data folder
Fig 4-28	The Ship folder, after the new data folder, dataphs, has been added
Fig 4-29	The Data Selection form is shown when two or more data folders are available
Fig 4-30	The Title bar, showing the new school's name, Pleasantville High School

   Installing on a Network

Fig 4-31	Windows Explorer, showing the c drive and the server as \\eschool1
Fig 4-32	Accessing the eSchool Security form from the System menu
Fig 4-33	The Security\Servers page, showing the only the local drive
Fig 4-34	The Security\Servers page after the new server was added
Fig 4-35	The eSchool Data Selection form, requesting that the user select a data file
Fig 4-36	The eschool.ini file, shows that 'server2' has been added
Fig 4-37	The eschool.ini file being displayed by Notepad and showing the server data paths encrypted

   Installing on a New Station

Downloading your School's Data

Fig 5-1	The toolbar showing the PDA Man button
Fig 5-2	The Forms menu shows various favorite forms, including the Pocket eSchool Manager form.
Fig 5-3	The Import Jobs page of the Pocket eSchool Manager form
Fig 5-4	The Data page of the Pocket eSchool Manager form
Fig 5-5	The Export Jobs page of the Pocket eSchool Manager form

   Importing Data

Fig 5-6	The Info Page showing the eight sample import jobs
Fig 5-6	The Import Script page, showing some script file information

      The Small File Example

Fig 5-8	The full script for the Small File Example Import Job
Fig 5-9	The Structure Directives for the Small File Example Script file
Fig 5-10	The Dictionary Directives for the Small File Example
Fig 5-11	The Data File Directives of the Small File example
Fig 5-12	The import log, progress message, and completion message for the import
Fig 5-13	The top of the Import Log, showing the results of the Structure and Dictionary Directives
Fig 5-14	The middle of the Import Log showing the results of the /ItemList Directives
Fig 5-15	The bottom of the Import Log, showing the results of processing the data files

      The Flat File Example

Fig 5-16	The Pocket eSchool Manager with the Flat File Example selected
Fig 5-17	The Import Script page showing information about the import script file
Fig 5-18	The top third of the Flat File Example script file
Fig 5-19	The middle third of the Flat File Example script file
Fig 5-20	The bottom third of the Flat File Example script file

      The Full Flat Example

Fig 5-21	The first quarter of the Full Flat Example script file
Fig 5-22	The second quarter of the Full Flat Example script file
Fig 5-23	The third quarter of the Full Flat Example script file
Fig 5-24	The fourth quarter of the Full Flat Example script file
Fig 5-25	The top of the import log, showing the script file listing and messages
Fig 5-26	The top of the import log, showing the result of the structure directives
Fig 5-27	The top of the Import Directory table
Fig 5-28	The bottom of the Import Directory table and the item header for students_flat
Fig 5-29	The item headers for schedules_flat, teachers_flat, and staff_flat
Fig 5-30	The bottom of import log, showing the File Import Summary and the Input Error Log

      The Physical File Types Example

Fig 5-31	Part of the script file, showing six kinds of file type references for the teacher import file
Fig 5-32	Viewing the teachers_flat_x.xls Teachers demographic file in Excel format
Fig 5-34	Viewing the teachers_card.txt Teachers demographic file in in Fixed Format

      The Relational Inline Example

Fig 5-35	Part 1 - The Structure Directives and AddItem Directives
Fig 5-36	Part 2 - The Student, Teacher, Person, and Relationships Dictionary Directives
Fig 5-37	Part 3 - The Addresses, Phones, Courses, Sections, and Schedules Dictionary Directives
Fig 5-38	Part 4 - The File Directives for the Students, Teachers, Persons, and Contacts Files
Fig 5-39	Part 5 - The File Directives for the Addresses and Phones Files
Fig 5-40	Part 6 - The File Directives for the Courses, Sections, and Schedules Files
Fig 5-41	Part 1 of the Relational Inline Example Script Log
Fig 5-42	Part 2 of the Relational Inline Example Script Log
Fig 5-43	Part 3 of the Relational Inline Example Script Log
Fig 5-44	Part 4 of the Relational Inline Example Script Log
Fig 5-45	Part 5 of the Relational Inline Example Script Log
Fig 5-46	Part 6 of the Relational Inline Example Script Log

      The Relational External Example

Fig 5-47	The Data File Directives of the Relational External Example script file
Fig 5-48	The Record Access portion of the Import Log for the Relational External Example

      The Pinnacle Example

Fig 5-49	The Structure and Dictionary Directives for the Pinnacle Script File
Fig 5-50	The Data File Directives for the Pinnacle Script File
Fig 5-51	Part 1 of the Pinnacle Script File Import Log
Fig 5-52	Part 2 of the Pinnacle Script File Import Log
Fig 5-53	Part 3 of the Pinnacle Script File Import Log
Fig 5-54	Part of the script file when external data files are accessed

      The Principalm Example

Fig 5-55	Part 1 of the Pocket eSchool script file
Fig 5-56	Part 2 of the Pocket eSchool script file
Fig 5-57	Part 1 of the multi.txt header file
Fig 5-58	Part 2 of the multi.txt header file
Fig 5-59	Part 1 of the Log file
Fig 5-60	Part 2 of the Log file
Fig 5-61	Part 3 of the Log file
Fig 5-62	Part 4 of the Log file
Fig 5-63	Part 5 of the Log file
Fig 5-64	Part 6 of the Log file

      Script File Directive Reference
      Using the Hex Viewers

Fig 5-65	The Hex Viewer menu is shown after clicking the Hex Viewer button
Fig 5-66	The Open dialogue box for selecting the file to be viewed is chosen
Fig 5-67	The hex editor, showing the beginning of the multi.txt file
Fig 5-68	A Hex Viewer look at the multi.txt file, showing Tabs in the item list
Fig 5-69	The Hex1 view of the multi.txt file
Fig 5-70	The Hex1 view of the multi.txt file, showing the tab character -- 09h
Fig 5-71	The Hex2 view of the multi.txt file
Fig 5-72	The Hex2 view of the multi.txt file, showing the tab character -- 09h
Fig 5-73	The Text Lines view of a text file showing start byte value, line length, and line values
Fig 5-74	The Text Column view of a data file
Fig 5-75	Using the Text Column viewer for a file in card image format

         What is hexidecimal?

Fig 5-76

An ASCII table, showing the character codes in decimal and in hexidecimal

      The eSchool Data Dictionary

Fig 5-77	The eSchool Dictionary form is available from the System menu item.
Fig 5-78	The first page of the Dictionary form, showing a number of data files
Fig 5-79	The Items page of the Dictionary form
Fig 5-80	Showing the System data item Last Name which may not be edited by users
Fig 5-81	A data item that is editable and deletable
Fig 5-82	Gender is an example of a List data type.
Fig 5-83	The data item Category uses a look-up list, named Persontype
Fig 5-84	The List page, showing the values of the Person Type list
Fig 5-85	The List Information page shows some of the specifications for this list
Fig 5-86	The Hidden Menu, showing some Diagnostic options
Fig 5-87	The Browse window, showing part of the Person table
Fig 5-88	The Diagnostic form where the Person file can be browses by any of its keys

   Viewing the Imported Data

Fig 5-89

The toolbar showing, the eSchool data form buttons

      Student Forms

Fig 5-90	The List page of the Student Demographic form
Fig 5-91	The List page after clicking the Student Name column and tapping on the P key
Fig 5-92	After the First Name column header was clicked, the first names are in ascending order
Fig 5-93	After the First Name column header is clicked again, the first names are in descending order
Fig 5-94	The Demographics page of the student form
Fig 5-95	The student form, showing the demographic data grid of the data to be downloaded to the handheld
Fig 5-96	Scrolling the demographic data grid down to see the rest of the data items
Fig 5-97	Selecting a different Demographic Data export grid
Fig 5-98	The contacts page shows three grids: the person grid, the phone grid, and the address grid
Fig 5-99	Clicking on Dustin Albrecht father's grid row makes his phone numbers and addresses appear in the grids
Fig 5-100	Double-clicking the work phone entry launches a phone detail form on the selected phone
Fig 5-101	Double-clicking the address entry launches an address detail form on the selected address
Fig 5-102	Double-clicking on a person's entry launches a person detail form on the selected person
Fig 5-103	The student form's Schedule page
Fig 5-104	Using the Terms filter drop-down list box to select a different display term.
Fig 5-105	Double-clicking the General Shop grid schedule cell launches the course form
Fig 5-106	Double-clicking the Rembold, Curtis teacher cell launches the teacher form
Fig 5-107	Double-clicking the Shop room cell launches the room form
Fig 5-108	Double-clicking the Start Date cell for the Shop section, launches the section form
Fig 5-109	The Class Data Grid page, showing the schedule and class-specific data
Fig 5-110	Using the horizontal scroll bar on the grid to scroll it to the right to see hidden data
Fig 5-111	Using the splitter bar to split a grid into two independently scrolling grids

         Form Design

Fig 5-112	The right-click menu, showing the Edit Form and Start Form Design menu items
Fig 5-113	The Form Design Toolbar and the Data Item Picker form for dragging data items to the form
Fig 5-114	The demographic page after dragging and dropping the Car Stall data item onto the page
Fig 5-115	After dragging the Car Stall caption and text box objects to a new location
Fig 5-116	Resizing the Car Stall text box so it is now 90 pixels wide

         Managing Relationships

Fig 5-117	The Relationship page of the System Setup Form, showing the Mother relationship
Fig 5-118	The Relationship page, showing the Daughter relationship
Fig 5-119	The newly added Step Grandmother relationship entry
Fig 5-120	The newly added @Step Grandmother reverse relationship entry
Fig 5-121	The Step Grandmother relationship
Fig 5-122	The Step Granddaughter relationship
Fig 5-123	The Step Grandson relationship
Fig 5-124	The Step Grandfather relationship

      Teacher and Person Forms

Fig 5-125	The Person form, showing the student, Jane Albrecht
Fig 5-126	The Teacher form, showing the teacher, Erin Brucklacher
Fig 5-127	The Export Data Grid showing data to be downloaded to the handheld
Fig 5-128	The Teachers' Contacts Page
Fig 5-129	The Teachers' Schedule Page

      Section Forms

Fig 5-130	The List page of the Section form
Fig 5-131	The Data page, showing the section's scheduling detail
Fig 5-132	The Roster page, showing the students enrolled in the section

         Department, Course, and Room Forms

Fig 5-133	The Favorite Forms Menu lists the Department form
Fig 5-134	The Department Form's List Page
Fig 5-135	The Department Form's Data Page, showing the Course List Grid
Fig 5-136	The Course Form's List Page
Fig 5-137	The Course Form's Data Page
Fig 5-138	The Room Form's List Page
Fig 5-139	The Room Form's Data Page

      Importing Pictures

Fig 5-140	The Windows Explorer, showing the sample Herff_Jones picture cd folder
Fig 5-141	A look at the student.txt file with Notepad
Fig 5-142	The JPGS folder with the image files and a display of one of the image files
Fig 5-143	The Group Picture Transfers page of the Picture Manager
Fig 5-144	Drilling down the jpgs folder in the Select Directory dialogue box
Fig 5-145	The message that the Picture Manager detected the Herff-Jones format
Fig 5-146	The image files with new names in the phototemp folder
Fig 5-147	The student.txt data and the picture for the selected student
Fig 5-148	Dragging the lower edge of picture form down to resize it.
Fig 5-149	The Thumbnails view of some of the pictures
Fig 5-150	The matching operation lists the student's status in the Status column
Fig 5-151	Teacher Alta Jones' Match status is listed as Unknown
Fig 5-152	Acknowledgement for the Post operation
Fig 5-153	The Teacher form for Alta West, showing no picture
Fig 5-154	The Teacher form after clicking on the picture control
Fig 5-155	A right-click shows the Read photo file menu item
Fig 5-156	The right-click menu shows several fixup options
Fig 5-157	Opening a folder containing jpg image files that need to be posted
Fig 5-158	Selecting an image in the list of image files

      Scripting data for the Handheld

Tab 5-1	Showing the pre-built script on the handheld
Tab 5-2	Constructing a script in a user-defined character data item
Fig 5-159	The Script Editor Form, showing medical data for Jane Albrecht
Fig 5-160	Moving the focus to a different Page by selecting it
Fig 5-161	The compressed version of Health Info stored as a memo data item
Fig 5-162	The Health Info data after the script processor has added some formatting
Fig 5-163	The Health Info data in its own text form

   Preparing the Demographic Data Grids

Fig 5-185	The Data page of the Pocket eSchool Manager form
Fig 5-186	The Grid Item Mover where Student Demographic items are selected to be downloaded
Fig 5-187	Reviewing the data items selected for the student demographic grid
Fig 5-188	The Key Item Mover Form for selecting the My Order data keys
Fig 5-189	The Grid Item Mover for the Teacher demographic data items
Fig 5-190	The Preview of the Teachers' Demographic Data Grid
Fig 5-191	The Grid Item Mover for the Staff demographic data items
Fig 5-192	The Preview of the Staff Demographic Data Grid

   Setting the Download Specifications

Fig 5-193	The Export Jobs page of the Pocket eSchool Manager with the Admin Palm job selected
Fig 5-194	The Export Specs page showing grid selections, data folders, and download options
Fig 5-195	The eSchool Card Folder Check message, showing that all folders are visible
Fig 5-196	The Card Folder Check message, showing that the SD card is not visible
Fig 5-197	The Export Specs page for downloading to a Pocket PC
Fig 5-198	The Options/Security Page, showing the default specifications
Fig 5-199	The Summary Grid Mover where various statistics grids are available
Fig 5-200	The Schedule Data Item Mover, used for selecting class-specific data items
Fig 5-201	The next set of security settings in the security grid
Fig 5-202	Showing some of the Management options
Fig 5-203	Showing more Management/Security options

      Building Statistics Grids

Fig 5-204	Launching and displaying the Grid Manager form
Fig 5-205	The Query Page of the Query Manager, showing the name of the associated query
Fig 5-206	The Query Manager form for the All by grade/gender query
Fig 5-207	The Query Manager's Info page, showing the query's name and subtitle
Fig 5-208	The Query Manager's Sort Order page, listing the order keys
Fig 5-209	Previewing the Grade Gender Summary grid
Fig 5-210	Selecting the Birth Month Number, Grade and Gender as sort keys
Fig 5-211	Previewing the Month Grade Gender Summary grid
Fig 5-212	The Gender, Ethnic Code, and Grade order selection
Fig 5-213	A preview with the Gender, Ethnic Code, and Grade order
Fig 5-214	The Grade, Ethnic Code, and Gender order selection
Fig 5-215	A preview with the Grade, Ethnic Code, and Gender order
Fig 5-216	The CourseGrade grid entry
Fig 5-217	This grid type allows keys to be selected from the Coursename file
Fig 5-218	A preview of the Course Grade summary grid
Fig 5-219	Adding the selection condition Ethnic Code equals W to the query
Fig 5-220	The Query Manager with the desired query condition constructed
Fig 5-221	A preview of the Grade Gender Summary grid for students whose ethnic code is W

   Downloading to a Palm

Fig 5-222	The Export Jobs page of the Pocket eSchool Manager, showing the Export button
Fig 5-223	A progress bar showing what is presently being downloaded
Fig 5-224	The download completion message

   Downloading to a Pocket PC

Fig 5-225	The Export Jobs page of the Pocket eSchool Manager, showing the Export button
Fig 5-226	The Export Specs page, showing the Pocket PC options selected
Fig 5-227	Progress information, showing the Pocket eSchool Manager writing export files
Fig 5-228	The download completion message

Update Notes

* topics are in progress