Scenario: You return to the scenario from the previous activity to complete the transformation: 

1.       The last name needs to be all UPPER-CASE. 

2.       Remove the Position and the Cost Center information (this shows that fields in your report need not be displayed in the resulting output file.) 

3.       ADVANCED (optional): Change from comma separated to pipe “|” separated.

Tasks to Use 

Configure Integration System 

Edit Integration Transformation 

Launch Integration System 

TASK 1 EDIT XSL TRANSFORMATION SCRIPT 

1.       Open your XSLT with a text editor, Notepad, Notepad++, Wordpad, or any text editor you are comfortable with. Do not open in a browser window. 

2.       Review the “substring” function being used on the SSN field. 

3.       Convert the string to upper case

4.       Make appropriate edits to upper-case the last name 

5.       Also, either remove or comment out (using “<!--” and “-->” comment start and end) the lines which output the Position and the Cost Center data, and anything else needed in order to remove these two columns.

6.       Save the file with a name different from the original .xsl file (such as IntNewHire_UPPER.XSL) 

TASK 2: CONFIGURE INTEGRATION SYSTEM 

1.       Edit your XSLT Attachment Transformation from the previous activity (HINT: search for “XSLT”) 

2.       Click the Attach button to locate your modified custom .xsl file 

3.       Click the OK button to save your XSLT Attachment Transformation 

4.       Click the Done button

TASK 3: LAUNCH INTEGRATION AND VIEW PROCESS MONITOR 

1.       Use the related action icon to Launch/Schedule the NewHireIntegration Integration System 

2.       Same as the previous activity, enter January 1^st, 2012 for the Start (to get more data than our 3 new hires)

3.       Enter Today’s date for the End 

4.       Click on the OK button to launch the integration 

5.       Open and review the output.

               a.       Did the last name appear in UPPER-CASE? 

b.      Did you correctly remove two of the columns?

ADVANCED (optional): 

More XSLT Practice: Change from a .csv to a .txt file, and from a comma separator “,” to a pipe separator “|” 

1.       Replace commas (“,”) with pipes (“|”) in all appropriate places

2.       Test your resulting file (if using Excel, file can be named .txt, and then open it in Excel and use the wizard to specify | delimited)