Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Automated process to place files in Qlikview Shared Folder?

Hi,

I have a requirement. Client is getting files from mails from 3rd parties and they would be placing the files in QV shared folder on daily basis. Kindly let me know what are different ways we can make it automated so that there is no manual intervention.

8 Replies
Employee
Employee

Re: Automated process to place files in Qlikview Shared Folder?

Hi,

You could create a application that will run and check to see if there are files in the folder. They will have to figure a way to get the files from email to the folder.

Bill

Re: Automated process to place files in Qlikview Shared Folder?

Send the emails-with-attachments to a special email address that operates some custom code to extract attachments and place them in a specific folder.

Now for the tricky part: at the moment the world still has lots of different mail server types in use, new, old and very old. What mail server software are you going to use for automatic attachment extraction?

Peter

Not applicable

Re: Automated process to place files in Qlikview Shared Folder?

Hi,

Thanks for your replies !!!

Would like to know various possibilities based on Qlikview best practice whether possible but on this front I am not sure to confirm. So,Would like to check with you all like ok, this is the way we can do automation

Re: Automated process to place files in Qlikview Shared Folder?

AFAIK QlikView offers no best practices for this kind of data preparation. Maybe someone else has already created an automated process to transfer/extract data files from containers.

If not, it's up to you to create a solution that fits your environment. I would be interested to hear what you solution looks like in the end.

Good luck,

Peter

MVP
MVP

Re: Automated process to place files in Qlikview Shared Folder?

The problem is related to your mail system and you may be better served Googling your question or finding a discussion forum for your mail system. Ask there how to automatically extract attachments and drop them somewhere for Qlikview to pick up.

Not applicable

Re: Automated process to place files in Qlikview Shared Folder?

May be I need to rephrase my question !!

So, Once the files are placed in a accessed QV shared path, we can setup in qlikview to pick the files automatically and also we can schedule the timings to pick the files from the QV shared folder..Right?

MVP
MVP

Re: Automated process to place files in Qlikview Shared Folder?

Well you would need to poll for the files to see when they arrive. You could use a file-watcher component (google to find one) to detect the file and trigger a batch job/publisher task, or you could simply trigger the batch job/publisher task periodically (say once per hour) to process any file(s) that arrive(s).

Not applicable

Re: Automated process to place files in Qlikview Shared Folder?

Hi,

Thanks for your reply !!!

Will try to analyze with the above methods and update here the results

Community Browser