Building your database

---

Adding entries

Start to build your Bookpedia database by adding entries to the Library collection. There are several ways of adding entries but most of them require an internet connection: Once the program has found a book, you can retrieve further information about it using the other search sites. For more information about that, take a look at the advanced information section.

• Press the plus button in the toolbar or choose 'Add...' from the Book menu.


• Choose which site to search by clicking on the little magnifying glass in the search field. (If you choose 'All' the search will go through all the sites selected in the Bookpedia Preferences/Sites until it finds a match.)


• Enter the title of a book or keywords such as the name of an author or publisher and parts of the title.


• Depending on the search site you might also be able to choose a limiter (search by 'Title' only, for example), the type (book or comic) and a sort order for the results. These options will appear automatically at the bottom of the search when available.


• Press the 'Search' button to start the search.

Once the program has found a match for your search, the Add window will come up with the first result displayed. If it's a match, press the 'Add' button and the entry becomes part of your library.

If there is more than one result for your search you will see the number of results displayed at the bottom of the Add window. To see the titles of the next results, click the little arrow in the lower right-hand corner of the Add window to slide out a drawer. Click on the titles to see the results.


When you select "All" from the search site menu, the program will cycle through the selected sites until it finds a match for your search. In the Preferences > Sites, found under the Bookpedia menu, you can select the sites and drag them into the order you'd like the program to cycle through them.

• Choose 'Add...' from the Book menu or press the Add button on your toolbar.


• Click on the iSight button in the Search window.


• Position the bar code roughly inside the red square, at a distance where the barcode looks to be in focus.


• If there is a small additional bar code on the side, don't include that part in the scan.


• Once the iSight has read the bar code, the red square turns green, you'll hear a beep, the iSight window closes and the search for the entry starts automatically.


• If you have many books to scan in one sitting, set your Preferences to 'Return to search window automatically after add' and 'Add first search result automatically'. That way you can keep scanning and don't have to worry about pressing any buttons. (You will find these options in Preferences > General under the Bookpedia menu.) Alternatively, use the 'Add Multiple...' feature found under the Book menu to bring up an 'Add Multiple' window.


• If you have a built-in iSight but would prefer to use an external camera for scanning, plug in your camera, hold down the Ctrl key and then press the 'iSight' button in the search window. This will bring up a dialogue where you can choose which camera to use for the future. If you want to change this setting at some point, hold down the Ctrl key and then press the 'iSight' button to bring up the dialogue again.

• Choose 'Add...' from the Book menu or press the Add button on your toolbar.


• Scan the barcode of the entry and it'll appear in the search window.


• If there is a small addition to the bar code on the side, do not include that part in the scan.


• Most scanners send an automatic return after the scan so the search will start automatically.


• If your scanner does not send an automatic return, hit the 'Search' button.

• Choose 'Add Multiple...' from the Book menu or press the Add Many button on your toolbar.


• Press the Bluetooth button in the multiple add window to pair your scanner with the program. (The pairing code for the Flic is 0000. For other scanners, please consult the scanner manual.) You only have to do this once. The program will remember the scanner in the future.


• Scan the barcode of the entry - it will appear in the table of the multiple add window and the search will start automatically. The search will use whatever site you have selected in the regular search window that comes up when you press the 'Add' button in the toolbar.


• If the search cannot find a UPC or EAN, a warning triangle will appear at the bottom of the multiple add window. Clicking that triangle will bring up a list of the UPCs that could not be found.



• Once your scanner is paired with the program you can also use the regular search window if you prefer.

If you don't have an Internet connection, if Bookpedia can't connect to any of the search sites or if none of the sites have any information about the book, you can also add entries manually.

• From the Book menu choose 'Add...' or press the plus button on your toolbar.


• The regular search window will appear. Press the 'Add manually' button.


• This will bring up a blank window for you to fill in the information.



• Alternatively hold down the Option key and click on the plus button in the toolbar to bring up a manual add window.

You can still update information for an entry even though the information was added manually. All the information the program needs to conduct an advanced search is the title of the entry.

Adding multiple entries

If you have a scanner, a webcam or a list of UPCs/EANs or titles, use the "Add multiple" feature to add many titles in one go.

• Go into the Book menu and choose 'Add multiple...' or press the 'Add Many' button on the toolbar.


• Click on the magnifying glass to select a search site, enter a keyword or UPC/EAN into the search field and press the 'Add' button or Return-key to add it to the list.


• The search will start automatically in the background and you can keep entering UPCs and/or titles to add to the list.


• You can also use an iSight or a scanner to scan multiple UPCs into the list. Just press the iSight button in the multiple add window and scan an entry or if you're using a Bluetooth scanner, press the Bluetooth button to pair the scanner with the program. You'll hear a beep when the program has scanned the barcode and added it to the list.



• Any entries not found will be saved and added to a separate list. When this happens, a little yellow warning triangle appears at the bottom of the window. Click on it to see the list of entries that were not found.

If you already have a list of UPCs or titles, each separated by a return, then you can also copy paste that list into the search field and hit the 'Add' button. The list will appear in the window underneath the search field and the search will start automatically. Although the field is just one line in height, it will accept a paste of many lines as input.

Please note that when you are using the 'Add Multiples' feature, the entries will be added directly to your library and you will not be able to review them before adding since the 'add multiple' feature was designed with UPCs/EANs in mind.

Advanced searches - adding and/or updating info

To gather more information about an entry or to update information, use the little gear button in the Add/Edit window to choose the site you'd like to query for info. If there is more than one result returned, the drawer on the side of the window will pop out and present you with the choices. Select the correct title and the information will automatically be added to the entry. Please note that Bookpedia will never overwrite information already present so if you want to update a field, delete the data from it first and then use the gear button to query for more data.

You can also use the Update from... command found under the Book menu however this will download the first result found from the chosen website. In most cases that'll be the result you're looking for but for some books, especially those with a common title, it can happen that the wrong result is returned. That's why using the gear button is generally the safer option.


To do an advanced search for more than one entry at a time, select the entries in the list view and choose 'Update from >' under the Book menu. Choose the site you'd like to query and the program will download the information.
PLEASE NOTE: With this option the program will automatically add the first result returned. You will not be able to check whether this result is the correct one until after it has been added. (Especially if the title has many common words in it or it is part of a series, it can happen that the wrong result is added.)


Instead of choosing a site from the magnifying glass in the search window or the gear button in the Edit window, you can also use the keyboard shortcut Command-Control-[digit] to choose the site. The digit depends on the order of your sites in the Preferences > Sites.

For example, if your sites are ordered like this in the Preferences:

• Doghouse
• LoC
• AbeBooks
• ...

Then a search in Doghouse would correspond to the keyboard shortcut Command-Control-1, a search on the LoC would correspond to Command-Control-2, a search on AbeBooks would correspond to Command-Control-3, etc.

Cover images

When you add an entry through the internet, the cover art, if available, will be downloaded automatically.

Should there be no cover available or if you are adding an entry manually, either drag an image into the image well below the collections window or use the 'Download from...' command found in the contextual menu of the cover image well (Ctrl-click or right-click the image well to open the menu).

If you have an iSight or a firewire camera you can also use that to capture an image of the item. Use the 'Capture Cover...' command under the Book menu.

When you click on the cover image below the Collections column, it will appear in a separate, adjustable window which you can use to print the cover image.

To hide the cover image well, click on the cover image toggle button at the bottom left of the main window. Ctrl-clicking (right-clicking) a cover image brings up a contextual menu which lets you copy the image, remove it or if there is no image present, download it. There's also an option to "Show in Finder" which will show you the original image file in the Finder.

Adding eBooks or PDFs

• Drag the file(s) over the Bookpedia icon in your Dock.


• Bookpedia will create a new collection called 'Imported eBooks' and add the file(s). As much information as possible will be extracted from the file(s), such as a cover image, title, author, etc. and a link back to the original file will be included as well.

To give you the opportunity to check that the import went correct, imported entries are put into a library-independent collection first. (Marked with a grey collection icon instead of a blue one.) To make the import part of your library:

• Select the imported collection.


• From the File menu, choose 'Include Collection in Library'.


• Delete the imported collection.

If you're just looking to link a PDF to an already existing entry in Bookpedia, take a look at the linking section.

Searching Amazon for information

To access Amazon searches with Bookpedia, you have to sign in with your personal Amazon Web Services keys and Associates ID in the Bookpedia Preferences > Sites tab. The following is a short overview of the sign-up process. If you'd like a more in-depth and illustrated step-by-step guide, please take a look at this post on our blog.

To get your free Amazon Web Services key,

• Sign in to the AWS (Amazon Web Services) site. If you already have an Amazon account that you use to purchase goods from their site you can use that same account. Otherwise sign up as a new user.
  
  AWS provides many different services, including the free search that the Pedias let you access. Some other AWS services are paid. The AWS search feature is 100% FREE, regardless of how many searches a day you do, but since it is part of the greater AWS feature, Amazon may ask for credit card information as part of the sign up process.


• Once you are on the AWS Homepage, scroll down the page a little to see an area called “Access Credentials”. Here you'll find the Access Key listed under the ‘Access Key ID’ header. To see your Secret Key, click on the ‘Show’ link.

Then sign up for a free Associates ID at the Amazon Affiliate Program. You will be asked to provide a website but anything will work, even your Twitter feed. (This means the Amazon sales commission generated via the Amazon access will now go directly to you!*)

If the Amazon Associate program is not available in your state or you are not interested in becoming an associate, you may also leave the field blank and it will automatically be populated with the Bruji associate ID.

With your keys ready,

• Open the Bookpedia Preferences > Sites and click on the 'Amazon Settings' button.


• Copy paste your access key, secret access key and Amazon associate ID (if you have one) into the appropriate fields.


• Press the Sign Up button.

The Amazon sites will now appear in your Sites window. Check the box next to those you'd like to use and drag them into the order you want the search to access them.

* Whenever you click on a link in the Pedias that takes you back to Amazon it has an ID attached to it. If you end up buying something on Amazon, the commission generated by that sale gets paid to the ID attached. This can happen through direct links in the program or if you export your database to the web and someone clicks on your link to Amazon.

z39.50 servers

z39.50 is an international standard defining a protocol for computer-to-computer information retrieval, mainly used by libraries and universities. You can add those servers to your Bookpedia search list through the 'z39.50 servers...' option found under the View menu.

To download information from a z39.50 server, you first have to add the institution to the Bookpedia search list.

• Choose 'z39.50 servers...' from the View menu.


• Click on the 'Possible Servers' link.


• The "z39.50 Target Directory" will open. Access it by clicking on the 'Find a target' link in the left-side menu.


• Once you have found the institution you want to add to Bookpedia, click back to Bookpedia and enter the information into the z39.50 window in Bookpedia.

The information you need to access a server is contained in these three fields: Host, Port and Database Name.



Enter the information into the Bookpedia z39.50 window in this format: "server:port/database"

• Add the name of the server into the field 'Name' (this is for your own identification of the site in the search window later so you can assign whatever name you like).


• In the 'Server' field, enter the host information followed by a colon (:).


• After the colon, add the port number followed by a forward slash (/).


• After the forward slash, add the database name.


• Press the plus button to add the server to your list and OK to close the window.


• Now you'll be able to access the server from the Search drop down menu in the Search window.

Note: The default number of results returned is 50. If you'd like to change that, open the application "Terminal" found in Applications/Utilities and copy paste the following line into it, followed by a return (the number at the end is the number of results returned, i.e. in this case 20):

defaults write com.bruji.bookpedia NumberOfResultsYAC 20

The target directory site provided is one of the best we've found online so far, but there are many others available on the Internet, for example:

http://www.ukoln.ac.uk/distributed-systems/zdir/   (UK targets)
http://www.webclarity.info/registry/browse  (international targets)
http://www.nla.gov.au/apps/libraries?action=ListTargets  (Australian targets)

Unfortunately at this point Bookpedia cannot access servers that require a password or login.