How to export PM not based on date ?

[vo]

I tried to clean up my PM box and was going to export PM by member's name but cannot find that option ???
Is there anyway to do it ?
TIA

 

[olds]

I am not sure but try this.
Click on the users name, that will sort them, then export them.

But, don't select the option for deleting them till you are sure you have what you want saved. Don't ask me how I know.

 

[vo]

Thanks for the tip but I tried that and it still export everything.

 

[olds]

You're right. You can only export all of them or some of them based on date.

 

[Evadman]

I need to bust out my PM import database again. I never bothered to update it with the last PM change, which was a while ago. I am almost at the limit with 970 something.

 

[EagleKeeper]

Cleanout all the spam messages first.

 

[vo]

Originally posted by: Evadman
I need to bust out my PM import database again. I never bothered to update it with the last PM change, which was a while ago. I am almost at the limit with 970 something.

I am at 992 and no SPAM :thumbsup:
Really need to export them out but I would like to order them by author ... :clock:

 

[vo]

Come on ...

 

[vo]

Ok ... I got it as there is no way to sort by name.
But I still have a little hope left ... can I export them to excel so I can sort them later ?

 

[Evadman]

Originally posted by: vo
Ok ... I got it as there is no way to sort by name.
But I still have a little hope left ... can I export them to excel so I can sort them later ?

The format does not get along with sorting. I'll see what I can do tommorow.

 

[Evadman]

Here ya go. Export your messages from here, and import them into this database. The database will take care of parcing the messages out of the HTM file that you get when you export the messages.

The database has 2 web pages that display your messages like a thread or all of them so you can do your own filtering. You can also make queries to your hearts content since it is an unlocked access database. Feel free to distribute it as you see fit, but don't sue me. I don't have any money anyway.

Extract wherever you want on your machine and open the database. For some reason, the data access pages son't like being extraced into a 'my documents' folder. Not sure why, don't have time to figure it out. If you do that you will need to relink the page and data source on the access database.

AnandTech PM Database

 

[olds]

Originally posted by: Evadman
Here ya go. Export your messages from here, and import them into this database. The database will take care of parcing the messages out of the HTM file that you get when you export the messages.

The database has 2 web pages that display your messages like a thread or all of them so you can do your own filtering. You can also make queries to your hearts content since it is an unlocked access database. Feel free to distribute it as you see fit, but don't sue me. I don't have any money anyway.

Extract wherever you want on your machine and open the database. For some reason, the data access pages son't like being extraced into a 'my documents' folder. Not sure why, don't have time to figure it out. If you do that you will need to relink the page and data source on the access database.

AnandTech PM Database

Cliffs for us idiots?

I have my PMs on my desktop.
I try to open them with PM Database.mdb and I get an error about it not being a valid win32 application.
Thanks.

 

[Evadman]

It is an access database, you need microsoft access. Maybe I should just write one in Visual basic or something, but then it is harder for others to make modifications.

 

[vo]

Cool ... I will try later and report back ... Thanks Evadman

 

[vo]

I got the following error from Microsoft Visual Basic when I imported it:

Run-time error '-2147217887(80040e21)':

Field 'TBL_PrivateMessage.PM_Message' cannot be a zero-length string.

 

[KLin]

Cool db :thumbsup:. I couldn't get the data pages to work, so I just created a report and a form to filter the data on the report by the various fields. Works well.

 

[KLin]

Originally posted by: vo

I got the following error from Microsoft Visual Basic when I imported it:

Run-time error '-2147217887(80040e21)':

Field 'TBL_PrivateMessage.PM_Message' cannot be a zero-length string.

I recreated the problem. apparently you have some PM's that are blank.


EDIT: if you want to fix this yourself do the following:

1. goto the database window
2. click modules
3. right click module1 and click design view
4. goto line 67(it should tell you what line you are on in the menu bar
5. copy and paste the following after line 67:

If TextToSave = "" Then
TextToSave = "No Message"
End If

6. close the db and click yes to save changes
7. open database and try the import again.

 

[vo]

Bingo ... it works ... thank you very much !
Evadman and Klin, this is a very good information.
Like oldsmoboat said, maybe we should put it in the FAQ like a cliff note for the rest of us

BTW, oldsmoboat, did you get it to work ?

 

[olds]

Originally posted by: vo
Bingo ... it works ... thank you very much !
Evadman and Klin, this is a very good information.
Like oldsmoboat said, maybe we should put it in the FAQ like a cliff note for the rest of us

BTW, oldsmoboat, did you get it to work ?

I don't have Access on this machine, only my desktop which crashed.

 

[RossMAN]

Originally posted by: vo
Like oldsmoboat said, maybe we should put it in the FAQ like a cliff note for the rest of us

I would also recommend adding it to the unofficial AT wiki :thumbsup:

 

[Evadman]

Good catch on the import KLin, I didn't take into account that a PM could be blank. I didn't have any in my PM files, so it worked on all mine. You can also turn 'allow zero length strings' option on the PM_Message field in the TBL_PrivateMessage table. I updated the database so the field will be NULL if the message was blank.

Originally posted by: KLin
Cool db :thumbsup:. I couldn't get the data pages to work, so I just created a report and a form to filter the data on the report by the various fields. Works well.

Did you just make a form using the auto tool, or did you make it look 'presentable'? If it is presentable, I would love it if you could send a copy of your database to me and I will update the Zip file. Make sure to remove your PM's.

I have added a note to my note list to write this in some other kind of tool besides Access so everyone on windows can use it. I am thinking VB and SQL 2005 probably; that would be most user and developer friendly. that will allow a 2 GB database, which you should never hit with PM's. Unless you are RossMAN maybe.

 

[KLin]

Originally posted by: Evadman
Good catch on the import KLin, I didn't take into account that a PM could be blank. I didn't have any in my PM files, so it worked on all mine. You can also turn 'allow zero length strings' option on the PM_Message field in the TBL_PrivateMessage table. I updated the database so the field will be NULL if the message was blank.

Originally posted by: KLin
Cool db :thumbsup:. I couldn't get the data pages to work, so I just created a report and a form to filter the data on the report by the various fields. Works well.

Did you just make a form using the auto tool, or did you make it look 'presentable'? If it is presentable, I would love it if you could send a copy of your database to me and I will update the Zip file. Make sure to remove your PM's.

I have added a note to my note list to write this in some other kind of tool besides Access so everyone on windows can use it. I am thinking VB and SQL 2005 probably; that would be most user and developer friendly. that will allow a 2 GB database, which you should never hit with PM's. Unless you are RossMAN maybe.

Sent you an email :thumbsup:. a vb.net app with a sql 2005 express backend would be cool too. I'd do it if I could program in .net. I'm not up to that level yet .


EDIT: The access report I made does not translate the HTML code unfortunately. I guess I could just recreate those HTML data pages.

 

[Evadman]

Originally posted by: KLin
EDIT: The access report I made does not translate the HTML code unfortunately. I guess I could just recreate those HTML data pages.

If you made a report, taht's cool too. The more ways to view the data the better for the end user.