<html><body><div style="font-family: arial, helvetica, sans-serif; font-size: 12pt; color: #000000"><div><br></div><div><br></div><hr id="zwchr" data-marker="__DIVIDER__"><div data-marker="__HEADERS__"><blockquote style="border-left: 2px solid #1010FF; margin-left: 5px; padding-left: 5px; color: #000; font-weight: normal; font-style: normal; text-decoration: none; font-family: Helvetica,Arial,sans-serif; font-size: 12pt;" data-mce-style="border-left: 2px solid #1010FF; margin-left: 5px; padding-left: 5px; color: #000; font-weight: normal; font-style: normal; text-decoration: none; font-family: Helvetica,Arial,sans-serif; font-size: 12pt;"><b>From: </b>"Steve Litt" <slitt@troubleshooters.com><br><b>To: </b>ale@ale.org<br><b>Sent: </b>Tuesday, January 3, 2017 7:05:41 PM<br><b>Subject: </b>Re: [ale] Fetchmail IMAP backup<br></blockquote></div><div data-marker="__QUOTED_TEXT__"><blockquote style="border-left: 2px solid #1010FF; margin-left: 5px; padding-left: 5px; color: #000; font-weight: normal; font-style: normal; text-decoration: none; font-family: Helvetica,Arial,sans-serif; font-size: 12pt;" data-mce-style="border-left: 2px solid #1010FF; margin-left: 5px; padding-left: 5px; color: #000; font-weight: normal; font-style: normal; text-decoration: none; font-family: Helvetica,Arial,sans-serif; font-size: 12pt;"><br>I'm not sure how procmail can use an external command to decide<br>something, but I bet it can, thereby accommodating your programming to<br>look in spreadsheets and the like.<br></blockquote><div><br></div><div>A rule like this</div><div>:0:</div><div>* YADA YADA</div><div>| ~/myprogram.pl</div><div><br data-mce-bogus="1"></div><div>YADA is search criteria if required.</div><div><br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div>So far I've got his working and I have it handling MIME Attachments. It keeps a track of all #s it sees in the email body and appends it to a file, named with the number, that is mbox format. I can use mutt to read that and see all history of that target.</div><div><br data-mce-bogus="1"></div><div>I ran into one issue where the history ended in 6/30/16, but I have it active till 6/30/17. After 15 minutes I found that info in a spreadsheet where they listed the #s, but the email body does not reference it.</div><div><br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div>I now need to parse the XLSX. I'll try DBD::Excel which allows me to loop through each cell without k knowing the schema.</div><div>I'll keep track of the #s found in that and append that email to mbox file described above.</div><div><br data-mce-bogus="1"></div><div>I have found some PDFs. I've parsed those in the past too. :)</div><div><br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div><br></div><div><br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div></div></div></body></html>