Powerful Outlook Add-ins

Service Support Forum for DS Development Add-ins and Utilities
It is currently Wed Sep 18, 2019 2:09 pm

All times are UTC




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Technical Support
PostPosted: Fri Mar 26, 2004 7:37 pm 
Offline
Site Admin
User avatar

Joined: Thu Mar 25, 2004 1:52 pm
Posts: 669
Please use this topic to post your questions and potential problems with Email Address Collector.

Also, feel free to create new topics related to Email Address Collector.

Only registered users can post messages or new topics. Registration is free for everyone.



Top
 Profile  
Reply with quote  
 Post subject: Need Info Before I Buy
PostPosted: Mon Apr 04, 2005 4:14 pm 
Hi,

I just Googled "Microsoft DBX" and ended up visiting your
website. I need a product I can run from a command line that
will scan an OE 6.0 DBX file containing messages sent there
based upon a message rule I have defined. The emails are all
from PayPal and contain the string "Notification of Payment
Received" in the Subject line. From each of these emails, I
need to extract the "real" email address of the sender (i.e.
mailto:sender@somedomain.com), the PayPal Transaction ID which is a
17 character string following the string "Transaction ID:"
and the item ordered which will be an 11 character string
following the character string "Item Name:". I need these
items to be sent to a plain text file every 60 seconds which
will be read by another process I have running on the same
computer. If your product can run from a command line, I can
incorporate the command into my code and it will look
something like "EXTRACTOR c:\temp\orders.dbx" (assuming your
command line program is called EXTRACTOR and my file to read
is c:\temp\orders.dbx. The output file I need from your
program should look something like this:

Customer Email Address Transaction-ID Item Ordered
-------------------------------------------------------------
mailto:jimsmith@aol.com 12345678901234567 XYZ Reports
mailto:bobjones@hotmail.com 98765432109876543 ACB Reports
mailto:billharris@yahoo.com 111222345609DS764 WWW Reports

etc etc.

The date and time of the email would be nice too but not
really necessary since the PayPal transaction codes are
unique and after the automated emailing of the customer
reports, I will create a file named (i.e.
12345678901234567.TXT) which if found in your output file and
my hard drive, I will know the order was already processed
and a second email won't go out.

Can your program produce this or something similar?



Top
  
Reply with quote  
 Post subject:
PostPosted: Mon Apr 04, 2005 5:25 pm 
Offline
Site Admin
User avatar

Joined: Thu Mar 25, 2004 1:52 pm
Posts: 669
Email Address Collector can only extract email addresses and alias names from Outlook Express mailfolders. It doesn't "know" how to extract other data.

On the other hand, as far as I know, there is no commercial product on the web to fit your specific needs...

If you have scripting access to your mail server, a good solution would be to deploy a script (like a Perl script) on your mail server, in order to parse the emails and produce the required output. You can resend all those emails to a separate mailbox on your mail server and then the script will take over it. Depending on your server OS, you can schedule the script to run at some defined periods via cron (Linux) or Windows Task Manager.

It is really a 2-3 hours job for an average Perl or C programmer. Or you can search online script libraries (like hotscripts.com) for code samples.

I hope it helps,
Bogdan



Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group