Re: Displaying JSON data on iSeries Apache web server

Booth,

Glad to see you're having success with this. I believe my eRPG books are
heavily discounted now if you're interested in some reading (but the first
one used the Cern HTTP server because the Apache server wasn't being used
yet so you can ignore that info).

Most of the web presentation is done with HTML, CSS, JS, etc. All you need
is something to spit the "data" out and you're golden. As RPG programmers
we already know how to do that. In fact, creating a report type web page
using RPG and pagination (using SQL of course) is surprisingly more simple
than creating a subfile.

It's fun stuff, that's for sure! Don't fall into the trap that "RPG can't
do web" or "CGI is so outdated".

All RPG is doing for the most part is spitting out the data, as is with
most web application languages. Just because it's RPG doesn't mean it
can't be "pretty". That's up to someone on the team learning HTML, JS and
CSS.

Brad
www.bvstools.com

On Fri, Nov 25, 2016 at 7:49 AM, Booth Martin <booth@xxxxxxxxxxxx> wrote:

Turns out that was the answer. Thank you Kevin. User QTMHHTTP had to be
given permission to the JSON file. Then all worked as desired, with both
Firefox and IE11.

So, as it turns out, providing an organization's casual users with their
reports and data needs in modern and attractive ways is surprisingly easy,
even for old-timey RPGers like me. I used Eclipse Neon and its editors to
write the HTML, CSS, JavaScript files. I used FileZilla to FTP the files
to the iSeries. I set up a simple HTTP server using the iSeries IP address
plus :2001/HTTPAdmin. I used port 7878 for the new Apache server. Then,
with my browser I could reach xx.xxx.xxx.xx:7878 and see the data

Anyone cares to see the code, please view Page Source on
ventures.martinvt.com . Building the .json file is pretty straight
forward RPG coding. My program is less than 100 lines, although it does
have a line "/copy MARTIN/QDEV,IFSIO_H" to include Scott Klement's 1200+
line set of includes that makes dealing with the IFS manageable by
programmers like me. Anyone wants to see my RPGLESQL program to see how I
did it, just let me know. Happy to share.

There is more to be done of course, but for the moment I am reflecting
upon how much easier it was to do than I expected. I made way too much
work of it.


On 11/24/2016 6:13 PM, Kevin Turner wrote:

Qtmhttp1 is not authorised

--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.