Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Sept. 16, Qlik Product Portfolio Strategy and Roadmap for Data Integration 11 AM ET REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prassinoux
Contributor II
Contributor II

Data Source - Email File Attachments

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?

4 Replies
agni_gold
Specialist III
Specialist III

Are you asking for QlikSense Server

Michael_Tarallo
Employee
Employee

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

Regards,
Mike Tarallo
Qlik
prassinoux
Contributor II
Contributor II
Author

Yes

prassinoux
Contributor II
Contributor II
Author

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.