topic [resolved] HOW TO - tFileOutputDelimited Configuration in Talend Studio

[resolved] HOW TO - tFileOutputDelimited Configuration

Anonymous — Wed, 14 Jan 2015 16:11:16 GMT

Hi all,
I have a tFileOutputDelimited component in my Job,
so in the "Basic settings" windows; like file name,
i put "C:/TalendFtpToCustomerFtp/Comgest/DonneesPermanentes_CSA"+"_"+TalendDate.getDate("YYYY-MM-DD")+".csv"
And everything work right, but i put the same name in a context and i get this error

Démarrage du job ComgestPermData a 16:59 14/01/2015.
connecting to socket on port 3903
connected
Exception in component tFileOutputDelimited_2
java.io.FileNotFoundException: C:\TalendFtpToCustomerFtp\Comgest\DonneesPermanentes_CSA"+"_"+TalendDate.getDate("YYYY-MM-DD")+".csv (La syntaxe du nom de fichier, de répertoire ou de volume est incorrecte)
at java.io.FileOutputStream.open(Native Method)
at java.io.FileOutputStream.<init>(FileOutputStream.java:221)
at java.io.FileOutputStream.<init>(FileOutputStream.java:142)
at myspherescustomerdelivery.comgestpermdata_0_1.ComgestPermData.tFileInputDelimited_2Process(ComgestPermData.java:7621)
at myspherescustomerdelivery.comgestpermdata_0_1.ComgestPermData.tFileList_1Process(ComgestPermData.java:1345)
at myspherescustomerdelivery.comgestpermdata_0_1.ComgestPermData.tFTPGet_1Process(ComgestPermData.java:1158)
at myspherescustomerdelivery.comgestpermdata_0_1.ComgestPermData.tFTPConnection_1Process(ComgestPermData.java:823)
at myspherescustomerdelivery.comgestpermdata_0_1.ComgestPermData.runJobInTOS(ComgestPermData.java:12561)
at myspherescustomerdelivery.comgestpermdata_0_1.ComgestPermData.main(ComgestPermData.java:12319)
disconnected
Job ComgestPermData terminé à 16:59 14/01/2015.

May somebody help me please?
And i want to precise that i have also test this way like name:
""C:/TalendFtpToCustomerFtp/Comgest/DonneesPermanentes_CSA"+"_"+TalendDate.getDate("YYYY-MM-DD")+".csv""

Thanks you,

Re: [resolved] HOW TO - tFileOutputDelimited Configuration

Anonymous — Thu, 15 Jan 2015 06:15:16 GMT

Hi,
You can set directory C:/TalendFtpToCustomerFtp/Comgest/DonneesPermanentes_CSA as Context value.
Such as: context.path+"/"+TalendDate.getDate("yyyyMMddHHmmssSSSSSS")+".csv". Feel free to let us know if it is Ok with you.
Best regards
Sabrina

Re: [resolved] HOW TO - tFileOutputDelimited Configuration

Anonymous — Thu, 15 Jan 2015 09:44:42 GMT

Hi,
Yes it works, but this change the name of my file. i want to get like name:
DonneesPermanentes_CSA_20150120.csv
Thanks,

Re: [resolved] HOW TO - tFileOutputDelimited Configuration

Anonymous — Thu, 15 Jan 2015 13:24:21 GMT

Well, you have to do what xdshi said, but just a little bit different :

context.path+"_"+TalendDate.getDate("YYYYMMDD")+".csv"

Code tested, working fine.

Re: [resolved] HOW TO - tFileOutputDelimited Configuration

Anonymous — Fri, 16 Jan 2015 08:37:36 GMT

Hi all,
Yes everything work fine.
Thanks you very much.