Excel to CSV Conversion then Upload to FTP site
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I'm trying to convert an Excel file to CSV then upload it directly to an FTP/SFTP site/folder. I can get the file to convert but having trouble uploading it to the FTP site as the flow just keep running. Not sure what I am missing of if I have the right tools in the flow.
Thank you
- Labels:
- Developer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Try using the block until done tool.
- output to macro that converts files to csv
- output 1 to the ftp macro
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you Geraldo! However, the flow is still running for a long period of time with your added suggestions.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
As the macros did not come attached, it was not possible to analyze which tools you are using to make the ftp.
Are you using the download tool with the payload configured as PUT?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
yes, I have it set to " PUT" when I use the download tool. Then the flow fails because it is asking for Blob which I do not have. In this case I want to upload the newly converted 'csv' file into the FTP.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
