powermail-discuss Digest #2904 - Tuesday, November 23, 2010 Re: Deleting Attachments by "Don Zahniser" <dzahni...@rochester.rr.com> Re(2): Deleting Attachments by "George Henne" <g...@nsbasic.com> Re(3): Deleting Attachments by "Peter Lovell" <plov...@mac.com> Re: Deleting Attachments by "A Sanna" <asa...@sacofoods.com> Re(4): Deleting Attachments by "CTM info" <ctm-li...@ctmdev.com> Re: Re(4): Deleting Attachments by "Mirko Kranenburg" <mirko.li...@gmail.com> Re(6): Deleting Attachments by "CTM info" <ctm-li...@ctmdev.com> Re(7): Deleting Attachments by "George Henne" <g...@nsbasic.com> Re(8): Deleting Attachments by "Peter Lovell" <plov...@mac.com> Re: Deleting Attachments by "C. A. Niemiec" <polarb...@friarwire.net> Re: Deleting Attachments by "Tim Lapin" <t...@sympatico.ca> Re(2): sent messages with IMAP by "Evan Evanson" <eevan...@sprintmail.com> Re(3): sent messages with IMAP by "Peter Lovell" <plov...@mac.com> Re: Deleting Attachments by "Don Zahniser" <dzahni...@rochester.rr.com> Re: Re(3): sent messages with IMAP by "John Snippe" <j...@snippe.ca> Database problems by "Don Zahniser" <dzahni...@rochester.rr.com> Re: Database problems by "Bill Schjelderup" <b...@companioncorp.com> Re: Deleting Attachments by "C. A. Niemiec" <polarb...@friarwire.net>
---------------------------------------------------------------------- Subject: Re: Deleting Attachments From: "Don Zahniser" <dzahni...@rochester.rr.com> Date: Mon, 22 Nov 2010 15:04:48 -0500 On 11/22/10, A Sanna wrote: >Is there a way to delete a message's attachments when deleting the >message itself? My Downloads folder seems to get clogged with junk GIF's. > If I understand correctly, PowerMail is supposed to delete attachments when the message is deleted. What I think happens in practice, is that the attachment is deleted when PowerMail's Mail Trash is emptied. So, look in the Attachments folder, delete all Spam messages, empty PowerMail's Mail Trash, and for good measure quit PowerMail, then check the Attachments folder again. - Don ---------------------------------------------------------------------- Subject: Re(2): Deleting Attachments From: "George Henne" <g...@nsbasic.com> Date: Mon, 22 Nov 2010 15:17:57 -0500 >On 11/22/10, A Sanna wrote: > >>Is there a way to delete a message's attachments when deleting the >>message itself? My Downloads folder seems to get clogged with junk GIF's. I have 13,795 items in my Attachments folders, going back to 2003. I'm convinced that many of them are orphans. I wish there was a way to clean them out. ---------------------------------------------------------------------- Subject: Re(3): Deleting Attachments From: "Peter Lovell" <plov...@mac.com> Date: Mon, 22 Nov 2010 15:31:49 -0500 On Mon, Nov 22, 2010, George Henne <g...@nsbasic.com> wrote: >I have 13,795 items in my Attachments folders, going back to 2003. I'm >convinced that many of them are orphans. I wish there was a way to clean >them out. I wonder if there's a way to identify orphans? Anyone know of one? Perhaps CTM has a suggestion? Cheers.....Peter ---------------------------------------------------------------------- Subject: Re: Deleting Attachments From: "A Sanna" <asa...@sacofoods.com> Date: Mon, 22 Nov 2010 14:59:03 -0600 >If I understand correctly, PowerMail is supposed to delete attachments >when the message is deleted. Not always true. I have certain groups of files that come attached to messages that are never deleted, although the message is never opened or read. Tony -- Anthony R. Sanna SACO Foods, Inc. 1-800-373-7226 asa...@sacofoods.com ---------------------------------------------------------------------- Subject: Re(4): Deleting Attachments From: "CTM info" <ctm-li...@ctmdev.com> Date: Mon, 22 Nov 2010 23:24:55 +0100 Peter, On Mon, 22 Nov 2010 15:31:49 -0500, Peter Lovell <plov...@mac.com> wrote: >I wonder if there's a way to identify orphans? > >Anyone know of one? Perhaps CTM has a suggestion? The behavior is that message moved to PowerMail's mail trash should see their attachments moved to the Finder trash upon emptying PowerMail's trash. This was done so that there would be two layers of protection against inadvertant destruction of attachments. And no, there is no way to identify orphans since, precisely, they are orphaned. What I do use to keep the Mail Attachments folder under control is the "Find duplicates" feature of FileBuddy, which will compare the dataforks of attachments by content and let you select for instance only the newest ones, then delete them in one go. This will at least get rid of duplicates, with however the risk that one of the duplicate files may be the file referenced by a message as its attachment. Regards, jean michel ---------------------------------------------------------------------- Subject: Re: Re(4): Deleting Attachments From: "Mirko Kranenburg" <mirko.li...@gmail.com> Date: Mon, 22 Nov 2010 23:30:21 +0100 What about exporting as PowerMail Exchange including attachments, the deleting the whole lot and importing again? It is a bit a roundabout way, and it will take a lot of time for a large archive, but it should work, or am I wrong? Mirko On 22 nov 2010, at 23:24, CTM info wrote: > Peter, > > On Mon, 22 Nov 2010 15:31:49 -0500, Peter Lovell <plov...@mac.com> wrote: > >> I wonder if there's a way to identify orphans? >> >> Anyone know of one? Perhaps CTM has a suggestion? > > The behavior is that message moved to PowerMail's mail trash should see > their attachments moved to the Finder trash upon emptying PowerMail's > trash. This was done so that there would be two layers of protection > against inadvertant destruction of attachments. > > And no, there is no way to identify orphans since, precisely, they are > orphaned. > > What I do use to keep the Mail Attachments folder under control is the > "Find duplicates" feature of FileBuddy, which will compare the dataforks > of attachments by content and let you select for instance only the > newest ones, then delete them in one go. This will at least get rid of > duplicates, with however the risk that one of the duplicate files may be > the file referenced by a message as its attachment. > > Regards, > > jean michel > > ---------------------------------------------------------------------- Subject: Re(6): Deleting Attachments From: "CTM info" <ctm-li...@ctmdev.com> Date: Mon, 22 Nov 2010 23:40:48 +0100 Mirko, Funny that you should have thought of that and mentioned it here. I started to type a similar suggestion in my previous message, only to delete it before sending: figured that I'd get in a whole lot of trouble if I were the one to suggest this and for some reason something didn't work in the process. But hey, since you were the one suggested it, then it surely must be worth a try ! ;-) jean michel On Mon, 22 Nov 2010 23:30:21 +0100, Mirko Kranenburg <mirko.li...@gmail.com> wrote: >What about exporting as PowerMail Exchange including attachments, the >deleting the whole lot and importing again? >It is a bit a roundabout way, and it will take a lot of time for a large >archive, but it should work, or am I wrong? > >Mirko > >On 22 nov 2010, at 23:24, CTM info wrote: > >> Peter, >> >> On Mon, 22 Nov 2010 15:31:49 -0500, Peter Lovell <plov...@mac.com> wrote: >> >>> I wonder if there's a way to identify orphans? >>> >>> Anyone know of one? Perhaps CTM has a suggestion? >> >> The behavior is that message moved to PowerMail's mail trash should see >> their attachments moved to the Finder trash upon emptying PowerMail's >> trash. This was done so that there would be two layers of protection >> against inadvertant destruction of attachments. >> >> And no, there is no way to identify orphans since, precisely, they are >> orphaned. >> >> What I do use to keep the Mail Attachments folder under control is the >> "Find duplicates" feature of FileBuddy, which will compare the dataforks >> of attachments by content and let you select for instance only the >> newest ones, then delete them in one go. This will at least get rid of >> duplicates, with however the risk that one of the duplicate files may be >> the file referenced by a message as its attachment. >> >> Regards, >> >> jean michel >> >> > > ---------------------------------------------------------------------- Subject: Re(7): Deleting Attachments From: "George Henne" <g...@nsbasic.com> Date: Mon, 22 Nov 2010 17:56:09 -0500 Sounds workable - but is Microsoft Exchange the most reliable to export/ import to? >Mirko, > >Funny that you should have thought of that and mentioned it here. I >started to type a similar suggestion in my previous message, only to >delete it before sending: figured that I'd get in a whole lot of trouble >if I were the one to suggest this and for some reason something didn't >work in the process. > >But hey, since you were the one suggested it, then it surely must be >worth a try ! ;-) > >jean michel > >On Mon, 22 Nov 2010 23:30:21 +0100, Mirko Kranenburg ><mirko.li...@gmail.com> wrote: > >>What about exporting as PowerMail Exchange including attachments, the >>deleting the whole lot and importing again? >>It is a bit a roundabout way, and it will take a lot of time for a large >>archive, but it should work, or am I wrong? >> >>Mirko >> >>On 22 nov 2010, at 23:24, CTM info wrote: >> >>> Peter, >>> >>> On Mon, 22 Nov 2010 15:31:49 -0500, Peter Lovell <plov...@mac.com> wrote: >>> >>>> I wonder if there's a way to identify orphans? >>>> >>>> Anyone know of one? Perhaps CTM has a suggestion? >>> >>> The behavior is that message moved to PowerMail's mail trash should see >>> their attachments moved to the Finder trash upon emptying PowerMail's >>> trash. This was done so that there would be two layers of protection >>> against inadvertant destruction of attachments. >>> >>> And no, there is no way to identify orphans since, precisely, they are >>> orphaned. >>> >>> What I do use to keep the Mail Attachments folder under control is the >>> "Find duplicates" feature of FileBuddy, which will compare the dataforks >>> of attachments by content and let you select for instance only the >>> newest ones, then delete them in one go. This will at least get rid of >>> duplicates, with however the risk that one of the duplicate files may be >>> the file referenced by a message as its attachment. >>> >>> Regards, >>> >>> jean michel >>> >>> >> >> > > > ---------------------------------------------------------------------- Subject: Re(8): Deleting Attachments From: "Peter Lovell" <plov...@mac.com> Date: Mon, 22 Nov 2010 20:15:03 -0500 Hi George, Mirko mentioned PowerMail exchange format, rather than Microsoft Exchange. I think that would work OK - I wouldn't ever try to run stuff through MS Exchange. Regards.....Peter On Mon, Nov 22, 2010, George Henne <g...@nsbasic.com> wrote: >Sounds workable - but is Microsoft Exchange the most reliable to export/ >import to? > >>Mirko, >> >>Funny that you should have thought of that and mentioned it here. I >>started to type a similar suggestion in my previous message, only to >>delete it before sending: figured that I'd get in a whole lot of trouble >>if I were the one to suggest this and for some reason something didn't >>work in the process. >> >>But hey, since you were the one suggested it, then it surely must be >>worth a try ! ;-) >> >>jean michel >> >>On Mon, 22 Nov 2010 23:30:21 +0100, Mirko Kranenburg >><mirko.li...@gmail.com> wrote: >> >>>What about exporting as PowerMail Exchange including attachments, the >>>deleting the whole lot and importing again? >>>It is a bit a roundabout way, and it will take a lot of time for a large >>>archive, but it should work, or am I wrong? >>> >>>Mirko >>> >>>On 22 nov 2010, at 23:24, CTM info wrote: >>> >>>> Peter, >>>> >>>> On Mon, 22 Nov 2010 15:31:49 -0500, Peter Lovell <plov...@mac.com> wrote: >>>> >>>>> I wonder if there's a way to identify orphans? >>>>> >>>>> Anyone know of one? Perhaps CTM has a suggestion? >>>> >>>> The behavior is that message moved to PowerMail's mail trash should see >>>> their attachments moved to the Finder trash upon emptying PowerMail's >>>> trash. This was done so that there would be two layers of protection >>>> against inadvertant destruction of attachments. >>>> >>>> And no, there is no way to identify orphans since, precisely, they are >>>> orphaned. >>>> >>>> What I do use to keep the Mail Attachments folder under control is the >>>> "Find duplicates" feature of FileBuddy, which will compare the dataforks >>>> of attachments by content and let you select for instance only the >>>> newest ones, then delete them in one go. This will at least get rid of >>>> duplicates, with however the risk that one of the duplicate files may be >>>> the file referenced by a message as its attachment. >>>> >>>> Regards, >>>> >>>> jean michel >>>> >>>> >>> >>> >> >> >> > > > ---------------------------------------------------------------------- Subject: Re: Deleting Attachments From: "C. A. Niemiec" <polarb...@friarwire.net> Date: Mon, 22 Nov 2010 21:23:18 -0500 >>I have 13,795 items in my Attachments folders, going back to 2003. I'm >>convinced that many of them are orphans. I wish there was a way to clean >>them out. > >I wonder if there's a way to identify orphans? > >Anyone know of one? Perhaps CTM has a suggestion? Is there is any technical problem to putting all the attachments for each message in its own folder? Name the folder with some combination of message subject and date/timestamp received. This would prevent the need to rename attachments. If you find what you think is an orphaned attachment set, you have a clue to what the original message is, and if it's junk you can be rid of it all by deleting just one folder. Can metadata be set in the Finder on that folder in such a way that Spotlight will see that it is attached to a particular PowerMail message? Could FoxTrot use this kind of logic (maybe it does)? Here's another idea that perhaps could be done if attachments were stored in folders: an AppleScript that goes through your messages and finds the corresponding folder of its attachments and sets the Finder label to what you choose. Then you know which folders are orphaned by seeing which ones are not labeled. If one actually uses Finder labels for some other purpose here, "do not change label if already labeled" criterion, etc. Hrm. 13.932 items in my Attachments folder. That's quite a spin of the ol' beachball to see the list in the Finder. I can't imagine an Attachments folder with fewer folders (than that number of files) would be worse. Chris -- ---------------------------------------------------------------------- Subject: Re: Deleting Attachments From: "Tim Lapin" <t...@sympatico.ca> Date: Mon, 22 Nov 2010 23:28:36 -0500 Interesting idea, Chris. Metadata or folders could solve the issue. Of the two, the metadata idea seems more efficient. One of the big problems with attachments are all those image files that are included in HTML style mail: such as little emoticons, stuff in the headers and footers and even background images. Perhaps a better idea would be to maintain a separate index file for the attachments. Basically a simple database, each record would include sufficient info to recreate the links to a specific email message. That way a simple search for subject or date would be all that is required to determine whether or not a given attachment is orphaned and to which e-mail it once belonged. As far as the spinning beach ball goes, I don't think it would be too bad. I just checked my attachments folder. It has just under 3,000 items and it took less than 5 seconds to display. I have the last of the white iMacs (circa 2007) with the maximum amount of RAM (3 to 4 GB). Assuming an equivalent Mac, it should take less than 30 seconds to display just under 14,000 items. -- Tim Lapin t...@sympatico.ca On 2010-11-22, at 9:23 PM, C. A. Niemiec wrote: >>> I have 13,795 items in my Attachments folders, going back to 2003. I'm >>> convinced that many of them are orphans. I wish there was a way to clean >>> them out. >> >> I wonder if there's a way to identify orphans? >> >> Anyone know of one? Perhaps CTM has a suggestion? > > Is there is any technical problem to putting all the attachments for > each message in its own folder? Name the folder with some combination of > message subject and date/timestamp received. > > This would prevent the need to rename attachments. If you find what you > think is an orphaned attachment set, you have a clue to what the > original message is, and if it's junk you can be rid of it all by > deleting just one folder. > > Can metadata be set in the Finder on that folder in such a way that > Spotlight will see that it is attached to a particular PowerMail > message? Could FoxTrot use this kind of logic (maybe it does)? > > Here's another idea that perhaps could be done if attachments were > stored in folders: an AppleScript that goes through your messages and > finds the corresponding folder of its attachments and sets the Finder > label to what you choose. Then you know which folders are orphaned by > seeing which ones are not labeled. > > If one actually uses Finder labels for some other purpose here, "do not > change label if already labeled" criterion, etc. > > Hrm. 13.932 items in my Attachments folder. That's quite a spin of the > ol' beachball to see the list in the Finder. I can't imagine an > Attachments folder with fewer folders (than that number of files) would > be worse. > > Chris > -- > > > > ---------------------------------------------------------------------- Subject: Re(2): sent messages with IMAP From: "Evan Evanson" <eevan...@sprintmail.com> Date: Mon, 22 Nov 2010 23:41:13 -0500 On 1:40 PM CST, Mon, Nov 22, 2010, MiB wrote: >> No, Sent messages should show up on every client. And really don't >> do Gmail with IMAP. Their IMAP implementation is weird. > >It works really well with real IMAP clients. You actually find *that* >weird or is it really PowerMail«s limited abilities? Last I checked, you can get weird and even very weird results using IMAP to sync with Gmail because they don't have a folder system. They use labels, which an IMAP client will interpret as folders. But if you have an email marked with two labels, it will show up in your IMAP client as two emails in two folders. If you have nested folders, it used to be that the folder hierarchy appeared in Gmail as a single label, for instance "Work\Finances \Receipts". But labels have a limit of forty characters, so a sufficiently nested folder system broke Gmail's labels. Google Labs has a nested label system they're working on - I don't know if that fixes that problem. Evan Evanson -- "To announce that there must be no criticism of the President, or that we are to stand by the President, right or wrong, is not only unpatriotic and servile, but is morally treasonable to the American public." - Theodore Roosevelt ---------------------------------------------------------------------- Subject: Re(3): sent messages with IMAP From: "Peter Lovell" <plov...@mac.com> Date: Tue, 23 Nov 2010 00:06:50 -0500 On Mon, Nov 22, 2010, Evan Evanson <eevan...@sprintmail.com> wrote: >-- >"To announce that there must be no criticism of the President, or that >we are to stand by the President, right or wrong, is not only >unpatriotic and servile, but is morally treasonable to the American public." > > - Theodore Roosevelt Hi Evan, while I personally agree with your sentiment, I believe that this touches too close on an area where this list ought not go. I find this list to be very helpful, and offer help when I can. But I don't want it to be diverted into political issues. Even though I agree with the thought others might not. Thanks.....Peter ---------------------------------------------------------------------- Subject: Re: Deleting Attachments From: "Don Zahniser" <dzahni...@rochester.rr.com> Date: Tue, 23 Nov 2010 01:06:34 -0500 On 11/22/10, Mirko Kranenburg wrote: >What about exporting as PowerMail Exchange including attachments, the >deleting the whole lot and importing again? >It is a bit a roundabout way, and it will take a lot of time for a large >archive, but it should work, or am I wrong? I have a relatively small PowerMail message database (<170 MB) and less than 500 files in my Attachments folder. Unfortunately, many of the attachment files are duplicates from when I took a couple of excursions into other email programs, and re-imported messages that weren't recognized as duplicates by PowerMail. I figured I would try exporting the database, then importing into a new environment. I gave up exporting after it sat for an hour showing 25 minutes left, with the CPU on my Pismo maxed out, and the fan running (The first time EVER the fan on my Pismo kicked in!). The Dock icon, when clicked, said "Application not responding". I gave up, force quit PowerMail, and tried again, with the same results. Looks like I'll clean out the attachments manually... -- Don Zahniser Powerbook G3 (Pismo), 40GB HD (5200 RPM), 768 MB RAM, Mac OS 10.4.11 ---------------------------------------------------------------------- Subject: Re: Re(3): sent messages with IMAP From: "John Snippe" <j...@snippe.ca> Date: Tue, 23 Nov 2010 09:14:43 -0500 On 23-Nov-10, at 12:06 AM, Peter Lovell wrote: > while I personally agree with your sentiment, I believe that this > touches too close on an area where this list ought not go. it's a "signature", dude. Get over it. -- John Snippe ---------------------------------------------------------------------- Subject: Database problems From: "Don Zahniser" <dzahni...@rochester.rr.com> Date: Tue, 23 Nov 2010 11:43:19 -0500 After my spinning beachball adventures trying to export my PowerMail database to PowerMail exchange format, I thought I would try to do some maintenance on the database. I restarted PowerMail and checked all of the items in the first category. Everything seemed to work except the low-level rebuild. I got a series of errors, one for each database component that needed rebuilding. In each case, the error codes were the same: Class-DB what=100 err=130 Translation, please? Could this be related to my seeming inability to export to PowerMail Exchange format? Any further assistance would be welcome! - Don -- Don Zahniser Powerbook G3 (Pismo), 40GB HD (5200 RPM), 768 MB RAM, Mac OS 10.4.11; PowerMail 6.0.5 ---------------------------------------------------------------------- Subject: Re: Database problems From: "Bill Schjelderup" <b...@companioncorp.com> Date: Tue, 23 Nov 2010 10:03:03 -0700 Since the last update I've not been able to do low level rebuilds. I'm on the latest hardware and systems. I do rebuilds on a regular basis, so I suspect since the problem occurred just after the update, that there is a problem with Powermail. I've not noticed any other bad side effect, other options work well. It seems to be that Powermail is on "maintenance development" from CTM, I keep looking at alternatives...but none do it for me. I expect with all the competition for email clients and Powermail not supporting HTML email very well it's market is limited to the group of us that need the unique features of the program. I can only hope it's economically rational for CTM to continue to invest resources into the product into the future. Much like my Quicken 2006, the ONLY PPC application I still use. I'm happy to pay for a new product...but none can do the fairly simple things I need. I would feel more confident if the low level rebuild worked.... +-----------------------------------------------------------+ Bill Schjelderup, President b...@companioncorp.com COMPanion Corporation 801-365-0555 voice 1831 Fort Union Blvd. 801-943-7752 fax Salt Lake City, Utah 84121-3041 www.companioncorp.com +-----------------------------------------------------------+ Nusquam est qui ubique est. - He who is everywhere is nowhere. This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure, or distribution is prohibited. If you are NOT the intended recipient, I'm sorry to bother you and will attempt to address my messages more carefully in the future. >After my spinning beachball adventures trying to export my PowerMail >database to PowerMail exchange format, I thought I would try to do some >maintenance on the database. I restarted PowerMail and checked all of >the items in the first category. Everything seemed to work except the >low-level rebuild. I got a series of errors, one for each database >component that needed rebuilding. In each case, the error codes were >the same: > >Class-DB what=100 err=130 > >Translation, please? > >Could this be related to my seeming inability to export to PowerMail >Exchange format? > >Any further assistance would be welcome! > > - Don > >-- >Don Zahniser >Powerbook G3 (Pismo), 40GB HD (5200 RPM), 768 MB RAM, Mac OS 10.4.11; >PowerMail 6.0.5 > > > ---------------------------------------------------------------------- Subject: Re: Deleting Attachments From: "C. A. Niemiec" <polarb...@friarwire.net> Date: Tue, 23 Nov 2010 13:48:01 -0500 >... >As far as the spinning beach ball goes, I don't think it would be too >bad. I just checked my attachments folder. It has just under 3,000 >items and it took less than 5 seconds to display. That is 4.7 seconds too long! :) >I have the last of >the white iMacs (circa 2007) with the maximum amount of RAM (3 to 4 >GB). Assuming an equivalent Mac, it should take less than 30 seconds to >display just under 14,000 items. Again, way too long. If I were trying to see all of them at once, ok, but less than 60 visible in a list? That should be instantaneous. Maybe it is better on Snow Leopard... This is why I store all my third party applications in their own folder in the Applications folder (and also subfolder by type). Keeps the wait to a minimum. Chris -- ---------------------------------------------------------------------- End of powermail-discuss Digest