JDE report converted to HTML

Hi list,

I need to convert a jde´s report to HTML file. Now I am using a Access macro but it spend to much time.
I really need to improve this process that is delaying my month end.
I would like to know if somebody else has any other way (faster of course), that can help me.

Thanks in advance,

R.P.G.

Gomes :

JDE provides XML output, but no HTML output yet.

Sebastian Sajaroff

It is very simple but two step process.
Step 1 - Generate a report in XML format instead of a PDF format.
=================================================================
OneWorld-XE have a UBE option unfamiliar to most OneWorld users. This
option is Output Stream Access, or OSA. The OSA option allows UBE to run and
have the output created in XML format rather than limiting to a PDF format.
1. Once a UBE has been selected, and the submit button has been clicked,
select the 'Document Setup' tab
2. On the 'Document Setup' tab, click the check box 'OSA Interface Name'
3. A fill-in box opens up under the check box. Click inside the box and
select the 'Visual Assist' button.
4. With release Xe there are only two options, OSASample and XML.
5. Highlight XML and click the 'Select' button.
6. Click 'OK' and the UBE will run producing an output in XML format that
can then be used in 3rd party systems.
Technical details on OSA can be found in the Enterprise Report Writing
manual (Xe release) under Appendix F.

Step 2 - Write XSLT to convert XML into HTML
============================================
There is lot of online material available to do so.
My favirote place is IBM
http://www-106.ibm.com/developerworks/xml/

Enjoy
OW Hell

Simple Solution visit web site http://access.adobe.com/simple_form.html
This convert given .pdf into HTML

You can also email PDF as MIME attachment to [email protected]

Freeware available at
http://www.ra.informatik.uni-stuttgart.de/~gosho/pdftohtml/

Enjoy
OW Hell

Re: RE: JDE report converted to HTML

There seems to be a dll called "osahtml.dll" (windows) and
libosahtml.s[l,o] (UNIX) in SP17 and later. I imaging there is a
similar service program on the as400. I haven't found
anything on how to make it go on JDE's KG, nor have I asked,
but, say, on UNIX, I bet you could do:

nm -A libosahtml.sl

to get the function names, and then configure them in the OSA
app under GH9013 using a library name of 'osahtml' and it might
work...

I don't have time to play at the moment. Have fun if you try it out!

--seg

Re: RE: JDE report converted to HTML

Segfault,

I tried this out, and it works fine on SP21_K1 Xp Client and AS400 V5R2 server, thanks for the tip...

There are only four functions:

osaHTML_EndDoc
osaHTML_EndPage
osaHTML_StartDoc
osaHTML_TextOut

Paul

Re: RE: JDE report converted to HTML

Cool! I just tried it on NT and it works there too. I went and searched the KG for osahtml and got this SAR:

5094034 osaHTML addition

Looks like it has been there since SP17. I wonder if this is in some tech flash somewhere?

Maybe this should be added to the Tips & Tricks section?