Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [Solved] Loading Data From An Email Attachment
Go
New
Search
Notify
Tools
Reply
  
[Solved] Loading Data From An Email Attachment
 Login/Join
 
Master
posted
I'm knocking this around a couple of different ways, but the heart of what I'm dealing with is a need to load data from email attachments.

So I have Outlook 2016 receiving automated emails with file attachments containing the data I need.

What's the best way to get at the attachment? In theory Outlook can peel it off to a specific directory, but there are complications --

-- Outlook is a client tool that would presumably sit on an unattended machine, which I don't think will start up at reboot.

-- I need to be able to "Run a Script" in a rule. I think I can do that with a Registry edit, likely won't be popular with my client. Outlook doesn't allow you to run a script by default, out of security concerns.


Does I-Way/Data Migrator provide a direct connection to incoming emails with attachments? Or does it depend on another tool to serve up the attachment in a neater package? Sounds like it should be a master file of some sort if it can do it itself, but I haven't been able to find anything like that in the documentation or in the synonym builder.

This message has been edited. Last edited by: John_Edwards,



 
Posts: 944 | Location: At the Mast | Registered: May 17, 2007Reply With QuoteReport This Post
Master
posted Hide Post
By the way I'll mention that this is presumably an unmonitored machine. That is, this process would require that no one has logged onto the machine to start Outlook. The access to the email attachments would require that Outlook not be running on the machine. Is this in iWay's reach?



 
Posts: 944 | Location: At the Mast | Registered: May 17, 2007Reply With QuoteReport This Post
Guru
posted Hide Post
As you probably know DataMigrator has a File Listener that can process files as they appear in a directory or [S]FTP server. Is it possible to send files using something other than email?

Also why do you think Outlook is a requirement to read the incoming email messages? Couldn't any email client be used?

As it happens we have an email listener used for some internal processes. Although we haven't done so it is possible we could make a product out of it if we better understood your requirements.

What format are the attachments? csv or xlsx? Or are the docx, pdf, pptx? Assuming the former are they all in the same format? Same layout? Is it predefined? Is the target table predefined?

If this is something you want to pursue please open a case with hotline.
 
Posts: 389 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
Master
posted Hide Post
Yeah, email is a part of the requirements that I'm locked into. I'm interfacing with another product with very limited options.

I posted on an email gurus message board and got a product named Automatic Email Manager 7 that appears to provide a way to save email attachments to a folder. That is more or less the hard part of this solution, what remains is to hoover up that file and process it. Easy-peasy.

I thought I had heard that iWay could peel off email attachments, but at $200 for a perennial license on the product above I think it's definitely the way to go. It can interface with an Exchange server and can run as a Service on the platform, so I'm in a good place now.

Thanks for the response.

This message has been edited. Last edited by: John_Edwards,



 
Posts: 944 | Location: At the Mast | Registered: May 17, 2007Reply With QuoteReport This Post
Silver Member
posted Hide Post
Hi John,

I have implemented a solution using iWay SM listening to a Exchange Server using POP3. The attached csv files are saved separately and imported into the database for a later step.

If you are interested, I can show you some snapshot of my solution.

Cokey


iWay 5.5, 6.01
Windows
all output (Excel, HTML, PDF)
 
Posts: 45 | Registered: April 07, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [Solved] Loading Data From An Email Attachment

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.