SI_Examples

Sterling Integrator examples like bpml, user exits, java code, extended rules codes, XSLT or any other type of code used in SI.
Mirjana's picture

Google Translator - Custom Service

Submitted by Mirjana on Thu, 04/21/2011 - 13:52
Note: Prerequisite is to have MESA Developer Studio installed!!!
 
In MESA Developer Studio SDK, you have access to certain java classes for use in creating custom services and adapters. You can find detailed information about each class in the MESA Studio javadocs,
which are located in the install_dir/install/studiodocs folder of your application installation. The classes are grouped by functional area:
 
• ASI (Application Server Independence)
• IFC (Integration Framework Collection)
• AFC (Application Framework Collection)
 
The MESA Developer Studio SDK is designed as an Eclipse plugin and is installed locally on your computer. Use the SDK to create a service, build and export a service package within the Eclipse development environment, then install and test it with the application.
 
Start MESA Developer Studio SDK
 
Launch Eclipse >> Window menu >> Open Perspective >> Other >> MESA Developer Studio SDK
 
If this is the first time you have launched SDK, you are asked to enter licensing information.
• Hostname – the application server name
• Webdav Port - WebDAV port number for your application server
• Name - descriptive name for this instance
• Username - application username
• Password - password for your username
 
>> Click Finish
 
Create a new SDK project
 
New >> Project … >> MESA Developer Studio >> MESA Developer Studio SDK Project
 
  
 
Write the name of the project:
 
 
 
 
 
 
 
 
Here is the package and structure created in eclipse:
 
 
Add a business logic (2 ways)
 
  1. Show Window menu >> Show View >> Other >> General >> Tasks
 
 
TODO will appear in the right side in Tasks and you can double click on it and start implementing your code
 
 
 
  1. In the Package Explorer, under src > com.mypackage, find the folder called yourservicenameImpl.java, and doubleclick it.
 
You can go to method processData
 
 
 
The code for the project will be displayed in the Eclipse editor. Find the line “// TODO: Start here to implement the service logic.”
 
 
We will add a custom code here a little bit later.
 
First we will add google translator package (google-api-translate-java-0.92.jar) into the path.
 
Right click in the package >> Build Path >> Configure build path ... >> Libraries tab >> Add External JARs ... add google-api-translate-java-0.92.jar (or any newer version you can find at http://code.google.com/p/google-api-translate-java/ )
 
 
 
Available languages in google translator:
 
 
Define parameters:
 
Package Explorer >> project (e.g. googleTranslator) >> servicedefs >> [service name].xml >> right click … Open With … Service Definition Editor
 
 
Creating parameters:
 
Right click on any and/or every parameter group type and select New Group
 
Creating variable in any of parameters group:
 
Right click on a group title and select New Vardef
 
We chose select HTML type for every language and languauges options, and added 3 languages in Options as you can see below:
 
 
 
 
 
Change service label name
 
Package Explorer >> project (e.g. googleTranslator) >> ui >> properties >> lang >> en [project]_en.properties (e.g. googleTranslator_en.properties)
 
#
# googleTranslator Language File
#
# SERVICESDK_GUID=MIRJANA.F4bd107b8.12ebe36c477.F8000
 
googleTranslator.label.MIRJANA.F4bd107b8.12ebe36c477.F8000=googleTranslator
googleTranslator.description.MIRJANA.F4bd107b8.12ebe36c477.F8000=Theserviceimplements...
 
  
Import google translator packages into code:
 
package com.mypackage;
 
import java.text.MessageFormat;
 
import com.sterlingcommerce.woodstock.services.IService;
import com.sterlingcommerce.woodstock.services.XLogger;
import com.sterlingcommerce.woodstock.workflow.WorkFlowContext;
import com.sterlingcommerce.woodstock.workflow.WorkFlowException;
 
import com.google.api.GoogleAPI;
import com.google.api.translate.Language;
import com.google.api.translate.Translate;
 
  
Variable declaration:



private String srcDocString = null;
 
      private String sourceLanguage = null;
      private String targetLanguage = null;
      private String translatedText = null;
 
      private Document document;
      private InputStream inputStream;
      private OutputStream outputStream;
     
      private BufferedInputStream bis;
      private BufferedOutputStream bos;
           
      String chunk = null;
 
Service code:
 
// TODO: Start here to implement the service logic
                 
                  sourceLanguage = wfc.getParm("Source Language").toString();           
                  targetLanguage = wfc.getParm("Target Language").toString();
                 
                  if (sourceLanguage == null) {
                        wfc.setBasicStatus(1);
                        wfc.setAdvancedStatus("Source Language was not chosen. It is a required parameter!");
                        log.logError("Missing sourceLanguage parameter ...");
                        thrownew WorkFlowException("Missing parameter");
                  }
                 
                 
                  if (targetLanguage == null) {
                        wfc.setBasicStatus(2);
                        wfc.setAdvancedStatus("Target Language was not chosen. It is a required parameter!");
                        log.logError("Missing targetLanguage parameter ...");
                        thrownew WorkFlowException("Missing parameter");
                  }
                  Document srcDoc = wfc.getPrimaryDocument();
                 
                 
                  if (srcDoc == null) {
                        wfc.setBasicStatus(3);
                        wfc.setAdvancedStatus("Primary Document is missing. This service requires the primary Document!");
                        log.logError("Missing PrimaryDocument ...");
                        thrownew WorkFlowException("Missing PrimaryDocument");
                  }
                  inputStream = srcDoc.getInputStream();
                  bis = new BufferedInputStream(inputStream);
                  byte[] buffer = newbyte[1024];
                  int bytesRead = 0;
                
                 //Keep reading from the file while there is any content
                 //when the end of the stream has been reached, -1 is returned
                 while ((bytesRead = bis.read(buffer)) != -1) {
                    
                     //Process the chunk of bytes read
                     //in this case we just construct a String and print it out
                     chunk = new String(buffer, 0, bytesRead);
                 }
                
                 System.out.println("MIRJANA GOOGLE TRANSLATION ... chunk --> " + chunk);
           
           
                 
                 
                  GoogleAPI.setHttpReferrer("http://code.google.com/p/google-api-translate-java/");
                  try {
                        translatedText = Translate.execute(chunk, Language.valueOf(sourceLanguage), Language.valueOf(targetLanguage));
                        } catch (Exception ex) {
                        ex.printStackTrace();
                        }
                 
                        document = wfc.newDocument();
                        outputStream = document.getOutputStream();
                       
                        bos = new BufferedOutputStream(outputStream);
                        bos.write(translatedText.getBytes());
                       
                        System.out.println("MIRJANA GOOGLE TRANSLATION ... translatedText --> " + translatedText);
                       
                        wfc.setAdvancedStatus("Translated!");
                        wfc.setBasicStatus(000);
                       
                        bos.close();
                        wfc.putPrimaryDocument(document);
 
Build a service package
 
>> select the project you want to export in the Package Explorer
>> Right-click and select Export
>> In the Export window, select Mesa Studio > Service Packages as the export destination and
click Next
>> Browse to select the destination directory
>> Click Finish. The service package service name_version.jar is built and placed in the selected package folder/service name/dist/service name folder
 
The service is now ready to be installed into the application.
 
Install and run the service in an application test instance
 
>> MESA Studio perspective >> choose the application instance where the service will be Installed >> Right-click and choose Install Service Package
>> Browse and select the package file. Click Open
>> Click Finish to begin the installation of the service on the application instance
>> After the service package is installed, restart the application instance
>> Log in to the application and ensure that the service definition can be viewed and configured by using the options available from the Deployment > Services > Configuration screen
 
Service in a BP
 
 
 
  • This is what the find command found for all “Google files” in SI system:
 
[si@lin2 install]$ find . -name *oogle*
./properties/services/googleTranslator.xml
./properties/lang/en/googleTranslator_en.properties
./noapp/deploy/dashboard/webapp/search/images/google.gif
./noapp/deploy/dashboard_OLD/webapp/search/images/google.gif
./installed_data/patch/components/gis/components/neo/exploded_wars/dash
./installed_data/gis/components/neo/exploded_wars/dashboard/search/imag
./installed_data/GoogleTranslator_CustomService
./installed_data/GoogleTranslator_CustomService/ui/properties/lang/en/g
./installed_data/GoogleTranslator_CustomService/servicedefs/googleTrans
./installed_data/GoogleTranslator_CustomService/jars/GoogleTranslator_C
./installed_data/GoogleTranslator_CustomService/jars/GoogleTranslator_C                 stomService_3000.0.0.jar
./packages/GoogleTranslator_CustomService_3000.0.0.jar
 
 
  • Removing the services that we do not need any more:
 
1. Delete all configurations for the adapter you want to delete from the application.
 
2. Stop GIS.
 
3. A Directory structure with sub directories will have been created under the [SI_Install_Folder]/installed_data directory.
 
The directory name is the same as the name of the *.jar file installed. Remove the entire directory structure created.
 
Example:
 
rm -r GoogleTranslator_CustomService/
 
 
4. Remove the *.jar file from [SI_Install_Folder]/jar/si/version ?!?!
 
Could not find ‘si’ folder in UNIX/Linux system, but only ‘packages’!!!
 
Note 1:
  • Windows system contains package for custom service in [SI_Install_Folder]/installed_data,
[SI_Install_Folder]/jar/si/[Service_Version] and
[SI_Install_Folder]/packages
 
  • UNIX system contains custom service package in [SI_Install_Folder]/installed_data,
[SI_Install_Folder]/jar/[Service_Name]/[Service_Version]  and [SI_Install_Folder]/packages
 
UNIX: Found the package in jar directly, not under jar/si!!!
 
/si/si50-2/install/jar/GoogleTranslator_CustomService
 
Example:
 
rm GoogleTranslator_CustomService_3000.0.0.jar
 
Note 2: To be sure where the package is, you can make a note of the path referring to the *.jar file in dynamicclasspth.cfg and dynamicclasspth.cfg.in and remove the *.jar from the specified file system location.
 
Remove the *.jar file from the directory [SI_Install_Folder]/packages.
 
5. Remove the entries referring to the *.jar file in dynamicclasspth.cfg and dynamicclasspth.cfg.in
 
6. Remove the corresponding entry from the GIS database table service_def to avoid future issues with another custom service being imported with the same name.
 
7. Start GIS again.
 
Mirjana's picture

Google Translator - User Exit, used in Translation Map

Submitted by Mirjana on Thu, 04/21/2011 - 13:31
Creating User Exit for Google Translator
 
Steps to do:
 
  • Download java api (package) for google translation
  • Install google translation package in SI system
  • Write user exit code
  • Compile and pack user exit code
  • Install user exit in SI system
  • Write the map that will use the user exit
 
1. Download google-api-translate-java-0.92.jar or newer that can be found at
 
 
Note: Be careful with google translator API version and java version used by SI. I think for GIS/SI versions that uses java 1.5 we should use Google Translator 0.92 and SI system that uses java 1.6, we should take Google Translator 0.95!
 
2. Install the jar with install3rdParty.sh/cmd script in SI system
 
SI_Install_Folder/bin/install3rdParty.cmd GoogleTranslator 0_92 -j /path_To_Jar/google-api-translate-java-0.92.jar
 
You will be able to find the jar file in
  • SI_Install_Folder/jar/GoogleTranslator/0_92/
  • Also, you will see the following line in the end of dynamicclasspath.cfg file:
 
 
3. Java code for user exit (GoogleTranslation.java)
 
package google.translation;
 
import com.google.api.GoogleAPI;
import com.google.api.translate.Language;
import com.google.api.translate.Translate;
 
         public class GoogleTranslation {
                   public String trans(String str, String sourceLanguage, String targetLanguage) {
                            String translatedText = new String();
                            GoogleAPI.setHttpReferrer("http://code.google.com/p/google-api-translate-java/");
                            try {
                                      translatedText = Translate.execute(str, Language.valueOf(sourceLanguage), Language.valueOf(targetLanguage));
                                      System.out.println(translatedText);
                                      } catch (Exception ex) {
                                      ex.printStackTrace();
                                      }
                                      return translatedText;
                  
         }
         }
4. Compile GoogleTranslation.java into GoogleTranslation.class
 
Compilation can be done with a proper version of java in eclipse or in the command line.
 
 
SI_Install_Folder/jdk/bin/javac /path_To_Java_Code/GoogleTranslation.java
 
… or …
 
C:\temp>c:\SterlingCommerce\MEFG_43\jdk\bin\javac -classpath c:\temp\google-api-translate-java-0.92.jar GoogleTranslation.java
 
GoogleTranslation.class should be created in the folder in which you have run the command.
 
5. Pack the class file into jar
 
  • Place the class file under package folder (google/translation)
  • Change directory to parent folder of ‘google’
  • SI_Install_Folder/install/jdk/bin/jar cvf GoogleTranslation.jar google
 
GoogleTranslation.class, in package (jar), must be under google\translation path, that means in the package defined in code.
 
 
 
6. Install GoogleTranslation.jar at SI system
 
 
SI_Install_Folder/bin/install3rdParty.cmd UserExit 1_0 -j /path_To_Jar/GoogleTranslation.jar
 
 
After installing google translate api (google-api-translate-java-0.92.jar) and GoogleTranslator.jar package as a User Exit, you can also find the following lines in dynamicclasspath.cfg (SI_Install_Folder/properties folder):
 
VENDOR_JAR=C:\SterlingCommerce\MEFG_43\jar\GoogleTranslator\0_92\google-api-translate-java-0.92.jar
VENDOR_JAR=C:\SterlingCommerce\MEFG_43\jar\UserExit\1_0\GoogleTranslation.jar
 
  • Restart GIS/SI system!!!
 
7. Google translation in Translation map
 
  • Extended rule in a #field:
 
///////////////////////////////////
 
object obj;
String[50] sourceLanguage;
String[50] targetLanguage;
 
obj = new("google.translation.GoogleTranslation");
 
sourceLanguage = "ENGLISH";
targetLanguage = "CROATIAN";
 
#word = obj.trans(#word,sourceLanguage,targetLanguage);
 
///////////////////////////////////
 
 
 
  • Input file:
 
Welcome to the World of Integration.
Wish you a nice day!
 
Different results for translation to CROATIAN, SPANISH and GERMAN languages:
 
  • Result of translation (from ENGLISH to CROATIAN langugae):



Dobro došli u svijet integracije.                                                                   
Želimo vam lijep dan!
 
(For specific Croatian characters I added 0x00 – 0xFF range in X Syntax Token and also set Encodings at both sides of the map to Cp1250 - Windows Eastern European)
 
  • Result of translation (from ENGLISH to SPANISH language):
 
////////////////////////////////
...
sourceLanguage = "ENGLISH";
targetLanguage = "SPANISH";
...
////////////////////////////////
 
Bienvenido al mundo de la integración.                                                             
Deseamos un buen día!                                                                              
 
  • Result of translation (from ENGLISH to GERMAN language):
 
////////////////////////////////
...
sourceLanguage = "ENGLISH";
targetLanguage = "GERMAN";
...
////////////////////////////////
 
Willkommen in der Welt von Integration.                                                            
Wünsche dir einen schönen Tag!                                                                     
 
8. Uninstall/Remove User Exit
 
  • Remove GoogleTranslation.jar from SI_Install_Folder/jar/User Exit/1_0, or remove the whole UserExit folder if there is nothing you need from it any more
  • Remove google-api-translate-java-0.92.jar SI_Install_Folder/jar/GoogleTranslator/0_92 or remove the whole GoogleTranslator folder if you do not need it any more
  • Remove the lines from dynamicclasspath.cfg file that reference to these packages, mentioned in the previous steps
 
Mirjana's picture

FTP List Service - different list from file system depending on settings

Submitted by Mirjana on Tue, 04/19/2011 - 06:00
/home4/worldoh9/tmp/testFolder/folder
 
-- testFolder       -- a.txt
                            -- b.txt
folder
-- c.txt
-- d.txt
 
Result of ftp/dir command from cmd:
 
 
·        Bp – RemoteFileName (FTP Client LIST Service) -> *.*
 
 
o       Result of FTP Client LIST Service:
 
NamesOnly -> No
 
 
 
 
 
 
 NamesOnly -> Yes
 
 
 
 
 
 
·        BP – RemoteFileName (FTP Client LIST Service) -> * or empty
 
 
 
o       Result of FTP Client LIST Service:
 
NamesOnly -> No
 
 
 
 
NamesOnly -> Yes
 
 

Mirjana's picture

OFTP flow and test processing in SI

Submitted by Mirjana on Wed, 04/13/2011 - 02:48
1. Main steps for starting with OFTP:
 
 
·        Configure OdetteFTP Adapter
·        Create OFTP Profile
o        Physical Partner - LOCAL
o        Physical Partner – REMOTE
o        Logical Partner – ORIGINATOR
o        Logical Partner - DESTINATION
o        Physical Partner Contract
o        Logical Partner Contract
·        Create/modify template process for adding a FILE/EERP/NERP to OFTP table in database (oftpfile/oftpeerp/oftpnerp), by OFTPQueue Handler Service.
·        Create and run/schedule the process that will check if there is anything to send, by comparing PPC (Physical Partner Contract) initiate OFTP communication. That can be oftpcheckmessages BP, with OFTPScheduler Adapter.
·        Create/modify template process for initiating OFTP communication between partners. That BP name is written in Initiator Business Process Name parameter of PPC, and oftpinitsession can be used.
 

 

2. Profile creation
 
Physical Partner - PartnerA:
 
 
Physical Partner - PartnerB:
 
 
PPC:
 
 
Logical Partner – L_PartnerA:
 
 
 
Logical Partner – L_PartnerB:
 
 
 
LPC:
 
 
3. OFTP in SI - diagram
 
 
Note: A part II can be skipped, as we can put the file in OFTP storage as shown in a part I, and run it manually as shown in the part III. The whole flow is for automatic procedure.
 
Explanation of all the steps from diagram:
 
 
·        BPML code:
 
<process name="myOftpfile">
   <sequence name="send">
      <assign to="LogicalPartnerContract" from="'LPC_PartnerA_PartnerB'"/>
      <assign to="filename">dataitem1.dat</assign>     
      <assign to="Date">060825</assign>
      <assign to="Time">153055</assign>
 
      <operation name="CreateFILEStructure">
         <participant name="AssignService"/>
         <output message="DataItemOut">            
            <assign to="OFTPDataItem/FILE/document" from="PrimaryDocument"/>           
            <assign to="OFTPDataItem/FILE/properties/LogicalPartnerContract" from="LogicalPartnerContract/text()"/>           
            <assign to="OFTPDataItem/FILE/properties/OFTPVirtualFilename" from="filename/text()"/>
            <assign to="OFTPDataItem/FILE/properties/Date" from="Date/text()"/>
            <assign to="OFTPDataItem/FILE/properties/Time" from="Time/text()"/>
            <assign to="OFTPDataItem/FILE/properties/FileFormat" from="FileFormat/text()"/>          
            <assign to="." from="*"/>
         </output>
         <input message="toProcessData">
            <assign to="." from="*"/>
         </input>
      </operation>
 
      <!-- Queue document for OFTP send process -->
      <operation name="QueueFile">
         <participant name="OFTPQueueHandler"/>
 
         <output message="OFTPOut">
            <assign to="." from="*"/>           
         </output>
 
         <input message="OFTPIn">
            <assign to="." from="*"/>           
         </input>
      </operation>
   </sequence>
</process>
 
  • Process Data after OFTPQueueHandler:
 
<?xml version="1.0" encoding="UTF-8"?>
<ProcessData>
          <PrimaryDocument SCIObjectID="MIRJANA:node1:12f4dbd1146:26471"/>
          <LogicalPartnerContract>LPC_PartnerA_PartnerB</LogicalPartnerContract>
          <filename>dataitem1.dat</filename>
          <Date>060825</Date>
          <Time>153055</Time>
          <OFTPDataItem>
                   <FILE>
                             <document>
                                      <PrimaryDocument SCIObjectID="MIRJANA:node1:12f4dbd1146:26471"/>
                             </document>
                             <properties>
                                      <LogicalPartnerContract>LPC_PartnerA_PartnerB</LogicalPartnerContract>
                                      <OFTPVirtualFilename>dataitem1.dat</OFTPVirtualFilename>
                                      <Date>060825</Date>
                                      <Time>153055</Time>
                             </properties>
                   </FILE>
          </OFTPDataItem>
</ProcessData>
 
 Record written to a database (OFTP_OBJECT & OFTP_OBJECT_EXT)
 
 
<?xml version="1.0" encoding="UTF-8"?>
<ROWSET>
          <ROW>
                   <EVENT_ID>3</EVENT_ID>
                   <TYPE>FILE</TYPE>
                   <STATUS>SCHEDULED</STATUS>
                   <WFC_ID>MIRJANA:node1:12f4859ecf9:264726</WFC_ID>
                   <MESSAGE_ID>0</MESSAGE_ID>
                   <DOCUMENT_ID>MIRJANA:node1:12f4859ecf9:264681</DOCUMENT_ID>
                   <LPC>LPC_PartnerA_PartnerB</LPC>
                        <PPC>PPC_PartnerB_PartnerA</PPC>
                   <SFIDDSN>dataitem1.dat</SFIDDSN>
                   <SFIDDATE_TIME>2006-08-25 15:30:55.0</SFIDDATE_TIME>
                   <SFIDTIMEC>2</SFIDTIMEC>
                   <SFIDUSER/>
                   <SFIDDEST>admin</SFIDDEST>
                   <SFIDORIG>mirjana</SFIDORIG>
                   <NERPCREA>null</NERPCREA>
                   <SFIDFMT>T</SFIDFMT>
                   <SFIDLRECL>0</SFIDLRECL>
                   <SFIDFSIZ>21504</SFIDFSIZ>
                   <SFIDREST>0</SFIDREST>
                   <NERPREAS>null</NERPREAS>
                   <DELIMITERS>-01-01</DELIMITERS>
                   <RETRY_COUNT>0</RETRY_COUNT>
                   <CREATE_TIME>2011-04-12 12:48:48.0</CREATE_TIME>
                   <UPDATE_TIME>2011-04-12 12:48:48.0</UPDATE_TIME>
                   <RETRY_TIME>null</RETRY_TIME>
                   <OBJECT_LOCK>U</OBJECT_LOCK>
                   <EXTENSION_POINT>301989888</EXTENSION_POINT>
          </ROW>
</ROWSET>
 
 Run manually or schedule oftpcheckmessages
 
Run it manually (normally should be scheduled)
 
 Provide OFTPPPCName to OdetteFTP Scheduler Adapter in oftpcheckmessages
 
·        BPML code:
 
<process name="oftpcheckformessages">
   <sequence name="check">
 
<assign to="OFTPPPCName">PPC_PartnerA_PartnerB</assign>   
     
<operation name="CheckForOFTPMessages">
         <participant name="OFTPScheduler"/>
         <output message="DataSetOut">
            <assign to="." from="*"/>
         </output>
         <input message="toProcessData">
            <assign to="." from="*"/>
         </input>
      </operation>
   </sequence>
</process>
 
 Matching PPC with database
 
If there is match between PPC (OFTPPPCName) and PPCs in a database, then Initiator Business Process (oftpinitsession) is run by OFTPScheduler.
If OFTPActionType in OdetteFTPScheduler Adapter is Conditional, Initiator BP will be run only if there is match between PPCs, but if it is Uncoditional, Initiator BP will be run regardless of matching PPCs.
 
 oftpinitsession
 
·        BPML code:
 
<process name="oftpinitsession">
          <sequence name="oftp">
                   <!-- Start OFTP send process in Mailbox Mode-->
                   <operation name="SendOFTP">
                             <participant name="myOdetteFTP"/>
                             <output message="Out">
                                      <assign to="." from="*"/>
                             </output>
                             <input message="In">
                                      <assign to="." from="*"/>
                             </input>
                   </operation>
          </sequence>
</process>
 
 
 
  • Process Data transferred to OdetteFTPAdapter (myOdetteFTP) is:
 
<?xml version="1.0" encoding="UTF-8"?>
<ProcessData>
          <PhysicalPartnerContract>PPC_PArtnerA_PartnerB</PhysicalPartnerContract>
</ProcessData>
 
 
 
Note:with preconfigured OdetteFTPAdapter configuration (i.e. OFTPSendFile), oftpinitsession cannot be run, although there is match between PPC given to OdetteFTPScheduler Adapter and database. When I create custom configuration of OdetteFTP Adapter (myOdetteFTP), it started to work!!!
 
 
 oftpin
 
·        BPML code:
 
<process name="oftpin">
          <rule name="is-FILE">
                   <condition>
                  ( OFTPInbound/Type/text() = 'File')
         </condition>
          </rule>
          <rule name="is-EERP">
                   <condition>
                  ( OFTPInbound/Type/text() = 'EERP')
         </condition>
          </rule>
          <rule name="is-NERP">
                   <condition>
                  ( OFTPInbound/Type/text() = 'NERP')
         </condition>
          </rule>
          <sequence name="receive">
                   <!-- Check type of inbound -->
                   <choice name="Choice Start">
                             <select>
                                      <case ref="is-FILE" activity="processFILE"/>
                                      <case ref="is-EERP" activity="processEERP"/>
                                      <case ref="is-NERP" activity="processNERP"/>
                             </select>
                             <sequence name="processFILE">
                                      <!-- Add your business logic for processing inbound files, e.g. call EDIDeenvelope -->
                                      <operation>
                                                <participant name="EDIDeenvelope"/>
                                                <output message="ediout">
                                                          <assign to="." from="*"/>
                                                </output>
                                                <input message="ediin"/>
                                      </operation>
                             </sequence>
                             <sequence name="processEERP">
                                      <!-- Add your business logic for processing inbound EERPs -->
                                      <assign to="key" from="concat(OFTPInbound/FileName/text(),
                                       OFTPInbound/Date/text(),
                                       OFTPInbound/Time/text())"/>
                                      <assign to="status" from="'SUCCESS'"/>
                             </sequence>
                             <sequence name="processNERP">
                                      <!-- Add your business logic for processing inbound NERPs -->
                                      <assign to="key" from="concat(OFTPInbound/FileName/text(),
                                       OFTPInbound/Date/text(),
                                       OFTPInbound/Time/text())"/>
                                      <assign to="status" from="'ERROR'"/>
                             </sequence>
                   </choice>
          </sequence>
</process>
 
 
 
  • Process Data after oftpin:
 
<?xml version="1.0" encoding="UTF-8"?>
<ProcessData>
          <PrimaryDocument SCIObjectID="MIRJANA:node1:12f4dbd1146:11419"/>
          <OFTPInbound>
                   <FileName>dataitem1.dat</FileName>
                   <Type>File</Type>
                   <FileSize>266</FileSize>
                   <Destination>admin</Destination>
                   <Time>1530550001</Time>
                   <Originator>mirjana</Originator>
                   <Date>20060825</Date>
                   <FileFormat>T</FileFormat>
          </OFTPInbound>
</ProcessData>
 

 

Mirjana's picture

Conditional XPath

Submitted by Mirjana on Mon, 03/28/2011 - 02:41

Example of condition in XPath that can be used instead of bpml condition. Much shorter and simpler.

<assign to="result" from="if(urgent_ind/text() = 1,'U','N')"></assign>

 

SI User Authentication in Custom Web Application

Submitted by Pankaj.Sachdeva on Sun, 03/20/2011 - 12:50
Problem:
 
If you want to develop custom Web Application that will run on GIS Web Server & you want to provide GIS level authentication to your custom web application?
 
Problem Resolution:  Please follow the following steps 
  1. Include the JSP tag Library “userautho.tld” into your application WEB-INF folder. You can find this tld file at
<GIS Installation Folder>\SI\container\Applications\helloworld\WEB-INF\tld
 
  1. Add this taglib into your application by adding the following code into your application web.xml file
    <taglib>
        <taglib-uri>http://www.stercomm.com/uix/security</taglib-uri>
        <taglib-location>tld/userautho.tld</taglib-location>
    </taglib>
 
  1. Import this tag library into your JSP page using the following statement on top of JSP page
<%@ taglib uri='http://www.stercomm.com/uix/security' prefix='sec' %>
 
  1. Add the following code into your login jsp page
 
<sec:authenticate user="<%=strUser%>" pass="<%=strPass%>" login="error.jsp " />
            
Where "<%=strUser%>" & "<%=strPass%>" are the User Id & Password entered by user in Login page & error.jsp is the page which will be shown if user authentication failed.
Mirjana's picture

Run a BP from a map

Submitted by Mirjana on Fri, 03/11/2011 - 04:00

This is just an info of how to run a BP from the map.

Example 1:

object BPLauncher;
integer i;

BPLauncher = new("com.sterlingcommerce.woodstock.dmi.routing.BPLauncher","BPname");

i = BPLauncher.run();

Note: Of course it is better to control if a BP is run or invoke by the service in a BP!!!

Example 2:

(pass the value - #KEY, to a Process Data)

object BPLauncher;
integer i;

BPLauncher = new("com.sterlingcommerce.woodstock.dmi.routing.BPLauncher","VC_om_autoReplay_runPerMsg");
BPLauncher.addContentElement("KEY",#KEY);
i = BPLauncher.run();

Mirjana's picture

Pull a part of Process Data by XSLT

Submitted by Mirjana on Tue, 03/08/2011 - 05:36
Request: get a specific Output from the following Process Data
 
<ProcessData>
          <OUTPUT>
                   <Data>
                             <naziv>STAVKA1</naziv>
                             <kolicina>2</kolicina>
                             <cijena>10.20</cijena>
                             <uk_cijena>20.40</uk_cijena>
                             <produkt_ID>123</produkt_ID>
                             <adresa>Heinzelova 1</adresa>
                   </Data>
                   <Data>
                             <naziv>STAVKA2</naziv>
                             <kolicina>3</kolicina>
                             <cijena>15.10</cijena>
                             <uk_cijena>45.30</uk_cijena>
                             <produkt_ID>234</produkt_ID>
                             <adresa>Heinzelova 2</adresa>
                   </Data>
                   <Data>
                             <naziv>STAVKA3</naziv>
                             <kolicina>5</kolicina>
                             <cijena>12.41</cijena>
                             <uk_cijena>62.05</uk_cijena>
                             <produkt_ID>345</produkt_ID>
                             <adresa>Heinzelova 3</adresa>
                   </Data>
          </OUTPUT>
</ProcessData>
 
Output:
 
<ENABLED>
<naziv>STAVKA1</naziv>
          <produkt_ID>123</produkt_ID>
</ENABLED>
<ENABLED>
          <naziv>STAVKA2</naziv>
          <produkt_ID>234</produkt_ID>
</ENABLED>
<ENABLED>
          <naziv>STAVKA3</naziv>
          <produkt_ID>345</produkt_ID>
</ENABLED>
 
XSLT:
 
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
          <xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>
          <xsl:template match="/">
                   <ROOT>
                             <xsl:for-each select="//Data">
                                      <xsl:element name="ENABLED">
                                                <xsl:element name="naziv">
                                                          <xsl:value-of select="naziv/text()"/>
                                                </xsl:element>
                                                <xsl:element name="produkt_ID">
                                                          <xsl:value-of select="produkt_ID/text()"/>
                                                </xsl:element>
                                      </xsl:element>
                             </xsl:for-each>
                   </ROOT>
          </xsl:template>
</xsl:stylesheet>
 
BPML – XSLT Service configuration (result goes to PrimaryDocument):
 
…
<operation name="XSLT Service">
          <participant name="XSLTService"/>
          <output message="XSLTServiceTypeInputMessage">
                   <assign to="." from="*"/>
                   <assign to="input_pd_xpath">/</assign>
                   <assign to="xml_input_from">ProcData</assign>
                   <assign to="xslt_name">TEST_ProcessData_pull</assign>
          </output>
          <input message="inmsg">
                   <assign to="." from="*"/>
          </input>
</operation>
…
 
Result in the Primary Document:
 
PrimaryDocument
 
Process Name: TEST_ProcessData_pull     Instance ID: 1342884
Service Name: XSLTService
Document Name: xslt_result      Document Store: Database 
Document ID: 911:7252702:12e71919a89:lin2:node1 
Document in process data:   text/xml 
 
<?xml version="1.0" encoding="UTF-8"?>
<ROOT>
          <ENABLED>
                   <naziv>STAVKA1</naziv>
                   <produkt_ID>123</produkt_ID>
          </ENABLED>
          <ENABLED>
                   <naziv>STAVKA2</naziv>
                   <produkt_ID>234</produkt_ID>
          </ENABLED>
          <ENABLED>
                   <naziv>STAVKA3</naziv>
                   <produkt_ID>345</produkt_ID>
          </ENABLED>
</ROOT>
 
 
Assign for moving it back to the ProcessData:
 
<assign to="." from="DocToDOM(PrimaryDocument)/*"></assign>
 
Result in the Process Data after the last assign:
 
<?xml version="1.0" encoding="UTF-8"?>
<ProcessData>
          <OUTPUT>
                   <Data>
                             <naziv>STAVKA1</naziv>
                             <kolicina>2</kolicina>
                             <cijena>10.20</cijena>
                             <uk_cijena>20.40</uk_cijena>
                             <produkt_ID>123</produkt_ID>
                             <adresa>Heinzelova 1</adresa>
                   </Data>
                   <Data>
                             <naziv>STAVKA2</naziv>
                             <kolicina>3</kolicina>
                             <cijena>15.10</cijena>
                             <uk_cijena>45.30</uk_cijena>
                             <produkt_ID>234</produkt_ID>
                             <adresa>Heinzelova 2</adresa>
                   </Data>
                   <Data>
                             <naziv>STAVKA3</naziv>
                             <kolicina>5</kolicina>
                             <cijena>12.41</cijena>
                             <uk_cijena>62.05</uk_cijena>
                             <produkt_ID>345</produkt_ID>
                             <adresa>Heinzelova 3</adresa>
                   </Data>
          </OUTPUT>
          <PrimaryDocument SCIObjectID="746:7278775:12e71919a89:lin2:node1"/>
          <ENABLED>
                        <naziv>STAVKA1</naziv>
                        <produkt_ID>123</produkt_ID>
            </ENABLED>
            <ENABLED>
                        <naziv>STAVKA2</naziv>
                        <produkt_ID>234</produkt_ID>
            </ENABLED>
            <ENABLED>
                        <naziv>STAVKA3</naziv>
                        <produkt_ID>345</produkt_ID>
            </ENABLED>
</ProcessData>
 
 
 
Mirjana's picture

HTTPS configuration and process between SI and MS IIS

Submitted by Mirjana on Wed, 02/23/2011 - 22:40
I will go through settings we have to done at SI (HTTP client) and IIS (HTTP server) sides, in order to obtain HTTPS connection with server and client authentication included
 
IIS Manager:
 
 
URL that will be used in our process is:
 
https://PUTEST/mirjanaTest/test.html

 
Server Authentication
 
  • Apply Server Certificate in IIS server (for server authentication)
 
Right click on Default Web Site >> Properties >> Directory Security >> Server Certificate … add a certificate you wish.
 
  • Public key of the server certificate must be gotten from a partner and added as CA certificate in SI
 
Dashboard >> Trading Partners >>Digital Certificates >> CA >> New Certificate …  
 
Certificate checked in to the system is:
 
 
This certificate must be added to HTTP Client Begin Session Service as CACertificateID
 
 
Client Authentication
 
 
  • Certificate on SI:
 
We have to have a certificate (private – public) in the client side and its public key in the server side. After getting certificate, created by any wizard like self-signed or gotten by CA, we have to deploy it in SI system.
 
Dashboard >> Trading Partners >>Digital Certificates >> System >> Check-in
 
 
 
This certificate must be added to HTTP Client Begin Session Service as SystemCertificateId
 
 
  • Turn on client authentication on IIS side:
 
Right click on the application name that you will access to (e.g. mirjanaTest in our example) >> Properties >> Directory Security >> Secure communications >> Edit … >> Require secure channel (SSL) >> Require client certificates
 
 
  • Managinging trusted root certificates for a local computer
 
To include a root certificate in the server side, for client authentication, go to Microsoft Management Console, MMC (write mmc in Run or command prompt).
 
 
File menu >> Add/Remove Snap-in >> Add >> Certificates >> Computer account >> Local computer and open Certificates for the Local Computer
 
 
 
 
 
Go to Trusted Root Certification Authorities >> Certificates (right click) >> All Tasks >> Import … and import a new certificate (e.g. ABC)
 
 
 
BPML, server and client authentication included:
 
<process name="default">
 <sequence name="Sequence Start">
    <operation name="HTTP Client Begin Session Service">
      <participant name="HTTPClientBeginSession"/>
      <output message="HTTPClientBeginSessionServiceTypeInputMessage">
        <assign to="." from="*"></assign>
        <assign to="RemoteHost">putest</assign>
        <assign to="SystemCertificateId">MIRJANA:node1:12e4c62e17e:70732</assign>
       <assign to="HTTPClientAdapter">HTTPClientAdapter</assign>
        <assign to="CACertificateId">MIRJANA:node1:12e37c1aba0:172438</assign>
        <assign to="SSL">Must</assign>
        <assign to="RemotePort">443</assign>
        <assign to="CipherStrength">all</assign>
      </output>
      <input message="inmsg">
        <assign to="." from="*"></assign>
      </input>
    </operation>
 
    <operation name="HTTP Client GET Service">
      <participant name="HTTPClientGet"/>
      <output message="HTTPClientGetServiceTypeInputMessage">
        <assign to="." from="*"></assign>
        <assign to="SessionToken" from="SessionToken/text()"></assign>
        <assign to="URI">/mirjanaTest/test.html</assign>
      </output>
      <input message="inmsg">
        <assign to="." from="*"></assign>
      </input>
    </operation>
 
    <operation name="HTTP Client End Session Service">
      <participant name="HTTPClientEndSession"/>
      <output message="HTTPClientEndSessionServiceTypeInputMessage">
        <assign to="." from="*"></assign>
        <assign to="SessionToken" from="SessionToken/text()"></assign>
      </output>
      <input message="inmsg">
        <assign to="." from="*"></assign>
      </input>
    </operation>
 
 </sequence>
</process>
 
 

 

Mirjana's picture

Xpath - Check filename attribute after FSA multiple collect

Submitted by Mirjana on Sun, 02/20/2011 - 22:12
Request:
 
Write the rule that will check if the filename has an extension .inv or .sls, and depending on that will be extracted in a separate folders.
 
The Process Data:
 
<ProcessData>
         <BPID>5060827</BPID>
         <currentTimeMillis>1288382751118</currentTimeMillis>
         <time>20101029160511851</time>
         <loop_counter>1</loop_counter>
         <X12_ArchiveDirectory>/app/archive/</X12_ArchiveDirectory>
         <FSA_Document1 SCIObjectID="serverName:38a97b0b:12bf942739e:1144" filename="ConcatSLS2.sls"/>
         <FSA_Document2 SCIObjectID="" filename="ConcatINV2.inv"/>
         <FSA_DocumentCount>2</FSA_DocumentCount>
         <Prev_NotSuccess_Adv_Status/>
         <INVOKE_ID_LIST>5060828</INVOKE_ID_LIST>
</ProcessData>
 
 
The wrong XPath used in the rule is:
contains(string('FSA_Document',//loop_counter/text(),' ',SCIObjectID/text()), string('.sls')
 
… and it does not work!!!
 
To check if the filename attribute in FSA_Document[n] element contains ‘inv’ or ‘sls’, XPath should be like this:
 
contains(//*[name()=concat('FSA_Document',//loop_counter/text())]/@filename,'.sls')
 
That would be interpreted as:
 
… check if the attribute ’filename’ (@filename)
… inside of the element which name is FSA_Document[n] (composed dynamically by concat function)
… contains ‘.sls’ string
 
Result will be boolean, true or false, and depending on that FSA extraction folder can be set .
 
Syndicate content

Need help?

Advertisement

Library

Main Menu

SiteLock

User login

Login/Register

Tell a friend

Send an e-Postcard

New forum topics

Recent Posts Recent Posts