Adam,
Thanks for the excellent explanation.
I do have a data transfer request (.dtt) but I've tried running it from a CL program using RFROMPCB and always get some type of error. I'm very close to getting it to run though, so why should I go through the work of using NetServer or Scott's highly regarded programs? Do you not recommend using a .dtt in a CL?
I would think that 1000's of iSeries shops would be using RFROMPCB but I only get 2,610 hits on the web when I search for "RFROMPCB". This leads me to believe that to transfer data from Excel to a PF using RFROMPCB is not the right approach at all. Why not? I'm not a programmer and I almost got it working. I must be failing to see something.
Keep in mind that I was tasked to do this by my boss who said he's done this type of thing (automation of data transfer from a CSV to a PF) at a previous workplace. He asked me to find a way to do it but I just haven't been able to nail it down and I'm thinking that this is out of my league as a non-programmer.
Any comments?
Thanks,
Bryan
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Adam Glauser
Sent: Thursday, November 15, 2007 8:21 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: Access OS400 shared folder from windows
Burns, Bryan wrote:
I myself am trying to learn about the IFS. When someone says IFS and doesn't specify a file system, what does she mean? QSYS.LIB? Isn't QDLS one of the 11 file systems in the IFS?
Usually when when someone refers to the IFS, they mean the root file
system. You are correct that technically the QSYS and QDLS are both
filesystems under the IFS, as is the root filesystem.
I'm working on transferring data from an Excel CSV file to a PF using a CL command; but if I could drag and drop the CSV to the "IFS" that would work too.
You can set up Netserver on the System i to make part of the root file
system available as a Windows 'share'. You can also use NFS to make
these directories available to NFS clients on the network. Then, you
can mount this 'share' as a drive on your client and transfer files in
the usual drag-and-drop way. Once you have the CSV file in the root
file system, you can process it using the IFS APIs that allow you to
process stream files from HLLs on i5/OS. See Scott Klement has some
great resources here:
http://www.scottklement.com/rpg/ifs.html
Another way to get Excel data into a PF is to use the Excel extensions
that come with Client Access. These give you menu options under the
Data menu in Excel that allow you to transfer directly to a PF.
However, troubleshooting this process can be a big pain, as the data
transfer tool is somewhat opaque.
Hope this helps,
Adam
midrange.com
