topic Image email body in Qlik NPrinting

Image email body

jsobrinho — Wed, 08 Apr 2020 05:55:39 GMT

Hi guys,

I would like, insert an image (logo) in my NPrinting email body to create a template, when I try to insert the image the pop-up, a URL is requested to the image.
What is the idea and how to create this?

Re: Image email body

Lech_Miszkiewicz — Fri, 10 May 2019 10:55:52 GMT

you have 3 options:

1 - you can provide image url - in other words have an image hosted somewhere (for example on Qlik Sense server content library and provide url to it)
2 - you can embed image in HTML based report and use html report as email content
3 - my favourite - use "base64" image encryption and embed image as a html code directly in email. For this you need to toggle to HTML view (instead of rich text to be able to paste base 64 code into mail content (see screenshot and also see this as an example: https://www.base64-image.de/)

I am actually just writing blog about this exact topic and will comment here once it is finished.

cheers

Lech

Re: Image email body

jsobrinho — Fri, 10 May 2019 12:41:35 GMT

First of all, thank you for your answer

I created an email body, and I edit in TEXT format, to image base64 (this image is in desktop Npriting server), In NPriting e-mail view is possible to see the image it's OK, but when I send an e-mail the image not show.

Re: Image email body

Ruggero_Piccoli — Fri, 10 May 2019 13:17:20 GMT

Hi,

It could be something related with the email client you are using to open the email. Please try with different clients or with an online service that simulate them.

Best Regards,

Ruggero

Re: Image email body

jsobrinho — Fri, 10 May 2019 13:57:34 GMT

I tried to with gmail, its the same error, only a blank space

Re: Image email body

Ruggero_Piccoli — Fri, 10 May 2019 14:48:51 GMT

Hi,

Could you try also suggestions number 1 and 2 supplied by @Lech_Miszkiewicz ?

Re: Image email body

jsobrinho — Fri, 10 May 2019 15:35:20 GMT

I tried now create by embedding HTML, I create 3 images in my qvw file, this image is about the body in emails like a logo and border, ok the images its showing now, but I need to show the User Name in the message, and I have as result in %%User_FullName%% ....

How can I have the message by the user and the logos in the report by embed HTML?

Re: Image email body

Lech_Miszkiewicz — Sat, 11 May 2019 00:54:06 GMT

You did something wrong. There should not be an error about a link as you are not even generating link. You should be providing very long hashed code inline your html.

It is difficult to troubleshoot this as it is purely linked to the fact that you doing something wrong.

All 3 options I mentioned i use in my clients deployments and they all work succesfully. I said i liked the 3rd one the most because it allows me to send emails to any device, embed images and also keep imagase transparency if required.

I use base64 method also to embed images in html templates for the same reason.

See attached to this post short clip showing all steps of how i do it

Cheers

Re: Image email body

jsobrinho — Mon, 13 May 2019 09:00:19 GMT

@Lech_Miszkiewicz

Does my image need to be in a specific location? my images are in the desktp of the server NPrinting server, and I am generating the images in base64 on that server and the image still does not appear.

Re: Image email body

Lech_Miszkiewicz — Mon, 13 May 2019 09:25:04 GMT

are you using NPrinting Feb 2019 or April 2019? I cannot tell anything about previous versions as i dont stay on old ones for longer than a month after new version comes out.

It does not matter where you generate your base64 code from as at the end you are not referencing anything and you are just including image directly in html as a code.

if you still cannot get it working by following my exact steps i suggest you start talking to your smtp server admin and try inspecting if maybe some packets are dropped when sent via your smtp server.

you also should inspect html code generated in this email.

sorry mate, but i will not be able to help you more than i did as it is specific to your environment!

Re: Image email body

jsobrinho — Mon, 13 May 2019 09:46:12 GMT

I really appreciate your information.

My version is Feb 2019

Anyway, I have a question, when I insert the image through the report embed it is displayed in the email, is there any relation between these two ways of inserting the image?

Thank you one more time.

Re: Image email body

jsobrinho — Fri, 24 May 2019 09:10:54 GMT

@Lech_Miszkiewicz

When I put an image in .png my e-mail in the web browser (outlook office 365) show the image, but when I access the outlook from the desktop it's not showing.

Maybe I need to send an image as attached? this is possible?

Re: Image email body

Ruggero_Piccoli — Mon, 27 May 2019 10:00:36 GMT

Hi,

This is the email client behaviour. It depends also on the settings of the email client.

You could try to add the image as attachment or to embed an HTML report with the image.

There are also some online services that let you to simulate how an email will be rendered.

Best Regards,

Ruggero

Re: Image email body

jsobrinho — Fri, 31 May 2019 09:04:31 GMT

Hi @Ruggero_Piccoli ,

Yes, I understand you, I imagined this > You could try to add the image as an attachment, but I don't know how to do this? How can I do this in NPrinting? Could you please help me?

I created more three reports in HTML and use the embed HTML report, but I think it's not good.

Re: Image email body

Ruggero_Piccoli — Fri, 31 May 2019 10:56:36 GMT

Hi,

QlikEntity reports can be exported as images https://help.qlik.com/en-US/nprinting/April2019/Content/NPrinting/DistributionSchedulesAutomation/Report-output-formats.htm. So you could attach them.

In the past, in some specific cases, I was able to solve by adding custom html code in the template. So you could also search if there is a similar solution for your specific email client.

Best Regards,

Ruggero

Re: Image email body

jsobrinho — Fri, 31 May 2019 12:41:01 GMT

Thank you, I already did this,

- I create three more reports (1 with logo, 2 with border1 and 3 with border 3)

- In the email body, I inserted this embedded, this is attached?

But I would like another way, cleaner, just putting the URL, but in outlook desktop isn't working.

There is another way?

Re: Image email body

Lech_Miszkiewicz — Fri, 31 May 2019 13:23:50 GMT

I wonder why it is not working for you. It seems like you have used unsupported html code or did not consider mail client limitations.

can you share here your html code?

have you used any <SCRIPT> tags in your HTML report?

Re: Image email body

jsobrinho — Fri, 31 May 2019 14:49:54 GMT

I attached the file Email2.txt here.

I just change the text but the structure of HTML is the same.

First picture: Email using outlook desktop, second one outlook web

Re: Image email body

sqlsociety — Wed, 06 Nov 2019 14:22:37 GMT

I am also experience the same issue. I have tried the suggestions above but still get the error below. Any other ways i can fix this issue

Re: Image email body

Frank_S — Wed, 06 Nov 2019 17:37:36 GMT

Hello all! (Updated)

Please note that I have tested this functionality and it works as designed.

Note that you must use a valid URL which hosts the image you are trying to use with your report.

For example:

https://qlik--c.um1.content.force.com/servlet/servlet.ImageServer?id=0153z0000019KSqAAM&oid=00D20000000IGPXEA4

You must use the "Image" tool for this to work successfully (as shown below).

Also some systems may block images so you need to be mindful of that.

https://help.qlik.com/en-US/nprinting/September2019/Content/NPrinting/DistributionSchedulesAutomation/DistributingReportsbyEmail.htm#anchor-4

It is not possible to upload an image into the report message...only http is possible.

Kind regards...