Difference: 530DataExchangeFileField (5 vs. 6)

Revision 62014-03-07 - JeanNeron

Line: 1 to 1

META TOPICPARENT	name="Main.530DataExchange"

Define File/Field Map

Line: 30 to 30

The 'Details' button will allow you to change the specifics of a field mapping:

Changed:

<
<

>
>

The valid source types are:

Line: 38 to 38

Parent APPX File. We use this when we 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 Parent File Id and Parent File Field fields will become available for input.
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.
Date/Time Stamp. The current date/time will be set in the field.

Added:

>
>

The XML 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.

Ignorable Segments

Line: 66 to 67

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 FILEATTACHMENT	attachment="fieldnew.png" attr="h" comment="" date="1394232965" name="fieldnew.png" path="fieldnew.png" size="43626" user="JeanNeron" version="1"

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

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