topic Re: How to save Base64 from XML to file ? in Talend Studio

How to save Base64 from XML to file ?

Anonymous — Fri, 09 May 2014 16:04:28 GMT

Hi,
I'm new to Talend and i've been searching all over the net about how to iterate an XML and save bytes to file.
I still didn't manage to understand how to get it done.
I have the following XML:
<?xml version="1.0" encoding="UTF-8"?>
<root>
<row>
<actorid>1</actorid>
<name>AAA</name>
<pdf> SOME BASE64 STRING NEEDS TO BE CONVERTED TO BYTES AND SAVED TO FILE </pdf>
</row>
<row>
<actorid>2</actorid>
<name>BBB</name>
<pdf> SOME BASE64 STRING NEEDS TO BE CONVERTED TO BYTES AND SAVED TO FILE </pdf>
</row>
<row>
<actorid>3</actorid>
<name>CCC</name>
<pdf> SOME BASE64 STRING NEEDS TO BE CONVERTED TO BYTES AND SAVED TO FILE </pdf>
</row>
</root>
As I mentioned, I need to run over the XML --> convert each base64 string to bytes --> save it to file.
I do managed to read the input file and set a schema to it (You can see it in the attached image).
Any help ?

Re: How to save Base64 from XML to file ?

Anonymous — Sat, 10 May 2014 09:42:20 GMT

Any help ?

Re: How to save Base64 from XML to file ?

Anonymous — Sat, 10 May 2014 19:55:16 GMT

Hi,
If you search on the exchange platform (keyword: base64) you'll find a component and a routine collection which just might address your problem.
Good luck.

Re: How to save Base64 from XML to file ?

Anonymous — Sun, 11 May 2014 15:43:27 GMT

Hi,
1. What is "exchange platform" ?
2. Can you describe the message flow ? I'm very new to Talend and I can't figure out what should be the message flow.

Re: How to save Base64 from XML to file ?

Anonymous — Mon, 12 May 2014 09:29:18 GMT

Hi,
Talend Exchange Platform is the place where Talend community can share items related to Talend open source products.
Here is a custom component tBase64 which allows you to encode/decode distinctly each dataset columns by base64 scheme.
Best regards
Sabrina

Re: How to save Base64 from XML to file ?

Anonymous — Tue, 13 May 2014 07:03:47 GMT

@xdshi Thank you ! That really helps!
Just one more question:
How do I save each base64 to a file with custom file name convention ?
Thanks!

Re: How to save Base64 from XML to file ?

Anonymous — Tue, 13 May 2014 19:19:33 GMT

Still stuck.
Any help with saving multiple files with custom convention for each one ?

Re: How to save Base64 from XML to file ?

Anonymous — Mon, 21 Nov 2016 16:21:03 GMT

Did you ever solve your problem? I ran into the same issue.