Transferring files from AS/400 to Sharepoint 3

5 pts.
Tags:
AS/400 import/export
Microsoft Excel
SharePoint
SharePoint Services 3.0
We want to be able to transfer data files (Excel Spreadsheets) from our AS/400 to a Sharepoint site. We've been advised that e-mail is a solution, but for security reasons our company won't allow this. We have a utility that let's us create the Excel files on the AS/400 but cannot work out what's needed to get these files automatically onto sharpoint so that our sharepoint users can see them. Cqan anyone help

Answer Wiki

Thanks. We'll let you know when a new response is added.

One easy way to move files from the i to Windows is to use the netserver server within i/OS.
All the i/OS functions can be carried out using the Operations Navigator:

1) Define a folder within the IFS structure as a shared folder with appropriate permissions for your environment
2) Move the IFS files to transfer to this folder
3) on the Windows server: define a local user profile with the same name and password as the i/OS profile that is authorized to the shared folder (no magic to being a local user, but if your naming conventions are different for i/OS vs Windows profiles this is a low-impact way to make this work)
4) create a simple .cmd file on windows to copy from \\i_System_Name\folder_share_name\*.xls to c:\windows_folder
5) run the .cmd file periodically to capture all new files and move them to the windows environment

Netserver is found under the TCP/IP servers tree in Operations Navigator
IFS is found under the File Systems tree in Operations Navigator

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following