PDA

View Full Version : can anybody help w hand/note retrieval? willing to pay



praetor
05-18-2010, 10:34 PM
Having a problem w old Database, I grabbed the folder from a dead harddrive but cant access the DB or extract my notes

Was told that posting over here is best chance of finding someone able to help

Willing to pay for time

Cheers

Sarek
05-21-2010, 08:02 AM
I did it - it works
* start - programs - postgresql - pgadmin
* dbl-click on server (enter password) and find your DB
* expand to schemas - public - tables and find table named "hemplayernotes"
* right-click - Scriprts - SELECT script
* delete all text and type (or copy/paste) this
SELECT p.playername, p.site_id, n.note, n.icon_id
FROM hemplayernotes n, players p where n.player_id = p.player_id;
* press F5
* File - export - set there: Row separator = CR/LF, No qouting, charset = UTF8, column separator to "|"
* 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
should I explain this steps too, or you can do it without help?

praetor
05-21-2010, 06:42 PM
I mean, once I go thru that, into PG admin and databases, my old database isnt even there. I guess its not "linked" to Postgres on this computer or something? Its just my entire old HM folder sitting on my HD and I dont know what to do with it?

Sarek
05-22-2010, 05:38 AM
I grabbed the folder from a dead harddrive
Cheers

datavase lives in folder postgresql\data
do you have access to this "old" folder?
if no - no ways to extract notes from old base

praetor
05-22-2010, 05:39 AM
Oh. I naively assumed the database would be in the HM folder. Dont think so.

damn, thanks

a.k.a.Also
06-22-2010, 03:05 PM
I did it - it works
* start - programs - postgresql - pgadmin
* dbl-click on server (enter password) and find your DB
* expand to schemas - public - tables and find table named "hemplayernotes"
* right-click - Scriprts - SELECT script
* delete all text and type (or copy/paste) this
SELECT p.playername, p.site_id, n.note, n.icon_id
FROM hemplayernotes n, players p where n.player_id = p.player_id;
* press F5
* File - export - set there: Row separator = CR/LF, No qouting, charset = UTF8, column separator to "|"
* 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
should I explain this steps too, or you can do it without help?

Finally got round to trying this.

Changed to

4319

for the export settings, and it opened up nicely in a spreadsheet.

Thanks!