Fetching Data from xmii to html is very slow

[sidnooradarsh]

Hi,

Due to some business requirements I need to fetch data from

xmii and do some formatting and display the data using html table.

I am using an iCommand to fetch the data.

I am returning some 100 rows having 30 columns.

I am using following piece code:-

"document.commandappletname.getValue(col no, row no)"

to extract the data and then storing these values into a Javascript Array()

Populating data from array to html table is very fast but fetching data from command to array is consuming lots of time.

Please help me out with any other feasible solution which improves my performance and fetching speed from MII to Arrays.

[sidnooradarsh]

Hi,

My business requirement is to have a Check box against each row in the grid.

So this is the reason I am bringing the data from from xmii to html and then generating a dynamic html table putting check boxes against each row.

I am a novice or no idea of creation and use of xsl stylesheets.

So, can I generate check boxes against each row using xsl and allow users to check them.

How do I perform this.

Please help me out!!.

Regards,

Adarsh

[Former Member]

Also, even though I dont recommend it, You can format your html in a BLT transaction and avoid all client side loopage....

[Former Member]

...I recommend it.

[agentry_src]

Rick,

I know you are saying it tongue in cheek, but when would you suggest using that action block? I have not run into any circumstances where it would be a first choice.

Mike

[Former Member]

Actually, Mike, I don't use the XSL transform action block, but rather, I build up the HTML itself using BLS logic. Effectively, I'm creating a giant string which represents the resultant HTML. With a little creativity using transaction calls, along with a set of "library" transactions (which, ultimately, I had hoped to convert to action blocks themselves) for adding tables, images, text, forms, divs, and so on, I was able to create some very dynamic and data/logic-driven web pages using BLS. Similar, I suppose, to what you might do with JSP and ASP.

No one has mentioned this yet, but a JSP approach might also be a good choice.

[Former Member]

Hi,

Use the Spry Component ajax for XML.

Bye

[Former Member]

You might be better served by using an xsl transform in this application instead of applet -> Javascript -> HTML. I like this approach for several reasons, for one, when doing DHTML from java, you never are really sure what your output HTML really looks. Second, performace, using the method of query -> XSL -> HTML is very fast.

I've seen / used both methods and I nearly always use stylesheets when I can. For a test try one of the built in style sheets like IllumRowsetHTML.xsl

Your code will look something like:

    <SERVLET NAME="Illuminator">
             <PARAM NAME="QueryTemplate" VALUE="/Reports/PerformanceReports/ShiftSumReport/xacutePlannedDT">
             <PARAM NAME="StyleSheet" VALUE="http://localhost/Illuminator/StyleSheets/IllumRowsetHTML.xsl">
              <PARAM NAME="Content-Type" VALUE="text/xml">
             </SERVLET>

Edited by: Doug Holtke on Oct 3, 2008 5:08 PM Forgot the "text/xml"

[jcgood25]

From your description it sounds like all the slow aspects of what you are trying to do are on the client side with your javascript.

Much better to do this with an irpt call and a SERVLET section with an xsl stylesheet that builds your html table output on the server side.

Regards,

Jeremy

[Former Member]

Use a Servlet tag and an xsl transform for this.

[Former Member]

And here is some help:

[http://help.sap.com/saphelp_xmii115/helpdata/en/Advanced_Topics/Customizing_Output/Customizing_Output.htm#Using Server-Side Includes|http://help.sap.com/saphelp_xmii115/helpdata/en/Advanced_Topics/Customizing_Output/Customizing_Output.htm#Using Server-Side Includes]

And

[http://help.sap.com/saphelp_xmii115/helpdata/en/Advanced_Topics/Customizing_Output/Illuminator_XSLT_Servlet_Reference.htm|http://help.sap.com/saphelp_xmii115/helpdata/en/Advanced_Topics/Customizing_Output/Illuminator_XSLT_Servlet_Reference.htm]