6 Replies Latest reply: Jan 12, 2012 6:55 AM by Miguel Angel Baeyens de Arce RSS

    email

    Rajesh Vaswani

      Hi Community,

       

      I have one requirement where in a dashboard, for an filter condition I need to send email of one table box object result as a spreadsheet to the user. This has to be a scheduled activity. Could someone throw some light on this? What I could think about is Alerts and Macros.

       

      Thanks,

      Rajesh Vaswani

        • email
          Miguel Angel Baeyens de Arce

          Hi Rajesh,

           

          If your Server has Publisher license, you can create a new task and send an email when finished. But you can also use the code in this thread among many others to create a macro to send emails. You will need to add the attachment part to the macro with your file.

           

          You can create a new macro to export the chart to a xls or csv file and use it as the attachment.

           

          Hope that helps.

           

          Miguel

            • email
              Rajesh Vaswani

              Hi Migul,

               

              Thanks very much for your reply.

               

              If I create a macro inside the existing dashboard, how will i trigger this to send the email on scheduled basis.

               

              I ask this since I do not see any manual intervention here in achieving this.

               

              Thanks,

              Rajesh Vaswani

                • Re: email
                  Miguel Angel Baeyens de Arce

                  Hi Rajesh,


                  There are several things here. The macro will not trigger when the document is in the Server. What I would do is to create a trigger OnOpen or OnPostReload (Settings menu, Document Properties, Triggers, OnOpen, Add new action, External, Run Macro) and create a Windows Scheduler task to lauch a .BAT file similar to the following:

                   

                  "C:\ProgramFiles\QlikView\qv.exe" "C:\Folder\Document.qvw"
                  

                   

                  This will open the Document.qvw that will trigger the macro to send mail. You will need to allow system access in the Module Editor, on the right part.

                   

                  Hope that helps.

                   

                  Miguel

                    • email
                      Rajesh Vaswani

                      Hi Migul,

                       

                      You just answered what I had next in my mind. The reload wont fire the macro for me on the publisher thats correct. Currently we do have a different way we do that, we have the alert created that would get triggered during the reload. This would send a mail. Not sure if there is a way to send a attachment through the alert.

                       

                      Thanks,

                      Rajesh Vaswani

                        • email
                          Rajesh Vaswani

                          Hi Migul,

                           

                          The alert option which we have in Qlikview. When the alert is triggered could we have a macro run?

                           

                          This is when reload is triggered from publisher.

                           

                          Thanks,

                          Rajesh Vaswani

                          • Re: email
                            Miguel Angel Baeyens de Arce

                            Hi Rajesh,

                             

                            Glad to help. Unfortunately, there is no way to attach files to alerts so far, if you need to send the file in all cases, you will need to create a macro and use the Windows Scheduler or something, but not with QlikView.

                             

                            Regards.


                            Miguel

                             

                            EDIT: Well, you already have Publisher, that means that if you have the PDF license you can send by email a report with that object in PDF, or even a reduced QlikView document with only that object, which means that every recipient will need QlikView Desktop in their computers. Does that suit you?