Tag Archives: SI mapping

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. Continue reading

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. Continue reading

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. Continue reading

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. Continue reading

Generating a DDF Layout from IDoc

Purpose

This document will discuss how Gentran Integration Suite uses the SAP Meta Data Builder to generate a Data Definition File (DDF) from an IDoc layout.  This functionality saves time by generating the IDoc layout in a format that can be imported into the Map Editor so users do not have to create the IDoc layout by hand. Continue reading

EDI B2B Integration

EDI or DIE

EDI…or…DIE..!

Electronic data interchange (EDI), as the name implies, is a method of electronic information exchange between two business entities. It involves the usage of computer networks and related software to transmit information related to businesses. Continue reading

edi integration

Inhouse or Outsource EDI

In-House or Outsource….it’s a question that almost every company has to answer at one time or another regardless of your size. When we look at the options it can be overwhelming, but what are the true pros and cons of keeping your EDI In-house or outsourcing? Continue reading

edi integration

How EDI Is Jumping Through New Hoops

In the age of the web, most likely EDI is an idea whose time has gone? Not really, there’s life in the old pooch yet as it discovers ways… Continue reading