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

[Salesforcedevme]

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.

[manodwhb]

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

[Salesforcedevme]

Hi Manohar,

Thanks for the quick response.

Yes its opening in notepad++. 

[manodwhb]

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

[vapukov]

Hi,

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

c:\temp\out.csv

[Salesforcedevme]

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

[Salesforcedevme]

Hi,

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

Thanks

[manodwhb]

@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?

[manodwhb]

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

[vapukov]

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)