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.
Dale LoganConsultantAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

MetallimirkCommented:
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 
AlexPaceCommented:
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.
quihongCommented:
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.
Dale LoganConsultantAuthor Commented:
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.
quihongCommented:
When you publish as Access app to SP via Access Services, the access db tables get converted into SP List. You are then able to hit the SP List using the standard SP APIs - such as the client object model or via web services. I'm not sure how AccessHosting plays into this though.

Regarding your thought on having the client pull the data, that's not a bad option. You can have them manually download the Access file and open locally via Access 2010 and provide them with a macro/interface that would push the data from the local workstation to the AS400.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.