Collectorz now appears to be focusing on their mobile and web-based products for managing book collections, but they also provide a desktop Book Collector desktop application for systems running Microsoft Windows, though I don't even see a link for it on the homepage of their website nor do I see one in their sitemap webpage. However, if you are using the desktop product and need to update your Book Collector database if the location of cover images, thumbnails, list item images, templates, and/or local files for entries already in the datbase, you can take the steps below. You can specify the directories for new entries by clicking on Tools, Options, Folders to set the directories Book Collector should use by default.

Inside the Book Collector program, click on Tools then select Update File Links. In the Update File Links window you can "choose the kind of files you would like to repair". I left the default value of All Types, but you can also select Front Cover, Back Cover, Pick List Image, Pick List Template Image, Local File, or Backdrop. When you click on Next Step, you can choose to have the program automatically update the old folder to the new folder or you can choose to do it manually. With the automatic option, you can "Select a base folder and let the program find the missing files automatically" while with the manual option you can "Use a find and replace action to manually fix your file paths". For the "Choose folder where to find files", browse to the appropriate directory where the files are now located. Check the box next to "Include subfolders", if that is appropriate, and then click on Next step. The program will then show a "Finding best matches for missing files" window with a progress bar as it updated links.

At the next step, Step 4, you can see the resulting file paths and click on the Update File Links button to finalize the changes. You will then see the number of file links that will be updated and asked if you are sure to proceed. I saw a window with a message that Book Collector was not responding, but I chose "Wait" several times and it finally completed. When all the links are updated, you should see a window informing you of the number of file links updated. If you updated the location for the images for books already in the database, you should now see the images appear for book entries.

If you just need to update the links for a particular kind of files, e.g., the local files, or the location of those files differs from the location of other files, e.g., if they are on a different drive than the images, etc., at Step 1 where you "choose the kind of files you would like to repair", you can choose that file type instead of "All Types".

I was able to use the above steps when transitioning my wife's desktop computer from Windows to Ubuntu Linux, after I installed Book Collector under Wine, to specify the new location of image and local files.

[ More Info ]

[/software/database/collectorz] permanent link

If you wish to delete all of the records from a table in an SQLite database, you can do so using a command in the form delete from tableName where tableName is the name of the table from which you wish to remove all of the rows in the table. E.g., if I wished to delete all of the records in a table named TimeStamps, I could use the delete command below.

sqlite> select * from Timestamps;
2025-05-01 21:26:22|2025-05-01 21:23|10947739
2025-05-01 21:28:33|2025-05-01 21:28|10967247
2025-05-04 13:37:47|2025-05-04 13:36|18079581
sqlite> delete from Timestamps;
sqlite> select * from Timestamps;
sqlite>

If I only wanted to delete a record or records meeting a specific condition, I could specify that condition in a WHERE clause. E.g., if the columns in the table were CurrentTimestamp, LastUpdateTimestamp, and Size and I only wanted to remove the row where the value of CurrentTimestamp is 2025-05-04 13:37:47, I could use the command below, instead.

sqlite> .schema Timestamps
CREATE TABLE "Timestamps" (
        "CurrentTimestamp"      TEXT NOT NULL,
        "LastUpdateTimestamp"   TEXT NOT NULL,
        "Size"  INTEGER NOT NULL
);
sqlite> delete from Timestamps where CurrentTimestamp='2025-05-04 13:37:47';

[/software/database/sqlite] permanent link

[ More Info ]

[/software/database/collectorz] permanent link

[More Info]

[/software/database/sqlite/db_browser] permanent link

[/software/database/collectorz] permanent link

1. Within the Book Collector program, click on Clz Cloud on the menu bar at the top of the program window.
2. Select Synchronize.
3. Click on View my collection in CLZ Cloud if you wish to view the books stored in the copy of the database in the CLZ Cloud in a webpage in your default browser before deleting everything in that version, then click on the Clear CLZ Cloud button at the bottom of the program window to remove all book entries from the version of the database stored in the cloud.
4. You should then see zero cloud changes to be downloaded.

   

   If you wish to then synchronize your local copy of the database to a copy stored in the cloud, you can click on Sync Changes. When you do so you should see "sending items to cloud." Be prepared to wait a few minutes for the synchronization operation to complete if you have a large number of books in your Book Collector database. You will see the number of "Adds/Edits" decrease to zero as books are uploaded. When the process is complete you will see the message "Finished syncing changes. Would you like to view your collection in CLZ Cloud?"

[/software/database/collectorz] permanent link

<lockinfo><writable><client pcname="YYYYYYYY" name="5c22840efc7a3db854c44b0b780f8abc" key="xxxxxxxxxxxx" username="zzzzzzzz"/></writable></lockinfo>

In cases where Book Collector was not closed normally, you can either choose "yes" at the prompt or delete the .bkclck file before opening Book Collector as its presence is what causes the message to appear.

[/software/database/collectorz] permanent link

1. Download the image of the author. If you wish, you can place the image in the location where book cover images are stored, i.e. the images directory beneath the Book Collector directory where you store the book database.
2. If you are editing an entry for a book by the author, you can right-click on the icon of three horizontal bars to the left of the author's name while editing the book entry and select "Edit this author entry." Or from the main Book Collector window, you can select "Edit" then "Manage Pick Lists" to select the author picklist where you can select the relevant author—you can double-click on the author entry then to edit it.
3. In the Edit Author window, click on the Images tab.
4. For the "Template Image" field, browse to where you downloaded the image of the author. Once you have selected the image, click on OK. Leave the "Image (will be scaled to 16x16)" field blank. You can then close the entry where you are editing the author's information. When viewing the entry for a book by the author from the book list in the home screen for Book Collector, you should then see a small thumbnail picture of the author.

If you don't have an image, but want to add a picture to the author's entry, check to see if there is a Wikipedia entry for the author or if the author has a website.

You can use similar steps to add an image for a publisher's entry in the database.

[ More Info ]

[/software/database/collectorz] permanent link

I have an SQLite database that I use to track approval of tasks. Every Monday, I need to generate a count of the number of tasks approved from the prior Tuesday through the Monday on which I'm creating the report. The approval dates are stored in the database as an integer and I enter them in the form 2018-05-14. I use the following SQL command in a Python script to determine the number I've approved in the last week:

sql = 'SELECT COUNT(*) FROM Tasks WHERE Approved >= date(CURRENT_DATE,"-6 day")'

But I noticed that the count didn't always include the tasks I approved on the prior Tuesday. E.g., when I ran the script tonight, May 14, the number reported was 5, yet I expected the result to be 7.

[ More Info ]

[/software/database/sqlite] permanent link

I have an SQLite database stored on my MacBook Pro laptop that I use to track work requests. The database file is named CRQ.db, since it tracks work done under a Change Request (CRQ). Within that database are several tables two of which are "Equipment" and "Device". For every CRQ that I need to deal with, I store records with the CRQ number in a "CRQ" column and an identifier for each piece of equipment affected by work done under that CRQ in a "Device" column. information on equipment that is affected by the CRQ in the Equipment table. I have another table named "Device" that holds details for each device, including the manufacturer and model number as well as the physical location of the device. The information in the "Description" column in the "Device" table matches the "Device" name in the "Equipment" table. The two tables have the following structure:

Equipment.Device = Device.Description

[ More Info ]

[/software/database/sql] permanent link