Hi Rod
I created a transaction that calls a simple sql.
The output of this is mapped to the IllumDoc input of the MapIllumDoc2XcelsiusXML transaction.
when I point to the trx from IE7 i get (pasted from IE7)
<?xml version="1.0" encoding="UTF-8" ?>
- <data>
- <variable name="SAPMII_1">
- <row>
<column>743</column>
<column>667_SL-CT00205_WorkCenterBO:SISL,52BS002</column>
<column>SL-CT00205</column>
<column>WorkCenterBO:SISL,52BS002</column>
<column>SL-CT00205-0010-52BS002-S</column>
<column>A0</column>
<column>SL-CT00205-0000-52BS002-V</column>
<column>A3</column>
<column>2009-06-23T16:40:37</column>
<column>AA01267</column>
<column>2009-06-23T16:40:37</column>
<column>AA01267</column>
<column>TEMPLATE_PIS_CURE</column>
<column>ALL_PARAMETER</column>
</row>
- <row>
<column>742</column>
<column>666_SL-CA00001_01KM</column>
<column>SL-CA00001</column>
<column>WorkCenterBO:SISL,01KM</column>
<column>SL-CA00001-01KM-01KM-S</column>
<column>A0</column>
<column>SL-CA00001-01KM-01KM-V</column>
<column>A1</column>
<column>2009-06-23T16:00:08</column>
<column>NEI2664</column>
<column>TimeUnavailable</column>
<column>---</column>
<column>TEMPLATE_PIS_BUILD</column>
<column>ALL_PARAMETER</column>
</row>
- <row>
<column>741</column>
<column>665_SL-CA00001_02KM</column>
<column>SL-CA00001</column>
<column>WorkCenterBO:SISL,02KM</column>
<column>SL-CA00001-02KM-02KM-S</column>
<column>A0</column>
<column>SL-CA00001-02KM-02KM-V</column>
<column>A0</column>
<column>2009-06-23T14:27:22</column>
<column>NEI2664</column>
<column>2009-06-23T14:28:00</column>
<column>NEI2664</column>
<column>TEMPLATE_PIS_BUILD</column>
<column>ALL_PARAMETER</column>
</row>
</variable>
</data>
So it looks good on MII.
I then set up the url to the trx and mapped a range in xcelsius but still don't get any data back, just empty tags when I preview.
<data>
<variable name="SAPMII_1">
<row>
<column/>
<column/>
</row>
<row>
<column/>
<column/>
</row>
</variable>
</data>
Can somwone advise on the next step?
have I missed something?
regards
Amrik