topic Re: Data Source - Email File Attachments in Connectivity & Data Prep

Data Source - Email File Attachments

Anonymous — Thu, 26 May 2016 22:05:54 GMT

If your company is like mine, there is a lot of data floating around our enterprise environment in the form of excel and csv reports distributed automatically by email from source systems (example - daily receipt report from warehouse management system; on hand inventory report from ERP; etc).

It seems to me that this is a huge untapped resource - especially for reports sitting in my inbox from systems that are outside my company's environment where I don't have access to the databases.

While I've managed to come up with some MS Outlook macros to save attachments to folders on my Qlik Sense server, it isn't a good long term solution since it required me to have Outlook open and be on our network.

Is anyone aware of any solutions that could automate the solution? Needs to do the following:

Run on server
Store attachments into specific folders based on common rules (ie email sender, text in subject line)
Update the file name while storing

My thought is i could create a dummy email account to receive all these reports that would get routed to some kind of script that would perform the actions to download and store.

Any ideas?

Re: Data Source - Email File Attachments

agni_gold — Fri, 27 May 2016 10:55:29 GMT

Are you asking for QlikSense Server

Re: Data Source - Email File Attachments

Michael_Tarallo — Fri, 27 May 2016 13:04:48 GMT

Hello Pascal, stay tuned for NPrinting for Qlik Sense - coming soon.

Learn more here - (this is for QlikView, but will also be available for Qlik Sense soon)

Let me know if you have any questions.

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

Re: Data Source - Email File Attachments

Anonymous — Thu, 02 Jun 2016 21:33:24 GMT

Yes

Re: Data Source - Email File Attachments

Anonymous — Thu, 02 Jun 2016 21:38:13 GMT

Hi Michael.

I think nprinting is for sending reports by email ... I am looking for the opposite: systematically grabbing excel files sent as email attachments, putting them in a server folder so they can be used in an app via a Qlik Sense folder connection.

I don't I'm looking for a Qlik Solution here.