Getting Started with BookTrakker    Phone, Monday – Saturday 10 – 5, EST: 434 817-0010

 
Changing Status, or marking books Sold.

ABE has changed how your description from BookTrakker is displayed. Please click Mapping

 

Importing data from Fillz using the UIEE Export file format. Please click Import

 

Please Email tech support at: mailto:support@booktrakker.com if you have any questions or problems. Please include your name and a phone number.

 

Are your record numbers alphanumeric? Tools > Options > check Use Alpha Record Code. Click OK. Click Yes.

 

Deleting the Sample Database: Tools > Options > Records. Click Delete Sample Database button at the bottom. Click OK. Click Yes. Restart BookTrakker.

 

New Records: Click on "New Record" (lower right) After doing data entry, click “Done” or “Next Record” to continue.

 

Data Entry Order is set by Tools > Options > Tab Order. Pick the fields you want, in the order you want, click Set As Startup to use each time you click New Record. F1 for Help on setting up a tab order for data entry.

 

Tools > Options has a lot of default settings for data entry and other operations.

 

ISBN and BASIN Lookup: Click the Plugins icon at the top of BookTrakker.

 

Online Instructions

 

Import from Amazon Open Listings Report: http://www.booktrakker.com/help/Amazon/AmazonOLRImport.htm

 

Cleaning up Amazon OLR data: http://www.booktrakker.com/GrabIt!/amzolr.htm 

 

Importing data from HomeBase: http://www.booktrakker.com/Pub/HomebaseNEW.htm

 

Importing data from elsewhere: mailto:support@booktrakker.com

 

Setting up your uploads: http://www.booktrakker.com/upload_tutor.htm

 

Amazon Upload Setup: http://www.booktrakker.com/help/Amazon/AmazonUpload.htm

 

Amazon Data Entry: http://www.booktrakker.com/help/Amazon/AmazonDataEntry.htm

 

 

 

GrabIt! Information:  http://www.booktrakker.com/GrabIt!.htm

 

GrabIt! Instructions: http://www.booktrakker.com/GrabIt!/index.htm

 

 

 

Keyboard Shortcut Keys

 

F1        Context-Sensitive Help.

F2        Edit Record

F3        New Record/Next Record

F4        Open Field Pick Lists (Any drop-down list box in program)

 

F5        Set Show Records Option

F6        Set Sort Records Option

F7        When in the Inventory Detail View, this will bring up the Add to Catalog Window.

 

F9        New Invoice

F10      Use Menu

F11      Find     

F12      Save Record

 

Ctrl-C - Copy text.

Ctrl-D - Duplicate Current Record.  Works in Browse and New Record modes. 

Ctrl-K - Kill AutoEdit in current field.  Will resume effect in next field.

Ctrl-L - Set text to Lowercase.

Ctrl-M - Disable Mc and Mac text handling.

Ctrl-R - Copy data from previous Record. The Source Record will be the current Record # - 1.

Ctrl-S – Spell Check

Ctrl-U - Set text to Uppercase.

Ctrl-V - Paste text into field.

Ctrl-Z - Undo text changes in a field.

 

Changing Status Without Editing A Record

 

In Inventory Detail View (what BookTrakker opens up to) the focus is always on the Rec # field. You can type, on your keyboard, the record number you want to go to, then press the Enter key. 

 

For the following Status changes, you DO NOT have to Edit the record.

 

To mark a single book Sold, type “S”, then press the Enter key. 

To put books On Hold, type “H”, then press the Enter key. 

To reset On Hold to Available, type “A”, then press the Enter key..

 

If your Rec # field is alphanumeric, then its a little different. You have to use the Ctrl key in front of the single letters. 

To mark a single book Sold, type “Ctrl-S”, then press the Enter key. 

To put books On Hold, type “Ctrl-H”, then press the Enter key. 

To reset On Hold to Available, type “Ctrl-A”, then press the Enter key.

 

Other single letter keys as follows:

 

P – Special                   I – Missing

D – AvailDup                 R - Removed

U – Auction                   N – In Store

 

Any change of Status from Available to anything else results in the book being removed from Online Inventory.

 

If your Record Number is alphanumeric then you must use the Ctrl key followed by the single letters.

 

After importing data you need to set List Online to Yes if you want to be able to upload the records.

 

1. Click the Hit Lists tab along the left side of the Inventory screen.

2. Click New.

3. When the Name form appears, click OK. Notice the cursor blinking in the upper left under Search Field. Click on the dropdown button v and select Status. 

4.Click Execute.

5. You will now be in List View, check the Red Navigational Bar at the bottom to see if your Available record count is correct. 

6. Next, click the Hit Lists tab on the left again, look over to the upper right for the Action tab. Click this.

7. Select List Online from the choices on the left side. Click Execute. Confirm. Now your records are set for Online listing. Click on the Red Hit List button at the top of your screen to Exit Hit Lists.

 

Only books with Status = Available and List Online = Yes will be added to the online databases. Books where you change the Status to something other than Available will be uploaded for removal from the services, including books On Hold.

 

Mapping for ABE's new Condition display.

 

Do File > Export > UIEE > Map Export Fields:

 

 

Click the scroll bar on the right side to scroll down to where you see Book/DJ/Defects mapped into Condition.

 

Click into the Condition field across from Defects:

 

 

A dropdown button will appear. Click it, and scroll through the list for Notes:

 

 

Select Notes:

 

 

Click the X at the top right corner to close and save your changes, then click the Close button on the next form.

 

Upload All Online Inventory to ABE. You do not need to do a Purge/Replace.

 

Importing from Fillz using a UIEE file.

 

If your Record Numbers are alphanumeric then this method will not work. Numeric numbers only.

 

 1. Login to your Fillz account
 2. Click Export at the top.
 3. Scroll down to Manual Export - Inventory

 4. Click the dropdown button across from Format, and select UIEE (.msg):

 

 

 5. Click the All Data button.

 6. A file Download form will appear shortly.

 7. Click the Save button.

 8. A new form will appear. Save As:

 

 

 9. Click the dropdown button over on the right, and click on Local Drive (C):

 

 

 

10. In the window below you will see the BTPro folder. Doubleclick on it.

11. New folders will appear. At the bottom is Transfer. Doubleclick on Transfer

12. At the bottom of the form you will see:

 

 

13. Place your cursor at the end of export.msg and backspace three times:

 

 

14. Type in txt and then click the Save button over on the right:

 

 

15. Your file will be saved in the BTPro\Transfer folder.

16. You can log off Fillz.

 

17. Open BookTrakker.

18. Do File > Import > Standard, located at the upper left corner of the program:

 

 

19. Click the dropdown button to the right of Interloc:

 

 

20. Select UIEE, then click the yellow folder button over on the right:

 

 

21. Select export.txt and click the Open button, lower right, to get:

 

 

22. Click the Map Import Fields button on the left. A grid will appear looking like this:

 

 

23. Click on the right, as above, to scroll down to:

 

 

24. Click on the dropdown button in the row where Condition goes into DJ, and select Jacket:

 

 

25. Scroll down to the bottom of the form:

 

 

26. Click into the field to the right of the *, then click on the dropdown button and select ISBN,

all the way at the bottom of the list. click into the field across from the first ISBN, and it will fill it in automatically:

 

 

27. Close this form by clicking the X in the upper right corner. You do not need to Save, it

does this automatically.

 

28. Click on the First Name MI Last Name in the Imported Name Format section if you want to

end up with Last Name, First Name MI. Also, select which Title Capitalization you want:

 

 

29. Click Start. Wait for the import to finish. Click close when its done, then click OK. Then click

Yes to the question about Amazon Condition.

 

30. Close and Restart BookTrakker. If the import did not work you can do it again. Records

will not be duplicated if the incoming record numbers were numeric.