importing notes

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

importing notes

Postby Florian87 » Sun Oct 02, 2022 5:44 am

What does happen when we export/import notes and there were already notes for such player ? Do they all add up together or do the later import erases the previous notes ?
thanks
Florian87
 
Posts: 22
Joined: Thu Feb 12, 2015 9:01 am

Re: importing notes

Postby Flag_Hippo » Sun Oct 02, 2022 11:58 am

If you import notes into another database then those notes are added to the existing notes in that database. Also if the same note exists in both databases then the note text is appended meaning that it will be doubled up so this isn't ideal if you are going to import notes from one database into another and then back again. If you want to delete existing notes before importing then there isn't a built-in method so you'll need to use PGAdmin and run the following query:

Code: Select all
TRUNCATE TABLE notes;

To do that double click on PostgreSQL x.y' (where x.y is your PostgreSQL version) and if your prompted for a password the default is "dbpass" (without the quotes), expand 'Databases' and then select your database. The query tool can be opened via its icon in PGAdmin or via 'Tools -> Query Tool' and then you can run the query using 'Query -> Execute'. I'd recommend backing up your poker data before making any changes since PGAdmin is connected directly to your database so take care not to make any other unintended changes to your data while using it.
Flag_Hippo
Moderator
 
Posts: 12769
Joined: Tue Jan 31, 2012 7:50 am


Return to PokerTracker 4

Who is online

Users browsing this forum: Google [Bot], thejakunuthuru and 3 guests

cron