Difference: 530DataExchangeProcessing (2 vs. 3)

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"
 
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