topic Re: ABAP to XML using XSLT problem in Application Development and Automation Discussions

ABAP to XML using XSLT problem

Former Member — Wed, 01 Aug 2007 20:06:17 GMT

Hello Experts,

I'm trying to write a program to transform ABAP internal table to XML using XSLT. I found some code example on SXSLTDEMO_FLIGHTS report and have tried that. My problem is every time the transformation occurs, I always get 0 byte (ie, none was return) as XML output. Below is my code, can you please see what's wrong with it? Any input is appreciated!! I just use ID_INDENT as my XSLT.

REPORT z_xml_to_table.

PARAMETERS: p_file LIKE rlgrap-filename.

CONSTANTS: encoding type string value 'utf-8',

line_length TYPE i VALUE 4096.

TYPES: line_t(line_length) TYPE x,

table_t TYPE STANDARD TABLE OF line_t.

DATA: src_tab TYPE table_t,

xmlstr TYPE string,

resstream TYPE REF TO if_ixml_ostream,

g_encoding type ref to if_ixml_encoding,

g_ixml type ref to if_ixml,

g_stream_factory type ref to if_ixml_stream_factory,

restab type table_t,

ressize type i value 0,

r_xstring type xstring.

TYPES: BEGIN OF wa_sitelist,

siteid(5) TYPE c,

valid(1) TYPE c,

END OF wa_sitelist.

DATA: site_list type standard TABLE OF wa_sitelist.

DATA: xml_str TYPE string.

g_ixml = cl_ixml=>create( ).

g_stream_factory = g_ixml->create_stream_factory( ).

g_encoding = g_ixml->create_encoding( character_set = encoding

byte_order = 0 ).

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename = 'c:\temp\sites.xml'

filetype = 'BIN'

TABLES

data_tab = src_tab.

CALL TRANSFORMATION zjc_test

SOURCE XML src_tab

RESULT site_list = site_list.

REFRESH restab.

resstream =

g_stream_factory->create_ostream_itable( table = restab ).

resstream->set_encoding( encoding = g_encoding ).

CALL TRANSFORMATION ID_INDENT

SOURCE site_list = site_list

RESULT XML = resstream.

ressize = resstream->get_num_written_raw( ).

perform store_file using ressize restab.

BREAK-POINT.

form store_file

using

bin_filesize type i

tab type table.

data: s type string.

s = 'c:\temp\outxml.xml'.

if bin_filesize > 0.

call function 'GUI_DOWNLOAD'

exporting bin_filesize = bin_filesize

filename = s

filetype = 'BIN'

tables data_tab = tab

exceptions others = 1.

else.

call function 'GUI_DOWNLOAD'

exporting filename = s

filetype = 'ASC'

tables data_tab = tab

exceptions others = 1.

endif.

endform.

Re: ABAP to XML using XSLT problem

former_member194669 — Wed, 01 Aug 2007 20:12:14 GMT

Hi,

Change file type BIN to ASC


CALL FUNCTION 'GUI_UPLOAD'
EXPORTING
filename = 'c:tempsites.xml'
filetype = 'ASC'
TABLES
data_tab = src_tab.

aRs

Re: ABAP to XML using XSLT problem

Former Member — Wed, 01 Aug 2007 20:15:27 GMT

Sorry for not being clear. The first part of the program transform XML to ABAP internal table using my own XSLT which works fine. The problematic part is the second part where I use CALL TRANSFORMATION ID_INDENT.

Thanks!!

-- Jamie.

Re: ABAP to XML using XSLT problem

former_member194669 — Wed, 01 Aug 2007 20:16:38 GMT

Hi,

Check this example program , May this one give you some help


report  z_10                              .
type-pools: abap.

types: begin of t_xmldoc,
         doc(10) type c,
         date    like sy-datum,
         item(5) type c,
         totalprize type i,
       end of t_xmldoc.

types : begin of truxs_xml_line,
            data(256) type c,
        end of truxs_xml_line.

data: source_xml type table of truxs_xml_line.

data: xmldoc_itab   type standard table of t_xmldoc,
      wa_xmldoc     type t_xmldoc,
      result_xml    type abap_trans_resbind_tab,
      wa_result_xml type abap_trans_resbind.

call function 'GUI_UPLOAD'
  exporting
    filename = 'c:test.xml'
    filetype = 'ASC'
  tables
    data_tab = source_xml.

get reference of xmldoc_itab into wa_result_xml-value.
wa_result_xml-name = 'XMLDOC'.
append wa_result_xml to result_xml.

call transformation z_z10
source xml source_xml
result (result_xml).

loop at xmldoc_itab into wa_xmldoc.
  write: / sy-tabix, wa_xmldoc-doc, ' ', wa_xmldoc-date, ' ', wa_xmldoc-item, '  ', wa_xmldoc-totalprize.
endloop.

XLST <<<< program code

<xsl:transform version="1.0"
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:template match="/">
  <xsl:copy>
    <xsl:apply-templates />
  </xsl:copy>
</xsl:template>

<xsl:template match="xmldoc">
  <item>
    <DOC><xsl:value-of select="doc" /></DOC>
    <DATE><xsl:value-of select="date" /></DATE>
    <ITEMS><xsl:value-of select="items" /></ITEMS>
    <TOTALPRIZE><xsl:value-of select="Totalprize" /></TOTALPRIZE>
  </item>
</xsl:template>

</xsl:transform>

aRs

Re: ABAP to XML using XSLT problem

Former Member — Wed, 01 Aug 2007 20:47:41 GMT

Hi aRs,

I looked and tried to executed the program but I got 'XML_FORMAT_ERROR' dump. I am also confused with the code. Is this one transform from ABAP internal table to XML?

This is the XML file that I used.

<?xml version="1.0" encoding="UTF-8"?>

</xmldoc>

Please advise,

-- Jamie.

Re: ABAP to XML using XSLT problem

former_member194669 — Thu, 02 Aug 2007 01:27:54 GMT

Hi,

Check these threads

http://searchsap.techtarget.com/generic/0,295582,sid21_gci1207657,00.html

aRs