PNG to base64 string?

[madgpap]

Hi there, 

Is there a way to convert a PNG image in a KNIME table to base64 string?

 

Many thanks,

George

 

[christian.birkhold]

Hi George,

depending on your use-case also the "PNGs to Binary Objects" and "Binary Objects to PNGs" nodes might help. They are part of the "File Handling" Nodes which you can install via the KNIME Update-site.

Does this help? If not I will try to figure out how you can converts your PNGs to Base64 Strings (maybe JavaSnippet Node can help you).

 

Best,

Christian

 

[mwiegand]

Hi @christian.dietz,

I tried several options like:

• Converto to binary object > Java node convert binary array to base64
• Convert to binary object > Convert to string > Java node convert base64
• Save locally > read and convert via a Java node only

Unfortunately, I failed all the time. I’d really appreciate your advice as Java is totally new for me.

Thanks a lot
Mike

[mlauber71]

Have you tried to use an external tool like R? There was a discussion with an Excel file:

Base64 Decoder

OK now it does work. The R package can convert the original code.txt into an Excel file. output=the name and path of the Excel file file=the path and the original name of the file Since you mentioned that the base64 string can come via some stream I have loaded the content of the TXT file into knime and saved it again and converted it again to see if there is a way to do it without having an original TXT file. There should be a way to directly convert a block via R, but it is possible that t…

[Pierre_Ducrot]

Hi Mike, just wondering, did you eventually succeeded? I’m doing the same thing.
First converting PNG to binary, then encode the binary (InputStream format) with java snipped.

import java.util.Base64;
import java.io.*;

// system variables
public class JSnippet extends AbstractJSnippet {
// Fields for input columns
/** Input column: “Image” */
public InputStream c_Image;

// Fields for output columns
/** Output column: “Image_Base64” */
public String out_Base64;

// Your custom variables:

// expression start
public void snippet() throws TypeException, ColumnException, Abort {
// Enter your code here:

try {
int size = c_Image.available();
byte bytes = new byte[size];
c_Image.read(bytes);
out_Base64 = new String(Base64.getEncoder().encode(bytes));
}
catch(IOException ie) {
ie.printStackTrace();
}

Pierre

[mwiegand]

Hi Pierre,

yes, I did to some extend. Back then I did not further continued due to other priorities. I managed to add an image generated during the workflow as an attachment. Where I did not continued was about displaying it in the email as such.

Here are the results from back then:

Image as email attachment – mw

Best
Mike

[qqilihq]

fyi: There’s a Base64 encoder and decode node in newer versions of Palladian now:

Base64 Encoder — NodePit

Base64 Decoder — NodePit

–Philipp