Contents x
    Configuring Data Fields
    • 3 Minutes to read
    • Print
    • Dark
      Light
    Contents

    Configuring Data Fields

    • 3 Minutes to read
    • Print
    • Dark
      Light
    Article Summary

    The most important part of the Data import process is configuring how the data in your CSV File should be processed

    The Fields Screen is used to configure which infoodle Fields each Column of Data in your CSV File relates to, and how that data will be processed during the import. This process is referred to as Field Mapping.

    Fields Screen Overview

    The Fields Screen has three separate Tabs of Fields displayed, as well as the Field Mapping table, and the Overview section.

    1. Remaining Tab: Lists all of the Data columns in your file that are not yet mapped
    2. Assigned Tab: Lists all Data that has been mapped to an infoodle Field/Group
    3. No Import Tab: Lists the data slected to be Skipped, or saved using Do Not Map
    4. Below the Tabs is the main Field Mapping table
    5. To the Right of the tabs is the overview, which has a Remaining fields to Map progress bar, as well Save Mapping button.

    Overview.png

    Field Mapping table

    The Field Mapping table has 2 key sections, which are the same regardless of which of the 3 Tabs you are looking at.

    1. The Your Field section lists the Column headers from your Data File.
    2. In the Field Settings section, you select the appropriate infoodle field for that data and configure any additional settings.
    3. Clicking the Save Mapping button will apply the current mapping settings for all fields on this page, including any set to Do Not Map.
    4. Also note that for each Field, a sample of data from that column of data is listed below

    Field Table.png

    Mapping Data Fields

    Please take care that you map each Data field correctly, and take note of any additional Field Settings that are listed, as the fielr options may update after you have selected the infoodle field to map to.

    When Mapping data fields for import, there are essentially 3 key Steps:

    1. Use the Dropdown to search for and Select the infoodle Data field to connect
    2. Configure any available settings or that field, if required.
    3. Once all fields on this page have been configured, click the Save Mapping button to apply the configuration and map these fields.

    Field Mapping.png

    Once a field is mapped and saved, it will be moved to the Assigned Tab on this screen.

    Note:

    If you need information about the available settings when mapping a Data Field, you can look this up in the Field Settings section of this help page.

    For any Data fields that are not required, you can set these to Do Not Map, to skip loding that data during the import.
    Skipped/"Do not map" fields will be moved to the No Import Tab on this screen once you have clicked Save Mapping for that page.

    Skip Field.png

    If you need to make changes to Field Mapping:

    1. Go to the relevant Assigned or No Import tab
    2. Locate the Field(s), and reconfigure the settings as needed
    3. Click Save Mapping to re-map the page of fields using the new configuration

    Update FIeld.png

    Mapping Complete
    Once all of the fields have been fully mapped or Skipped, you will see the All Fields Sucessfully Asssigned Text displayed on the Remaining tab.
    From this tab, click the Continue option to move to the Configure Import stage

    Mapping Complete.png

    See Configuring Import Settings for instructions on Configuring the import

    Field Settings

    While you are mapping data fields, you will come across various settings for each field.
    Some settings, such as Duplicate Identifier are available for most fields, while other settings will only be listed for specific Types of fields, such as Date Format for a Date Field, or Create List Options for a Lookup or Multi-select Lookup field.

    Was this article helpful?
    What's Next