Home / Library Software / Handy Library Manager / Tutorials: importing data

Handy Library Manager  for Windows

.. > Auto-catalog, Import > Handy Library - Importing items, borrowers data


This topic explains:

  • Which data fields you can use when importing items or borrowers data?
  • What is the format of data fields used in new tables?

Moving data into our system:

LIBRARY_NEW table

Use this table in the following situations: import data from excel/text files, add data from MARC files (mnemonic text form), auto-catalogue from the web. If something goes wrong use Miscellaneous /Delete All Items command. If items are ready for circulation move them to main library catalogue.

BORROWERS_NEW table

Use this table in the following situations: import data from excel/text files. If something goes wrong use Miscellaneous/Delete All Items command.

Review tables below

  • use only data fields with YES status, other data fields are reserved by the program
  • verify data formats (DATE, NUMBER, TEXT are allowed)
  • set you barcode format before you import and move your data to main library catalog (check in/out options)
  • if you import data from Web or MARC files, verify marc mapping

DATE : date should be in your Window's short date format, example MM/DD/YYYY (01/22/2017):

NUMBER : number data should be in the following form: 12.22, 12, 2.02

TEXT : text data is used by all other data fields that are not DATE or NUMBER type

*B : if you don't import barcode number the program will create them automatically when data from the LIBRARY_NEW table is moved to LIBRARY main table, the same will happen with BORROWERS_NEW and BORROWERS main tables. New barocde numbers will be created according to the setup in the Options/Check In-Out/Barcode Options.


LIBRARY_NEW table:

field name

import allowed

ID -
DATE_ADDED -
TITLE YES
AUTHOR YES
TYPE YES
COAUTHORS YES
PUBLISHER YES
PUBLISHED YES
PLACE YES
SERIES YES
EDITION YES
CATEGORY YES
LEVEL YES
FORMAT YES
EDITOR YES
ILLUSTRATOR YES
PAGES YES
PHYSICAL YES
DEWEY YES
LCCN YES
ISBN YES
ISSN YES
UPC_EAN YES
SUBJECT1 YES
SUBJECT2 YES
SUBJECT3 YES
SUBJECTS YES
NOTES YES
SUMMARY YES
IMAGE YES
CUSTOM1 YES
CUSTOM2 YES
CUSTOM3 YES
CUSTOM4 YES
CUSTOM5 YES date
CUSTOM6 YES number
CUSTOM7 YES
CUSTOM8 YES
CUSTOM9 YES
BARCODE YES *b
CALL YES
VOLUME YES
LOAN_TYPE YES
COPY_NOTES YES
LOCATION YES
CONDITION YES
PURCHASED YES date
PRICE YES number
REPLACE_COST YES number
EVALUATED YES date
VALUE YES number
ACQUISITION YES date
ACQUISITIONNO YES
DONATEDBY YES
INMEMORYOF YES
DONATED YES date
PRINT -

BORROWERS_NEW table:

field name

import allowed

DATE_ADDED -
ID -
NAME YES
BARCODE YES *b
TYPE YES
STATUS -
EXPIRY YES date
ADDRESS1 YES
ADDRESS2 YES
CITY YES
STATE YES
ZIP YES
PHONE YES
CELL YES
SENDTXTMSG -
EMAIL YES
SENDEMAILS -
COMMENTS YES
PICTURE YES
NOTES YES
LASTEMAIL -
LASTTXTMSG -
CUSTOM1 YES
CUSTOM2 YES
CUSTOM3 YES
CUSTOM4 YES
CUSTOM5 YES date
CUSTOM6 YES date
CUSTOM7 YES number
CUSTOM8 YES number
CUSTOM9 YES
PRINT -

Handy Library Manager

software
tour
features
try now
cloud

Copyright © 2017 · All Rights Reserved · PrimaSoft PC