tpayne51
Member
RE: Download File to Excel from batch Job
Problem we have is that they are just as concerned about data being uploaded
as people having access to data on the system that they should not have, and
with file transfer you can obviously bypass the JDE security.
We need to be able to transfer the file created by our process to the pc
automatically as part of the file creation job, whether this is by ftp,
email or whatever means, but they do not want the placement of the file on
the pc to be a user manipulated function.
We can ftp the file down, but then would have to do something about
splitting the fields so the users can access the data in Excel.
We could also modify the program that creates the file to build a comma
separated file (1 field per record on the AS400) which when downloaded could
be loaded directly by Excel. This is a lot of programming effort and the
file is also useless on the AS400.
I would have thought that somewhere out there was a utility that would allow
a transfer of the file into Excel format that could be executed in batch
from a CL program.
Will keep you posted if I find something...
Problem we have is that they are just as concerned about data being uploaded
as people having access to data on the system that they should not have, and
with file transfer you can obviously bypass the JDE security.
We need to be able to transfer the file created by our process to the pc
automatically as part of the file creation job, whether this is by ftp,
email or whatever means, but they do not want the placement of the file on
the pc to be a user manipulated function.
We can ftp the file down, but then would have to do something about
splitting the fields so the users can access the data in Excel.
We could also modify the program that creates the file to build a comma
separated file (1 field per record on the AS400) which when downloaded could
be loaded directly by Excel. This is a lot of programming effort and the
file is also useless on the AS400.
I would have thought that somewhere out there was a utility that would allow
a transfer of the file into Excel format that could be executed in batch
from a CL program.
Will keep you posted if I find something...
