Posted by Jerry Stuckle on 09/23/07 01:22

Steve wrote:
> "Shelly" <sheldonlg.news@asap-consult.com> wrote in message
> news:13fb0rcom0qur6e@corp.supernews.com...
>> Here is a situation that I have to think out for a potential customer.
>> Currently he receives about 150 emails a day with pdf attachments for
>> orders. The format of the pdfs are all the same. Now he has to:
>>
>> 1 - look at his email
>> 2 - open the pdf
>> 3 - manually take the data from the pdf and enter it into an order
>> processing mode and a database.
>>
>> This is taking so much of his time that he is considering hiring someone
>> to do it.
>>
>> What I would like to be able to present him with is the following:
>>
>> 1 - Have all those emails go to a specified folder in his email
>> 2 - Without opening the email, upload the attachment to a server
>> 3 - Have an application that extracts the information from the pdf and
>> then does what it has to do.
>> 4 - Move the email to a second email folder (processed)
>>
>> I would like to have all this initiated with either a cron type job or via
>> a "Go" button.
>>
>> Short of this ideal, I would have him look at an email in his reader and
>> save the attachments to a directory. The "Go" button would upload button
>> would then do the rest.
>>
>> There are also other compromises I can and probably will have to make. I
>> posted the ideal.
>> The main point is to cut the hyman time down considerably.
>>
>> Any suggestions?
>
> what os is the mail server on, and would you have access to it? if it's a
> windows server, i'd use .net to tie into the onArrival (can't remember the
> exact name...but...) event. from there, you can parse it for either embedded
> content, or if it is a link, go out and grab it. if embedded, it's a snap to
> unencode it. if the os is *nix, it depends on the mail server, but usually
> it goes to file somewhere. a cron would work to scan for new messages and
> kick off the grabbing of the pdf.
>
>

On Unix systems you can usually pipe the incoming message to a script.
You can do it on many Windows servers, also.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]