topic Re: tfilecopy missunderstanding in Talend Studio

tfilecopy missunderstanding

phiibuntu — Sat, 16 Nov 2024 07:01:50 GMT

Hello,

I 'm making a job to copy and rename files. My tfilecopy seems to copy and correctly rename the files.

Sadly files are created with good name but they're empty.

Files are 0 ko in good destination repertory...

here's a screenshot of the job : no error ... I don't understand what I have missed.

Re: tfilecopy missunderstanding

Anonymous — Mon, 17 Dec 2018 10:59:33 GMT

Hi,

Could you please provide the component screen shot and the business user case so that we will get more idea about the task?

Warm Regards,
Nikhil Thampi

Please appreciate our members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: tfilecopy missunderstanding

vapukov — Mon, 17 Dec 2018 11:06:45 GMT

hi,

you need to provide more information - what in tMap? what settings for tFileCopy and etc

Re: tfilecopy missunderstanding

ankit7359 — Mon, 17 Dec 2018 11:14:04 GMT

hi @phiibuntu,

Greetings of the day,

i would like to repeat the same as @nthampi mentioned, once you specify or attach a component view of Tfilecopy then the Community will able to guide you from misunderstanding to proper understanding.

Well humor apart!!..Pls check the settings of the component whether you have given the correct source path(from where you must copy the file) and correct destination path(from where you are going to paste the file),

and if you want to rename the file then by specifying the name enclosed in double quotes.

Pls attach the screenshot of tfilecopy.

Thanks

Ankit

Re: tfilecopy missunderstanding

phiibuntu — Mon, 17 Dec 2018 12:08:48 GMT

the tFilecopy component screenshot :

the Tmap screenshot :

As you see the document_name come from inner join (mysql)

I need to copy file and change ID to document name in another repertory.

I hope I give you enough details.

My proble is that the document is not really copy with tfilecopy, only document name works with inner join from source file name to destination file name.

Re: tfilecopy missunderstanding

phiibuntu — Mon, 17 Dec 2018 12:10:19 GMT

and the TIteratetoflow screenshot in case...

Re: tfilecopy missunderstanding

Anonymous — Mon, 17 Dec 2018 12:13:15 GMT

Hi,

Could you please check whether you are giving the full path for the source to do copy? I believe you are populating only document name.

Warm Regards,
Nikhil Thampi

Please appreciate our members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: tfilecopy missunderstanding

vapukov — Mon, 17 Dec 2018 12:13:18 GMT

@phiibuntu wrote:

I hope I give you enough details.

of course - not 🙂

ok, we could guess - if join work - newColumns contain proper value (hope), but what about tFileCopy? is tFileCopy delete original file?

Re: tfilecopy missunderstanding

Anonymous — Mon, 17 Dec 2018 12:16:16 GMT

Hi,

Could you please select the check box for Fail on error?

Then it will show that your source path is not correct.

Warm Regards,
Nikhil Thampi

Please appreciate our members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: tfilecopy missunderstanding

phiibuntu — Mon, 17 Dec 2018 12:37:23 GMT

I think it is what I'm doing wrong.

in Tfilelist I give the full path for source file, but I don't know how can I do in Tmap to manage files.

I think tmpa I made only give document_name (file name) to Tfilcopy.
I hope I m clear with my bad english...

When I select the check box for Fail on error nothing more happens

Re: tfilecopy missunderstanding

phiibuntu — Mon, 17 Dec 2018 12:38:16 GMT

File copy don't, delete original file, for testing I don't think it was important, I only need copy and rename file not yet delete

Re: tfilecopy missunderstanding

Anonymous — Mon, 17 Dec 2018 12:40:11 GMT

Hi,

Please give full file path instead of file name from tFileList

((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))

This will help to get the source file properly.

If you are picking the file name from lookup flow only, then you will have to store the directory path also there.

Warm Regards,
Nikhil Thampi

Please appreciate our members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: tfilecopy missunderstanding

phiibuntu — Mon, 17 Dec 2018 12:54:57 GMT

if I put

"/home/phii/Documents/renommer" instead

((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))

no files match in Tmap (like Talend doesn't find file name from source repertory). so nothing happens in TFilecopy

Re: tfilecopy missunderstanding

Anonymous — Mon, 17 Dec 2018 13:03:27 GMT

Hi,

Why don't you give like below in your tfilecopy

"/home/phii/Documents/renommer/"+ok4.document_name

I am assuming that your source directory is constant. If it is different, then you will have to pass the full file path also as part of tFlowtoIterate as additional column and assign below value.

((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))

Warm Regards,
Nikhil Thampi

Please appreciate our members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: tfilecopy missunderstanding

phiibuntu — Mon, 17 Dec 2018 13:22:27 GMT

Sorry perhaps I don't have enough skill

If I use :

"/home/phii/Documents/renommer/"+ok4.document_name

I have this message :

The source File "/home/phii/Documents/renommer/AS_Metro_STRAS_FL_2017_10_23.pdf" does not exist or is not a file.

because in source repertory the file don't have the same name (I want to rename it with tmap inner join).

Re: tfilecopy missunderstanding

vapukov — Mon, 17 Dec 2018 13:29:08 GMT

you are swap source and target - this is why several time you was asked to attach screenshot of component, as suggested by @nthampi

source file -

((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))

target folder -

"/home/phii/Documents/renommer/"

target name:

ok4.document_name

Re: tfilecopy missunderstanding

Anonymous — Mon, 17 Dec 2018 13:29:36 GMT

Hi,

Don't worry. Lets go back to basics. Please try the below instructions.

Warm Regards,
Nikhil Thampi

Please appreciate our members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: tfilecopy missunderstanding

phiibuntu — Mon, 17 Dec 2018 13:35:02 GMT

I finally find solution with your help.

here's where I make mistake : I have to rename here the screenshot if someone have same lake of experience about Talend like me

Thank you for your help, I learn a lot about file management in Talend! )

Re: tfilecopy missunderstanding

phiibuntu — Mon, 17 Dec 2018 14:47:34 GMT

step by step...

Job works but files are limited to 20,1ko and are unreadable

file and name are ok but files content are corrupted...

If you have an Idea...

Re: tfilecopy missunderstanding

phiibuntu — Mon, 17 Dec 2018 14:54:51 GMT

I pull the files via ascii. Switched it to binary to fix the corrupted files.

ok it seems to work fine now