topic Re: Condition to check recipient email in Qlik NPrinting

Condition to check recipient email

miredoju — Tue, 06 Sep 2016 08:40:58 GMT

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

alexpanjhc — Tue, 06 Sep 2016 14:58:58 GMT

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

saimahasan — Tue, 06 Sep 2016 15:17:08 GMT

Can you please elaborate and clarify your question a bit

Re: Condition to check recipient email

agomes1971 — Tue, 06 Sep 2016 15:28:27 GMT

Hi,

please see this

Email Address Validation | Qlik Community‌

HTH

André Gomes

Re: Condition to check recipient email

miredoju — Tue, 06 Sep 2016 15:47:29 GMT

Hi,

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.

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

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

miredoju — Tue, 06 Sep 2016 15:53:23 GMT

Hi Alex,

thanks for answer - but we do not check manually the recipients.

For more Details see below ...

Michael

Re: Condition to check recipient email

miredoju — Tue, 06 Sep 2016 15:55:41 GMT

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

alexpanjhc — Tue, 06 Sep 2016 19:42:37 GMT

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

miredoju — Wed, 07 Sep 2016 04:58:00 GMT

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

alexpanjhc — Thu, 08 Sep 2016 13:41:36 GMT

I felt that checking the validity of the emails should be done outside of NPrinting. I think Qlikview maybe a good place to start. Yo can schedule the checking within Qlikview over night and then NPrinting can import that chart overnight. just my 2 cents.

Re: Condition to check recipient email

Anonymous — Fri, 09 Sep 2016 11:43:13 GMT

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

miredoju — Tue, 13 Sep 2016 14:10:10 GMT

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

Re: Condition to check recipient email

Anonymous — Wed, 14 Sep 2016 13:06:09 GMT

Hi, Michael,

Thanks for your reply.

Good that you figured out the way to test.

For import error problem I have, I later changed the "Import rule" from "All Recipients" to "Only New Recipients" in the import recipient task, and test run, then change it back, test run manually. Then run at first in the schedule. And it succeeded. Now the schedule run without error for last few days. That is really strange performance, but now it works.

Re: Condition to check recipient email

miredoju — Wed, 14 Sep 2016 15:21:48 GMT

Hi Zhihong,

thanks for this hind - it works for me too.

I do it the same way as you mentioned - tomorrow I will see if it works in batch too....

Michael