Excel Dashboard from AS/400 reports

Tags:
AS/400
Microsoft Excel
A client has asked me to populate an Excel sheet with reports generated from an AS/400 system. Currently these reports are entered manually 1-2 times a day. What I want to do is pull the data directly from the AS/400 system rather than having it run the report, but I'm not sure where I would start and would appreciate any direction. The implementation can be complicated, but the execution needs to be simple, as one of the warehouse managers will be running the dashboard.
1

Answer Wiki

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

You can write a RPG/CL program to extract the data into Physical file, Store it into IFS as CSV and Send out an email to user by using SNDDST command.

Do you see any challenges in writing the program for data extraction/Sending email?

Discuss This Question: 2  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.
  • ToddN2000
    Another option is to place a button on the Excel sheet with a macro behind it to run a data transfer import. We have a few of these used by our factory. They enter a part number, click a button and get real time inventory and shipping data imported from the i-series. I did not set it up but it does not seem too complicated. This way it can be run on demand as often as needed.
    129,355 pointsBadges:
    report
  • BigKat
    Just make sure your data transfers are select only.  Updates via this method could be very hazardous to your database integrity for the simple reason some user thinks it isn't running and clicks again (and again and ...)

    You have to build VERY robust logic to prevent confUSERS from entering invalid data, from multiply entering valid data, etc.

    If there are updates, we tend to write a CSV to the IFS and import it to the IBMi database to TRY and mitigate the risk.
    9,420 pointsBadges:
    report

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.

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

Following

Share this item with your network: