Prima/Microgaming hands reimport after database crash
Results 1 to 3 of 3
  1. #1
    Junior Member
    Join Date
    Feb 2012
    Posts
    5

    Question Prima/Microgaming hands reimport after database crash

    Is there a possibility to reimport Microgaming hands. There was a problem with my computer and it crashed with PostgreSQL. I've managed to restore some PostgreSQL tables. Table `handhistories` was also restored but only plain text. So I had couple of thousand Microgaming hands that start in string '----PRIMA.DAT----'.
    I understand that HM1 imports Prima/Microgaming hands from GameHistory.dat sqlite3 database. So I created MyOwnGameHistory.dat with the same structure (table HandHistory and all columns are the same as in original GameHistory.dat). I added those old hands into MyOwnGameHistory.dat with the same structure (unique HandID, HandDate in yyyymmddhhmmss format, WasSeated=1, XMLDump in xml format, TableName string, GameType 'Multi Table Hold'em' or 'Hold'em', TableType 'MTT' or 'Cash Game'). Columns are all the same as in original file.
    I asked HM1 to import MyOwnGameHistory.dat but my hands were not imported.

    Trace.log doesn't show much info:
    File C:\Temp\MyOwnGameHistory.dat IS in the previously imported file list but the last modified times are different.
    Preparing Statements for database
    *** Processing C:\Temp\MyOwnGameHistory.dat
    Passing a list of hands to skip...
    IMPORTED: 0 INCOMPLETE: 0 INVALID: 0 ERROR: 0
    *** File processing complete in 0.0

    I wanted to ask what is the logic and rules behind HM1 finding hands to be imported?
    Does it look at auto incrementing HandID? Does it look at HandDate and doesn't look into history dates?


    What's best practice of reimporting Prima/Microgaming hands in the future if one of those disasters occurs once more?

  2. #2
    HM Support netsrak's Avatar
    Join Date
    Feb 2009
    Location
    Germany
    Posts
    25,795

    Default

    I see no way how we could help you with this. Eventually Prima Support can send you the hands in a format we support?

    To prevent this in the future you should do regular database backups.

  3. #3
    Junior Member
    Join Date
    Feb 2012
    Posts
    5

    Default

    The thing is that I know the format of that database. The problem was now knowing the rules how HM finds new hands in GameHistory.dat.
    Changing HandID to "Game id" from XMLDump and reducing number of hands in GameHistory.dat worked. I've created script that generated thousands of small GameHistory databases and HM imported them.

Similar Threads

  1. Stan James/Microgaming/Prima not importing hands.
    By GetMoney in forum Manager General
    Replies: 4
    Last Post: 11-25-2011, 02:39 AM
  2. microgaming/prima hands not stored?
    By Rapala in forum Manager General
    Replies: 3
    Last Post: 07-02-2010, 03:44 AM
  3. Missing Prima/Microgaming hands
    By mikidi in forum Manager General
    Replies: 3
    Last Post: 02-15-2010, 02:54 PM
  4. Doesnt import all hands from prima/microgaming
    By ughhgu in forum Manager General
    Replies: 13
    Last Post: 08-14-2009, 05:58 AM
  5. Prima/Microgaming hands import
    By Ankhes in forum Manager General
    Replies: 9
    Last Post: 07-09-2009, 06:26 PM

Tags for this Thread

Posting Permissions

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