This topic explains how quickly you can transfer your data from your spreadsheet into our library application using copy/paste procedure.
The same technique you can use when you move your borrowers data.
If you want the program to generate unique barcode numbers, do not import barcode values into the program's BARCODE field. This applies to library items as well as library patrons.
Open your library data in Excel.
At the top of your excel table add one row and enter data field names that are used in our program. Field names define data mapping.
Check data field names that you can use.In this case the following names were entered into the corresponding columns: TITLE, AUTHOR, TYPE, PUBLISHER, PLACE, PUBLISHED, CATEGORY, LEVEL, FORMAT, PAGES, CALL, ISBN.
Use Ctrl-A shortcut to select the data area of your table (the cursor should be placed in any area of your table).
Click with the right mouse button on the selected table to open a popup menu, click Copy.
Open Windows Notepad software. Click with the right mouse button to open popup menu and click Paste.
Your table in the text form (text file tab delimited) is displayed in the Notepad.
On the File menu click Save.
Select a folder, enter a name for your library text file, and save the file.
Open Handy Library Manager, click Add Library Items.
On the Add Items tab click Add Items From Text File.
Click Start Import.
Verify the number of imported records. Click Close.
New items are added into the LIBRARY_NEW table.
Review data, add missing information, and move to your LIBRARY main catalog..
Questions:
I would be importing data from excel.
How does that work? Can I send the file to you to
process our library data import? We are not computer savvy.
Answer: Please send your file to us; we will try to transfer your data. You can try to review instructions listed above, and maybe you can process your export.
Questions:
Does your library application allow user to import from an Excel document? Our previous ILS company will send us
our library catalog as an Excel file so I need to know if we can import it or not.
Answer: Yes, you can import your library data into Handy Library using excel spreadsheet file. If there is any problem with the import you can contact us, we provide free support with the data transfer issues.
Questions:
How to import my library catalog that is a text delimited file?
I have downloaded and installed your program. I have our catalog information in a tab delimited text file.
I have not been able to determine where to start to be able to import my file.
Answer: Please follow instructions included in this help topic.
Questions:
I am trying to export records from small library organizer and import them to the handy library manager.
Answer: Please contact us, we offer free support with library data transfer.
Questions:
Can the excel file containing book information be imported?
How easy is it to rename some of the columns? I would like; a building location, year
published and language. Don't need all that are there now.
Questions:
Does PrimaSoft help with importing records from one library system into the Handy Library Manager system?
If the library already has a software program, then can the records from the current system be exported into the
Handy Library Manager system? Will PrimaSoft provide help with the transfer of records?
Answer: Please contact us, we offer free support with library data transfer.
Library latest how-to articles:
Handy v3.2 supports letter tabs?
How to predefine library email messages?
How to set library automated email notifications with your office365.com account?
How to update library data from the web with ISBN?
How to predefine library email messages?
Compilation of questions and answers from library requests will help you to make purchase decision.
How to verify if the item is checked out in the library main catalog window?
How to create a new record using Copy Selected Item?
Special Library, how to manage digital and paper document library?
How to display future reservations?
What is the maximum number of library items?
How to back up, restore, maintenance library feature?
Handy Library Manager
software
tour
features
try now, download
cloud
software reviews
Copyright © 2021 · All Rights Reserved · PrimaSoft PC