Building your database

---

Adding entries

Start to build your Gamepedia 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 game, 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 Game menu.


• Choose which site to search from the 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 Gamepedia Preferences/Sites until it finds a match.)


• Enter the title of a game or a combination of keywords such as the publisher or platform and parts of the title.


• Depending on the search site you might also be able to choose a limiter and a sort order for the results. These options will appear automatically if 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 Preferences > Sites, found under the Gamepedia 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 Game 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 games 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 Gamepedia menu.) Alternatively, use the 'Add Multiple...' feature found under the Game 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 Game 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 Game 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 UPC 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, 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 have Pocketpedia on your iPhone or iPad 2 then you can also use that as a scanner to get your barcodes into Gamepedia.

• Run Pocketpedia and tap the camera icon next to the Doghouse search field. (On the iPhone, tap the action/input button at the top of any collection and choose "Add" from the menu to bring up the Doghouse search field.)


• When the camera comes up, start scanning your barcodes.


• The color of the little computer icon at the bottom of the camera image lets you know whether you're searching Doghouse to add an entry to Pocketpedia directly (blue icon) or whether the UPCs are sent to Gamepedia for searches (green icon). Should Gamepedia not be running on your Mac or your devices are not connected to the same wireless network, the UPCs can be stored in Pocketpedia for future sending.


• The searches in Gamepedia will be done via the 'Add Multiple' feature so make sure you have the correct site selected in that window before your start the search.


• If Pocketpedia cannot find Gamepedia connected to the same wireless network, Pocketpedia will ask if you'd like to store the scans so you can store them to send to Gamepedia later. The number of scanned and stored barcodes will appear on top of the little computer icon on the camera image page. Once the two programs are connected to the same wireless network again, go back into the scanning feature in Pocketpedia and tap the little computer icon to send the scans to Gamepedia.

Drag the favicon from the browser window over the Gamepedia dock icon and the program will automatically start a search for that particular entry. This works with most sites and we'll try to expand this to all search sites in the future. (Make sure you drag the URL icon and not the actual URL address.)


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

• From the Game 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/titles, use the "Add multiple" feature to add many titles in one go.

• Go into the Game 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 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 Gamepedia 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 Game 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 games, especially sequels or games 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 Game 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 there are sequels to the movie, 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
• Freebase
• Moby Games
• ...

Then a search on Doghouse would correspond to the keyboard shortcut Command-Control-1, a search on Freebase would correspond to Command-Control-2, a search on Moby Games 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 Game 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.

Searching Amazon for information

If you'd like to integrate with Amazon you have to sign in with your personal Amazon Web Services (AWS) secret and access key as well as your Associates ID in the Gamepedia Preferences > Sites tab. Here's how you get those keys and IDs:

To get your free AWS keys,

• Sign in to the AWS (Amazon Web Services) Console. 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. (If you are signed up as a seller on Amazon, create a new account with a different email address.)
  
  AWS provides many different services, including the free search that the Pedias let you access. This search feature is 100% FREE, regardless of how many searches a day you do, but since it is part of the greater AWS cloud and some of the other options are paid, Amazon may ask for credit card information as part of the sign up process.


• Once you are signed in, click on your account at the top right of the page and select "Security Credentials" from the drop down menu.


• On the next page, click on the "Access Keys" link to create your access key and secret key. IMPORTANT: Store these two keys somewhere safe because you will not be able to access the secret key again. If you loose it, you will have to create a new set of keys. More detailed information about these keys can be found on the Amazon Security blog.


• Amazon recommends that you create an IAM user that has access keys instead of creating an access key for the root user but unfortunately at this point the Amazon Associate API does not support IAM users so you have to create a root access key. If you're having trouble creating an access key, try using this direct link.


• Your keys will look something like this:
  Access key ID: AKIAIOSFODNN7EXAMPLE
  Secret access key: wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY

Make sure you do not include any white spaces before or after the keys when you copy paste them to avoid any errors.

Then sign up for a free Associates ID at the Amazon Affiliate Program. You will be asked to provide a website but this does not need to be a game selling site. A personal blog or even a friend's webpage, if they don't mind, will do. (This means the Amazon sales commission generated via the Amazon access will now go directly to you!*)

With your keys ready,

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


• Copy paste your access key, secret access key and Amazon Associate ID (also called Tracking ID) 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. To generate referrals, click on the Amazon link in your Pedia program after adding an entry through the Amazon search.


If you have all three required IDs yet still get the error that "Your Access KeyID is not registered for Product Advertising API", please go back to the Amazon Associates page and log in once with your username and password. After that return to the Amazon Settings window and you shouldn't have any further trouble.