Perform the following steps to import data stored in Microsoft Excel format into Household Register Plus.
Warning: Create a backup of your database prior to importing data, so if the import is not correct, you can restore data back to its original status prior to trying the import again.
1. From the Book Librarian Plus main menu select File>Import>Excel Files. This starts the import export program.
2. You will see a warning to ensure that no one else is using the program before continuing. If you purchased the singe user version of Book Librarian Plus just press the continue button. If you have the 5 or 10 user version ensure no one else is using the program prior to continuing with the import.
3. You will see the source file options (Step 1) window below:
4. Use the file lookup button to select the Excel file you want to import. Excel files end with the extension xls. You have the option to select the number of records you want to import from the source file. Leave the number at 0 to import all the records in the source file. Click the Next Step button to display the Step 2 window (map source fields) window seen below.
5. Click the First button to read in the first record in the source file along with the field names. Unless you are importing a file previously exported from Book Librarian Plus the the source field names (left list) will probably be different from the Book Librarian Plus names (right list).
6. The list box on the left contains a list of fields from the file that you want to import data from. The list box on the right contains a list of fields in Book Librarian Plus. Click on the field you want to import data from in the left box and "drag" it across to the Book Librarian Plus field that you want to hold the data. Repeat for each field that you want to import.
To unlink a field double click the field in the right box.
Import Window Buttons
Start - starts the import operation and adds the data to Book Librarian Plus.
Map by Name - press this button to automatically link fields with the same names.
Save - After you have linked up the fields to import, you can click the button to save the setup so if you wish to import data from the same file again, you won't have to re-link the fields, just press the Retrieve button.
Retrieve - loads the previously saved import information.
Cancel - closes the import window.