Difference: 530DataExchangeProcessing (1 vs. 4)

Revision 32014-03-07 - JeanNeron

Line: 1 to 1
 
META TOPICPARENT name="Main.530DataExchange"

Processing

Line: 43 to 43
  The 'Raw Data' option displays all the extracted identifiers and the associated data:
Changed:
<
<
rawdata.png
>
>
datanew.png
  The columns have the following meanings:
Line: 52 to 52
 
  • Prnt is the 'Parent' row id for that row. In the example above. RID 1 is the ProspectData element, which is the top level element in our XML file. RID 2 is an element under ProspectData, so it's Parent is RID 1
  • Depth refers to the nesting of the current element.
  • Element is a abbreviated identifier, where the leading portions are replaced by a period. For example, '..name' would expand to <ProspectData><Prospect><name>
Added:
>
>
  • Element type refers to the different types that are extracted. ELEMENT indicates the beginning of a new element. TEXT and ATTR will contain the data and attributes, and END ELEMENT indicates the end of the element.
 
  • #chld refers to the number of children for the current element. For example. '.prospect' has 9 children because there were 9 <prospect></prospect> pairs in our source file.
  • vLen refers to the length of the longest data string
  • Value shows the actual data for the selected element.
Changed:
<
<
You can click on any row, and the system will drill down to show the elements (if any). For example, clicking on Rid 10 would display the 4 child elements.
>
>
You can click on any row, and the system will drill down to show the elements (if any). For example, clicking on Rid 24 would display the 8 child elements.
 

All Elements/Data Elements

The 'All Elements' and 'Data Elements only' display the same information, the only difference is the 'Data Elements only' will only show you the elements that contain data:

Changed:
<
<
allelements.png
>
>
allelementsnew.png
  The columns have the following meanings:
Line: 117 to 118
  When you run 'Define Field Map' you will see the following display:
Changed:
<
<
fieldmap.png
>
>
fieldmapnew.png
  This is where we define how each Appx field should be populated. If you ran the 'Populate Field Map' option in the previous step, then this display will be populated with all the fields in the selected file(s). If you did not do that, you have to manually add each field we are importing.
Line: 129 to 130
 
  1. Parent APPX File. You use this when you want the Appx field to be filled in from another (Parent) Appx File. For example, when importing the Contacts, we want the CONTACT PROSPECT NO field to be filled in from PROSPECT NO. When we choose this type, the Application Id, Parent File Id and Parent File Field fields will become available for input.
  2. Sequence Number. Use this to automatically assign a sequential sequence number to the Appx field. Note that the sequence number starts at zero every time you run the import step, so normally you would not use this to generate unique keys in an existing Appx file that uses a sequence number key.
  3. Date/Time Stamp. The current date/time will be set in the field.
Added:
>
>
The XML Tag Type indicates which tag type this mapping is applicable to. Most data will be in the TEXT tag type, however, if your incoming data contains something like <phone> </phone>, the whitespace will not trigger a TEXT record in XVALUE. In this case, you might want to add another mapping triggered by the END ELEMENT tag. You can then use a subroutine to check values, etc, as required.
 

Store Map

This option allows you to save the current mapping.

Line: 172 to 174
 
META FILEATTACHMENT attachment="upload.png" attr="h" comment="" date="1380739711" name="upload.png" path="upload.png" size="40941" user="JeanNeron" version="1"
META FILEATTACHMENT attachment="viewprocess.png" attr="h" comment="" date="1380740650" name="viewprocess.png" path="viewprocess.png" size="44880" user="JeanNeron" version="1"
Added:
>
>
META FILEATTACHMENT attachment="allelementsnew.png" attr="h" comment="" date="1394234072" name="allelementsnew.png" path="allelementsnew.png" size="54049" user="JeanNeron" version="1"
META FILEATTACHMENT attachment="datanew.png" attr="h" comment="" date="1394234137" name="datanew.png" path="datanew.png" size="101048" user="JeanNeron" version="1"
META FILEATTACHMENT attachment="fieldmapnew.png" attr="h" comment="" date="1394234403" name="fieldmapnew.png" path="fieldmapnew.png" size="42521" user="JeanNeron" version="1"
 
META TOPICMOVED by="JeanNeron" date="1388522583" from="Sandbox.530DataExchangeProcessing" to="Main.530DataExchangeProcessing"

Revision 22013-12-31 - JeanNeron

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

Processing

his page describes the various processing and updating options.

Line: 26 to 26
  The title will default to your user initials, plus the current date/time. You can change this if you wish. You can drag and drop an XML file, or use the file chooser. Currently 0DX only supports XML, you cannot change that. The 'Hide Errors/Warnings' flag normally suppresses any problems with the source file. If you are having problems importing a file, you can uncheck this flag to see if there are any formatting problems with the incoming data.
Changed:
<
<
Refer to the Tutorial or the Reference for a discussion of Ignorable / Replaceable segments.
>
>
Refer to the Tutorial or the Reference for a discussion of Ignorable / Replaceable segments.
  Once you click 'Execute' the tags and data will be extracted from the XML file and it will be ready for further review and/or importing in the next step.

View/Modify Processed Files & Import

Line: 43 to 43
  The 'Raw Data' option displays all the extracted identifiers and the associated data:
Changed:
<
<
rawdata.png
>
>
rawdata.png
  The columns have the following meanings:
Line: 60 to 60
  The 'All Elements' and 'Data Elements only' display the same information, the only difference is the 'Data Elements only' will only show you the elements that contain data:
Changed:
<
<
allelements.png
>
>
allelements.png
  The columns have the following meanings:
Line: 73 to 73
  You can click the 'Data Values' button for any selected row, and you will get a display of all the actual data values for each occurence of the element:
Changed:
<
<
datavalues.png
>
>
datavalues.png
  The 'Data Values' option shows us the same information as above, but not constrained to any element, ie, we can scroll thru all the extracted data.

Refining

Line: 83 to 83
  In the 'Ignorable Segments' popup we can specify segments that are to be ignored (removed) when extracting the identifiers. For example, if 'ProspectData' was the top level identifier and is prefixed on all identifiers, we can remove it by entering 'ProspectData' as a segment to be ignored.
Changed:
<
<
ignoreable.png
>
>
ignoreable.png
 

Replaceable Segments

'Replaceable Segments' are used for a very particular situation. Consider the following XML fragment:

Line: 92 to 92
  Notice that the Segments all have the same name (j2:feature), and the identifier is really encoded in the attribute (name="..."). In this case, we can use the Replaceable Segments to move the attribute to the segment, which will allow us to map the segment to an Appx field:
Changed:
<
<
replace.png
>
>
replace.png
  Now our segment names will become "SourceName", "FileSystemProperties", "Path", "LastModified" instead of "j2:feature"

Regenerate Elements

Line: 105 to 105
  When you run 'Define File Map' you will see the following display:
Changed:
<
<
filemap.png
>
>
filemap.png
  If you provided a map when you loaded the source file, then any existing File Mappings will be shown. The columns have the following meaning:
Line: 117 to 117
  When you run 'Define Field Map' you will see the following display:
Changed:
<
<
fieldmap.png
>
>
fieldmap.png
  This is where we define how each Appx field should be populated. If you ran the 'Populate Field Map' option in the previous step, then this display will be populated with all the fields in the selected file(s). If you did not do that, you have to manually add each field we are importing.
Line: 133 to 133
  This option allows you to save the current mapping.
Changed:
<
<
savemap.png
>
>
savemap.png
  If you enter the name of an existing mapping, it will be overwritten with the new mapping.

Retrieve Map

This option allows you to load an existing mapping. After loading it, you can refine it using the 'Define File Map' and 'Define Field Map' options, then save it under a new name or replace the original, using the 'Store Map' option.

Changed:
<
<
loadmap.png
>
>
loadmap.png
 

Processing

Create Import Subr

This option will create a subroutine that does the work of importing the XML data into our Appx files:

Changed:
<
<
createsubr.png
>
>
createsubr.png
  Fill in any Application and Process Name you want. When you click 'Proceed', the subroutine will be written and compiled. If any errors occur during the compile, you can view the subroutine in Application Design. You can also further customize the subroutine, however, you will lose those changes if you 'Create Import Subr' again.

Import Data

Line: 157 to 157
  This option will upload the data and run the import subroutine, all in one step. When you choose this option, you should see the following display:
Changed:
<
<
0dx.png
>
>
0dx.png
  The title will default to your user initials, plus the current date/time. You can change this if you wish. You can drag and drop a file from your desktop, or use the file chooser. You must enter the import map name. Currently 0DX only supports XML, you cannot change that. The 'Hide Errors/Warnings' flag normally suppresses any problems with the source file. If you are having problems importing a file, you can uncheck this flag to see if there are any formatting problems with the incoming data.
Line: 172 to 172
 
META FILEATTACHMENT attachment="upload.png" attr="h" comment="" date="1380739711" name="upload.png" path="upload.png" size="40941" user="JeanNeron" version="1"
META FILEATTACHMENT attachment="viewprocess.png" attr="h" comment="" date="1380740650" name="viewprocess.png" path="viewprocess.png" size="44880" user="JeanNeron" version="1"
Added:
>
>
META TOPICMOVED by="JeanNeron" date="1388522583" from="Sandbox.530DataExchangeProcessing" to="Main.530DataExchangeProcessing"

Revision 12013-10-02 - JeanNeron

Line: 1 to 1
Added:
>
>
META TOPICPARENT name="530DataExchange"

Processing

his page describes the various processing and updating options.

_

_

Overview:

The 'Processing' options give us various ways of processing and importing data. Processing refers to extracting the identifiers and data from the source file. A mapping is not required for this step. Importing refers to running the import subroutine (created as part of defining the File/Field mapping) to update our Appx files.

Each source file processed is held in temporary work files until you log off or delete them.

Usage

The 'Upload and Process' option will upload the source file and extract the data and identifiers. You can upload several files, and their data will be kept separate. Processing does not actually import any data.

The 'View/Modify Processed Files & Import' allows you to review all the files that have been uploaded and processed in the current session and refine the mappings, view the data, and ultimately run the import step to actually update the Appx files.

The 'One Step - Upload/Import' combines the above functions, so you can upload, process and import the data all in one step.

Upload and Process

This option allows you to upload a file to the server and process it. When you run 'Upload and Process', you will see the following display:

upload.png

The title will default to your user initials, plus the current date/time. You can change this if you wish. You can drag and drop an XML file, or use the file chooser. Currently 0DX only supports XML, you cannot change that. The 'Hide Errors/Warnings' flag normally suppresses any problems with the source file. If you are having problems importing a file, you can uncheck this flag to see if there are any formatting problems with the incoming data.

Refer to the Tutorial or the Reference for a discussion of Ignorable / Replaceable segments.

Once you click 'Execute' the tags and data will be extracted from the XML file and it will be ready for further review and/or importing in the next step.

View/Modify Processed Files & Import

This option will show you all the files that have been uploaded and processed in the current session. From here you can load an existing mapping, create a new mapping, modify the existing mapping, view the data, create the import subroutine and import the data.

viewprocess.png

Files that you loaded via the 'Upload & Process' option will not have mapping assigned to them. You can use the 'Retrieve Map' button to load a previously defined mapping (must be in change mode to enable the button), or you create a mapping here by running 'Define File Map'

Data Review

The Data Review options allow us to examine the extracted data.

Raw Data

The 'Raw Data' option displays all the extracted identifiers and the associated data:

rawdata.png

The columns have the following meanings:

  • Key is a sequential number assigned to each file you process. You can have multiple files processed and awaiting import at the same time.
  • RID is a 'Row Id' assigned to each extracted identifier. It does not refer to a line number in the source file
  • Prnt is the 'Parent' row id for that row. In the example above. RID 1 is the ProspectData element, which is the top level element in our XML file. RID 2 is an element under ProspectData, so it's Parent is RID 1
  • Depth refers to the nesting of the current element.
  • Element is a abbreviated identifier, where the leading portions are replaced by a period. For example, '..name' would expand to <ProspectData><Prospect><name>
  • #chld refers to the number of children for the current element. For example. '.prospect' has 9 children because there were 9 <prospect></prospect> pairs in our source file.
  • vLen refers to the length of the longest data string
  • Value shows the actual data for the selected element.
You can click on any row, and the system will drill down to show the elements (if any). For example, clicking on Rid 10 would display the 4 child elements.

All Elements/Data Elements

The 'All Elements' and 'Data Elements only' display the same information, the only difference is the 'Data Elements only' will only show you the elements that contain data:

allelements.png

The columns have the following meanings:

  • Seq # is a sequential number assigned to each row. This does not refer to a line number in the source file
  • Identifier is the extracted identifier
  • Data is a flag that indicates whether this element contains data or not.
  • Appears is a count of the number of times this element appears in the source file.
  • Max Length is the maximum length of the data for this element.

Data Values

You can click the 'Data Values' button for any selected row, and you will get a display of all the actual data values for each occurence of the element:

datavalues.png

The 'Data Values' option shows us the same information as above, but not constrained to any element, ie, we can scroll thru all the extracted data.

Refining

The 'Refining' section allows us to fine tune the extraction of identifiers from the XML file.

Ignorable Segments

In the 'Ignorable Segments' popup we can specify segments that are to be ignored (removed) when extracting the identifiers. For example, if 'ProspectData' was the top level identifier and is prefixed on all identifiers, we can remove it by entering 'ProspectData' as a segment to be ignored.

ignoreable.png

Replaceable Segments

'Replaceable Segments' are used for a very particular situation. Consider the following XML fragment:

<j2:feature name="SourceName">
<j2:value>136</j2:value>
</j2:feature>
<j2:feature name="FileSystemProperties">
<j2:features>
<j2:feature name="Path">
<j2:value>/usr/local/appx/archive/110928/136</j2:value>
</j2:feature>
<j2:feature name="LastModified">
<j2:value>2011-09-28T20:19:52-04:00</j2:value>
</j2:feature>
</j2:features>

Notice that the Segments all have the same name (j2:feature), and the identifier is really encoded in the attribute (name="..."). In this case, we can use the Replaceable Segments to move the attribute to the segment, which will allow us to map the segment to an Appx field:

replace.png

Now our segment names will become "SourceName", "FileSystemProperties", "Path", "LastModified" instead of "j2:feature"

Regenerate Elements

Whenever you change the Ignorable or Replaceable segments, you must run 'Regenerate Elements' to reprocess the XML file using your new rules.

Mapping

This is where we can enter or modify the mapping rules. A 'File Map' indicates when a new record should be written to the Appx file, and a 'Field Map' indicates how the incoming data should be moved to an Appx field.

Define File Map

When you run 'Define File Map' you will see the following display:

filemap.png

If you provided a map when you loaded the source file, then any existing File Mappings will be shown. The columns have the following meaning:

  • Appl is the Application Id of file to be written
  • Dest File is the name of the Appx file to be written
  • File Start Identifier is the XML identifier that should trigger writing a new record. You can Scan the identifiers in the current source file.
The 'Populate Field Map' button will load the Field Map with all the fields from the current file. This might be quicker than manually entering the fields later. Note that this will replace any existing fields in your Field Mapping.

Define Field Map

When you run 'Define Field Map' you will see the following display:

fieldmap.png

This is where we define how each Appx field should be populated. If you ran the 'Populate Field Map' option in the previous step, then this display will be populated with all the fields in the selected file(s). If you did not do that, you have to manually add each field we are importing.

For each field choose an appropriate 'Source Type'. if you leave the 'Source Type' blank they will be assigned the default values as per the Data Dictionary.

The valid source types are:

  1. XML Data Field. When you choose this type, the XML Identifier, Application Id and Proces Name fields will become available for input. You can Scan on the XML Identifier field to choose an identifier that exists in the current XML file. The Application Id and Process Name allow us to specify a subroutine that you want to run when this field is imported (optional). The subroutine will be invoked DETACHED and will be passed 2 fields. You should RECEIVE 2 fields, the first field is the data extracted from the XML file and the second field is the XML identifier. You can change the first field, and the resulting data will be written to the Appx file.
  2. Parent APPX File. You use this when you want the Appx field to be filled in from another (Parent) Appx File. For example, when importing the Contacts, we want the CONTACT PROSPECT NO field to be filled in from PROSPECT NO. When we choose this type, the Application Id, Parent File Id and Parent File Field fields will become available for input.
  3. Sequence Number. Use this to automatically assign a sequential sequence number to the Appx field. Note that the sequence number starts at zero every time you run the import step, so normally you would not use this to generate unique keys in an existing Appx file that uses a sequence number key.
  4. Date/Time Stamp. The current date/time will be set in the field.

Store Map

This option allows you to save the current mapping.

savemap.png

If you enter the name of an existing mapping, it will be overwritten with the new mapping.

Retrieve Map

This option allows you to load an existing mapping. After loading it, you can refine it using the 'Define File Map' and 'Define Field Map' options, then save it under a new name or replace the original, using the 'Store Map' option.

loadmap.png

Processing

Create Import Subr

This option will create a subroutine that does the work of importing the XML data into our Appx files:

createsubr.png

Fill in any Application and Process Name you want. When you click 'Proceed', the subroutine will be written and compiled. If any errors occur during the compile, you can view the subroutine in Application Design. You can also further customize the subroutine, however, you will lose those changes if you 'Create Import Subr' again.

Import Data

To import the data into our Appx files, click the 'Import Data' button. This will run the subroutine that was created from our mapping, transferring the data from the internal 0DX files to the files/fields specified by our mapping.

One Step - Upload/Import

This option will upload the data and run the import subroutine, all in one step. When you choose this option, you should see the following display:

0dx.png

The title will default to your user initials, plus the current date/time. You can change this if you wish. You can drag and drop a file from your desktop, or use the file chooser. You must enter the import map name. Currently 0DX only supports XML, you cannot change that. The 'Hide Errors/Warnings' flag normally suppresses any problems with the source file. If you are having problems importing a file, you can uncheck this flag to see if there are any formatting problems with the incoming data.

Once you click 'Execute' the tags and data will be extracted from the source file and the import subroutine specified in the mapping will be run to import the data. When this is complete you will be returned to the menu.

Comments:

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


<--/commentPlugin-->

-- JeanNeron - 2013-10-02

META FILEATTACHMENT attachment="upload.png" attr="h" comment="" date="1380739711" name="upload.png" path="upload.png" size="40941" user="JeanNeron" version="1"
META FILEATTACHMENT attachment="viewprocess.png" attr="h" comment="" date="1380740650" name="viewprocess.png" path="viewprocess.png" size="44880" user="JeanNeron" version="1"
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2022 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback