I`v not really had any luck with using SSPU`s ftp. (personally I think there’s a bug and ftp has never worked in SSSPU 7.x, but then again no ones complained, so maybe I`m doing something wrong??? or everyone is scared to work with SSPU :D)
The strange thing is my ftp status in SSPU always comes back as successful with no errors, but no files appear on the destination server.

So, I decided to write up my own ftp configuration, to transfer files as soon as SSPU had done its transformations.

Read on to find out how its done

Now I know I could of used publisher and set it to transfer all the files at midnight or written a service to push files across..
But I wanted SSPU to do what it was supposed to.. So heres what I did as a work around.

Step 1. Install FTP client
Unfortunatly windows command prompt FTP is very very basic!
So I decided to go ahead and install NcFTP.. Why, well its free. and has all the commands I needed to ftp the SSPU transformed site.

Info on NcFTP:
The program has been in service on UNIX systems since 1991 and is a popular alternative to the standard FTP program, /usr/bin/ftp. NcFTP offers many ease-of-use and performance enhancements over the stock ftp client, and runs on a wide variety of UNIX platforms as well as operating systems such Microsoft Windows and Apple Mac OS X.

Step 2. Setup NcFTP connection details.
Create a text file remember to set the permissions on the file so no one else has access..
Enter your connection information into the text file: ‘bluestudios.conf’.

host ucm.bluestudios.co.uk
user sim01
pass y34hR1ghtL1k3ImG0nn4Sh0wY0u!?

The server connection details should look like the above.
Save the file.

Step 3. Write out SSPU.config.
In your <job></job> tags add the following trigger:

<trigger when=”after” type=”cmd”>
cmd /C ncftpput -R -f x:\ucm\sspu\ftp\bluestudios.conf /I/LOVE/SSPU x:\ucm\sspu\offers\21
</trigger>

This will run after the transformation has been complete.
And will move all files from offer-id 21 to the bluestudios server SSPU directory

Don`t forget you will have to restart SSPU services to pull in the updated config!

I hope this has helped anyone who has experienced the same problem as me…
Or if anyone has a solution to fixing SSPU ftp please pass it on and don`t say upgrade to 10gR3
Thanks.

I haven`t had time to test this out just yet.. But in theory should work.. Will update soon!

Tested and works! The only thing is it copies the cache/tmp folder over which usually gets deleted.
But at least all the files now get ftpd across