export notes to HM1

[rkt1337]

Is it possible to export my notes to HM1? im playing on a site that runs better on HM1 and i have a lot of notes to move over

[Patvs]

Unfortunately this is NOT possible. HM2 isn't forward-compatible.

In fact, at the moment it's not even backward-compatible as HM2 also is unable to import a HM1-exportednotes file, but this will be fixed as soon as possible. (and as a temporary solution you can run a import from database on the entire HM1 database, which will also import the notes)

[rkt1337]

Unfortunately this is NOT possible. HM2 isn't forward-compatible.

In fact, at the moment it's not even backward-compatible as HM2 also is unable to import a HM1-exportednotes file, but this will be fixed as soon as possible. (and as a temporary solution you can run a import from database on the entire HM1 database, which will also import the notes)

is there a way i can open my notes in a XML or txt in hm2 so that i can ctrl+f the player during my first few sessions and just transfer them one by one?

[fozzy71]

is there a way i can open my notes in a XML or txt in hm2 so that i can ctrl+f the player during my first few sessions and just transfer them one by one?

No, this is not possible. The notes are part of the PostgreSQL database and not contained in any txt/xml type of file.

[CuoReNeRo]

No, this is not possible. The notes are part of the PostgreSQL database and not contained in any txt/xml type of file.

What about editing the database with some queries? Could you say where are exactly the notes and which tables should be edit?

[fozzy71]

What about editing the database with some queries? Could you say where are exactly the notes and which tables should be edit?

This is well beyond our first level support and I have very limited PGAdmin knowledge. I have escalated this to our 2nd level support techs and have explained the issues you are having but I am not sure if what you want to achieve is even possible. If it is actually possible it will likely be very complicated and time consuming. Once we have more info we will reply here but I am not sure how long that will take.

Here are the instructions for how to do it in HM1 but this is a bit beyond me so I have forwarded it to the rest of our team to see if we can possibly do the same thing - http://forums.holdemmanager.com/mana...tml#post149891

[Sarek]

Did some research: it IS possible to extract notes from HM2 database and to prepare them in HM1 "notes_in_file" format
* start - programs - postgresql - pgadmin
* dbl-click on server (enter password) and find your DB
* expand to schemas - public - tables
* right-click on ANY tablename - Scriprts - SELECT script
* delete all text and type (or copy/paste) this

SELECT p.playername, p.pokersite_id, n.note, n.icon_id
  FROM player_notes n, players p  where n.player_id = p.player_id and category_id = 5;

* press F5
* In that Query window do menuitem
File - export
set there: Row separator = CR/LF, No qouting, charset = UTF8, untick "column names", leave column separator to "|"
see picture
hm2notesexp.jpg

* save file as CSV = you have extracted notes
* but now you need to format them exactly as in HM exported file - change separator and some, delete headers etc
Because "original" HM1 file with exported notes looks so:

----PLAYER NOTE----
PEELII~|~2~|~note1~|~-1
----PLAYER NOTE----
kmccarron~|~2~|~~|~6
----PLAYER NOTE----
whitecorax~|~2~|~note and mark~|~6

But file you just got looks like this

AlfenNnn|4|note1|0
mato818|4|note adn mark|0

So you need to change separators between values
and to insert a kind of "separator" between lines
This all can easy be done in any text editor.
But do not forget to save resulting file as "plain text"
Then rename it to
ExportedNotes.HMNotes
and import in HM1

The only thing I am not sure right now is: are Pokersites numbered is same order in HM1 and HM2.
IMO, odds = 90% order and IDs are the same.
Just try

[CuoReNeRo]

I'll try it tomorrow or when i'll have some spare. Really THANKS for your explanation, i'll let you know if it works.

[CuoReNeRo]

--- EDITED ---

IT WORKED.

Thanks a lot.

[fozzy71]

Thank you for letting us know it worked for you.