SelectQu Manual v24.0 9/27/03

SelectQu

Data Download

and

Terminal

Software

V 24.0.0.0 September 27th, 2003 Select Information Systems, Inc

www.selectqu.com 856-224-0165 info@SelectQu.com

14. Downloading Map File setups:

This is the new (v23.0.0.4) way to create download data map files. This new way has the

data Fields defined from the DMS system. You don’t need to know the field layouts

on your DMS, because we’ve done the work for you. Below if a explanation of the

different portions of the screens and how they are used.

Operation Type: This is the type of download or upload you are doing. You select this setting when you create first

Create the Download Map File and can’t be changed afterwards. Here are your chooses:

Download ADP via SODB. SODB Stands for SelectQu’s Data Transfer engine. This is a special type of

transfer that SelectQu uses and allows many special features. Using this type

of transfer does require that the SODB program be loaded on your DMS

system.

Download ADP via ENG: Download data using a English statement along with the ENG function on

the DMS system. This function must be used if SODB isn’t loaded onto

your DMS system. Warning: The integrate of the data can’t be validated

using this method.

Download R&R (Old Way) This is the method that SelectQu used for the last five years and is only

Included because of backwards compatibility.

Download R&R (New Way) Build a map file using this Operation type will give you the ability to

Download data from R&R via the 6910 function (Report Generator).

All the other functions are disabled are only for use with 3^rd party pc application companies.

File Prefix: This is the four letters that your download will be called. It can only contain 4 letters,

no less or no more. Try to name it something you will remember when you see the name.

File Type: This is defined when the Download Map file is first created and can’t be changed. Below

is a list of the available files:

Vehicle Inventory Service Customer/History

Service Customer/Vehicles Service Appointments

Finance Customer and Fin Data Finance Customer and Fin History

Customer Name File Data Parts Inventory Data

Parts and Service Work In Process Service Stories

Service Op Codes Service Op Code Usage

Other

All of the files listed above have had their Data Fields map out, so SelectQu can allow

you to point-and-click to build your download map files without knowing anything

about the file structure on your DMS system.

Logon or Store#: This is where you would enter the name of the Logon (ADP) or the Store# (R&R). If

you are downloading from multiple logons/stores then separate them with a comma (,).

Description: This is the description for your download map file.

Field Description Grid:

This is the actual fields that you will be downloading. Some data in these grids would show up based

on the type of DMS you are creating the map file.

Field Description: This is the description of the field you will be downloading.

Field Name: This is the actual name of the field as defined by the DMS type.

Width: This is the actual width of the field as defined by the DMS type.

Attribute: This is the physical location of the data in the DMS system.

Conversion: This is the conversion that is used to turn raw data into formatted data.

File Name: Is the name of the file where the data resides. In most cases the file

name is the same for all fields, but can be different based of the data

you are pulling.

Query Grid:

All queries made against the data are stored in this grid, for each maintenance.

Query: You can create questions to ask, when the download is ran by entering the question

in this column. All questions must be assigned a # (number) in the next grid, so the

answer to these questions can be inserted into the correct place in the query.

# This is used for prompts. You would assign a different number to each Query

question that you are going to ask when the download is ran.

File Name: This is the data field to base the query on. Drop this column down and choose

the field.

Test: Is the type of test to do on the data:

Equal: The data in the download must match exactly to the value entered.

Not Equal: The data in the download can’t match the value entered.

Greater The data in the download must be greater than the value entered.

Greater or Equal: The data in the download can be either Equal to or Greater than the value

entered.

Less: The data in the download must be less the value entered.

Less or Equal: The data can be either Less or Equal to the value entered.

Data: You would enter the data that will be used in the query to check if its allowed to be

included in the download. This information must be surrounded by double-quotes “.

And/Or: You can group the queries together by using the word AND or the word OR.

The example above states the following:

1. The Vehicle can’t be Sold (NO SOLD)

2. The Balance has to be greater than 100.00 BALANCE Greater “100.00”

3. The vehicles NEW/USED field can’t have MISC in it.

Download Field Grid:

These are the available fields for this type of download. You can choose a field to be included in the download

by double-clicking on the field and it will add it to the download (Field Description Grid) at the column high-

lighted. Note: When you hold your mouse over a field the information on the field is displayed at the bottom.

The column ‘Type’: Means that the fields can be used for different download only:

Both: Means this field can be used for the SelectQu’s SODB interface program, English Statement

download or the Report Generator.

Report Only: This field can only be used in a English Download or the Report Generator.

SODB Only: This is a special field and can only be used with SelectQu’s SODB interface program.

Delimited Type:

This is the format that the data will have when it comes back from the DMS system:

1. Comma: Each field will be separated by a comma 2003,CUTLAS

2. Quoted: Each field will be separated by a comma, but will have

quotes surrounding the data: “2003”,”CUSTLAS”

3. Tab: Each field will be separated by a Tab.

4. Fixed 25: Each field will be padded with 25 spaces, so every 25 spaces

would contain a new field.

5. Other: This will allow you to specify what character is used to separate

the data. Some use | or ^

The remaining types are for special purposes.

By: This is the field that will be used to sort the data and is optional.

Actual Query Statement:

This statement is build either by you entering it or SelectQu creating it by the items you have

in the Query grid. The item in the query grid determine what data you will be getting. The

query items are then build to create the actual statement in the box.

We supply this box because you

might need to overwrite what it

being displayed.

Remember don't include any display

fields in this box, those go in the

Field Description box to the left.

The query can be rebuild automatically by either:

1. Clicking the button at the bottom that says: 'Build Query' or

2. When you say your changes it will as you to Rebuild the Query.

You don't need to do either one if you haven't changed the items in the Query Grid.

Buttons and Misc at bottom of screen:

Wait time: This is the time that you giving your DMS system to respond with data. If no data

has started after the time runs out then SelectQu will register a error, but keep waiting

for up to 10 errors. Some older DMS systems might require you to increase this

if you are doing a Service History download, but leave it at 300 and try the download

first.

Zip Up: This will automatically zip-up the download file after it has completed.

New: When you click on this button, it will clear all data except for the File Type information

and allow you to start a new Download Data Map File.

Delete: This will delete the current displayed Download Data Map file.

Build Query: Will take you Query selection items and build a query statement. This doesn't need

to be done unless you have changed you Query grid items.

Save: This will save all changes made to the Download Data Map file. It will also ask you

if you would to 'Rebuild the Query' first and also open a window for Download Save

Options:

1. If Create Installation Script for Download is checked it will create a installation script

that you can use to install the download on your Reynolds & Reynolds system.

2. If Install Download Map Files onto System now is checked then right after you click on

Continue it will connect to your DMS and install the downloads.

3. If Do a Test Download Now is checked then a test download will run after you click on

Continue.

If there are any question in the download that need to be answered, then the Download

Questions box will appear. After answering these questions click on Continue.

Add Field: SelectQu has a list of defined fields that match your DMS system. Some DMS systems

might have customs fields that wouldn't be in here. If this is the case or you just want to

change the description of the field then click this button to Add or Modify the field

definitions.

Close: Close the Download Map Building program and return to the list of maps on file.

Build Query: Will take you Query selection items and build a query statement. This doesn't need

to be done unless you have changed you Query grid items.

Options: This is where you set the special settings for the Download Maps.

Startup Data Needed:

Enter required keystrokes needed to start download. If most cases the only thing needed

in this grid is a O (letter O) if it is a Reynolds & Reynolds download. If you are using a

Unix printer name to do a download then you would substitute the O with %Print and enter

then Unix printer name under: R&R Slave Printer Name and check the box This is a Unix

printer.

Printer Max Width:

This is the maximum width that this report will print using the %Print options. 99% of the time

it will be 132.

Reynolds & Reynolds Systems:

If you are using a Unix slave printer to print then you can set this to 256. If you are using a

regular slave printer then you would enter the print width of that printer. If it is a printer that

does condensed printing then enter 256.

ADP:

If the type of download that you are doing is ENG (English Statement) then you can enter

the actual width of the download fount at the bottom of the Download Map setup screen, to

right of the Save button (Download Width).

Report Name:

Reynolds & Reynolds:

This would be the name of the report in Report Generator (function 6910). If multiple

reports are needed, due to a width restriction, then two things happen:

1. This download data map will be converted into multiple download data map

with each corresponding to different reports. You won't have to worry about

the additional download maps because SelectQu will handle the maintenance

and downloads from the main download map file that you are creating now.

2. Multiple reports will be created automatically. Each report corresponds to

the map files it creates. Internally SelectQu will add a number to each report

it needed.

ADP:

If this download is run from RPG Report Generator then this would be the name of the report.

Beginning of Report Data:

This would be the first thing that SelectQu would see when the report starts. This is how SelectQu

knows that the report is actually running. Normally you would use the field title of the first field

in the report.

End of Report Data:

SelectQu will look for this data in order to know when the report has completed.

Reynolds & Reynolds: This is always 'REPORT COMPLETED'

ADP (Eng): This is always: 'ENTER ENGLISH'

Merge Blank Line Setting:

Only applicable when doing a download on Reynolds & Reynolds or using ADP's (ENG or RPG)

Doesn't apply to SelectQu's ODBC connection.

Some fields that either have data that is wider that the field width allows or has multiple values

will wrap around to the next line. If this is happening on you download you can control it with

this:

Merge and Separate: This will take the wrapped lines and join them to the lines they

belong to and then separate them with a value mark chr(253). This

is used when you have multiple values in one field.

Merge Data Only: This will merge the data only: Example:

AAA Truck S will become: AAA Truck Stop

top

Skip Line: This will throw away any blank lines, causing it to ignore the data.

Do Nothing: Treats the wrap around as a record in the download.

MultiValue Seperation:

Some fields have multiple values in them. In most cases they are separated by a value

mark chr(253). Some companies don't link this character as a separation character, so

you can change it to another character.

Don't replace will leave the data alone.

Replace with a comma. This will replace the value mark with a comma. Warning:

will mess up the order of the fields in your download if the download is setup using

Delimitated Type of Comma and should not be used (Comma Quotes is Ok). Use

the next option instead.

Replace with a pipe. This will replace then value mark with a pipe | This character

is located on your keyboard, below the Backspace key.

Insert Store#/Acct Name:

This will add a addition field to the end of the download. This field represents on:

Reynolds & Reynolds: The store number that the data came from.

ADP: The account name that the data came from.

Type: Change this download type to another type. This feature is only available on ADP

downloads.

15. Report Downloads R&R (Old way):

Prefix Name: Is the four (4) letters given to the name of the map file. It can only contain 4 letters.

Logon:

Is the store # that will be used for this download. If you are downloading from multiple

stores then separate the store numbers with a comma (,). If you have to do navigate between

multiple menus and stores then you can specify then store number and the additional menu

option for department. Example: Need to download from store 1 and 3, plus pick the service

department which is menu option # 2, you would enter: 1;2,3;2

Actual key stokes:

These are the keystrokes needed to get the report started. Anything that begins with % will

not be sent over to the DMS. %PP tells SelectQ to prompt for data when doing a Manual

download.

Merge Blank Line Setting

Merge and separate data by VM (Value Mark #253).

This is used for the downloads that have multiple lines and must be

delimited into one field but still separated. Like Vehicle Option Codes,

their Descriptions and Service Op Codes and their description.

Merge Data Only. This will merge any data that has been wrapped, such as customer name.

Skip Line. This will force the download to skip the line altogether.

Leave Alone: If the first field is blank and this option is choosen then the data won’t

be modified.

16. Get Financial Statement:

SelectQu can also download your financial statement.

17. Doing Manual Downloads:

SelectQu can perform downloads either manually or with the use of simple text files. To use SelectQu manually all is

needed is the telephone number, system type, login and password.

All you need to do is enter this information on the Communications tab of setup and then Click on File – Do a

Download and this window will open:

The Single Download Files (Map files) list is a list of all the available downloads. The Grouped Download Files list is

downloads that are grouped together and ran as one.

You would check the box for the download you want to do. If there are any parameters that need to be set, such as

starting and ending dates you would enter them in the Starting Parameters box.

All map file names are based four characters, so when your data is returned, the file name will also be the same four

letters. If you need to make the file name unique then you can enter the unique data in the Add to Que entry box and

SelectQu will append this information onto the data file that is returned.

You can enter a Reynolds & Reynolds store# and this will change the map files for the download you are doing.

Now all you have to do is click on Start Download and the download will run.

18. Doing Automated Downloads:

Your program can also control SelectQu completely. Below is a list of operations needed to do this:

1. If you are mass calling DMS systems then you will need to create the following file.

This will override the current settings in SelectQu. The name of this file is: Sphone.Txt

and it contains the following information (if no changes are needed then leave a blank line):

Line 1: Telephone number you are calling.

Line 2: System type: 0 = Adp, 1 = R&R or any other number that corresponds

to the dropdown titled: Login Procedure.

Line 3: This will override the comport/modem settings.

Line 4: R&R store number where the data is to coming from. This will

override the store number in the map file.

Line 5: Override the login and password from what is currently listed in

the login grid. It is stored in the current format:

$USER,username,password

Note: The login grid on the Communication tab must have: $USER and

$PASS in the appropriate places for this to work.

2. Start SelectQ if it isn't already running. See instructions below for starting parameters.

a. If SelectQ isn't started with a parameter matching a download map file then the following will need to be done.

1. Create a que file that matches the first four letters of the download map

file. After the first four letters of the file name you can include any

characters that you want to make this file name unique. The remainder of the

file name would consist of .que: invv.que invvBobHonda.que Also

remember if you are using Group Downloads then use the grouped down-

load name.

If you need to pass any parameters to the download, such as dates, then you would

also include each one of the parameters on a separate line in the Que file.

b. After creating the que file(s), SelectQ will then start the download/upload. At

this point and until the download has completed you should do three things:

1. Start your own timer in your program. This is done solely because

someone could forced SelectQ to shutdown through the use of

Windows Task Manager. In almost all cases SelectQ will return

a error in your answer file stating that someone has shutdown SelectQ.

2. Start monitoring what is happening with SelectQ. This happens with

the use of a file called: Qstatus.txt. SelectQ writes a one line message

to this file constantly with the current status of it's operation. On average

this file changes every 6-15 seconds. SelectQ will protect Itself from

I/O file errors and you must do the same error checking to see if the file

is in use when you read it in.

This message is also great for displaying the messages in a dialog box

in your program, so the user will have some feedback as to the status

of the download/upload.

3. Wait for the answer file. This file will be created after the download

has completed. This is you key that SelectQ has finished.

If SelectQ was started by using a que file as a parameter then SelectQ will

automatically shutdown when it has processed the request. If it was running

and you created the que file, then it will go back to checking for more

downloads every 5 seconds.

19. Startup Parameters for SelectQu

Parameters can be specified in the short-cut that you would be using. They would be entered along with the program

in Target. Your other option of starting SelectQu is from within your program with the program name and the any

parameters. All parameters must be entered with a space in between each one.

If no parameters are used to startup SelectQu, then SelectQu will start and begin checking for downloads that need to

be done. This will allow SelectQu to continue running even after a download completed. If you specify a map file in

the parameter SelectQu will shutdown after the download is completed.

C:\SelectQu\SelectQu.Exe

Parameters:

Mapfile

Startup SelectQu and do the download for the map file specified, by the first four letters of the map file

name. Additional you can append any characters on the end of the 4 letters, so the answer files that you get

back will have the additional characters in it's name. Also, if the map file has a xtr file, then any additional

downloads that are specified in the xtr file will also be downloaded.

SelectQu.exe invv or SelectQu.exe invv1234

Additional Parameters:

P1 Parameter number 1. This would be any data that you want to pass to the download, such as

a beginning date. e.i. PU3/10/2003

P2 Parameter number 2. This would be any data that you want to pass to the download, such as

a ending date. e.i. PU3/10/2003

NU The telephone number you want to call. This will override the number that is currently in

SelectQ. If this is a direct connect via the comport or telnet connection then don't specify

this parameter. The number can include 9 to get out, but remember to use a, if need to pause

when dialing. e.i. NU8562240553 or e.i. NU9,8562240553

LO This parameter will allow you to change to a different login grid. Normally you would use 0

{zero} for ADP and 1 {one} for R&R. LO0 or LO1

ST This is the Reynolds & Reynolds Store number. If you need to get information from a

certain R&R store other than what is specified in the map file, then use this parameter.

Multiple store number can be specified by commas. e.i. ST1 e.i. ST1,2

UN This parameter will override the user login name in the login grid. The login grid must have

the word $USER

UP This parameter will override the user login password in the login grid. The login grid must

have the word $PASS in it where the password would go.

AS Auto start the download specified using the additional parameters stored in this text file.

You would create a text file with the additional commands listed above on one line separated

by a space. This would be helpful if you where calling multiple stores, because you could

create a different file for each store. e.i. ASTheFileName.txt

P Startup SelectQu and Prompt for the map file you want to download.

Nomad Startup SelectQu in Setup Mode.

SelectQu

Data Download

and

Terminal

Software

V 24.0.0.0 September 27th, 2003 Select Information Systems, Inc

www.selectqu.com 856-224-0165 info@SelectQu.com

Contents:

Excel Column Widths

SS Command Data Scol Srow Ecol Erow Column Row

Data @SUM E 5 E 10 E 12

Data @SUM E 5 E LastE Last+2

Data @SUM(E5..E10) E 12

Data ---------------- A 1 F 1

14. Downloading Map File setups:

16. Get Financial Statement:

18. Doing Automated Downloads:

19. Startup Parameters for SelectQu