Command Line Adapter 2 to execute Java Code in Sterling Integrator

Using Command Line Adapter we can run a java program in a business process. We run programs, perl scripts, OS commands.
To work out this we must have JVM in the machine where Sterling integrator is installed.

To execute java program in Sterling Integrator first check the java program working or not through command with this line.

java -jar C:\Users\PDFToXML\dist\PDFToXML.jar C:\53_Map_Editor.pdf D:\data.xml
I am passing two parameters. One is input file and other one is output file.

Then write the bat file like this.
 pdftoxml.bat
java -jar C:\Users\miracle\Desktop\test\PDFToXML\dist\PDFToXML.jar %1 %2

Note: % for windows, $ for Linux

%1 is Input file %2 is Output file.

Configuring Command Line Adapter
In cmdLine option write like this
C:\Users\pdftoxml.bat $Input $Output



 Give input Name:(i.e input file path)
Give outputName(i.e Output file path)
 Make useInput and useOutput true saying that we are sending input and ouput file path.
The other requirement is we need to send primary document to this Command Line adapter. If we didn't give path for inputName (inputpath). Then Primary Document is the input for this service. Otherwise inputName(inputpath) is replaced with Primary Document.

BPML:

<process name="CommandLineAdapterSample">
  <operation name="Command Line 2 Adapter">
    <participant name="CommandLineAdapter2"/>
    <output message="CmdLine2InputMessage">
      <assign to="." from="*"></assign>
      <assign to="cmdLine">C:\Users\pdftoxml.bat $Input $Output</assign>
      <assign to="inputName">C:\53_Map_Editor.pdf</assign>
      <assign to="outputName">C:\data.xml</assign>
      <assign to="successValue">0</assign>
      <assign to="useInput">true</assign>
      <assign to="useOutput">true</assign>
    </output>
    <input message="inmsg">
      <assign to="." from="*"></assign>
    </input>
  </operation>

</process>

 It shows Success value 0 if this bp is success.


 If find any issues regarding please leave comment.

Working with Dates in IBM BPM

This the twx it calculates the age by entering the year your born. This will be good example for the usage of dates.
I am attaching document and twx.

Click for document Click for twx

Uninstalling WebSphere Enterprise Applications forcefully using JACL Script in Process Cherography

If the application not installed properly or uninstalled properly When we are deploying application we usually get Publishing error. In that case We need to Uninstall it properly to avoid publishing error.

Find the path of bpcTemplates.jacl file.

In my system it is C:\Program Files (x86)\IBM\WebSphere\AppServer\ProcessChoreographer\admin

Check the path if it is typical installation.

C:\IBM\BPM\V8.0\ProcessChoreographer\admin

1)Go to Command Prompt with administration privileges.

cd C:\Program Files (x86)\IBM\WebSphere\AppServer\ProcessChoreographer\admin

2)Then execute this command.

bpcTemplates.jacl -lang jacl -uninstall $appName -force

It will jacl file open and see whether it is succeeded or failed.

We can Check wheather it is uninstalled or not by using Adminstration console.

Go to Adminstration Console.

Click on Applications -> Websphere enterprise applications -> see your appName is uninstalled or not.

How to delete profiles:


manageprofiles -delete -profileName ProcSrv01



You can see the following link for uninstalling Process Application
Click here

Drop Down list/Select list from Database (IBM BPM 8.5)

Which deserves more than you expected.

Electroplating Mirror Iphone 5/5S and IPHONE 7 Mobile Case

Buy from Amazon:
Buy from Amazon





Creat A List Variable . For Ex: myVar(String)List
 
 Bind this variable to your Select Control in your Coach View. 







Take Script: Write a SQL Query as per your requirement.
Attach a Nested Service to execute SQL Statement.See I attached SQL Execute Statement(SQLResult).It returns result of type SQLResult.
The Business Object of SQLResult is


Take a Script and write this : Parsing which I used is SQL Parsing
tw.local.MyVar=new tw.object.listOf.String();
if(tw.local.Result[0].rows[0]!=null && tw.local.Result[0]!=null)
{
for(var i=0;i<tw.local.Result[0].rows.listLength;i++)
{
tw.local.MyVar[i]=tw.local.Result[0].rows[i].NAMES;
}
}
 







Download the twx.

https://drive.google.com/file/d/0B1OEJ8wVoN6qUkV4YUFZN05kYzA/view?usp=sharing