Issue with writing CSV data to FTP - it creates the file itself, though the file is empty

Integrator.io
, , ,
1

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.

5301043caa20740200000001-7d3e635b8d834f7fb8a32573fbe21f5f.png
5301043caa20740200000001-7d3e635b8d834f7fb8a32573fbe21f5f.png1118×274 18.7 KB

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.

5301043caa20740200000001-9b22e6fcb6654811b7ee394a5bfa00a8.png
5301043caa20740200000001-9b22e6fcb6654811b7ee394a5bfa00a8.png1375×106 19.7 KB

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.

5301043caa20740200000001-12ea82d4c6d94d11bca6aaf759b0b471.png
5301043caa20740200000001-12ea82d4c6d94d11bca6aaf759b0b471.png1031×117 4.22 KB

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.

Christian

2

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?

3

Hi, Was this ever solved? Having the same issue.

4

Hi @basvanditzhuijzen,

Thank you for reaching out. We could not replicate the issue and tried multiple options as well. Could you please share the flow zip with me?

Best Regards,

Rohit Prasad

5

Hi,

After some debugging we figured out we needed to turn on 'require socket reuse', as the server was configured to only use one port. So the file was being created but the data-transfer to it was failing.

5301043caa20740200000001-9c19b4600f8b4f5eaf2d369845d6ff64.png