Difference: 530DataExchange (8 vs. 9)

Revision 92013-12-31 - JeanNeron

Line: 1 to 1
Changed:
<
<
META TOPICPARENT name="APPX530Features"
>
>
META TOPICPARENT name="Main.APPX530Features"
 

Data Exchange Application

A new application (0DX) is included with 5.3. This application facilitates the exchange of data between Appx and external systems.

Line: 15 to 15
 
  • The 'import' subroutine must be run. This is a subroutine (created by 0DX based on the mapping) that will read the internal files and move the data to the final files and fields based on the user defined mapping.
Alternatively, an external Appx process can read the extracted data & process it without defining a mapping or creating a subroutine.
Changed:
<
<
An API allows a programmer to perform one or both of those steps under ILF control. Mapping the data is optional, the programmer can just use the API to process the file and then read the extracted data directly.
>
>
An API allows a programmer to perform one or both of those steps under ILF control. Mapping the data is optional, the programmer can just use the API to process the file and then read the extracted data directly.
  When defining the mapping, the user can enter the tags directly or they can choose to process an actual XML file first, and then refer to the tags found in that XML file in their mapping. This is often easier, as the user will be able to see the actual tags and the data associated with the tag.

Installation

Line: 24 to 24
  Next, add 0DX as a related application to any Databases that will use it, and run Create Files for that Database.
Changed:
<
<
If you plan to expose the user interface, define an Optional Child somewhere in your application that invokes application 0DX, process type MENU, with no process name. If you only plan to use the API, you can skip this step.
>
>
If you plan to expose the user interface, define an Optional Child somewhere in your application that invokes application 0DX, process type MENU, with no process name. If you only plan to use the API, you can skip this step.
  Your client screen size should be set to 28 x 120 minimum to run 0DX interactively.

Usage

Line: 36 to 36
  The easiest way to understand how to use 0DX is to work through an example. In the DMO application, run the Job called EXPORT PROSPECTS/CONTACTS. On the disposition screen, make sure you choose a form with a page length of zero, otherwise the resulting XML file will not import completely. This will export the Prospect and Contact Data from DMO in a simple XML format and upload it to your desktop as PROSPECT.XML. We will use this file for the tutorial.
Changed:
<
<
The first step is to define our mapping using Mapping Files and Fields.
>
>
The first step is to define our mapping using Mapping Files and Fields.
 
Changed:
<
<
Once you have created a mapping, you can import the data using the Import Data option.
>
>
Once you have created a mapping, you can import the data using the Import Data option.
 

Reference

Changed:
<
<
Use Define File/Field Map to modify existing mappings. You can use this to create new mappings as well, but you will probably find it easier to use Define File/Field map from Source File
>
>
Use Define File/Field Map to modify existing mappings. You can use this to create new mappings as well, but you will probably find it easier to use Define File/Field map from Source File
 
Changed:
<
<
The Transfer Maps option can be used to copy a mapping from one Database to another (ie, from a test to production database). You can also use this to copy an existing mapping to a new name.
>
>
The Transfer Maps option can be used to copy a mapping from one Database to another (ie, from a test to production database). You can also use this to copy an existing mapping to a new name.
 
Changed:
<
<
The View Raw Data options give you various ways of examining the source file(s) that you have processed.
>
>
The View Raw Data options give you various ways of examining the source file(s) that you have processed.
 
Changed:
<
<
The Processing options give you various ways of loading data into Appx.
>
>
The Processing options give you various ways of loading data into Appx.
 
Changed:
<
<
The API allows you to process and optionally import data under ILF control.
>
>
The API allows you to process and optionally import data under ILF control.
 

Comments:

Read what other users have said about this page or add your own comments.

Line: 61 to 61
 
META FILEATTACHMENT attachment="0dx.jpg" attr="h" comment="" date="1380742343" name="0dx.jpg" path="0dx.jpg" size="87184" user="JeanNeron" version="2"
META FILEATTACHMENT attachment="replace.png" attr="h" comment="" date="1380666653" name="replace.png" path="replace.png" size="20114" user="JeanNeron" version="1"
META FILEATTACHMENT attachment="0dxnew.jpg" attr="h" comment="" date="1380742415" name="0dxnew.jpg" path="0dxnew.jpg" size="87184" user="JeanNeron" version="1"
Added:
>
>
META TOPICMOVED by="JeanNeron" date="1388522519" from="Sandbox.530DataExchange" to="Main.530DataExchange"
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback