How To Perform Validation On Quantity Data Not Being Zero
Problem: Is it possible to perform validation on quantity data not being zero? (more…)
How to Perform Validation on Incoming Data
Problem: Is it possible to perform validation on incoming data? (more…)
Error in Root Put
Problem: ScriptError: Userscript "C:\Python27\lib\site-packages\bots\usersys\mappings\edifact\DESADVD96A2DELVRY03": "MappingRootError: Error in root put "{'BELNR': u'demo', 'BOTSID': u'E2EDL43000', 'QUALF': u'C', 'BOTSIDnr': u'1'}".". This writes to the root of the outgoing message, which is EDI_DC40. Normally there would be loops, getloop() and putloop(). (more…)
Grep Examples in Unix
Simple grep grep -il "ref" *201701* Where "ref" is the reference I'm looking for. The 201701 is part of the filename so it's easy to pull out messages for Jan '17 for example or, say *2017012" ... all messages in 20-29th Jan 2017. (more…)
XPATH Tutorial
XPath is a set of syntax rules for defining parts of an XML document. XPath is a major element in the W3C XSLT standard. Without XPath knowledge you will not be able to create XSLT documents. XPath is a set of syntax rules for defining parts of an XML document. What is XPath? (more…)
How To Use Indexing Rules (Example 2)
The following document explains how complex indexing works in map editor The input file is an XML IDoc file and we want to group all LOT_NUMBER fields together along with the quantity accumulated per Lot Number. The only way to do this is using indexing within the Extended Rules as shown below. (more…)
SQL Mapping – A General Note
Purpose This paper will discuss SQL (ODBC) maps and outline general information necessary to complete a SQL map. The paper will also cover the flow of the translator for outbound SQL (ODBC) Maps and how to use the components available with the SQL File Format to design a map to process the result set returned via the SQL statement defined in the map. (more…)
Selecting and Updating Process Data in SI
Storing values into process data can be really useful. However, when you “update” process data, it is an update TO process data. It is not an update OF process data. If you have multiple updates, it will create multiple entries. Multiple updates will NOT overwrite the value in process data. (more…)
Some Extended Rule Tips
Uppercase and Lowercase in mapping #stringField = new("java.lang.String",#stringField).toUpperCase(); #stringField = new("java.lang.String",#stringField).toLowerCase(); Date Difference in map extended rule object date1; object date2; date1=new("java.util.GregorianCalendar"); date2=new("java.util.GregorianCalendar"); date1.set(2008,08,01); date2.set(2008,09,31); #Number_of_days = (date2.getTimeInMillis() - date1.getTimeInMillis()) / 86400000; Using Replace Function object obj; if len(#0166:19) > 0 then begin obj = new ("java.lang.String",#0166:19); #0166:19 = obj.replace("*",""); end X-path interaction String[20] BPID; SELECT XPATHRESULT INTO BPID FROM PROCESSDATA WHERE XPATH="/ProcessData/SIFramework/SFG/WorkflowId/text()"; Customised java class calling from ER Object xref; xref = new("com.CVAM.utility.CVAMUserExits"); xref.method(parameter1,parameter2); Click below to find out more what Appleyard’s EDI Services can do for you
How to Use Indexing Rule in SI
The following document explains (hopefully) how indexing works. The input file is a flat-file and we want to group all PROD's together as shown in the OUTPUT file result. The only way to do this is using indexing within the Sterling Integrator Mapper Extended Rules. (more…)