Hi Team,
In one scenario, we are exporting the transition data in the CSV file on the server & attaching the same file in the email delivery for reporting purposes. But sometimes we are getting blank CSV files. the exported file has data present on the server. Can you please help me with this?
Below is the screenshot of the workflow.
Also, attaching the path where we are exporting the CSV file.
/user/local/neolane/nl6/var/<instance name>/export/report.csv
Regards,
Amit
Solved! Go to Solution.
Views
Replies
Total Likes
Yes, we had to fix the file name being generated. Add the path with static file name in the attachment and in the advanced tab select script to rename the file as needed.
Hi Amit,
Can you check the last modified date on the CSV file and when the email was originally prepared? It's possible that if the delivery preparation kicked off while the CSV was still being written to that it wasn't able to attach the data.
Can you also let us know if there is any consistency with the size of the files that get attached successfully versus those that show up blank? It might be that the file size is too large.
Regards,
Craig
Views
Replies
Total Likes
Hi Craig,
Thanks for your reply. I have checked the last modified for CSV on the server & email preparation date. Email preparation date is greater than CSV last modified date by 30 Sec.
Also, the size of the file is below 100KB.
Thanks,
Amit
Views
Replies
Total Likes
Views
Replies
Total Likes
@Craig_Thonis @Sukrity_Wadhwa Is this resolved?? We are facing the same issue.
We even added a wait of 5 minutes before preparing the delivery to ensure the files are prepared but even that does not seem to work.
The logs shows the size of the file correctly but the email comes with a blank file.
Thank you
Saurav
Views
Replies
Total Likes
Views
Replies
Total Likes
Yes, we had to fix the file name being generated. Add the path with static file name in the attachment and in the advanced tab select script to rename the file as needed.
Views
Like
Replies