Condition to check recipient email

[miredoju]

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

[alexpanjhc]

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?

[saimahasan]

Can you please elaborate and clarify your question a bit

[agomes1971]

Hi,

please see this

Email Address Validation | Qlik Community‌

HTH

André Gomes

[miredoju]

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

[miredoju]

Hi Alex,

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

For more Details see below ...

Michael

[miredoju]

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

[alexpanjhc]

Why not do C) in A)

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

[miredoju]

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

[alexpanjhc]

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.