topic Re: how to create new folder from tfileoutputdelimiter component ??/ in Talend Studio

how to create new folder from tfileoutputdelimiter component ??/

amit_n — Sat, 16 Nov 2024 07:53:58 GMT

i have to create the folder in tfileoutputdelimiter and then create csv file in that folder.

example:

tfileoutputdelimiter:

filename path :

context.tmp_folder+"/new_folder/"+context.filename

1. context.tmp_folder is having path

2. new_folder needs to create after tmp_folder path

3. context.filename is having csv file name

here ia m not able to create new folder as above format?

please let me know how to proceed..

Re: how to create new folder from tfileoutputdelimiter component ??/

iamabhishek — Wed, 25 Jul 2018 16:32:51 GMT

Have you selected the option - "Create directory if doesn't exists" under the Advanced settings.

Re: how to create new folder from tfileoutputdelimiter component ??/

amit_n — Wed, 25 Jul 2018 17:23:13 GMT

i have checked this option ..but also folder is not created.

Re: how to create new folder from tfileoutputdelimiter component ??/

vboppudi — Wed, 25 Jul 2018 17:42:29 GMT

Are you getting any error?

Regards,

Re: how to create new folder from tfileoutputdelimiter component ??/

amit_n — Wed, 25 Jul 2018 17:49:44 GMT

yes,m getting the below error.

java.io.FileNotFoundException: D:\tmp_path\new_folder\filename_error.csv (The system cannot find the path specified)

Re: how to create new folder from tfileoutputdelimiter component ??/

vboppudi — Wed, 25 Jul 2018 17:54:05 GMT

If you are running talend on windows try the below

in Context variable for Folder path use forward slash "/" instead of "\".

Regards,

Re: how to create new folder from tfileoutputdelimiter component ??/

iamabhishek — Wed, 25 Jul 2018 18:05:32 GMT

Tried to re-pro your use case but didn't find any such error occurrence. Would it be possible if you could show the job layout and the configuration for your tFileOutputDelimited.

Re: how to create new folder from tfileoutputdelimiter component ??/

amit_n — Wed, 25 Jul 2018 18:11:04 GMT

tmp_data path is taking from property file. +

newfoldershould create +

context.filename is taking from source_file_name_error.csv

error:: java.io.FileNotFoundException: ----> path (The system cannot find the path specified)

Re: how to create new folder from tfileoutputdelimiter component ??/

vboppudi — Wed, 25 Jul 2018 18:31:45 GMT

please provide the path and folder details in context group for context.tmp_data_path.

Regards,

Re: how to create new folder from tfileoutputdelimiter component ??/

amit_n — Thu, 26 Jul 2018 05:24:31 GMT

i cant hard code the path in context group.. path will taken from the config property file. When we move the code to test environment it should not have the problem.