Link to home
Start Free TrialLog in
Avatar of Dale Logan
Dale LoganFlag for United States of America

asked on

Automate daily output from SharePoint 2010 to FTP

I am working with a client where we are using an Access 2010 hybrid app in SharePoint 2010 with Access Services. The client is wanting to get an update on a daily basis. This update will be automatically incorporated into their AS400 system. Is there a way that SharePoint can export something and have it upload to an FTP. I guess it could even go to their internal network.

NOTE: SharePoint is not hosted by the client, but instead is hosted over the internet by AccessHosting.com.

I have no idea if I have given enough information. Thanks for any suggestions.
Avatar of Metallimirk
Metallimirk
Flag of United States of America image

This is from a PAQ, you can do this is using an application named SPIEfolder.
You can schedule it to export the doc(s) in one site collection. Then write another batch script that ftp's those docs to a location that the AS400 can pickup, you will then need to write a script to process the data in the AS400 using RPG or ILE code.

http://www.codeplex.com/SPIEFolder 
You could use an automated Robo-FTP script that downloads a file from the SharePoint server over HTTP and then uploads it to the AS400 over FTP.
If its Access Services hosted by AccessHosting, then we're not talking about documents. Most likely you want to export accessdb data which would be in list form.

Yes its possible, but just harder. You can write a script that uses the Client Object model to hit the list and write to file and then upload via ftp.
Avatar of Dale Logan

ASKER

quihong,

I think you see what I am up against. Yes, it's Access Services hosted by AccessHosting and not a SharePoint document. So, are you saying Access can export data which would then be a list in SharePoint?

Another thought I had, it may be easier for the client to pull the data instead of me pushing it to them. I could provide them with an Access file that is linked to the SharePoint database. They would then need to figure out a way to link the AS400 to the Access database. The tricky part may end up being how they provide the user name and password when opening the Access file.
ASKER CERTIFIED SOLUTION
Avatar of quihong
quihong
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial