topic Re: Not able to open csv file which is exported using Context filename in Talend Studio

Not able to open csv file which is exported using Context filename

Salesforcedevme — Sat, 16 Nov 2024 06:40:29 GMT

Hi ,

Im new to Talend Integration .When i export template to csv file, im not able to open the csv file .Im using filename as context variables.There is no error while running the job,it shows rows in the diagram.This happens to only few templates.Could anyone help me to resolve this issue? I have added error pics for the reference.

Re: Not able to open csv file which is exported using Context filename

manodwhb — Tue, 05 Feb 2019 05:31:02 GMT

@Salesforcedevme ,can you open that file in some editor like notepad++ and see ?

Re: Not able to open csv file which is exported using Context filename

Salesforcedevme — Tue, 05 Feb 2019 05:45:24 GMT

Hi Manohar,

Thanks for the quick response.

Yes its opening in notepad++.

Re: Not able to open csv file which is exported using Context filename

manodwhb — Tue, 05 Feb 2019 05:46:45 GMT

@Salesforcedevme ,are you able to verify the data,which you have extracted from salesforce?

Re: Not able to open csv file which is exported using Context filename

vapukov — Tue, 05 Feb 2019 05:51:37 GMT

Hi,

first of all - test same job with a much shorter path, like

c:\temp\out.csv

Re: Not able to open csv file which is exported using Context filename

Salesforcedevme — Tue, 05 Feb 2019 05:56:10 GMT

I could see only field name when i opened with notepad.When i rename the file ,it is showing all data.

Re: Not able to open csv file which is exported using Context filename

Salesforcedevme — Tue, 05 Feb 2019 05:57:14 GMT

Hi,

Yes it is working with shorter path. Im getting issue only when i used context file name

Thanks

Re: Not able to open csv file which is exported using Context filename

manodwhb — Tue, 05 Feb 2019 05:58:49 GMT

@Salesforcedevme ,now just to hard code path as @vapukov said or you can use context variable also try to reduce the dynamic file name length and execute the job,how was it loading and are you able to open and see the data?

Re: Not able to open csv file which is exported using Context filename

manodwhb — Tue, 05 Feb 2019 06:37:56 GMT

@Salesforcedevme ,you need to review the context path to limit length.

Re: Not able to open csv file which is exported using Context filename

vapukov — Tue, 05 Feb 2019 06:43:07 GMT

as you can see from picture - file in workspace, which is not acceptable at all

so, need to talk not about reduce context length but about using proper path (of course dynamic, but not what on picture)

Re: Not able to open csv file which is exported using Context filename

Salesforcedevme — Tue, 05 Feb 2019 07:02:07 GMT

hi ,

how to reduce file name if im using context variable.I tried to change the path in Context >General >.It is showing me error.

Thanks

Re: Not able to open csv file which is exported using Context filename

manodwhb — Tue, 05 Feb 2019 07:06:46 GMT

@Salesforcedevme ,i am not understand what error are you getting. but you can change the context variable.

filename C:/text/file_output.csv

Re: Not able to open csv file which is exported using Context filename

vapukov — Tue, 05 Feb 2019 07:07:01 GMT

it not seen from your screenshots

but generally - if result file in workspace - it means your context variable is null! and file saved in place from where compiled job started

please attach - how you define context variable and filename

Re: Not able to open csv file which is exported using Context filename

Salesforcedevme — Tue, 05 Feb 2019 08:39:26 GMT

Hi ,

Im defining context variable like this :

Re: Not able to open csv file which is exported using Context filename

vapukov — Tue, 05 Feb 2019 08:45:26 GMT

look

data/export/xxxx

will work from current folder:

- when you build standalone job and run it from CMD/shell - it will Job folder + data/export/xxxx

- when you run it from studio - it will be under workspace

try to define path as full - starting from root /something/data/export/xxx

Re: Not able to open csv file which is exported using Context filename

Salesforcedevme — Tue, 05 Feb 2019 08:53:43 GMT

Yes it worked thank you so much