I think that's correct Ben. and yes, 1 needs to be changed to the the id_player of your first account, if it isn't 1 already. X changed to the id_player of account #2.

I was doing something somewhat similar in theme but different in execution.

Specifically, creating a number of NoteTracker rules such as "3bets OOP preflop", then dumping the results to a flat file, manipulating them in PHP to do such things as range visualization.

The ultimate goal is to be able to look at the data, see who has a merged 3b range and who has a polarized 3b range, see how wide those ranges are and see if there are other markers for identifying those sorts of players.

I've not had time to work on a set all the way to completion but hit me up on Skype, I can share the data/methods I've got.

Quux I'll pm you...

I get the same error as mrbambocha did but I dont have 2 Stars accounts. What could I have done wrong?

If it's the same error, probably this

Not this unfortunately.

have you ever imported an observed hand, or one played by anybody else?

Yes I probably did. How do I get rid of them?

I have removed all observed hands and still doesnt work.... I think I will give up now

if you'd like to PM me your skype, I will take a look and try and help.

The easiest (if time consuming) method is to "Database -> Export", and choose only SNG (2-Max) hands for hero.

If you have aliases / multiple screen names yourself, this is also a problem. In the database to be converted to population tendencies, you need only two types of people involved in a hand - you, and people playing you.

Hey guys now I'm having similar errors.

Anyone can help? I've got latest PT4 beta (4.05.8beta) and have tried exporting hands 3 times to my new DB to ensure only from PS and only HU and only hypers. I don't have multiple accounts or anything. WTF.

chances are it is an observed hand. maybe you imported someone else's HH to do a game review? maybe you have "memory grabber" enabled and observed a game with PT4 running.

One idea is to get all original your hh text files from wherever you archive them to into the same place, sort by filename so all hu games are in a row, copy/paste them to new folder then import that. This should ensure all hands feature only one villain.

yeah I have imported other people's hands, that's probably it.

Do you know if there's an easy way to only export my hands? The Active player selection on the advance tab of the hand export screen seems to make SFA difference.

Or is there some code I could run to delete any hand I was not involved in in the pop db from PGSQL...?

Can this be accomplished for 6max population tendencies or do the errors created by multiple villain showdowns hose the whole result?

zero

These errors do in fact seem to mess up the whole result.

[QUERY ] UPDATE tourney_hand_summary SET id_winner = 593 WHERE id_winner != 6 AND id_winner != 0 AND id_winner != -1
[WARNING ] UPDATE tourney_hand_player_statistics SET id_player = 593 WHERE id_player != 6 AND id_player != 0 AND id_player != -1
ERROR: duplicate key value violates unique constraint "tourney_hand_player_statistics_primary_key"
[WARNING ] UPDATE tourney_hand_player_combinations SET id_player = 593 WHERE id_player != 6 AND id_player != 0 AND id_player != -1
ERROR: duplicate key value violates unique constraint "tourney_hand_player_combinations_primary_key"
[QUERY ] UPDATE tourney_summary SET id_winner = 593 WHERE id_winner != 6 AND id_winner != 0 AND id_winner != -1
[WARNING ] UPDATE tourney_results SET id_player = 593 WHERE id_player_real != 6 AND id_player_real != 0 AND id_player_real != -1
ERROR: duplicate key value violates unique constraint "tourney_results_primary_key"
[QUERY ] UPDATE player SET id_player_alias = 593 WHERE id_player != 6 AND id_player != 0 AND id_player != -1

Here are the errors for importing 6max. I am not sure how to interpret them but would like to try to work it out for 6max also if possible. Is it possible to just not do this database update and use the filter described in the OP on this exported database to at least get the population stats without the heat map?

Regards,
zero

Don't think it's possible with 6max as if you create an alias of all players then you have the same player playing 5 hands simultaneously (+ hero = 6).
_dave_ is the one to ask though.

You may be able to use my first post in this thread to remove hero from stats, but I think this will only let you have a look at things like %vpip, %3bet, etc in reports, not actual ranges

Thanks man, so far I have learned a lot from this thread and the HUD thread as well. You get my vote for HUSNG forum MVP(oster) 2012.

I was able to get the method in the OP working to derive stats but even in hyperturbo 6max some players are using a polarized range, so getting the ranges would be really helpful.

In some ways the above makes sense but it seems like you should be able then to merge every position into a specific player at least. Since we really only care about what a player does in a given position anyways that would probably provide a "population tendency" by position where we can see what a general SB is raising etc? It would be like we had 6 global villains. I have no idea how to implement this though.

I'll keep digging around. Maybe _DAVE_ has some thoughts if he helped code the initial sql?

zero

Not sure if in PT4 creation of the alias is the same as in HEM.
In HEM you can create an alias of 2 players and I don't think that both playing on the same table will be an issue.
So my suggestion to someone with some SQL knowledge would be to create such an alias for 2 players and see how this is input in the Database.
Once you see this (i.e. how the two players are linked and a name is created for them) it should be pretty easy to write up the SQL which will create an alias for you for ALL players which are not hero.
So you will have a real Alias and not a player which simply has all the stats of all other players.
From that point on, you could analyze the game based on position (for 6 max games) and see how it goes.

Just my 2 cents.
Don't have PT4 to be able to actually look at the database itself, but it shouldn't be very hard for someone who know a little SQL.
If someone probably gives me the schema for the DB (could be exported) I am willing to try and figure out the SQL for them.

That seems like a pretty good idea actually. I can export a single stake and game, then just tie every player together with an alias. By brute force I can probably accomplish this using a script program to just add them one by one. Then I can analyze them as if they are hero. I actually think this would work in as an alternate to the HU example given here as well.

Thanks for the idea!
zero

Not sure that even a script program would be needed (although you could use one).
This should pretty much work for all stakes/all formats as an idea.
Just a quick guess on my side.
I guess an alias consists of a row in a table with at least the following columns:
"id","aliased_players"

Let's say that (which may be true) that this is the same table as the one for all other players.
At that point the SQL would look like:
(!) The code is just a concept! Do not run it on your machines.

Hope this helps.
Without actual knowledge on what the DB and tables actually look like, I don't think I can contribute more.

What steps/codes do I need to take if I have four heros?
And what code do we use to find their ID?

Is it possible to delete players once we´ve made the DB so we can exclude regs from it? (or villains we have over 250 hands vs since its mostly gonna be regs. Or maybe we can we sort the DB in ascending order and remove those players he have a certain amount of hands on?)

Export all HH from your original dbase again.
Make your dbase active that you want to use to decide which players to exclude.
For each player, use windows search in newly exported HH folder & manually delete all files with the opponents name in it.
Create a new dbase with remaining files.

A more time-saving method would be interesting.

So for those of us still having issues with non HU or other players in our population DB (creating errors in PGAdmin when running the code) there is a solution here:

https://www.pokertracker.com/forums/...art=10#p229942

Basically you need to select the tourneys slightly differently, it has worked for me but it makes it very hard to filter the data for date, BI, tourney type, etc.

Has anyone else found a better solution?

You may also be able to exclude the regs 'player numbers' from the code when creating the population DB in this step:

and just add on a WHERE id_winner != 'reg1 player number' AND id_winner != 'reg2 player number' etc. for each line in the code above. (i.e. use id_player for line 2...)

I know nothing about SQL so maybe someone else can comment.