Entering a Borrower Import Command Line

You can run Borrower Import two ways. You can create an icon to run it from your desktop using standard Windows procedures. You can also enter a command line that consists of switches. Each switch specifies a piece of data that defines how Borrower Import handles the information you import. Some switches are required—others are optional.

You can use switches to log on to Horizon if Horizon is not already running. Other optional switches specify defaults for the Borrower Import program. (For example, you can set a default for the btype of a group of borrowers so that you do not need to specify it in your header and data files.)

Here is a list of Borrower Import switches:

Switch

Description

/H

Header.ext. The header file name. This is optional if you are using a single line format.

/S

Server. The server name

/P

Password. The password

/U

User. The user name

/D

Database. The database name

/L

Location. The location

/B

Btype. The default borrower type.

/J

Julian date. This lets you enter the date as an integer date, or computer-assigned date since January 1, 1970.

/M

Mail sort type. The default mail sort type

/O

Phone type. The default phone type

/E

Alternate phone type. The default phone type to use when the borrower address contains an email address

/R

Begin/End Range. Beginning row, ending row

/C

Table, table. (Custom) tables based on borrower number

/N

New line code. ASCII code value (decimal) to use as the new line character

/Z

Zap. (Delete) Specify Y to delete or N not to delete all subtables on update or modify. The default for this is true in version 4.1, and false in version 4.2 and later versions.

/I

Input. The input file name

/F

Format. Either S32, S41, or M41

/K

Key. The unique key to the borrower table

/A

Address. Keep borrower_address data in send_notice_by, emailname, email_address, and preoverdue_flag columns from existing current address row when it's updated.

0. Do not keep any existing address data. (This is the default.)

1. Keep the data and move it to the current imported address.

2. Keep the data and move to all imported addresses.

3. Keep any existing address data. If there is no existing data, populate the address rows with the data from the incoming borrower record.

/X

No Checkout

No entry required.

Add the switch if you do not want borrowers whose records you import to Horizon to be able to automatically check out items.

If you add this switch, Horizon does not automatically mark the Approved box in the borrower record. To let borrowers check out items, your staff must mark the Approved box on the borrower’s record.

/V

Day End

No entry required.

This switch sets up Borrower Import as a Day End task. (Day End puts a /Vxxx into the command-line parameters of all the routines that it starts up.)

/Y

Match Column

No entry required.

This switch bypasses the requirement that the match column must be in a unique SQL index. When you use this switch, the match column can be in any SQL index. This means that Borrower Import can work with the second_id column. (The borrower triggers ensure that any non-null second_id values in the borrower table are unique.)

Unless you use the /Y switch, there must be a unique SQL index on the borrower number column and any columns specified with the /K (key) switch in order for Borrower Import to work. If one does not exist and you do not know how to create one, call SirsiDynix Customer Support.

 


© 1998-2017 Sirsi Corporation