Moving .XLS from a folder on an as400 to a shared folder on a network

Johnd01

55 pts.

Tags:

file sharing

FTP

Microsoft Excel

SEQUEL

XLS

I have an excell spread sheet generated from Sequel, I can get it ot a folder on the 400 but would like it get it to a shared folder on my network. I have tried to copy it FTP it and nothing seems to work.

Asked: May 27, 2010 6:43 PM Last updated: June 2, 2010 1:41 AM

Answer Wiki

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

Send me notifications when members answer or reply to this question.

Discuss This Question: 5 Replies

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.

TomLiotta May 27, 2010 10:05 PM GMT

I have tried to copy it FTP it and nothing seems to work. That implies that you tried multiple things and none of them worked, even though you only listed FTP. It doesn't tell us what you've tried nor what happened in the attempts. What happened? What messages appeared, particularly their identifiers? Where did you see them? Tom

125,585 pointsBadges:

report
TomLiotta May 27, 2010 10:09 PM GMT

...to copy it FTP it ... I guess that could mean two separate actions, but it's not clear. If "copy" is separate from "FTP", how was the copy attempted? From a Windows command line? An AS/400 command line? In ieries Navigator? Somewhere else? What did you use to do the copy? A command? Drag/drop? Something else? Tom

125,585 pointsBadges:

report
Johnd01 Jun 1, 2010 6:22 PM GMT

I have the XLS on a AS400 folder. I can see the folder and document when I do WRKFLR. I want to get it to a network drive (\S00DATA01Public Shared DOCS). How can I do this ?

55 pointsBadges:

report
Johnd01 Jun 1, 2010 6:23 PM GMT

That was \S00DATA01\PUBLIC SHARED\DOCS. And I want to automate it.

55 pointsBadges:

report
TomLiotta Jun 2, 2010 1:41 AM GMT

WRKFLR Ah, it's a *DOC object in a *FLR object. That's probably the base cause of the problem. Put it out in a streamfile somewhere under the /root directory system. Don't use the /QDLS file system with versions of Windows newer than Windows 2000. Actually, it probably shouldn't be used for anything newer than Windows 98, but Win2K can handle it. (WinXP had some Microsoft patches that allowed it to work with some IBM PTFs. Things got really questionable after that because both MS and IBM tried to stop enhancements.) /QDLS has networking capabilities that are not supported well, if at all, by more current versions of Windows. It is an old DOS file system. It also has SNA/DS restrictions that require appropriate configurations in the system directory. It has been effectively obsolete for ten years or so. You should never need to use the WRKFLR command. Tom

125,585 pointsBadges:

report