Notes
Results 1 to 4 of 4

Thread: Notes

  1. #1
    Senior Member
    Join Date
    Jul 2009
    Posts
    158

    Default Notes

    Is it possible to delete all player notes on hm3?

  2. #2
    *** HM3! *** fozzy71's Avatar
    Join Date
    Sep 1971
    Location
    HM Support
    Posts
    31,750

    Default

    - Install the SQLite Browser.
    - Launch the SQLite Browser program and then click 'Open Database' option, switch the File Type box to 'All Files' and select your database you want to compact.
    - Open/click the 'Execute SQL' tab and enter the command:
    UPDATE players SET note = ''
    - Note: the '' is 2 single quotes
    - Click the 'Play' button to execute the SQL command
    - Click the 'Write Changes' button
    - Note: If you also color code players you will need to also execute the following SQL command and Write Changes.
    UPDATE players SET color = ''
    Here is a video of me showing how to do this in my test database.

    p.s. If you have a lot of notes/colors you will also want to compact the database after you write those changes to the database as instructed below.

    - Launch the SQLite Browser program and then click 'Open Database' option, switch the File Type box to 'All Files' and select your database you want to compact.
    - Now click Tools - 'Compact Database...' - 'OK'.
    - The process will likely say 'not responding' but just be patient as it can take a good bit of time for larger databases.
    - When the process finishes the 'Compact Database' window that had popped up will close and then you can close the main DB Browser software.

    Here is a short video example of me showing the process on an old test database.

  3. #3
    Senior Member
    Join Date
    Jul 2009
    Posts
    158

    Default

    Didnīt understand the compact database instructions it seems that you are purging hands from the database and I donīt want to do that. So you loose hands when you compact the database?
    As for the rest it worked.

  4. #4
    *** HM3! *** fozzy71's Avatar
    Join Date
    Sep 1971
    Location
    HM Support
    Posts
    31,750

    Default

    Quote Originally Posted by fow View Post
    Didnīt understand the compact database instructions it seems that you are purging hands from the database and I donīt want to do that. So you loose hands when you compact the database?
    As for the rest it worked.
    You only lose hands from the database if you delete them from a report or purge them from the tools menu. Compacting is used AFTER you purge hands, and also if you delete any other data from the database. The steps I gave you removes the notes and colors from those database tables which takes some space. Compacting will reclaim that space. When I tested this on my own test database I had 80 - 90 players with notes and colors in my database that was about 185 MB in total size. After I removed the notes/colors then did that compact I think the database was about 180 MB. If your database had 1,000's of notes/colors that you cleared/removed the space savings could be significant.

Similar Threads

  1. Replies: 2
    Last Post: 11-08-2012, 03:32 AM
  2. Replies: 2
    Last Post: 02-02-2010, 07:05 PM
  3. Will import of notes write over my existing notes?
    By melles in forum Manager General
    Replies: 4
    Last Post: 09-07-2009, 10:18 AM
  4. Smart buddy notes and holdem manager notes
    By brett701 in forum 3rd Party Programs Compatible With HM2 or HM1
    Replies: 0
    Last Post: 08-26-2009, 07:18 AM
  5. Smart Notes / Notes?
    By Sean314159 in forum Manager General
    Replies: 1
    Last Post: 08-23-2008, 08:32 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •