Discuss and learn how to use TableTracker for table selection and NoteTracker for taking automated notes.
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
by PHJJR » Thu Jun 14, 2012 4:51 pm
I just downloaded PT$ and imported my PT3 databaes.
Problem is there are 500k notes from notecaddy.
Can I purge these notes or do I need to purge the Database?
Havent gotten into the program yet sooo looking forward to the new PT4 with Notetracker
-
PHJJR
-
- Posts: 47
- Joined: Fri May 16, 2008 11:37 am
by kraada » Thu Jun 14, 2012 6:16 pm
There isn't built in functionality to remove manually entered notes, only NoteTracker notes.
That said, I can give you a way to remove all notes fairly easily.
Click Start --> All Programs --> PostgreSQL --> PGAdminIII.
In PGAdmin connect to your server by double clicking it. Expand the Databases list to find your PT4 database. Click on it to connect and you'll see the red X go away. Click Tools --> Query Tool.
Type in this query:
TRUNCATE TABLE notes;
Then click Query --> Execute in the menu bar.
Exit out, restart PT4 and your converted PT3 notes should be completely eliminated.
-
kraada
- Moderator
-
- Posts: 54431
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
by PHJJR » Fri Jun 15, 2012 8:37 am
I know its simple and Ive got it somewhere but don't remember the password.
Seems like its postpass ?? or something like that.
Help pls
Thanks
-
PHJJR
-
- Posts: 47
- Joined: Fri May 16, 2008 11:37 am
by kraada » Fri Jun 15, 2012 9:08 am
Try:
dbpass
or
postgrespass
It's likely one of those two.
-
kraada
- Moderator
-
- Posts: 54431
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
Return to TableTracker & NoteTracker
Users browsing this forum: No registered users and 8 guests