Help! Want to Import Exported Prima-Eurolinx Hands from HEM

[DollarsNEuros]

Currently, HEM claims to support Prima/Microgaming, in particular multicurrency, but actually does not yet. They've been claiming they would support multicurrency for quite some time.

I must do my 2008 taxes early this year to apply for a loan to buy a house, but can't because of this. (I'm filing as pro for only the 2nd year.)

Hold Em Manager can export the Prima hands, but PT2 will not import the data as supplied. (This issue might also be relevant PT3, since I'll want to export HEM hands from Prima into PT3, when PT3 provides full support for that site.)

I tried renaming the text to gamehistory.dat, but that won't work. I've tried doing a generic HH import from the textfile(s), and that doesn't work.

Each individual hand history within the file is in the following format, each with the prima.dat suffix as well:
----PRIMA.DAT----

<Game id="2000000000" date="2008-10-01 00:00:05" unicodetablename="RgBpAGwAdABpAGEAcgBuACAAMgA=" tablename="Filtiarn 2" stakes="3.00|6.00" betlimit="NL" tabletype="Cash Game" gametypeid="1" gametype="Hold &apos;em" realmoney="true" currencysymbol="rCA=" rake="0" playerseat="1" betamount="2100" istournament="0">
<Seats>
<Seat num="1" alias="Hero" unicodealias="TwBGAEYAXwBEAEEAXwBIAEkAWgBaAFkA" balance="653.00" endbalance="659.00" dealer="true"/>
<Seat num="2" alias="Villain" unicodealias="YgBsAGEAYwBrAHMAbQBpAHQAaAAxAA==" balance="371.69" endbalance="365.69"/>
</Seats>
<Gameplay>
<Action seq="1" type="SmallBlind" seat="1" value="3.00"/>
<Action seq="2" type="BigBlind" seat="2" value="6.00"/>
<Action seq="3" type="DealCards" seat="1">
<Card value="2" suit="c" id="14"/>
<Card value="J" suit="c" id="23"/>
</Action>
<Action seq="4" type="Raise" seat="1" value="21.00"/>
<Action seq="5" type="Fold" seat="2"/>
<Action seq="6" type="MuckCards" seat="1"/>
<Action type="Win">
<Seat num="1" amount="27.00" pot="0" type="" lowhandwin="0"/>
</Action>
</Gameplay>
</Game>

[DollarsNEuros]

I greatly appreciate any help in solving this issue.

[ptrack pat]

PT2 can only import the hands from either the SQLite database files (the gamehistory.dat file) or from the text that was generated when the hands were imported into PT2. PT2 takes that XML text and creates readable text and the text must be in that exact format for PT2 to be able to reimport it. It does not expect just a file containing the XML text of the hand so it won't import it. Don't you have the original gamehistory.dat file that these hands were imported from? If not, PT won't import them.

[DollarsNEuros]

I've put in quite a bit of playtime, so my history.dat file doesn't have all the hands from last year. Only from last month.

I don't think I'll be the only one who wants to import my Prima HHs from HEM->PT3 when support is provided, but it looks like we'll be stuck it seems. Also, right now, I know at least 3 other people who would like to be able to do HEM->PT2, and judging by the HEM forums, there are a lot of HEM customers unhappy with the broken support of Prima.

Is there any way to convert the XML to SQLite?

[ptrack pat]

The only way to do it would be to actually create records in the gamehistory.dat file using a SQLite database tool that contains the XML hand history text along with 6 other fields that are in the HandHistory table in that database.

[DollarsNEuros]

I've been trying to do what you've suggested.

The easy part was opening the gamehistory.dat and delete all the old data in there to clear space.

Next I exported the empty database to XML and got the following output:

<?xml version="1.0" standalone="yes"?>
<DATAPACKET Version="2.0">
<METADATA>
<FIELDS>
<FIELD FieldName="HandID" DisplayLabel="HandID" FieldType="Integer" FieldClass="TField"/>
<FIELD FieldName="HandDate" DisplayLabel="HandDate" FieldType="String" FieldClass="TField"/>
<FIELD FieldName="WasSeated" DisplayLabel="WasSeated" FieldType="Integer" FieldClass="TField"/>
<FIELD FieldName="XMLDump" DisplayLabel="XMLDump" FieldType="String" FieldClass="TField"/>
<FIELD FieldName="TableName" DisplayLabel="TableName" FieldType="String" FieldClass="TField"/>
<FIELD FieldName="GameType" DisplayLabel="GameType" FieldType="String" FieldClass="TField"/>
<FIELD FieldName="TableType" DisplayLabel="TableType" FieldType="String" FieldClass="TField"/>
</FIELDS>
</METADATA>
<ROWDATA>
</ROWDATA>
</DATAPACKET>

---

I took a single record like the earlier posted single, though I removed the ----PRIMA.DAT---- heading, and pasted it between <ROWDATA></ROWDATA>.

Then I attempted to import that into the SQLite database and it didn't import correctly.

Screenshot of the results here: http://img66.imageshack.us/img66/2740/s ... 350fe5.png

Any ideas?

[ptrack pat]

Did you try to export the contents of a gamehistory.dat file that had maybe a hand or two in it to see what that might look like? Maybe there is some formatting you are missing?