In case anyone is interested, I started a post about using IBMi ACS automation to upload/download files to the IFS using the Data Transfer functionality.
Found an older Craig Pelkie Ocean presentation on this from wait for it...wait for it..... That's right: 2012.
ACS already luck 13yrs old. Where does the time go.
Documenting it for posterity in case someone wants to use this functionality.
https://github.com/richardschoen/howtostuff/edit/master/acsautomation
Regards,
Richard Schoen
Web:
http://www.richardschoen.net
Email: richard@xxxxxxxxxxxxxxxxx
----------------------------------------------------------------------
message: 1
date: Sat, 1 Feb 2025 19:14:28 +0100
from: "Leif Guldbrand" <Guldbrand@xxxxxxxxx>
subject: Re: Utility for import excel file to db2 file
I did this many years ago, both from an iSeries database to a Win PC within Excel and from Win PC Excel to a database in the iSeries. So, it's doable.
At the end of workday, the person in charge startet a job from his PC and updated his new data from Excel to the iSeries, where the DB got updated.
From the iSeries (with new data too), a job started at midnight and after end, both the Excel DB and iSeries DB were equal.
As I remember, I used Scott Klements POI utility:
https://tinyurl.com/24t4995y
Regards, Leif
---- Original Message -----
From: gio.cot via RPG400-L <rpg400-l@xxxxxxxxxxxxxxxxxx>
Reply-To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
To: 'RPG programming on IBM i' <rpg400-l@xxxxxxxxxxxxxxxxxx>
Cc: gio.cot <gio.cot@xxxxxxxxxxx>
Sent: 01-02-2025 16:11:52
Subject: Utility for import excel file to db2 file ________________________________________________________________________________
Hi all
I'm looking for an free utility (if exist), to invoke from RPG
program, for import data from excel to Ibm i file; could you share
which command/programs do you use ?
Thanks in advance
Gio
midrange.com
