Previous Notes

Discuss and learn how to use TableTracker for table selection and NoteTracker for taking automated notes.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Previous Notes

Postby 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

Re: Previous Notes

Postby 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

Re: Previous Notes

Postby 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

Re: Previous Notes

Postby 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

Who is online

Users browsing this forum: No registered users and 7 guests

cron