PDA

View Full Version : Can I extract hands from my DB for a specific site?



Sirus
10-22-2010, 12:58 PM
I would like to know if i can I extract hands from my DB for a specific site? Without extracting all the hands, e.g extract Everest and ipoker hands only.

tia

Patvs
10-22-2010, 02:20 PM
You can create an alias: attach your Everest + ipoker hero's to the alias

Select the ALIAS--> then in the HANDS tab--> select ALL the hands--> export them

---

But if you have many hands, it's easier to just run a Windows search on your archive folder. Only search for the Everest/ipoker hands--> copy them to a different folder. So you can run a import from folder on ALL the original handhistories

Sirus
10-22-2010, 04:14 PM
i want to extract all my everest without hero - i didnt play there and i purchased them for future.

Patvs
10-23-2010, 12:27 AM
Did you ever save the original Everest hands?
If there is no hero, there is no way to export just the Everest hands.
So your only option is to export ALL hands in the database (options--> database management--> export)

Sirus
10-26-2010, 08:12 PM
You can create an alias: attach your Everest + ipoker hero's to the alias

Select the ALIAS--> then in the HANDS tab--> select ALL the hands--> export them

---

But if you have many hands, it's easier to just run a Windows search on your archive folder. Only search for the Everest/ipoker hands--> copy them to a different folder. So you can run a import from folder on ALL the original handhistories


im trying to do the above an unhandle request appeared i pressed continue and its been going for some time. Im only trying to export 230k hands - how long should it usually take?


See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
at d8.d()
at d8.a(Object A_0, RunWorkerCompletedEventArgs A_1)
at System.ComponentModel.BackgroundWorker.OnRunWorker Completed(RunWorkerCompletedEventArgs e)
at System.ComponentModel.BackgroundWorker.AsyncOperat ionCompleted(Object arg)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4206 (VistaSP2GDR.050727-4200)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
HoldemManager
Assembly Version: 1.11.4.2754
Win32 Version: 1.11.04.2754
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/HoldemManager.exe
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4016 (NetFxQFE.050727-4000)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4205 (VistaSP2GDR.050727-4200)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4016 (NetFxQFE.050727-4000)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
DevComponents.DotNetBar2
Assembly Version: 8.3.0.0
Win32 Version: 8.3.0.0
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/DevComponents.DotNetBar2.DLL
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4016 (NetFxQFE.050727-4000)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4016 (NetFxQFE.050727-4000)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
DeployLX.Licensing.v3
Assembly Version: 3.2.2000.0
Win32 Version: 3.2.2000.3813
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/DeployLX.Licensing.v3.DLL
----------------------------------------
System.Web
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4209 (VistaSP2GDR.050727-4200)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4016 (NetFxQFE.050727-4000)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
WindowsFormsIntegration
Assembly Version: 3.0.0.0
Win32 Version: 3.0.6920.4000 built by: QFE
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/WindowsFormsIntegration/3.0.0.0__31bf3856ad364e35/WindowsFormsIntegration.dll
----------------------------------------
PresentationCore
Assembly Version: 3.0.0.0
Win32 Version: 3.0.6920.4016 built by: VistaSP2GDR
CodeBase: file:///C:/Windows/assembly/GAC_32/PresentationCore/3.0.0.0__31bf3856ad364e35/PresentationCore.dll
----------------------------------------
WindowsBase
Assembly Version: 3.0.0.0
Win32 Version: 3.0.6920.4016 built by: VistaSP2GDR
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/WindowsBase/3.0.0.0__31bf3856ad364e35/WindowsBase.dll
----------------------------------------
Softelvdm.SftTreeNET
Assembly Version: 2.0.13.0
Win32 Version: 2.0.13.0
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/Softelvdm.SftTreeNET.DLL
----------------------------------------
Softelvdm.Controls
Assembly Version: 1.0.0.17
Win32 Version: 1.0.0.17
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/Softelvdm.Controls.DLL
----------------------------------------
Npgsql
Assembly Version: 2.0.6.0
Win32 Version: 2.0.6.0
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/Npgsql.DLL
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4016 (NetFxQFE.050727-4000)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4016 (NetFxQFE.050727-4000)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
Mono.Security
Assembly Version: 2.0.0.0
Win32 Version: 2.0.0.0
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/Mono.Security.DLL
----------------------------------------
ZedGraph
Assembly Version: 5.1.4.31904
Win32 Version: 5.1.4.31904
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/ZedGraph.DLL
----------------------------------------
PresentationFramework
Assembly Version: 3.0.0.0
Win32 Version: 3.0.6920.4016 built by: VistaSP2GDR
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/PresentationFramework/3.0.0.0__31bf3856ad364e35/PresentationFramework.dll
----------------------------------------
SitNGoWizard.1.1
Assembly Version: 1.0.2.17
Win32 Version: 1.0.2.017
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/SitNGoWizard.1.1.EXE
----------------------------------------
SitNGoWizard.Localization.2.0
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/SitNGoWizard.Localization.2.0.DLL
----------------------------------------
log4net
Assembly Version: 1.2.10.0
Win32 Version: 1.2.10.0
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/log4net.DLL
----------------------------------------
HoldemVision
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/HoldemVision.DLL
----------------------------------------
LeakBuster2.5
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/LeakBuster2.5.DLL
----------------------------------------
LeakBuster2.5 Limit
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/LeakBuster2.5%20Limit.DLL
----------------------------------------
HEMGUI
Assembly Version: 1.0.9.161
Win32 Version: 1.0.9.161
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/HEMGUI.DLL
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

morny
10-26-2010, 08:19 PM
Its not really designed to show and export that many hands at once, depending on your specs it may work but its much more likely to succeed if you export 10-30k hands at a time, maybe do it by month or bi monthly until theyre all exported

also Try removing Winner Name, Winner cards and winner won from the hands view column http://faq.holdemmanager.com/questions/192/Hands+View+Column+Selection save it and refresh.

If your using the newer version youll find it under Options > Settings > Hands View Column Selection as this will display the hands quicker

Sirus
10-26-2010, 08:38 PM
Its not really designed to show and export that many hands at once, depending on your specs it may work but its much more likely to succeed if you export 10-30k hands at a time, maybe do it by month or bi monthly until theyre all exported

also Try removing Winner Name, Winner cards and winner won from the hands view column FAQ - Hold'em Manager Poker Tracking Software :: Hands View Column Selection (http://faq.holdemmanager.com/questions/192/Hands+View+Column+Selection) save it and refresh.

If your using the newer version youll find it under Options > Settings > Hands View Column Selection as this will display the hands quicker

same thing happening. HEM needs to add these features