13 Replies Latest reply: Sep 14, 2016 11:21 AM by Michael Wenning RSS

    Condition to check recipient email

    Michael Wenning

      Hi,

       

      for testings we load a dummy email into all recipients - for production send out we load the real user email.

       

      Sometimes Task to Import test emails runs into Connection Errors or something else - so email will not be updated with test-mail.

       

      Question:

      I would like to check before send out if there is a Special test-mail for each recipient maintained - how can I do that ?

       

      I tried to use Report condition - but I didn´t find any field relation to recipients...only variable or Chart.......

       

      Thanks

      Michael

        • Re: Condition to check recipient email
          Alex Pan

          I am not completely sure your questions but let me try:

          1 You can sort the recipients by emails and you can find out who has the test emails? How about delete all the recipients and load again?

          2 Maybe you want to try filters rather than condition?

          • Re: Condition to check recipient email
            saima siddiqui

            Can you please elaborate and clarify your question a bit

              • Re: Condition to check recipient email
                Michael Wenning

                Hi,

                 

                A)

                we load email, filter, tags, ... for recipients from Recipient.qvw via Nprinting "Recipient Import Task" - email field will be filled with a testing@mail.com adress.

                 

                B)

                Task creates reports for this recipients (they have different filters, tags, etc .... only the email is the same for all)

                Task send it all to testing@mail.com

                 

                Then we do some checks if reports are ok - if OK we goto C)

                 

                Note: This Report is based on Report.qvw (there is no relationship to Recipient.qvw which we used for Import recipients).

                 

                C)

                We start manually the next Task in Nprinting - this Task do the same as A) only the email will be maintained now with the real email of the recipients.

                 

                Send out emails...FINISHED

                 

                Next Day - a Job Run TASK A) again to maintain all recipients to testing@mail.com

                 

                Run B) do some Tests , .....

                 

                Problem:

                Yesterday Task A) doesn`t run (because of Response time from Server or any other issue) - so all recipients has the real email

                 

                Next Task run (I don't know how to say Nprinting to stop if Task before does not end without ERROR)

                send out to real recipients (instead of testing@mail.com)

                 

                Thats why we would like to check for every Mailing

                 

                "Is email <> testing@mail.com than do not send email automatically"

                 

                Thanks

                Michael

                  • Re: Condition to check recipient email
                    Alex Pan

                    Why not do C) in A)

                    if some of the recipients you do not want to send out emails, then do not load them.

                      • Re: Condition to check recipient email
                        Michael Wenning

                        We would not do it manually - in the end we also would not do C) manually.

                         

                        It's only for a testing Phase because of trouble currently with our scheduler.

                         

                        Ok I have to Change the repipients Import from test to real email (but this is only a change in nprinting for 2 Tasks test recipients to real recipient Import task).

                         

                        But then we do not load recipients manually - this will be over night by a Job.

                         

                        So we can not check if recipients are imported correctly manually - in nprinting we need a possibility to check recipient email ....

                  • Re: Condition to check recipient email
                    André Gomes

                    Hi,

                     

                    please see this

                     

                    Email Address Validation | Qlik Community

                     

                    HTH

                     

                    André Gomes

                      • Re: Condition to check recipient email
                        Michael Wenning

                        Hi,

                        I would not check if email is valid - I Need a condition or something else to check which email adress is maintained for recipient.

                         

                        Michael

                          • Re: Condition to check recipient email
                            Zhihong He

                            Hi, Michael,

                             

                            As you noticed, Nprinting will not stop the rest tasks in a schedule if one fails.

                            As the process  A, B and C is not your real use case. And your purpose for the process A and B is to check the update of the setting (filters, tag) in recipients. So a work around is to create a test schedules with test task A and B. And then manually run the real process A and B. In the test process A and B, use test recipient names and testing@mail.com.


                            And for the failure of process A, import the recipient. Seems it successfully run sometime, right? But in your setting, it fail the other times. Do you already figure out the reason?

                            I recently have a requirement to get the recipients from a "import recipient task" from a .qvw file as well, and it never success when it runs FIRST or independently  in a schedule. And I get no error when run it manually.  Do you have some special setting when create this recipient import task? I follow the method here to set the import recipient task,  except that I use Group to group the recipients. 


                            Zhihong

                              • Re: Condition to check recipient email
                                Michael Wenning

                                Hi Zhihong,

                                 

                                thats exactly what I do - I load with a testtask all recipients with testing mail address - check logfile - edit each recipients with error "field x not found" - load real mail address and send out manually.

                                 

                                We have created a ticket at qliktech Support - I hope they find my error.....

                                 

                                For nprinting it´s not an error only a message that "field xxx not exists".

                                 

                                I do it in the same way as shown in your link ( I load also PrivateFilter otherwise I have 500 filters in filter list ;-( )

                                 

                                Michael