topic Re: XML File to PDF in Talend Studio

XML File to PDF

Anonymous — Sat, 16 Nov 2024 10:07:10 GMT

Morning All,
I have a XML file that i generate from a csv file
Now from this XML file, i want to get a pdf file with a beautiful format like a cv.
So i try to use component tXLST with a xls file to create this pdf.
But pdf generate with tXLST component is not good.
So May somebody tell me how to solve this problem by advice me a good proccess please
Thanks,

Re: XML File to PDF

Anonymous — Thu, 26 Jan 2017 21:25:52 GMT

You can play with xslt but for me this is wasting time. I suggest using a tool like JasperReport designer to design a very nice looking report based on the data in your XML file. If you want to automate the processing of such a report you can use the component tJasperReportExec from talend exchange:
https://exchange.talend.com/#marketplacesearch:gallery=marketplace%252F1&ob=releaseDate&o=0&c=20&d=true&s=tJasperReportExec&f=&tf=&bf=&cat=&title=Search%2520Results

Re: XML File to PDF

vapukov — Thu, 26 Jan 2017 23:47:53 GMT

Just to confirm - reports best to do in reports tools!
JasperReport - it very for this. As Ian suggest - look for his components, work perfect!

Re: XML File to PDF

Anonymous — Fri, 17 Feb 2017 14:12:33 GMT

Hi,
Thank you very much for your advice, it is the best way.
1st Step
My Job looks like bellow

When i run it, i get the run failure bellow, i don't know exactly why?
But i mean, it is because i designed report with Jasper Studio
Exception in component tJasperOutput_1
java.io.IOException: Le chemin d’accès spécifié est introuvable
at java.io.WinNTFileSystem.createFileExclusively(Native Method)
at java.io.File.createNewFile(Unknown Source)
at myspheres.test_0_1.Test.tFileInputDelimited_4Process(Test.java:745)
at myspheres.test_0_1.Test.runJobInTOS(Test.java:1741)
at myspheres.test_0_1.Test.main(Test.java:1437)
: myspheres.test_0_1.Test - tJasperOutput_1 Le chemin d’accès spécifié est introuvable
May somebody tell me why i get this bug?
2nd Step
FYI : jlolling
I try tJasperReportExec component,
But like you can note it, my data source is a csv file so impossible to connect it to this component
To find a work around solution, i create a new table in my data base
But what worries me, is to know how to config tJasperReportExec component, to pointer on new table.
Thank all for help,

Re: XML File to PDF

vapukov — Fri, 17 Feb 2017 23:26:54 GMT

Hi,
Thank you very much for your advice, it is the best way.

2nd Step
FYI : jlolling
I try tJasperReportExec component,
But like you can note it, my data source is a csv file so impossible to connect it to this component
To find a work around solution, i create a new table in my data base
But what worries me, is to know how to config tJasperReportExec component, to pointer on new table.
Thank all for help,

for work tJasperReportExec need have installed Jasper Report Server, and JRS could be connected for any (mostly) datasources
So Job could be look like:
1) define datasource in Jasper Server - for csv it is format AND path
2) Create report in Studio and upload report to Server
3) By Talend (or not) - upload file to proper folder (defined in 1)
4) call Report from JRS for execution

About step 1 - it mean java could not create file, for example - wrong folder ...

Re: XML File to PDF

Anonymous — Mon, 20 Feb 2017 09:21:36 GMT

Dear all,

vapukov wrote,
for work tJasperReportExec need have installed Jasper Report Server, and JRS could be connected for any (mostly) datasources
So Job could be look like

But on exchange, this is the givn explaination for the usecase of component tJasperReportExec
"This component can use a local jrxml file and compiles, fills and exports the report in a Talend job without a JasperServer.
It detect the need of compiling the report as well as subreports. "
So i am confused, may you give an exemple or more details
Thanks,