โ10-26-2018 07:57 AM
Hi,
Iโm trying to write a CSV file with Date.now() at the end of file name. But Iโm not able to see the file in destination folder If I have date.now in the expression[โsftp://zing.grouponinc.net/Workday/Completed/workday_integrationโ + Date.now() +โ.csvโ]. I can see the new file creating in the destination folder if the expression doesnโt have date.now()[โsftp://zing.grouponinc.net/Workday/Completed/workday_integration.csvโ].
Can anyone help me in this why itโs not showing?
Solved! Go to Solution.
โ10-26-2018 09:21 AM
Are you seeing any error messages when you run the pipeline? If not, this seems like there may be a bug that needs to get fixed.
The Date.now() function will write out the local date and time in the format YYYY-MM-DDTHH:mm:ss.SSS
. Sometimes colon characters are not allowed in file names, so maybe itโs that? You could try changing the expression to
โsftp://zing.grouponinc.net/Workday/Completed/workday_integrationโ + Date.now().toString().replaceAll(":", "_") + ".csv"
Or something similar and try to see if that works.
โ10-26-2018 09:21 AM
Are you seeing any error messages when you run the pipeline? If not, this seems like there may be a bug that needs to get fixed.
The Date.now() function will write out the local date and time in the format YYYY-MM-DDTHH:mm:ss.SSS
. Sometimes colon characters are not allowed in file names, so maybe itโs that? You could try changing the expression to
โsftp://zing.grouponinc.net/Workday/Completed/workday_integrationโ + Date.now().toString().replaceAll(":", "_") + ".csv"
Or something similar and try to see if that works.
โ10-26-2018 09:49 AM
Thank you @tlikarish
Itโs because of the column. By replacing colon has fixed the issue.
โ08-27-2021 01:24 AM
Hi skodali,
i have encountered same error , i have resolved it by adding this file name in s3 writer
โs3:///bucket@s3.region.amazonaws.com/outfile1_โ + Date.now() + โ.csvโ
Regards,
Mangesh