Home
elephant

« v0.65 release - Pokerroom support, backup speed tuned | Main | Slightly offtopic: new Equilator version (1.3)»


My picture!

As you will have noticed, the PokerStrategy Elephant now supports full backup of your databases to ensure data integrity especially in cases of version upgrades and associated reimports.

Why is reimporting necessary at all?

With new versions of the Elephant it is now and then necessary to reimport your handhistories, because it is the only way for us to fix errors in calculations due to wrongly imported hands. With an analysis tool like the Elephant, we have loads of data to cope with, especially since the introduction of the new expert values. In order to present the results in a quick manner, we do a technical trick that is called caching. Caching allows us to store calculated values (like the Vp$ip, WTS etc) without having to calculate them over and over again. It is obvious, that looking up a single value is way faster than recalculating the same value from hundreds of thousands of hands.

Unfortunately, the method of caching is somewhat error-prone - assume a handhistory that cannot be properly parsed for whatever reason (some might remember the recent change of the handhistory format by PartyPoker for instance). The Elephant misinterprets this hand and thus produces a wrongly calculated value. As we have no way of knowing what values have been miscalculated, we need to recalculate all values. The quickest way to do so is by completely reimporting all hands currently in your database.

How does the reimport work in versions V0.64 and up?

Starting with version 0.64, we have introduced a database backup mechanism, that allows you to export all your imported handhistories into a folder of your choice. When doing an export, three kinds of files are exported:

- original handhistory files (like those from PartyPoker or PokerStars)

- proprietary handhistory files (in cases of portals for which there are no "real" handhistories, like PokerRoom or the old Mansion databases). These files get an .ehx (for elephant handhistory export) extension.

- additional userbased files (like comments on players of games)

You can safely store these away and reimport them whenever you like.

The same mechanism is used to do a reimport. First you are asked to export your database, then the database is cleared and the exported data is reimported.

Known issues

We have extensively tested and improved the export functionality of the Elephant. The only known error up until now is, that when reimporting .ehx files (the proprietary handhistory files) the displayed number of imported files in the handhistory-tab is incorrect - so if you only import ehx-files, the import count will always be 0. Still, all hands are properly imported as you will be able to see in the other tabs as soon as the import has finished.

Summary

I hope this give a little insight into the export process. If you have any questions regarding this topic, feel free to ask in our support forums:


German Beta Forum

International Beta Forum

13 Comments | "Concerning database exports and handhistory reimports" »

unknown

xyz : Easier way?

22/11/2008, at 15:21 [ Reply ]

Isn't it possible to just reimport hands from a certain date?

For example the PP handhistory change was on 12.11.2008 then why not just reimporting hands from the date on instead of reimprtant all hundred of thousand hands?

Could tthis be possible in the future?

unknown

ron : To xyz

22/11/2008, at 16:53 [ Reply ]

This of course depends on why there are wrong values in the first place. In case of the partypoker hands, that would of course be possible, but as we have introduced new values with almost every new version, we of course had to calculate the cache-values for each entry.

In other words: yes, if it is possible for us to minimize the reimport step, we will of course try to do so!

unknown

xyz :

22/11/2008, at 22:37 [ Reply ]

Alright thank you. :)

unknown

yaqbpl : since .62 hands imported with errors

22/11/2008, at 23:13 [ Reply ]

sice v62 database didnt work correctly. i tried many times to reimport, recreate, but hands keep being incorect in database. (looks like i won almost every hand in 150.000). do sth plz

unknown

yaqbpl : yaqbpl

23/11/2008, at 11:32 [ Reply ]

...on party poker. maybe all all-ins imported as 'won'

unknown

xyz :

23/11/2008, at 13:45 [ Reply ]

yaqbl: You could try deleting the database completly with pgAdmin III. Maybe a developer can right a howo for that.

Just an idea I have no idea if this really might work. :)

unknown

norenore : Filter

23/11/2008, at 15:35 [ Reply ]

Hi,

wird es in absehbarer Zeit vernünftige Filtereinstellungen geben? Wäre für eine vernünftige Spielanalyse unentbehrlich.

unknown

wHizard82 : automatically remove hands from portals to own hh-folder

23/11/2008, at 19:57 [ Reply ]

would be a nice feature in order to really save ALL hands...unfortunately a 2nd time during a change of version some hands got lost. if all hands manually or automatically would get moved to the special hh-folder nothing should become lost in future...

unknown

4A888 :

23/11/2008, at 23:32 [ Reply ]

Don't you store the original HHs. If so why don't you just recalculate the cache tables from the HHs in the database. So no new import would be needed.
I analyse my hands in the elephant and make notes to the hands using the comment function in the hands tab.
If i have to reimport every time elephant is updated, i lose my notes every time. And that really isn't optimal.

unknown

ron : export of notes

24/11/2008, at 09:27 [ Reply ]

With the 0.65 version you should not lose any notes, as those are exported as well before reimporting. If this happens, please report it in the user forums!

A complete reimport is necessary, if the first import step created some errors in the value calculations. The second step relies on the parsing results of the first, so only doing a new analysis would not be sufficient.

Please note that the second import step is also what we consider a reimport, although we're only working on the data already stored in the database - so perhaps there's only a naming convention dilemma ;)

unknown

yaqbpl : yaqbpl

24/11/2008, at 12:05 [ Reply ]

why should i delete db from pgadmin ?

any way i create completly new db and try to import again

unknown

TheBrood : Some questions...

26/11/2008, at 01:43 [ Reply ]

1. On the HUD, what does "Sum Dollar" mean?
2. On the "Hand-Overview" page, what does "enable forum stats export" option do?
3. Why doesn't Elephant show UTG stats in the "Hand-overview"?

unknown

blanks : Q&A

01/12/2008, at 17:29 [ Reply ]

is there a beginners forum somewhere for Q&A on this Elephant?

Add comment

Add comment

Recent Articles

Poker-Blogs

Userblogs

Strategy-Blogs

Recent Comments

Search

calendar

« July 2009 »
Mo Tu We Th Fr Sa Su
    1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31    

archives

Categories

login

username:
password:
Password forgotten?

RSS-Feed

  • RSS 1.0
  • RSS 2.0
  • Atom 0.3