IBM Sterling Transformation Extender

 View Only
Expand all | Collapse all

Excel output not mapping to correct tab

  • 1.  Excel output not mapping to correct tab

    Posted Fri March 31, 2023 11:12 AM

    I inherited a map from a now retired programmer that maps an xml file to an Excel spreadsheet with 30 tabs.  One of the tabs is not getting populated with some data from the xml file and is instead, showing up in an "extra" tab at the end.  The map has one input and 30 outputs that all go to the same Excel template file.

    The input and output traces show recognition as valid and mapping tot he output.

    I assume ITX creates the tabs in order of the 30 output maps?  Tab 26 is the one that is not working correctly and is instead mapping to a tab 31.

    I've been unable to determine why this is occurring.  Any suggestions are welcome.  This is the first time I've ever dealt with a map doing Excel.

    Thanks.



    ------------------------------
    Steve Arbo
    ------------------------------


  • 2.  RE: Excel output not mapping to correct tab

    Posted Fri March 31, 2023 12:37 PM

    What version of ITX was the map created in?
    (In Design Studio, you can click on Help tab and then About to find out)

    What version of ITX are you running?
    The latest version is 10.1.2.
    <bx-table-cell _ngcontent-buf-c13="" role="cell">M07KPML - </bx-table-cell><bx-table-cell _ngcontent-buf-c13="" class="dswdown-big-column" role="cell"><slot>IBM Sterling Transformation Extender Design Studio v10.1.2 - Released on </slot></bx-table-cell><bx-table-cell _ngcontent-buf-c13="" class="dswdown-column" role="cell"><slot>10/31/2022</slot></bx-table-cell>



    ------------------------------
    Rex Chan
    ------------------------------



  • 3.  RE: Excel output not mapping to correct tab

    Posted Fri March 31, 2023 12:44 PM

    Version:  10.0.0.0
    Build id: 51
    Windows 2016 server

    This map has been working fine in production but this particular information has never been included until recently.



    ------------------------------
    Steve Arbo
    ------------------------------



  • 4.  RE: Excel output not mapping to correct tab

    Posted Fri March 31, 2023 12:59 PM

    ITX 10.0.0.0 was released back in March, 2019.  It will no longer be supported by 4/30/2023 which is about a month away.   I recommend that you download 10.1.2 as listed in the previous chat.  It can be installed side by side with 10.0.0.0.  Installation only takes 10 min.  They are independent from each other as long as you use a DIFFERENT workspace. 

    My suggestion is to copy the project to the new workspace and tested it with 10..1.2.  It may fix your problem.



    ------------------------------
    Rex Chan
    ------------------------------



  • 5.  RE: Excel output not mapping to correct tab

    Posted Fri March 31, 2023 01:27 PM

    My coworker has v10.1.2.  He copied the maps to his pc and gets the same incorrect results.



    ------------------------------
    Steve Arbo
    ------------------------------



  • 6.  RE: Excel output not mapping to correct tab

    Posted Fri March 31, 2023 01:50 PM

    Can you export the project and include the input data so I can take a look on my side to see if there is any obvious mistake?   I also need to see the RIGHT output so I can compare.

    If you tell me which ITX version produces the correct result, it will be helpful.



    ------------------------------
    Rex Chan
    ------------------------------



  • 7.  RE: Excel output not mapping to correct tab

    Posted Mon April 03, 2023 01:16 PM
      |   view attached

    The export is attached.  You asked which version produces the correct results;  neither version produces the correct results.

    There are two Excel spreadsheets.
     - VA_output_complete_corrected.xlsx ==> this is what the correct output should be.
     - VA_output_complete.xlsx  ==>  this is what the map is producing.

    The tab "Step Interest Rate Change" is the one in question.  You'll notice there is a second "Step Interest Rate Change" tab at the end.

    Thank you.



    ------------------------------
    Steve Arbo
    ------------------------------

    Attachment(s)

    zip
    VA7_Claims_260.zip   1.31 MB 1 version


  • 8.  RE: Excel output not mapping to correct tab

    Posted Mon April 03, 2023 02:44 PM

    First of all, having -TV in every output card doesn't really help in debugging.  Each adapter trace overrides the last one, so only the last trace is produced.   I removed the trace option for all those after output card #26 (StepinRChg) and I can see that it's receiving the right input.

    It looks like a V10 bug to me.  When you produced the correct output in the older version, are you running in V9.0.3?

    <936-5016-04/03/23 13:21:05>: File            | VA_output_complete.xlsx
    <936-5016-04/03/23 13:21:05>: Worksheet       | Step Interest Rate Change
    <936-5016-04/03/23 13:21:05>: Template        | VA_output_complete.xlsx
    <936-5016-04/03/23 13:21:05>: Excel Format    | false
    <936-5016-04/03/23 13:21:05>: Trace file      | m4excel.mtr
    <936-5016-04/03/23 13:21:05>: Trace append    | false
    <936-5016-04/03/23 13:21:05>: Trace error     | false
    <936-5016-04/03/23 13:21:05>: Trace verbose   | true
    <936-3956-04/03/23 13:21:05>: Map instance number is: 2
    <936-3956-04/03/23 13:21:05>: [beginTransaction]
    <936-3956-04/03/23 13:21:05>: [beginTransaction] (rc = 0) OK
    <936-3956-04/03/23 13:21:05>: [put]
    <936-3956-04/03/23 13:21:05>: | Excel document data received from the map follows: 34 bytes
    2|123456789999|09/01/2021|3.0000
    <936-3956-04/03/23 13:21:07>: | Parsing map data for creating an Excel document...
    <936-3956-04/03/23 13:21:07>: | Row: 1  <No Data>
    <936-3956-04/03/23 13:21:07>: | Row: 2  Column data follows...
    <936-3956-04/03/23 13:21:07>: | Column: 1  Cell Value: 123456789999
    <936-3956-04/03/23 13:21:07>: | Column: 2  Cell Value: 09/01/2021
    <936-3956-04/03/23 13:21:07>: | Column: 3  Cell Value: 3.0000


    ------------------------------
    Rex Chan
    ------------------------------



  • 9.  RE: Excel output not mapping to correct tab

    Posted Mon April 03, 2023 02:49 PM

    No version has ever produced the correct output when the Step Interest Rate Change data is sent in the xml file.  This is the first time since implementing the map last year.



    ------------------------------
    Steve Arbo
    ------------------------------



  • 10.  RE: Excel output not mapping to correct tab

    Posted Tue April 04, 2023 11:01 AM

    My co-worker figured it out.  The name in the Excel tab had a space at the end of it and the name in the output card did not have a space.  Once we deleted the space in the tab name the map worked correctly.



    ------------------------------
    Steve Arbo
    ------------------------------



  • 11.  RE: Excel output not mapping to correct tab

    Posted Tue April 04, 2023 12:31 PM

    I am glad you found the problem, that would be a difficult one to troubleshoot.



    ------------------------------
    Rex Chan
    ------------------------------