Import Book/Borrower

Site Map Support Pricing

Products

Remote Card Catalog
Remote Circulation
MARC/AL
MARC LOC
MARCExplorer
Remote Data Entry
Import Book/Borrower
BookWhere 2000
Internet Catalog
Network Configuration

Solutions

Library Management
Bar Code Solutions
Internet Research

 

Import Book/Borrower 

(supports Auto Librarian™ SE)

Product Fact Sheet

Auto Librarian™ Import Book/Borrower SE is a utility which allows books and/or borrowers to imported into a new or existing Auto Librarian SE database from a dBase 4 or greater file in 2 easy steps.
FEATURES

Easy to Use

Auto Librarian™ Import Book/Borrower SE is an easy way to import existing book or borrower data into Auto Librarian SE book or borrower databases. If the existing data can be exported into dBase 4 or greater format and the data can be manipulated to mee the import file specifications this utility will import the data in 2 easy steps. Librarians can save hours of duplicated data input time by using this import feature if the data is available in another database.

Includes instructions including the file specifications and import instructions in .pdf format.  The user creates the import dBase file from an existing database (for example Microsoft Access or Excel) by exporting the data into a dBase file with the specifications listed below.  The files are placed in a particular folder on the hard drive and the import utility does the rest. Duplicate booknums and borronums are rejected.

Import Book File Specifications

FILE STRUCTURE OF THE IMPORT DBASE FILE

Field

Field Name

Dbase Type

Access Type

Size

BOOK NUMBER

BOOKNUM

STRING

TEXT

12

TITLE

TITLE

STRING

TEXT

60

AUTHOR

AUTHOR

STRING

TEXT

40

COPYRIGHT

COPYRIGHT

STRING

TEXT

4

PUBLISHER

PUBLISHER

STRING

TEXT

30

CALLNUMBER

CALLNUMBER

STRING

TEXT

25

ISBN

ISBN

STRING

TEXT

13

LCCN

LCCN

STRING

TEXT

12

COST

COST

FLOAT64

NUMBER CHOOSE SIZE: DOUBLE IN ACCESS

7(2DEC)

SUMMARY

SUMMARY

BLOB

MEMO

MEMO

SUBJECT 1

SUB1

STRING

TEXT

50

SUBJECT 2

SUB2

STRING

TEXT

50

SUBJECT 3

SUB3

STRING

TEXT

50

SUBJECT 4

SUB4

STRING

TEXT

50

ILLUSTRATOR

ILLUSTRAT

STRING

TEXT

40

PAGES

PAGES

STRING

TEXT

5

Import Borrower File Specifications

FILE STRUCTURE OF THE IMPORT DBASE FILE

Field

Field Name

Dbase Type

Access Type

Size

BORROWER NUMBER

BORRONUM

STRING

TEXT

12

LAST NAME

LAST_NAME

STRING

TEXT

20

FIRST NAME

FIRST_NAME

STRING

TEXT

10

ADDRESS

ADDRESS1

STRING

TEXT

10

ADDRESS

ADDRESS2

STRING

TEXT

30

CITY

CITY

STRING

TEXT

20

STATE

STATE

STRING

TEXT

2

ZIP CODE

ZIP

STRING

TEXT

10

PHONE

PHONE

STRING

TEXT

13

EMAIL

EMAIL

STRING

TEXT

50

System Requirements

COMPUTER: Pentium processor with 24 MB RAM.

MONITOR: Resolution: 640 x 480

SYSTEM: Windows 2003/XP/2000/NT/Me/98/95

More reasons to choose Import Book/Borrower:

No Service Fees or Contracts - Unlimited Technical Support - Technical support is available at no additional cost via email or non-toll free number.

Affordable Pricing - See Pricing for current prices. License: Price is for single site license (per library) and is a one time purchase.

Companion Products:

Auto Librarian™ SE Library Server - Library Management Software used in conjunction with Remote Data Entry Utility.

To order call, write or email 

MC˛ SYSTEMS

Address:  115 Oregon Lane, Boca Raton, FL 33487-1523

Phone (sales):  (800)330-8026

Phone (technical support): (561)997-2509

Fax/local phone:  (561)997-8026

Email:  sales information - sales@autolib.com

technical support - techsupport@autolib.com

Website:  www.autolib.com

AUTO LIBRARIAN is a  trademark of MC˛ SYSTEMS. Windows Me/98/95/XP/2000/NT/XP/2003 are trademarks of Microsoft Corp. Other brand, company and product names are trademarks or registered trademarks of their respective holders.

 

 

 

Back Home Up Next