Import Problems

[SharpObject]

I was just in the middle of export and reimporting my hands into a new 8.4 DB. While my computer was importing it shut down unexpectedly. (hit the surge protector with my foot "oops") Now when i try to import I just get import errors, in 1000 hand blocks thorough out the entire folder. I tried unRARing them again, into a new folder. Then it would import and list duplicates, until it got to the new hands, where it would then give import errors. Also I can connect to the DB and I tried vacuuming and analyzing it, but this didn't help.

Windows 7 and HM 1.09 Beta 42 postgres 8.4 is being used.

Thanks
-Jerimy

[fozzy71]

unexpected power outage, while importing will usually corrupt a DB.

Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe

*Try creating a new UTF DB - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146
*Now import a small portion of your \HMArchive so you can see if the problem exists in the new DB - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173
*If the new DB seems to work properly, you will want to import the rest of your archives to the new DB, export/import the hands from the old DB to the new DB, and export/import any player notes and tourney summaries - and then delete the old DB. - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=21