ASSOCIATION OF JUNIOR LEAGUES INTERNATIONAL, INC.
        660 First Avenue, New York NY 10016-3241


        HOW TO USE AJLI INFO-SYSTEM DATABASES

You'll find valuable information on the varied work of Leagues, and other useful information, in the Database section of AJLI Info-System. Here's how to get started using it.

From the Top (Main) Menu, choose the menu letter for AJLI Databases (which at this writing is letter E), and then hit <ENTER>. You'll then see the following screen:


Please select one of the following:

1 ... Community Activities Database
2 ... Thrift Shops Database
3 ... Money Raising Events Database
4 ... Cookbooks Database
5 ... Child Health Database
6 ... Trainers/Consultants Database
7 ... Education Database
8 ... BBS Users Database
9 ... Download Database Queries

AJLI Databases (DATABASE)
Make your selection (1,2,3,4,5,6,7,8,D,? for help, or X to exit):

For Databases 1-7, you then choose a database to "query," or search for information. For this example, let's look at the Community Activities Database. Type "1" and then press the <ENTER> key. You'll then see the following message:

(Hit RETURN to Abort)

Please wait...Connecting to Community Act. Database...Connected to the Database Server.

Please wait.....



Then several quick characters will flash by--probably too fast to read. Don't worry; the Doorway to the AJLI Database machine is being opened. Soon you'll see these messages:

OK

DOORWAY to unlimited doors V 2.22ß - Copyright (C) 1987-1992 by Marshall Dudley
        COMMERCIAL VERSION
Your time available in door is 100 Minutes

Please Wait while Paradox loads...
Paradox Runtime 4.5 Copyright (c) 1993 Borland International All Rights Reserved.

¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦
¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦
¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦
¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦
¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦ Generating download file name, please wait...ACT2.TXT¦¦¦¦
¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦
¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦
¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦

Then you'll see the Database Query Form, which is a "worksheet" for you to fill in the specifics of your query.

JUNIOR LEAGUE/SPAC COMMUNITY ACTIVITY BULLETIN BOARD QUERY
In the fields below enter the criteria in which you are interested. See
page 2 for more fields. LEAVE FIELDS BLANK FOR WHICH YOU HAVE NO CRITERIA.
IF YOU LEAVE ALL FIELDS BLANK, THE ENTIRE DATABASE WILL BE CHOSEN.
Name of League      (i.e. ALB for ALBANY)
League State       (i.e. GA for Georgia)
League ID        (3 digits required)
League Area       (I, II, III, IV, V, or VI)
Title of Activity       (i.e. type any part of the title such as "child" for all community activities with the word child anywhere in the title.)
Activity Issue Code        (must be a 4 digit issue code.)
Page 1 of 2
----------------------------------------------------------------------------+
Press Ctrl-U to back up 1 field
Press ENTER to advance 1 field.
Pressing [CTRL-R] will process your query.
Pressing [CTRL-X] will Cancel.   
+----------------------------------------------------------------------------+ 
You move through the "fields" (search criteria) on this screen one at a time, using the <ENTER> key. After the Activity Issue Code field, hit <ENTER> and you'll be placed on Page 2 of the worksheet for this query.
This is what page 2 of the worksheet for this database looks like:

+-----JUNIOR LEAGUE/SPAC COMMUNITY ACTIVITY BULLETIN BOARD QUERY-------------+

  For the remaining fields enter a numeric range such as ">=50" to retrieve  
community activities which utilized 50 or more volunteers or "<10000"
for community activities to which the League contributed 10000 or less.
----------------------------------------------------------------------------

Number of volunteers involved in the activity

Total League/SPAC funds allocated +------------
;Page 2 of 2
----------------------------------------------------------------------------
Press Ctrl-U to back up 1 field, Press ENTER to advance 1 field.
Pressing [CTRL-R] will process your query. Pressing [CTRL-X] will Cancel.
+----------------------------------------------------------------------------+

Now, let's create a query. As a general rule with databases, the fewer "fields" you enter information, the more "records" you'll include in your query. For instance, if you leave all the fields blank except for Page 1's "Activity Issue Code," you'll create a query of all the records in this database sent in by members that were coded for that activity. You can obtain a list of these codes by downloading the file CODES.TXT in the Community Programming Library (/COMMPROG) on AJLI Info-System.

For example, the community activities code for Senior Citizens Services is 0540. If you enter this code in the Activity Issue Code field, the database will collect all the records coded to senior citizens services.

When finished, process your request by hitting the CTRL-R key combination. You'll see a screen similar to this. Don't worry if it takes more than a minute to display all this text. The database engine is searching for the records that match your criteria:

Querying database, please wait...
        [pause]
        24 records matched your criteria
        [pause]
Creating report file, please wait...
        [pause]
Done! Please download ACT2.TXT from the BBS QUERIES Library
Press X to exit,

Then hit X to exit. You'll see:

RETURNING TO HOST, Please wait...
***
Database Connection Closed.
Returning to the BBS...
Note that it's possible that your query might come up empty--that is, your criteria excluded all records in the database you're querying. In that case you'll see a message similar to

No Communities activities match the criteria!
Press any key to continue

You've been told the name of the new file with your information--in this case, ACT2.TXT--both just before you enter the query worksheet area, and as you leave. You can go back and create a new query now, or move on. Either way, you'll see the Database Menu again:
Please select one of the following:

1 ... Community Activities Database
2 ... Thrift Shops Database
3 ... Money Raising Events Database
4 ... Cookbooks Database
5 ... Child Health Database
6 ... Trainers/Consultants Database
7 ... Education Database
8 ... BBS Users Database
D ... Download Database Queries

AJLI Databases (DATABASE)
Make your selection (1,2,3,4,5,6,7,8,D,? for help, or X to exit):

If you then choose D, <ENTER>, to (D)ownload your query at this time, you'll see the QUERIES menu:

Welcome to the QUERIES Library.
Description: Paradox Report Queries

These are the reports from the Paradox Database

F ... DOS file listing
D ... Download a file
S ... Select a Library
P ... Set your preferences
X ... Exit File Libraries

Select a letter from this list, or ? for help:

Selecting D allows you to download the single query ACT2.TXT.

Enter file name to find, X to exit, or ? for help:

You must now type in the name of your query file--ACT2.TXT. Then <ENTER>.
Then you'll see the BBS's File Download Menu:

To begin downloading, choose:

L... Listing (a screen at a time)        

A... ASCII (continuous dump)  B... YMODEM Batch
K ... Kermit / Super Kermit  G... YMODEM-g
Z ... ZMODEM ZR... ZMODEM (resume after abort)

Choose a download option (or "X" to exit):

Here you can download the file as you would any other on the BBS.

However, it may be more convenient to do all your downloads at a later time. You may want to do other work during the current BBS session, such as look through a library for files to download. If so, you can (T)ag the query file(s) for later download..

To do this, at the QUERIES menu (shown below) choose F to list queries for Tagging. In addition, choosing F here will also show any queries created so far on this date by others:

Welcome to the QUERIES Library.
Description: Paradox Report Queries

These are the reports from the Paradox Database

F ... DOS file listing
D ... Download a file
S ... Select a Library
P ... Set your preferences
X ... Exit File Libraries

Select a letter from this list, or ? for help:

Choose F, <ENTER>, and you'll see a list of the query files for today:

QUERIES (DOS-Only)
File Name Size Date Time
_ ____________ _________ ________ _____
¯ ¯¯¯¯¯¯¯¯¯¯¯¯ ¯¯¯¯¯¯¯¯¯ ¯¯¯¯¯¯¯¯ ¯¯¯¯¯
** LISTING **
A MONY1.TXT 25558 07/28/94 09:55
B ACT1.TXT 11034 07/28/94 10:05
C ACT2.TXT 38981 07/28/94 10:16

Press ? for help, or X to exit.
To highlight a file, use your arrow keys or the letters in the left column.
RETURN views details on highlighted file, SPACE tags it, CTRL-D downloads.
All of the files that you have requested are displayed

Note that there are other queries listed, in addition to the "ACT2.TXT" file just created. If you had created several queries today, they'd all be listed here. Incidentally, if you accidently download the same query file twice, the second copy will be renamed. In the case of ACT2.TXT, the last letter will be changed (ACT2.TXU), to guarantee the first copy isn't erased.

Because these are "DOS only" files (not files uploaded by anyone), there are no descriptions (such as those for other files in the file libraries). If you try to view details on a highlighted file by hitting <ENTER>, you'll see the following error message:

+--NOTICE----------------------------------------------------+
¦
¦
¦ Sorry, there are no additional details regarding files
¦ in "DOS-Only" Libraries.
¦------------------------------------------------------------
¦ --- HIT ANY KEY TO RETURN --- ¦
+------------------------------------------------------------+

CTRL-T downloads tagged files.

Now tag your query file ACT2.TXT. Highlight it by typing either its letter in the left column, or by using the arrow keys. Then hit the Space Bar. You'll see the Tagged file(s) marked with astericks (*). The upper right corner of the menu will keep track of how many files you've Tagged.

QUERIES (DOS-Only)        (1 file Tagged)
File Name Size Date Time
_ ____________ _________ ________ _____
¯ ¯¯¯¯¯¯¯¯¯¯¯¯ ¯¯¯¯¯¯¯¯¯ ¯¯¯¯¯¯¯¯ ¯¯¯¯¯
** LISTING **
A MONY1.TXT 25558 07/28/94 09:55
B ACT1.TXT 11034 07/28/94 10:05
C * ACT2.TXT * 38981 07/28/94 10:16

Press ? for help, or X to exit.
To highlight a file, use your arrow keys or the letters in the left column.
RETURN views details on highlighted file, SPACE tags it, CTRL-D downloads.
All of the files that you have requested are displayed.

Hit X to exit this menu without immediately downloading ACT2.TXT.
Then you'll be placed back in the Queries Menu (shown on page 5). Then X, <ENTER>, to see the Database Menu:

Please select one of the following:

1 ... Community Activities Database
2 ... Thrift Shops Database
3 ... Money Raising Events Database
4 ... Cookbooks Database
5 ... Child Health Database
6 ... Trainers/Consultants Database
7 ... Education Database
8 ... BBS Users Database
D... Download Database Queries

AJLI Databases (DATABASE)
Make your selection (1,2,3,4,5,6,7,8,D,? for help, or X to exit):

Now type X, <ENTER> to leave the Database Menu.
You'll then be back at the TOP (Main) Menu. You can now work in other areas of AJLI Info-System, or leave the BBS at this time.
When you log off, you'll be reminded to download any files you left (T)agged--including your database queries. If you hit X to logoff, you'll see:

Intercepting logoff!

You have tagged the following file(s):

1. The file ACT2.TXT in the QUERIES Library (38K, < 1 minute)

To begin downloading, choose:

L... Listing (a screen at a time)        
A... ASCII (continuous dump)  G... YMODEM-G
B... YMODEM Batch  K... Kermit / Super Kermit
ZR... ZMODEM (resume after abort)   Z... ZMODEM

(Add ! to automatically log off when done)
        -1... untag the file
Your choice ('X' to log off, or 'R' to return online): z
(Hit Ctrl-X a few times to abort)

You may choose any Xmodem, Ymodem, or Zmodem protocol that you've set your communications software up already to use. Follow your communications packages instructions for downloading. This example uses Zmodem:

Beginning ZMODEM download of the file ACT2.TXT in the QUERIES Library (38K, < 1
minute)

*** DOWNLOAD COMPLETE ***

You are about to terminate this connection!
Are you sure (Y/N, or R to re-logon)? y
Ok, thanks for calling AJLI INFO-SYSTEM.
You were online this session for 24 minutes.
Hope to see you back again real soon!!
Have a nice day...


The BBS Users Database--Database #8--is fundamentally different than the others on the Database Menu. This database doesn't access the Doorway to an external database, and it doesn't create a file for download. But you can look up every currently registered user of AJLI Info-System, and search by any of three fields: First Name, Last Name, and League/SPAC number or other extension.

From the Top (Main) Menu, choose the menu letter for AJLI Databases, followed by <ENTER>. This is the Database Menu:

Please select one of the following:

1 ... Community Activities Database
2 ... Thrift Shops Database
3 ... Money Raising Events Database
4 ... Cookbooks Database
5 ... Child Health Database
6 ... Trainers/Consultants Database
7 ... Education Database
8 ... BBS Users Database
9 ... Download Database Queries

AJLI Databases (DATABASE)
Make your selection (1,2,3,4,5,6,7,8,D,? for help, or X to exit):

Type 8, <ENTER>, for the Users Database. You'll then see:

Find Users

This function allows you to look up other BBS users based on any/all
of the following criteria: First Name, Last Name, League/SPAC # or
Extension. You do not need to know the exact spelling of a name.
You can enter the first few characters of any field. For example,
if you type AN it will display all ANne, ANnette, or ANderson, etc.
You can also enter a League/SPAC #, or Extension in the appropriate
space to receive a list of all users in that group.

You may leave any two of the three search criteria blank if you lack
the requested information.

You may eXit this function at any time by entering 'X'.

Enter First Name:

You may then input information for any or all of the three fields--each time followed by <ENTER>:

Enter First Name:

Enter Last Name :

Enter League/SPAC # or Extension:

As with other databases, entering only partial details will list more information--in this case, more AJLI Info-System users.

For instance, leaving the First Name and Last Name fields blank, and entering "bod" for the League/Spac # or Extension field, will list all the Board of Directors who are currently registered on AJLI Info-System.

On the other hand, if you just type "andy" in the First Name field, and leave the Last Name and League/SPAC # or Extension blank, the database will list my name:

First Name   Last Name LG/SPAC # or Ext.

Andy     Polon     NYHQ


          End of Listing!

(N)onstop, (Q)uit, or (C)ontinue?


In this way you can quickly look up League/SPAC members and Association personnel.

In the Library BBSDOCS (at this writing, Library menu choice G) you can find the files:
LGLISTAL.TXT--League IDs alphabetically listed
LGLISTID.TXT--League IDs listed numerically
and STATES.TXT--Leagues listed alphabetically by state.
You can use these as references for League/SPAC ID numbers.


Back to Examples of Andy Polon Documentation

Back to Andy Polon PC Services Main Page