[Chap Moore]

We are looking to upload a CSV to an FTP website. I am looking for an alternative to building a site that pulls in the data from the search and builds a csv then uploads to the FTP (seems like we are rebuilding the wheel). We have the search built and want to export it automatically to the ftp once a day. This is with SPS and does anyone have the experience with this?
This is a cached copy. Click here to see the original post.

[dansteg]

I’ve sort of ghetto rigged this for the time being. I know Celigo offers what appears to be a good solution, but it’s $3,600 annually with 2 flows and is $600/yr per additional flow. What I’ve done:

– Created a saved search that gets sent to “auto-reports@mydomain.com” @ 2AM

– Have Mozilla Thunderbird running on a server with the AttachmentExtractor (Thunderbird add-on)

– When an email arrives from @netsuite.com and has an attachment, it will automatically extract it and dump it into a directory. This also renames the file to whatever the subject is.

– Email gets sent at 2AM

– Task Scheduler job runs a script at 5AM to upload to FTP

– All done.

I’ve had this in place for a while and it does work great and is pretty simple to set up. I have it running for two different saved searches. It does require Thunderbird to be running at all times, though. I guess you can set up some sort of alert on the server to check if Thunderbird gets accidentally shutdown.

Hope that helps!

[Chap Moore]

thanks. The issue for us is that the FTP is on another server so we are just middle ground between NS and the Thirdparty.

[dansteg]

Similar case for us as well. We upload our inventory information to one of our suppliers, so that they can display it on their website.

– Run Thunderbird on a local server. Local server extracts attachment and then runs a script to uploads to their FTP.

For our other file, we have a local SQL server that I throw some inventory levels in:

– Run Thunderbird on a local server. Local server extracts attachment and then runs a script to dump it on the SQL server. SQL server runs a script to drop tables and import new dataset.

Good luck!

[samzad]

There could be another option, use webservice to pull the saved search result in csv and dump it at the desired location in the other server. It should be pretty simple. There is java based open source tool called Apache Camel can be used for this purposes even bi-directional transfer.

[srodriguez]

Hey Chap, let us know if you haven’t resolved this yet (it’s been a while so I assume you have). If not, we can definitely help. We’ve done this several times with just the need for another server in your environment (on prem or hosted ie aws) that runs an application that uses web services to get the data from NS and then performs an FTP upload. It could be set up to run on a scheduled basis using a job scheduler.

[Chap Moore]

Fixed thanks

[webbee]

Hello ,

There is a simple workaround we generally follow:

1. Create a PHP / any other programming lang file and have the code to post to the PHP file hosted on a webserver , and PHP code will post to the FTP .

Let me know if you need a code for that , we have it successfully running.

thanks

[Author]

Posts