Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.sys.mac.system > #67718 > unrolled thread

A program to show all Mac Mail Rules?

Back to article view | Back to comp.sys.mac.system

Contents

  A program to show all Mac Mail Rules? Gary <gary_w1@hotmail.com> - 2014-12-18 15:00 -0500
    Re: A program to show all Mac Mail Rules? Alan Baker <alangbaker@telus.net> - 2014-12-18 12:14 -0800
    Re: A program to show all Mac Mail Rules? Jolly Roger <jollyroger@pobox.com> - 2014-12-18 23:16 +0000
      Re: A program to show all Mac Mail Rules? Jolly Roger <jollyroger@pobox.com> - 2014-12-19 00:55 +0000
        Re: A program to show all Mac Mail Rules? Gary <gary_w1@hotmail.com> - 2014-12-19 17:18 -0500
          Re: A program to show all Mac Mail Rules? Jolly Roger <jollyroger@pobox.com> - 2014-12-19 23:18 +0000
            Re: A program to show all Mac Mail Rules? Gary <gary_w1@hotmail.com> - 2014-12-19 21:03 -0500
              Re: A program to show all Mac Mail Rules? Jolly Roger <jollyroger@pobox.com> - 2014-12-20 03:31 +0000
                Re: A program to show all Mac Mail Rules? Gary <gary_w1@hotmail.com> - 2014-12-20 10:08 -0500
                  Re: A program to show all Mac Mail Rules? Jolly Roger <jollyroger@pobox.com> - 2014-12-20 21:18 +0000
                Att:Jolly Roger Re: A program to show all Mac Mail Rules? Gary <gary_w1@hotmail.com> - 2014-12-20 10:47 -0500
                  Re: Att:Jolly Roger Re: A program to show all Mac Mail Rules? Jolly Roger <jollyroger@pobox.com> - 2014-12-20 21:16 +0000
                    Re: Att:Jolly Roger Re: A program to show all Mac Mail Rules? Jolly Roger <jollyroger@pobox.com> - 2014-12-22 06:17 +0000
                    Re: Att:Jolly Roger Re: A program to show all Mac Mail Rules? Gary <gary_w1@hotmail.com> - 2014-12-22 16:16 -0500
                      Re: Att:Jolly Roger Re: A program to show all Mac Mail Rules? Jolly Roger <jollyroger@pobox.com> - 2014-12-22 22:35 +0000

#67718 — A program to show all Mac Mail Rules?

Does anyone know of either:

1- a program to show all the Mac Mail Rules in a report, or

2- a program to export all the Mac Mail Rules in spreadsheet format, 
that will allow importing into an Excel spreadsheet?

[toc] | [next] | [standalone]

#67720

On 2014-12-18 20:00:03 +0000, Gary said:

> Does anyone know of either:
> 
> 1- a program to show all the Mac Mail Rules in a report, or
> 
> 2- a program to export all the Mac Mail Rules in spreadsheet format, 
> that will allow importing into an Excel spreadsheet?

The rules are found in a plist file (in xml1 format, not binary on my 
computer) named "MessageRules.plist" found in the "MailData" folder 
inside the "V2" folder, inside the "Mail" folder, inside the "Library" 
folder of your home folder. And there are other files in there that are 
a part of the whole system, such as "RulesActiveState.plist"

So have a look at "~/Library/Mail/V2/Maildata/"

[toc] | [prev] | [next] | [standalone]

#67722

On 2014-12-18, Gary <gary_w1@hotmail.com> wrote:
> Does anyone know of either:
>
> 1- a program to show all the Mac Mail Rules in a report, or
>
> 2- a program to export all the Mac Mail Rules in spreadsheet format, 
> that will allow importing into an Excel spreadsheet?

You can certainly write a short AppleScript script to do it. Which
rule properties (columns) would you want in the spreadsheet?

-- 
E-mail sent to this address may be devoured by my ravenous SPAM filter.
I often ignore posts from Google. Use a real news client instead.

JR

[toc] | [prev] | [next] | [standalone]

#67724

On 2014-12-18, Jolly Roger <jollyroger@pobox.com> wrote:
> On 2014-12-18, Gary <gary_w1@hotmail.com> wrote:
>> Does anyone know of either:
>>
>> 1- a program to show all the Mac Mail Rules in a report, or
>>
>> 2- a program to export all the Mac Mail Rules in spreadsheet format, 
>> that will allow importing into an Excel spreadsheet?
>
> You can certainly write a short AppleScript script to do it. Which
> rule properties (columns) would you want in the spreadsheet?

This is rough, but will give you an idea of what I'm talking about.
Open this script in Script Editor and then run it, and you will end up
with a CSV file with the properties of each rule:

<http://jollyroger.kicks-ass.org/software/Export%20Mail%20Rules.zip>

Here's the source:

-- begin script
property exportFilename : "Mail Rules Export.csv"

property rEnabledLabel : "enabled"
property rDisabledLabel : "disabled"
property rAllConditionsOnLabel : "match all"
property rAllConditionsOffLabel : "match some"
property rDeleteOnLabel : "delete"
property rDeleteOffLabel : "do not delete"
property rFlagOnLabel : "flag"
property rFlagOffLabel : "none"
property rMarkReadOnLabel : "mark"
property rMarkReadOffLabel : "do not mark"

-- ask user to specify destination file

set destFile to choose file name with prompt "Export Mail rules to
file:" default name exportFilename default location (path to the desktop
folder)

-- export rules

tell application "Mail"
	try
		set fileRef to open for access destFile with write
permission
		if fileRef ≠ 0 then
			
			-- write column header row
			
			set nextRow to "\"name\",\"enabled\",\"match all
conditions\",\"delete\",\"forward message\",\"forward
recipients\",\"flag\",\"flag index\",\"mark
read\",\"sound\",\"redirect\",\"reply\",\"script\",\"copy to\",\"move
to\",\"color\",\"action\""
			
			write (nextRow & return as string) starting at 0
to fileRef
			
			-- write rule rows
			
			repeat with r from 1 to the count of every rule
				
				set nextRow to ""
				
				set nextRule to item r of (a reference
to every rule)
				
				set nextRow to nextRow & "\"" &
nextRule's name & "\","
				if nextRule's enabled then
					set nextRow to nextRow & "\"" &
rEnabledLabel & "\","
				else
					set nextRow to nextRow & "\"" &
rDisabledLabel & "\","
				end if
				if nextRule's all conditions must be met
then
					set nextRow to nextRow & "\"" &
rAllConditionsOnLabel & "\","
				else
					set nextRow to nextRow & "\"" &
rAllConditionsOffLabel & "\","
				end if
				if nextRule's delete message then
					set nextRow to nextRow & "\"" &
rDeleteOnLabel & "\","
				else
					set nextRow to nextRow & "\"" &
rDeleteOffLabel & "\","
				end if
				set nextRow to nextRow & "\"" &
nextRule's forward text & "\","
				set nextRow to nextRow & "\"" &
nextRule's forward message & "\","
				if nextRule's mark flagged then
					set nextRow to nextRow & "\"" &
rFlagOnLabel & "\","
					set nextRow to nextRow & "\"" &
nextRule's mark flag index & "\","
				else
					set nextRow to nextRow & "\"" &
rFlagOffLabel & "\","
					set nextRow to nextRow & "\"\","
				end if
				if nextRule's mark read then
					set nextRow to nextRow & "\"" &
rMarkReadOnLabel & "\","
				else
					set nextRow to nextRow & "\"" &
rMarkReadOffLabel & "\","
				end if
				set nextRow to nextRow & "\"" &
nextRule's play sound & "\","
				set nextRow to nextRow & "\"" &
nextRule's redirect message & "\","
				set nextRow to nextRow & "\"" &
nextRule's reply text & "\","
				set nextRow to nextRow & "\"" &
nextRule's run script & "\","
				if nextRule's should copy message then
					-- to do: tweak this code to get
the name of the "copy to" mailbox
					(*
				set destBox to nextRule's copy message
				set nextRow to nextRow & "\"" & name of
destBox & "\","
				*)
					set nextRow to nextRow &
"\"copy\","
				else
					set nextRow to nextRow & "\"\","
				end if
				if nextRule's should move message then
					-- to do: tweak this code to get
the name of the "move to" mailbox
					(*
				set destBox to nextRule's move message
				set nextRow to nextRow & "\"" & name of
destBox & "\","
				*)
					set nextRow to nextRow &
"\"move\","
				else
					set nextRow to nextRow & "\"\","
				end if
				if nextRule's highlight text using color
then
					set nextRow to (nextRow & "\"" &
nextRule's color message as string) & "\","
				else
					set nextRow to nextRow &
"\"none\","
				end if
				if nextRule's stop evaluating rules then
					set nextRow to nextRow &
"\"stop\""
				else
					set nextRow to nextRow &
"\"continue\""
				end if
				
				write (nextRow & return as string) to
fileRef
			end repeat
			
			-- close the file
			close access fileRef
		end if
		display alert "Finished Exporting" message "Exported
rules are in this CSV file:" & return & return & the POSIX path of
destFile
	on error
		beep
		-- close the file
		close access fileRef
	end try
end tell
-- end script

-- 
E-mail sent to this address may be devoured by my ravenous SPAM filter.
I often ignore posts from Google. Use a real news client instead.

JR

[toc] | [prev] | [next] | [standalone]

#67729

It worked very well.
A heroic attempt must have taken a few hours.
I was able to open it in Excel and sort on "name", which in my case 
corresponded to Mailbox 98% of the time.
I had many instances of rules like:

Name: Travel
If any of the following:
   From contained Vacations For All
   From contained Caribbean
   From contained Cruise Critic
Then Move to Mailbox Travel

I don't think the script picked up all the conditions properly, but 
just the sorting enabled me to consolidate my rules into one per 
resulting mailbox.

Thank you very much for your help.


On 2014-12-19 00:55:15 +0000, Jolly Roger said:

> On 2014-12-18, Jolly Roger <jollyroger@pobox.com> wrote:
>> On 2014-12-18, Gary <gary_w1@hotmail.com> wrote:
>>> Does anyone know of either:
>>> 
>>> 1- a program to show all the Mac Mail Rules in a report, or
>>> 
>>> 2- a program to export all the Mac Mail Rules in spreadsheet format,
>>> that will allow importing into an Excel spreadsheet?
>> 
>> You can certainly write a short AppleScript script to do it. Which
>> rule properties (columns) would you want in the spreadsheet?
> 
> This is rough, but will give you an idea of what I'm talking about.
> Open this script in Script Editor and then run it, and you will end up
> with a CSV file with the properties of each rule:
> 
> <http://jollyroger.kicks-ass.org/software/Export%20Mail%20Rules.zip>
> 
> Here's the source:
> 
> -- begin script
> property exportFilename : "Mail Rules Export.csv"
> 
> property rEnabledLabel : "enabled"
> property rDisabledLabel : "disabled"
> property rAllConditionsOnLabel : "match all"
> property rAllConditionsOffLabel : "match some"
> property rDeleteOnLabel : "delete"
> property rDeleteOffLabel : "do not delete"
> property rFlagOnLabel : "flag"
> property rFlagOffLabel : "none"
> property rMarkReadOnLabel : "mark"
> property rMarkReadOffLabel : "do not mark"
> 
> -- ask user to specify destination file
> 
> set destFile to choose file name with prompt "Export Mail rules to
> file:" default name exportFilename default location (path to the desktop
> folder)
> 
> -- export rules
> 
> tell application "Mail"
> 	try
> 		set fileRef to open for access destFile with write
> permission
> 		if fileRef ≠ 0 then
> 			
> 			-- write column header row
> 			
> 			set nextRow to "\"name\",\"enabled\",\"match all
> conditions\",\"delete\",\"forward message\",\"forward
> recipients\",\"flag\",\"flag index\",\"mark
> read\",\"sound\",\"redirect\",\"reply\",\"script\",\"copy to\",\"move
> to\",\"color\",\"action\""
> 			
> 			write (nextRow & return as string) starting at 0
> to fileRef
> 			
> 			-- write rule rows
> 			
> 			repeat with r from 1 to the count of every rule
> 				
> 				set nextRow to ""
> 				
> 				set nextRule to item r of (a reference
> to every rule)
> 				
> 				set nextRow to nextRow & "\"" &
> nextRule's name & "\","
> 				if nextRule's enabled then
> 					set nextRow to nextRow & "\"" &
> rEnabledLabel & "\","
> 				else
> 					set nextRow to nextRow & "\"" &
> rDisabledLabel & "\","
> 				end if
> 				if nextRule's all conditions must be met
> then
> 					set nextRow to nextRow & "\"" &
> rAllConditionsOnLabel & "\","
> 				else
> 					set nextRow to nextRow & "\"" &
> rAllConditionsOffLabel & "\","
> 				end if
> 				if nextRule's delete message then
> 					set nextRow to nextRow & "\"" &
> rDeleteOnLabel & "\","
> 				else
> 					set nextRow to nextRow & "\"" &
> rDeleteOffLabel & "\","
> 				end if
> 				set nextRow to nextRow & "\"" &
> nextRule's forward text & "\","
> 				set nextRow to nextRow & "\"" &
> nextRule's forward message & "\","
> 				if nextRule's mark flagged then
> 					set nextRow to nextRow & "\"" &
> rFlagOnLabel & "\","
> 					set nextRow to nextRow & "\"" &
> nextRule's mark flag index & "\","
> 				else
> 					set nextRow to nextRow & "\"" &
> rFlagOffLabel & "\","
> 					set nextRow to nextRow & "\"\","
> 				end if
> 				if nextRule's mark read then
> 					set nextRow to nextRow & "\"" &
> rMarkReadOnLabel & "\","
> 				else
> 					set nextRow to nextRow & "\"" &
> rMarkReadOffLabel & "\","
> 				end if
> 				set nextRow to nextRow & "\"" &
> nextRule's play sound & "\","
> 				set nextRow to nextRow & "\"" &
> nextRule's redirect message & "\","
> 				set nextRow to nextRow & "\"" &
> nextRule's reply text & "\","
> 				set nextRow to nextRow & "\"" &
> nextRule's run script & "\","
> 				if nextRule's should copy message then
> 					-- to do: tweak this code to get
> the name of the "copy to" mailbox
> 					(*
> 				set destBox to nextRule's copy message
> 				set nextRow to nextRow & "\"" & name of
> destBox & "\","
> 				*)
> 					set nextRow to nextRow &
> "\"copy\","
> 				else
> 					set nextRow to nextRow & "\"\","
> 				end if
> 				if nextRule's should move message then
> 					-- to do: tweak this code to get
> the name of the "move to" mailbox
> 					(*
> 				set destBox to nextRule's move message
> 				set nextRow to nextRow & "\"" & name of
> destBox & "\","
> 				*)
> 					set nextRow to nextRow &
> "\"move\","
> 				else
> 					set nextRow to nextRow & "\"\","
> 				end if
> 				if nextRule's highlight text using color
> then
> 					set nextRow to (nextRow & "\"" &
> nextRule's color message as string) & "\","
> 				else
> 					set nextRow to nextRow &
> "\"none\","
> 				end if
> 				if nextRule's stop evaluating rules then
> 					set nextRow to nextRow &
> "\"stop\""
> 				else
> 					set nextRow to nextRow &
> "\"continue\""
> 				end if
> 				
> 				write (nextRow & return as string) to
> fileRef
> 			end repeat
> 			
> 			-- close the file
> 			close access fileRef
> 		end if
> 		display alert "Finished Exporting" message "Exported
> rules are in this CSV file:" & return & return & the POSIX path of
> destFile
> 	on error
> 		beep
> 		-- close the file
> 		close access fileRef
> 	end try
> end tell
> -- end script

[toc] | [prev] | [next] | [standalone]

#67732

On 2014-12-19, Gary <gary_w1@hotmail.com> wrote:
> It worked very well.
> A heroic attempt must have taken a few hours.

Great! Nah, it took about half an hour.

> I was able to open it in Excel and sort on "name", which in my case 
> corresponded to Mailbox 98% of the time.
> I had many instances of rules like:
>
> Name: Travel
> If any of the following:
>    From contained Vacations For All
>    From contained Caribbean
>    From contained Cruise Critic
> Then Move to Mailbox Travel
>
> I don't think the script picked up all the conditions properly, but 
> just the sorting enabled me to consolidate my rules into one per 
> resulting mailbox.

Like I said the script is rough, and could be added to and improved. It
could be modified to output rule conditions, but how would you present
that in a tabular format? 

> Thank you very much for your help.

Any time. : )

-- 
E-mail sent to this address may be devoured by my ravenous SPAM filter.
I often ignore posts from Google. Use a real news client instead.

JR

[toc] | [prev] | [next] | [standalone]

#67737

On 2014-12-19 23:18:51 +0000, Jolly Roger said:

> On 2014-12-19, Gary <gary_w1@hotmail.com> wrote:
>> It worked very well.
>> A heroic attempt must have taken a few hours.
> 
> Great! Nah, it took about half an hour.
> 
>> I was able to open it in Excel and sort on "name", which in my case
>> corresponded to Mailbox 98% of the time.
>> I had many instances of rules like:
>> 
>> Name: Travel
>> If any of the following:
>> From contained Vacations For All
>> From contained Caribbean
>> From contained Cruise Critic
>> Then Move to Mailbox Travel
>> 
>> I don't think the script picked up all the conditions properly, but
>> just the sorting enabled me to consolidate my rules into one per
>> resulting mailbox.
> 
> Like I said the script is rough, and could be added to and improved. It
> could be modified to output rule conditions, but how would you present
> that in a tabular format?
> 
>> Thank you very much for your help.
> 
> Any time. : )

I may be looking at this with a brain limited to the reason I use rules 
(to move mail messages into mailboxes), but this may be the beginnings 
of an answer to your "tabular" question:

Name
Part
Condition
String
Action
Mailbox
Travel
From
contains
Vacations For All
Move
Travel

From
contains
Hilton
Move
Travel

From
contains
Embassy Suites
Move
Travel
Apple
From
contains
Apple
Move
Apple

Subject
contains
THELIST
Move
Apple
IBM
From
contains
IBM
Move
IBM

From
contains
ibmpension@yahoogroups.com
Move
IBM
Junk
Message is junk mail
-
-
Delete message

[toc] | [prev] | [next] | [standalone]

#67739

On 2014-12-20, Gary <gary_w1@hotmail.com> wrote:
>> 
>> Like I said the script is rough, and could be added to and improved. It
>> could be modified to output rule conditions, but how would you present
>> that in a tabular format?
>
> I may be looking at this with a brain limited to the reason I use rules 
> (to move mail messages into mailboxes), but this may be the beginnings 
> of an answer to your "tabular" question:

To illustrate the question: Take an empty spread sheet, and create named
columns for each of the rule properties you want to track. Now fill in a
row with sample data from one of your existing rules. Now do it again
for a different rule with a different set of conditions (preferably with
a different *number* of conditions). So you have a spreadsheet with a
set number of named columns, but you have rules with any number of
conditions. The best way to lay that out is unclear.

-- 
E-mail sent to this address may be devoured by my ravenous SPAM filter.
I often ignore posts from Google. Use a real news client instead.

JR

[toc] | [prev] | [next] | [standalone]

#67746

On 2014-12-20 03:31:05 +0000, Jolly Roger said:

> On 2014-12-20, Gary <gary_w1@hotmail.com> wrote:
>>> 
>>> Like I said the script is rough, and could be added to and improved. It
>>> could be modified to output rule conditions, but how would you present
>>> that in a tabular format?
>> 
>> I may be looking at this with a brain limited to the reason I use rules
>> (to move mail messages into mailboxes), but this may be the beginnings
>> of an answer to your "tabular" question:
> 
> To illustrate the question: Take an empty spread sheet, and create named
> columns for each of the rule properties you want to track. Now fill in a
> row with sample data from one of your existing rules. Now do it again
> for a different rule with a different set of conditions (preferably with
> a different *number* of conditions). So you have a spreadsheet with a
> set number of named columns, but you have rules with any number of
> conditions. The best way to lay that out is unclear.

I think I owe you an apology.  I actually constructed such a table, a 
2D matrix,
with the first row column headings 
1-Name,2-Part,3-Condition,4-String,5-Action,6-Mailbox.
(the numbers refer to column numbers)
For the second row, the entries were 
1-Travel,2-From,3-contains,4-Vacations For All,
5-Move,6-Travel.

I copied it (from a MS Word document) and pasted it into my previous
answer to you.  When it got processed and posted, the matrix disappeared and
all you saw were the cell entries, each on a separate line of the response.

So, translating the jibberish that went to you, the column names and second row
looked something like (ignore the dots; they're just to keep the 
columns lined up)"

Name.|.Part...|.Condition.|-String..................|.Action.|.Mailbox.|
Travel,|,From,|,contains..,|,Vacations.For.All.|.Move..|.Travel...|

I'll see if I can reconstruct the matrix (it was 10 lines) and find a 
way to present it,
maybe a fixed pitch font.

[toc] | [prev] | [next] | [standalone]

#67750

On 2014-12-20, Gary <gary_w1@hotmail.com> wrote:
>
> I think I owe you an apology.  I actually constructed such a table, a 
> 2D matrix,
> with the first row column headings 
> 1-Name,2-Part,3-Condition,4-String,5-Action,6-Mailbox.
> (the numbers refer to column numbers)
> For the second row, the entries were 
> 1-Travel,2-From,3-contains,4-Vacations For All,
> 5-Move,6-Travel.
>
> I copied it (from a MS Word document) and pasted it into my previous
> answer to you.  When it got processed and posted, the matrix disappeared and
> all you saw were the cell entries, each on a separate line of the response.

No problem. I figured as much. In the future you might want to consider
making an actual spreadsheet in Excel/Numbers/whatever, and then sending
the spreadsheet in an email (or posting a link to it in Dropbox or
whatever).

-- 
E-mail sent to this address may be devoured by my ravenous SPAM filter.
I often ignore posts from Google. Use a real news client instead.

JR

[toc] | [prev] | [next] | [standalone]

#67747 — Att:Jolly Roger Re: A program to show all Mac Mail Rules?

This is about the best I can do in providing a 2D matrix (5 columns)
that shows the parts of rules I would be interested in.  Clearly rules 
are much more sophisticated than my limited use of them.  But they 
still serve me quite well.

Description  Part      Condition String          Action  Mailbox
AAII         From      contains  AAII            Move    AAII
AAII         From      contains  aaii            Move    AAII
Ads1         From      contains  dealnews        Move    Ads
Ads1         From      contains  foxwoods        Move    Ads
Ads1         Subject   contains  Stew Leonard’s  Move    Ads
Apple        From      contains  AppShopper      Move    Apple
Apple        Subject   contains  THELIST         Move    Apple
Apple        From      contains  Apple           Move    Apple
Cryptos      Subject   contains  crypto          Move    Cryptos
Cryptos      Subject   contains  threadbender    Move    Cryptos
DeleteMsg    From      contains  templatezone    Delete
                                                  Message
DeleteMsg    From      contains  annoyance       Delete
                                                  Message
Facebook     From      contains  Facebook        Move    Face
                                                          Book
IBM          From      contains  ibm             Move    IBM
IBM          From      contains  ibmpension@     Move    IBM
Out          From      contains  Gary Lotto      Move    Out

[toc] | [prev] | [next] | [standalone]

#67749 — Re: Att:Jolly Roger Re: A program to show all Mac Mail Rules?

On 2014-12-20, Gary <gary_w1@hotmail.com> wrote:
> This is about the best I can do in providing a 2D matrix (5 columns)
> that shows the parts of rules I would be interested in.  Clearly rules 
> are much more sophisticated than my limited use of them.  But they 
> still serve me quite well.
>
> Description  Part      Condition String          Action  Mailbox
> AAII         From      contains  AAII            Move    AAII
> AAII         From      contains  aaii            Move    AAII
> Ads1         From      contains  dealnews        Move    Ads
> Ads1         From      contains  foxwoods        Move    Ads
> Ads1         Subject   contains  Stew Leonard’s  Move    Ads
> Apple        From      contains  AppShopper      Move    Apple
> Apple        Subject   contains  THELIST         Move    Apple
> Apple        From      contains  Apple           Move    Apple
> Cryptos      Subject   contains  crypto          Move    Cryptos
> Cryptos      Subject   contains  threadbender    Move    Cryptos
> DeleteMsg    From      contains  templatezone    Delete
>                                                   Message
> DeleteMsg    From      contains  annoyance       Delete
>                                                   Message
> Facebook     From      contains  Facebook        Move    Face
>                                                           Book
> IBM          From      contains  ibm             Move    IBM
> IBM          From      contains  ibmpension@     Move    IBM
> Out          From      contains  Gary Lotto      Move    Out

Okay, that's a spreadsheet containing only the conditions for one single
rule. What about all the other properties the script is already
outputting? Where do they go? Also, what about the other rules with
different conditions? If you have, say, twelve rules, each with a
completely different number and type of conditions, how will you present
that in a single spreadsheet? Or were you perhaps thinking that each
rule would have its own spreadsheet? Either way, you need to define it
before coding it. If you really want to understand the problem, do this
exercise: make a new spreadsheet to hold your rules, add a column for
each and every rule property you want to track, and then manually fill
it in with a couple different rules with a different set of conditions
for each rule. If you can show me what you want, I'll be happy to modify
the script accordingly for you. : )

-- 
E-mail sent to this address may be devoured by my ravenous SPAM filter.
I often ignore posts from Google. Use a real news client instead.

JR

[toc] | [prev] | [next] | [standalone]

#67752 — Re: Att:Jolly Roger Re: A program to show all Mac Mail Rules?

On 2014-12-20, Jolly Roger <jollyroger@pobox.com> wrote:
>
> Okay, that's a spreadsheet containing only the conditions for one single
> rule. What about all the other properties the script is already
> outputting? Where do they go? Also, what about the other rules with
> different conditions? If you have, say, twelve rules, each with a
> completely different number and type of conditions, how will you present
> that in a single spreadsheet? Or were you perhaps thinking that each
> rule would have its own spreadsheet? Either way, you need to define it
> before coding it. If you really want to understand the problem, do this
> exercise: make a new spreadsheet to hold your rules, add a column for
> each and every rule property you want to track, and then manually fill
> it in with a couple different rules with a different set of conditions
> for each rule. If you can show me what you want, I'll be happy to modify
> the script accordingly for you. : )

I had some time to think about this tonight and came up with one
potential solution. The modified script outputs one "All Rules" master
list containing a list of all rules and their properties except the
conditions. Then for each rule, the script creates another "Rule n
Conditions" file - one for each rule, containing a list of all
conditions for a given rule. So you end up with something like this:

All Rules.csv
Rule 1 Conditions.csv
Rule 2 Conditions.csv
Rule 3 Conditions.csv
Rule 4 Conditions.csv
Rule 5 Conditions.csv 
...and so on

<http://jollyroger.kicks-ass.org/software/Export%20Mail%20Rules.zip>

Enjoy. : )

-- 
E-mail sent to this address may be devoured by my ravenous SPAM filter.
I often ignore posts from Google. Use a real news client instead.

JR

[toc] | [prev] | [next] | [standalone]

#67758 — Re: Att:Jolly Roger Re: A program to show all Mac Mail Rules?

On 2014-12-20 21:16:17 +0000, Jolly Roger said:

> On 2014-12-20, Gary <gary_w1@hotmail.com> wrote:
>> This is about the best I can do in providing a 2D matrix (5 columns)
>> that shows the parts of rules I would be interested in.  Clearly rules
>> are much more sophisticated than my limited use of them.  But they
>> still serve me quite well.
>> 
>> Description  Part      Condition String          Action  Mailbox
>> AAII         From      contains  AAII            Move    AAII
>> AAII         From      contains  aaii            Move    AAII
>> Ads1         From      contains  dealnews        Move    Ads
>> Ads1         From      contains  foxwoods        Move    Ads
>> Ads1         Subject   contains  Stew Leonard’s  Move    Ads
>> Apple        From      contains  AppShopper      Move    Apple
>> Apple        Subject   contains  THELIST         Move    Apple
>> Apple        From      contains  Apple           Move    Apple
>> Cryptos      Subject   contains  crypto          Move    Cryptos
>> Cryptos      Subject   contains  threadbender    Move    Cryptos
>> DeleteMsg    From      contains  templatezone    Delete
>> Message
>> DeleteMsg    From      contains  annoyance       Delete
>> Message
>> Facebook     From      contains  Facebook        Move    Face
>> Book
>> IBM          From      contains  ibm             Move    IBM
>> IBM          From      contains  ibmpension@     Move    IBM
>> Out          From      contains  Gary Lotto      Move    Out
> 
> Okay, that's a spreadsheet containing only the conditions for one single
> rule. What about all the other properties the script is already
> outputting? Where do they go? Also, what about the other rules with
> different conditions? If you have, say, twelve rules, each with a
> completely different number and type of conditions, how will you present
> that in a single spreadsheet? Or were you perhaps thinking that each
> rule would have its own spreadsheet? Either way, you need to define it
> before coding it. If you really want to understand the problem, do this
> exercise: make a new spreadsheet to hold your rules, add a column for
> each and every rule property you want to track, and then manually fill
> it in with a couple different rules with a different set of conditions
> for each rule. If you can show me what you want, I'll be happy to modify
> the script accordingly for you. : )

I do not take advantage of all the features of rules.  However, one feature I
use extensively is saying "if ANY of the following conditions apply"; you will
see that technique implemented in my "spreadsheet" by giving a number of
rules the same column 1 Description.  Thus, for example, Rule "IBM" says

if any of the following apply
   From contains ibm
   From contains ibmpension
then move message to mailbox IBM.

I'm afraid I cannot address the rest of your excellent question, because it
assumes a level of usage I just don't perform.

BTW, I don't personally need you to do anything further with the script;
I used it and was able to sort the output in such a way as to be able to
modify all my rules efficiently; i.e., it already covered everything I used
rules for. 

[toc] | [prev] | [next] | [standalone]

#67759 — Re: Att:Jolly Roger Re: A program to show all Mac Mail Rules?

On 2014-12-22, Gary <gary_w1@hotmail.com> wrote:
> On 2014-12-20 21:16:17 +0000, Jolly Roger said:
>
>> Okay, that's a spreadsheet containing only the conditions for one single
>> rule. What about all the other properties the script is already
>> outputting? Where do they go? Also, what about the other rules with
>> different conditions? If you have, say, twelve rules, each with a
>> completely different number and type of conditions, how will you present
>> that in a single spreadsheet? Or were you perhaps thinking that each
>> rule would have its own spreadsheet? Either way, you need to define it
>> before coding it. If you really want to understand the problem, do this
>> exercise: make a new spreadsheet to hold your rules, add a column for
>> each and every rule property you want to track, and then manually fill
>> it in with a couple different rules with a different set of conditions
>> for each rule. If you can show me what you want, I'll be happy to modify
>> the script accordingly for you. : )
>
> I do not take advantage of all the features of rules.  However, one feature I
> use extensively is saying "if ANY of the following conditions apply"; you will
> see that technique implemented in my "spreadsheet" by giving a number of
> rules the same column 1 Description.  Thus, for example, Rule "IBM" says
>
> if any of the following apply
>    From contains ibm
>    From contains ibmpension
> then move message to mailbox IBM.
>
> I'm afraid I cannot address the rest of your excellent question, because it
> assumes a level of usage I just don't perform.

Actually, you *do* use conditions, which were absent from the output. I
guess I'm not explaining clearly enough. The problem I outlined is that
there's no clear way to show all rule properties *including* conditions
in a *single* spreadsheet. 

The next best thing is a set of spreadsheets. I spent about 45 minutes
revising the script so that it outputs conditions for each rule. Give it
a spin and you'll see what I mean:

<http://jollyroger.kicks-ass.org/software/Export%20Mail%20Rules.zip>

> BTW, I don't personally need you to do anything further with the script;
> I used it and was able to sort the output in such a way as to be able to
> modify all my rules efficiently; i.e., it already covered everything I used
> rules for. 

Too late! : D

-- 
E-mail sent to this address may be devoured by my ravenous SPAM filter.
I often ignore posts from Google. Use a real news client instead.

JR

[toc] | [prev] | [standalone]

Back to top | Article view | comp.sys.mac.system

csiph-web