Difference: 530DataExchangeFileField (4 vs. 5)

Revision 52013-12-31 - JeanNeron

Line: 1 to 1

Changed:

<
<

META TOPICPARENT	name="530DataExchange"

>
>

META TOPICPARENT	name="Main.530DataExchange"

Define File/Field Map

This page describes how to map incoming data to Appx files/Fields.

Line: 7 to 7

Define File/Field Map

Overview:

Changed:

<
<

This option allows you to maintain existing File/Field maps. You can also use this to add new mappings, but it's usually easier to define a new map using Define File/Field map from Source File.

>
>

This option allows you to maintain existing File/Field maps. You can also use this to add new mappings, but it's usually easier to define a new map using Define File/Field map from Source File.

Usage

When you click 'Define File/Field Map', you will see a display similar to the following:

Line: 19 to 19

The 'Component Files' button allows you to specify what identifiers indicate the beginning of a new record in the source file:

Changed:

<
<

>
>

You can also click the 'Populate Field Map' button to populate the 'Component Fields' file with all the fields in the currently selected file. This might be easier than manually entering the fields later. However, if the Appx file has many fields and you are only importing a few of them, it might be easier to manage if you just manually add the fields.

Component Fields

Line: 40 to 40

Date/Time Stamp. The current date/time will be set in the field.

Ignorable Segments

Changed:

<
<

>
>

Ignorable Segments are segments we want removed from the identifiers. For example, most XML files have a top level segment, such as 'ProspectData', and all identifiers are subordinate to that (ie, /ProspectData/Prospect No, /ProspectData/ProspectName, etc). To simplify our mapping, we might want the 'ProspectData' portion removed so that we have /ProspectNo, /ProspectName, etc. In that case, we would enter 'ProspectData' as one of the Ignorable Segments.

Replaceable Segments

Line: 66 to 66

META FILEATTACHMENT	attachment="fields.png" attr="h" comment="" date="1380664245" name="fields.png" path="fields.png" size="107988" user="JeanNeron" version="1"
META FILEATTACHMENT	attachment="fielddetail.png" attr="h" comment="" date="1380664367" name="fielddetail.png" path="fielddetail.png" size="43830" user="JeanNeron" version="1"
META FILEATTACHMENT	attachment="replace.png" attr="h" comment="" date="1380666692" name="replace.png" path="replace.png" size="20114" user="JeanNeron" version="2"

Added:

>
>

META TOPICMOVED	by="JeanNeron" date="1388522656" from="Sandbox.530DataExchangeFileField" to="Main.530DataExchangeFileField"

View topic | History: r7 < r6 < r5 < r4 | More topic actions...