PDA

View Full Version : HEM not importing Ongame hands



benthj
07-01-2009, 05:36 PM
HEM doesnt seem to import Ongame hands, as it normally does. I have just upgraded to 1.09 beta 11 which didnt change anything though.

HH's are created in the same place as they normally do, but even if I try to import as file, or from folder doesnt make it work.

the HUD recognizes the tables, but keeps saying 0/10 and ofcourse no stats coming up.

Any suggestions?

fozzy71
07-01-2009, 05:49 PM
SNG or Cash games? or both?

Have you tried using the Table Finder to help the Table Manager start picking up the tables automatically again? http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=54


Check out this thread about Ongame and the Beta versions - http://208.109.95.123/forum/showthread.php?t=11834


If you play a session on Ongame and you are missing hands / money please email me the entire hand history and let me know what you think you should have made or lost on the session and that should help me pinpoint the problem

Roy

If you want to send any hand histories, they go to support@holdemmanager.net, and make sure to include your forum name and a link to this thread.

benthj
07-01-2009, 06:21 PM
Cashgame. Table finder doesnt work when hands are not imported.

Have sent the HH file to support.

dedalus
07-01-2009, 07:23 PM
i have the same problem. when i start importing, holdem manager doesn't recognise any of the .txt files.

i'm importing datamined hands - not hands saved on my hard drive by the ongame client.

i will send you a few example hands

i have the latest version of holdem manager etc..

dedalus
07-02-2009, 08:15 AM
ok i think i have gotten hm to start importing the ongame hands

i had created a new database for the datamined hands and was going to use that to import them

i just changed my original database (where had previously gotten full tilt hands to import etc) to the default and tried to import the ongame hands. it's working. weird.

by the way - any tips for dealing with large databases, keeping hm running smoothly/efficiently ..?

netsrak
07-02-2009, 08:18 AM
I'l let this one for Fozzy. He had some optimisation links over the last days :)

fozzy71
07-02-2009, 08:46 AM
ok i think i have gotten hm to start importing the ongame hands

i had created a new database for the datamined hands and was going to use that to import them

i just changed my original database (where had previously gotten full tilt hands to import etc) to the default and tried to import the ongame hands. it's working. weird.

by the way - any tips for dealing with large databases, keeping hm running smoothly/efficiently ..?


Here is a great thread with tons of links and info for improving SQL performance.


Top 10: HEM performance increase tips (http://208.109.95.123/forum/showthread.php?p=62613&posted=1#post62613)


I just thought it would be helpful to post this list. The HEM FAQ has most of this information, but it's quite cluttered to find it in so many FAQs.

Please post here, if you can think of other tips that will help increase the performance of HEM, HM Import, Table Scanner, HUD and postgreSQL. Specifically for those that have a HUGE database. And maybe some experts/admins can give some insight, which on these list will cause the greatest performance improvements and which will be hardly noticable. And HEM users can discuss about their experiences using these tips here.

Read this first: Ten (!) tips already posted in the HEM FAQ to improve performance (http://www.holdemmanager.net/faq/?f=162).
I've re-used three out of those ten tips in the list below:


Top 10 tips:

Upgrade your HARDWARE:
1 to 3

-1 Get a fast harddisk!
---x Preferably two+ SSD harddisks in a RAID-0 array. (fastest)
---x Or just one SSD just for your database
---x Or two Western Digital Velociraptors in RAID-0
---x Or just a really fast SCSI/SAS 10k RPM / 15k RPM harddisk
---x A normal 7200 RPM IDE/SATA harddisk (slowest)
-2 Get lots of RAM (at least 2+ GB RAM recommended if you have a 10+ GB database) (note: when using more than 3 GB RAM, use a 64-bit version of Windows)
-3 PostgreSQL love multible CPUs, so the more CPUs the better. (Intel Core 2 Quad / i7 or AMD Phenom) Also "Holdem Manager will be adding improvements in 1.10 that will take advantage of quad core/64 bit versions."

Update your SOFTWARE:

-4 Always use the latest version of Holdem Manager (http://www.holdemmanager.net/forum/forumdisplay.php?f=11), use the most current version of PostgreSQL (http://www.postgresql.org/) Currently that's 8.3. Look out for performance improvements in 8.4 (8.4 beta 2 is already available, but I'd recommend to wait for the final version of 8.4) And update your Windows (use Microsoft Update) and update all system drivers (including your videocard driver!).

-5 Remove the WinnerName, WinnerCards and WinnerWon from the Hands View Column Selector (http://img179.imageshack.us/img179/2655/removewwwxg8.jpg)

-6 Defrag your harddisk, using Defraggler by Piriform (http://www.defraggler.com/download/). Or you can use Disk Defrag by Auslogics (http://www.auslogics.com/en/software/disk-defrag/download) or Power Defragmenter (http://www.softpedia.com/progDownload/Power-Defragmenter-Download-20185.html) (all FREE software and better than the Windows included Defrag)
It is recommended to stop postgreSQL from running before you use defrag! (To stop and start the service: Start > All Programs > PostgreSQL > Stop Service / Start Service)

PostgreSQL:

-7.1 Advanced postgreSQL tuning (http://www.holdemmanager.net/faq/?f=172) (How to configure PostgreSQL memory usage specifically for your computer's specifications)

-7.2 Advanced postgreSQL tuning II (really advanced) :-)
Performance Tuning PostgreSQL - General Tuning (http://www.revsys.com/writings/postgresql-performance.html) (How to manually change your max-connections, shared-buffers, effective-cache, work-memory, etc.)

Decrease the SIZE of your database:

-8 How to optimize the database size in 3 steps: -1 Vacuum, -2 Reindex, -3 dump/restore (http://www.linuxinsight.com/optimize_postgresql_database_size.html)
--8.1 VACUUM: VACUUM Analyse your database regularly (http://www.holdemmanager.net/faq/afmmain.aspx?faqid=163) (How to do a manual VACUUM)
--8.2 REINDEX (see 8.1 for instructions, but choose Reindex instead of Vacuum in pgAdmin)
--8.3 Dump/restore (for advanced users) Step by step how to dump/restore the database (http://www.linuxinsight.com/optimize_postgresql_database_size.html#comment-538)

-9 Purge hand histories (http://www.holdemmanager.net/faq/?f=107) (It will free up disk space without losing stats, but you lose the option to see the HH or view the hand in the replayer)

-10 How to make PostgreSQL stop making those big log files (http://www.holdemmanager.net/forum/showthread.php?t=8423) (I had 8 GB of logfiles before I realized you're allowed to delete the content of the data/pg_log directory!)


Anyone can think of #11 and other tips?

Here are my cliff notes for turning off and deleting the log files.



- Start > My Computer > Tools > Folder Options > View > UnCheck 'Hide Extensions for known file types' > OK

- C:\Program Files\PostgreSQL\data\postgresql.conf > Right-Click > Open With.. > NotePad > Check 'Always use this program'

- Scroll about half way down to ~Lines 245 - 260:

- The last line of this block of code, for the 'logging_collector', must be changed from On to Off.


------------------------------------------------------------------------------
# ERROR REPORTING AND LOGGING
#------------------------------------------------------------------------------

# - Where to Log -

log_destination = 'stderr' # Valid values are combinations of
# stderr, csvlog, syslog and eventlog,
# depending on platform. csvlog
# requires logging_collector to be on.

# This is used when logging to stderr:
logging_collector = off # Enable capturing of stderr and csvlog

File > Save; File > Close

Start > Programs > PostgreSQL 8.3 > Reload Configuration.

*edit:
- Start > My Computer > C:\Program Files\PostgreSQL\data\pg_log, or C:\Program Files (x86)\PostgreSQL\data\pg_log, if you have 64 bit Vista. Delete all files in that folder. And it might be a good idea to empty your recycle bin at that point, or use a 3rd party utility like CCleaner (http://www.ccleaner.com) to clean up all your junk/temporary files. You want to do this before you get to the vacuum and defrag process.


************************************************** *****************

benthj
07-02-2009, 01:36 PM
Any news on the original problem i posted, and have you tested the HH's I sent?

Rvg72
07-02-2009, 02:08 PM
Any news on the original problem i posted, and have you tested the HH's I sent?

Hi, i imported the file and it got every hand - this is with the latest test builsd which is beta 12

Roy

benthj
07-02-2009, 03:50 PM
So weird. Now its importing, but HUD can't find any tables. When I then use "table finder" it comes up wit "I can not find ant unnattached hands, please wait until the Manager has imported some".

So, whats next step? Never had a problem with HUD before, so pretty strange if the problem has to do with my settings.

fozzy71
07-02-2009, 04:19 PM
Please email fabio@holdemmanager.net, with a link to this thread, and your forum name, so you can schedule a Teamviewer (http://www.teamviewer.com) session. Download and install the Teamviewer software using all the default settings.

Maxstar
07-03-2009, 04:21 PM
i got the same problem... i think

Day before yesterday, with the new VPP PS tables. HUD didn't work on new tables, but still runned on ''normal'' tables that night. Yesterday HUD didnt run on any tables at all (pokerstars).

1st the problem was that HM couldn't stop, stopping importing hands. quitting auto import didn't work. rerinstalled, put beta 11 and 12 on it.

1st problem disappearred but now when you start auto import handHistories aren't found. These aren't added to the database. When you open HUD tables can be found, but no players. And all tables are described as sixhanded tables with no players on it.

I can manually import Handhistories to my database...

I am following this thread with great interest.

Ciao joris aka Maxstar.

netsrak
07-03-2009, 04:51 PM
Please check / reconfigure your AutoImport folders. It might be necessary with the latest Beta.