Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to know if it is possible to distribute a daily csv file using nprinting? Im storing these csv files straight from the script in my .qvw and also applying filters here at the same time.
So i have stored and want to distribute them daily using nprinting.
file1.csv to:client1@gmail.com, filter: client1
file2.csv to:client2@gmail.com, filter: client2
file3.csv to:client3@gmail.com, filter: client3
Anyone got any ideas?
Niklas,
NPrinting can easily do this provided that the CSV file is built from a single QlikView chart.
Here are some tutorials you may find helpful:
How to Export QlikView Objects to CSV files
How to Distribute User Specific QlikView Reports by E-mail
How to Create and Import Recipients with Filters and Distribution Groups
Niklas,
NPrinting can easily do this provided that the CSV file is built from a single QlikView chart.
Here are some tutorials you may find helpful:
How to Export QlikView Objects to CSV files
How to Distribute User Specific QlikView Reports by E-mail
How to Create and Import Recipients with Filters and Distribution Groups
I see. Thing is that I generate and store the CSV file right in the script.
//N
The only data source for Nprinting is a QVW and its objects. Aran's solution is pretty easy.
Niklas,
What you want to do is possible, but more complex if you want to generate csv files and then have NPrinting just take care of delivery. I would consider the solution below a workaround and there are a few assumptions:
1) Each CSV file is already filtered in the appropriate way for a specific client
2) Each CSV file is saved to a different directory or is named in a different way from every other csv file
3) The CSV files are always saved to the same location and always have the same name each time they are built
If all of the above conditions are true, then you could build a Report Task for each client and simply attach that client's csv file to the email for their Task. The hard part is that if there are say 500 clients, then you'd have to manually build 500 Report Tasks and you would have to maintain these Tasks (adding a new client = adding a new Task...)
With my original solution, maintenance can be easily automated assuming you have a way of associating the Client with their email address and the field name(s) and value(s) on which you want to filter for that specific client.
Best
Aran
Yeah
I have decalred a variable to today() and add that to the file_name i'm supposed to send one file per day. So I guess I fulfill the conditions you mentioned above.