User import tag list

BAR

Barcode

ALTBAR

Alternative barcode

B-NOTES

Notes

B-NOTE1 - 10

User note 1 – 10

B-NOTES1 - 10

User note 1 – 10

(Added in SP13)

B-XXXXX

Any column in the borrowers table not covered by the standard tags, with some restrictions for data which requires special handling

CAT

User category

CIRCBAN

Banned from circulation (Y or N)

COSTC

Cost centre

DIST(+)

District

DOB or UDOB

Date of birth

EXP

Membership expiry date

FORE

Forename

GNAME

Group name (group record)

GROUP

Group name (group membership record)

GRSEC

Group seccode (group membership record)

IDENT or UIDENT

User's Identification field

INIT

Initials

INST(+)

Institution

JOIN

Join date

LASTACTIVE

Last active date

LASTCHANGE

Last changed date

LOC

Location

MAIL

Email address

MAXLOAN

Maximum loans

MAXREN

Maximum renewals

MAXRES

Maximum reservations

OCCUP(+)

Occupation

OWNSEC

Group owner’s seccode (group record)

PASS

Password (plain text)

PAYDATE

Pay date

PRESIGN

Presigned copyright declaration Yes/No

ROOMNO

Room number

SEC

Secondary Code

SELFREG

Self-registered (Y or N)

SEX

Gender (M or F)

SUR

Surname

TELHOME

The user’s home telephone number (to the borrowers record)

TELMOB

The user’s mobile telephone number (to the borrowers record, for SMS alerts)

TELWORK

The user’s work telephone number (to the borrowers record)

TEMP

Temporary (Y or N)

TIU

Title (Mr, Mrs, Miss, etc.)

TP(+)

User type

ADTP

Address Type (changed from ATP in OLIB 8.0. ATP continues to be supported for import, but use ADTP in preference for forward compatibility

ADREE

Addressee

HOUSE

House Name

STR

Street

PO

PO Box

DST

District

CITY

City

REG

Region

CNTRY

Country

PC

Post Code

EMAIL

Email Address

TELCOUNTRY

TELAREA

TELNUMBER

TELEXTEND

Telephone Number

FAXCOUNTRY

FAXAREA

FAX

FAXEXTEND

Fax Number

FTP

ftp address

NOTE

Note

END

End Date

START

Start Date

DELETE

For removing links to departments

DEPT(+)

User's department key ID
When suffixed with "+", the data should specify both the key ID and the description, separated by two or more consecutive spaces.

DEPTD(+)

User's department long description
When suffixed with "+", and the description does not match an existing record, the key ID will be generated as a number.

DELETE

For removing links to courses

COURSE(+)

User's course key ID.
When suffixed with "+", the data should specify both the key ID and the description, separated by two or more consecutive spaces.

COURSED(+)

User's course long description
When suffixed with "+", and the description does not match an existing record, the key ID will be generated as a number.

DELETE

For removing links to objects

OBJECT(+)

Object type and locator for the object to attach to the user

The value should be specified in several parts, for example: T - for textual (as opposed to file) location information

A space

WWW - The key value for the Object Type to be assigned to the Object created

Two spaces

http://students.ourcollege.ac.uk/......dent-78485.jpg - the URL for the image

SEC

Group identifier

FLD

Name of RAPID field to add/update

VAL

RAPID field value to insert or set