XML File to PDF

Five Stars

XML File to PDF

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,
Seventeen Stars

Re: XML File to PDF

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=t...
Twelve Stars

Re: XML File to PDF

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

Re: XML File to PDF

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,
Twelve Stars

Re: XML File to PDF

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

Re: XML File to PDF

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,