Issue with writing CSV data to FTP - it creates the file itself, though the file is empty
Hi, wondering if anyone has encountered this issue.
We are exporting a Netsuite Saved Search as the first part of a two-part flow, then that export as a CSV to an FTP.
The issue is that it creates the file itself on the FTP (with the correct file name convention we've set up), though the file itself is empty.
We can see when clicking "Download Files" that the file is being created (with a temporary file name), though the flow is reporting as successful and we can see the data is in there.
As you can see below, this is the temporary file from Celigo, and it's populated, it just doesn't write the data during the last phase to put it into the created file on the FTP.
Any glaringly obvious answer to this as this is the only thing now stopping us from pushing this information to our supplier for total automation.
As you can see, empty files...
Temporarily, to test permission on the FTP, that folder has 777 permissions and the user has full write permissions to the ftp folder being used (using vsftp). I've also tested uploading and deleting files manually with that user and it works fine.
Any assistance would be appreciated.
This is really strange. Are you saying that the file looks correct when you click on the "Download files" link, but then the file on the actual FTP site is empty? I have never seen anything like this before.
I def recommend opening a support ticket, and please let the community know the root cause once it is determined. i.e. was it an FTP permission issue, or maybe some other process was running that is clearing the files, or was there a bug in integrator.io, or a config mistake?0
Please sign in to leave a comment.