1. On the top of your excel table add one row and enter data field names that are used by Handy Library Manager.
2. In this case the following names were entered into the corresponding columns: TITLE, AUTHOR, TYPE, PUBLISHER, PLACE, PUBLISHED, CATEGORY, LEVEL, FORMAT, PAGES, CALL, ISBN

Note:
The row with field names from Handy Library Manager will simplify the importing procedure. You will not have to define the import mapping.

At the end of this topic there is a table with data field names that you can enter into the first row of your spreadsheet.

1. Save your excel table as a text tab delimited file.
2. Click Save As, select Other Formats.

1. In the Save As type box select Text (Tab delimited). Your file will be saved as a text file and data will be delimited by tab character.

1. Enter your name into the File Name box. Click Save.

1. Start Handy Library Manager, on the Add Items/Patron tab click Add Library Items.

1. On the Add Items tab click Add Items From Text File.

1. Click Select.
2. Select the text file that you created in Excel.
3. Content of the selected file is displayed in the Text File Contents box.
4. Click Next.

1. Under Fields Separated By select TABs.
2. Under Fields Delimited By select Nothing.
3. In the Import Fields section check First Line Contains Field Names.
4. Click Preview On Screen, verify 3 imported records.
5. Click Next.

1. Click Start Import.

1. Verify the number of records.
2. Click Yes to continue.

1. Verify if the number of imported records is correct.
2. Click Close.

1. New items are added into the LIBRARY_NEW table.
2. Verify your items, add missing data.

When your items are ready for circulations move them to your LIBRARY main catalog.

If you want the program to generate unique barcode numbers for you, do not enter barcode values into the barcode field.

LIBRARY_NEW table:

BORROWERS_NEW table:

Question: I think I have followed the instructions about exporting data from the Book Collector system to the Handy Library Manager. I have not managed to get the data to Excel, it goes to notebook. What am I doing wrong?

Answer: The file will open in the Windows Notepad application when it has a "txt" extension. So you can send this file to us, and we will review it.