Converting an EDI Source Containing an N1 Loop-- The sample transformation converts an EDI source file that contains an N1 loop into an ASCII Delimited target file. Using EDI X12 Iterator to Read Messages-- Break an EDI file into multiple interchanges (ISA segment through IEA segment) to permit lookup of training partner information or sending of responses for each interchange separately. Dynamic SQL Lookup with Reject Records Handling-- Return lookup values from a table in an Access database to a target file and handle rejected records in a specified manner. Dynamic SQL Lookup with Error Handling-- Return lookup values from a table in an Access database to an ASCII Fixed target file and handle errors in a specified manner. Dynamic SQL Lookup-- Return lookup values from a table in an Access database to an ASCII Fixed target file. Sometimes it is desirable or necessary to retrieve data that changes frequently. In such cases, dynamic SQL lookups serve this purpose. Working with DJRowSet and Arrays-- Use DJRowSet operations to segment text from a source file into three record types and insert the appropriate rows in the transformation target file. Complex Date Filtering-- Select a group of records filtered by a date range and write the records to a target file. Manipulating Binary Dates at the Bit Level-- Convert a date stored as a 16-bit (2 byte) binary source field to a valid date field in the target file using bit-level manipulation. Aggregating Records-- Demonstrates how to aggregate values from multiple records of a single record type. Using Buffered Put Tree to Create Hierarchical Records-- Buffer a set of records and then write the set to a file based on the hierarchical structure. Setting OnDataChange Events-- Files that are sorted by one or more data items can also be monitored for a change of data values to identify a new grouping. In this sample we group records together and perform actions on those related records. Mapping Database Records to EDI-- In this sample, we map records from a Microsoft Access database to an EDI target file. Mapping from One Record Type to Many-- A SQL Passthrough statement creates a hierarchical target file. Using the FileList Function in a Process-- Demonstrates how to check a directory for the existence of ASCII files and then process the files found. Using Global Variables in Transformations-- Declare a global variable in Transformation and Map Properties and use that variable in an event handler action. Using an Exe Step to Run Multiple Transformations-- Demonstrates running multiple transformations from a process using an Exe step. Oracle Siebel CRM On Demand 14: Deleting Child Records-- Removes a Account_Contact child entity from an Account child entity. Microsoft Dynamics CRM 4.0: Inserting Records-- Inserts Account and Contact records, then makes Contact the Primary Contact for the Account in a Microsoft Dynamics CRM 4.0 target entity. Microsoft Dynamics GP 10: Updating Records-- Shows how the Microsoft Dynamics GP 10 connector provides insert, update, and delete access by implementing a TargetRecordSet. Running a .djar File on Unix-- This sample shows you how to edit a map and process files so that you can run a .djar on Unix. Using DJX to Pass Variables to a SQL Stored Procedure-- We use Rapid Integration Flow Language (RIFL) and DJX in scripting steps, along with a transformation map, to populate an Access 97 database table. Standardizing Multiple Date Formats-- Standardize source dates in different formats. Filtering Source Data-- Select only the account records with a Texas address (TX in the State field), write those records to the target file, and discard all other source records. Using Macros to Change Connections-- This transformation demonstrates how to use macros to change from development, test, and production environments. Using Conditional Put Actions with Event Handlers-- The use of event handler actions that allow Map Designer to process record data on a conditional basis. | 