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.
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.
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?
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
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.
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.
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?
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).