Changes

==This is an '''extremely'''important part of setting up a campaign.  Field mapping is the mechanism by which bxp software maps its data fields to the fields in your form. bxp software designates fields using its own nomenclature. e.g. strCDA_41_field_3_1. (Campaign database 41, field 1, subpart 3). In BE this represents the surname in a complex title block. Clearly, it’s easier for us to understand Surname so field mapping allows you to tell BE that strCDA_41_field_3_1 = Surname.  You can read more about how the concept works here. [[Understanding_Field_Mapping]]  All reports, searches and displays will use your name rather than the BE name which is why this part of the set-up is so important.   == Field Mapping – Manage'''== Here  This is where the Data Field, Database question Question and the New Column Name are displayed within a particular campaign.* The New Column Name field can be edited, and it is very important to make sure that each field in this column have has a unique namesname.*For example – if there is a Complex Address Field in the campaign – you must distinguish between each field in this block – ; Address Line 1, Address Line 2, Address Line 3, in the New Column Name, as opposed to Address, Address, and Address – which would be incorrect.*''' Always''' go to '''Field Mapping – Manage''' after building a campaign form to ensure that the column names are mapped correctly to the question, and that there are no duplicates.*This is important for when importing a data file, for example an excel spreadsheetspread sheet. *The spread sheet headings in the Excel spreadsheet to be imported too, must match the column names in the '''New Column Name''' in the Database - Field Mapping section of the system.  The process of updating the field mapping names will automatically remove single inverted commas, so they can semi colons and commas. The field names will also be added trimmed to the system successfullyremove leading and trailing spaces.So [Name';,`1 ] will become [Name1] <br/>=='''Field Mapping - Reset'''==*This allows you to reset the fields fields’ names back to the defaults when the campaign form was first built.*This NOTE, this action is irreversible so be very careful when doing this action.!   [[Category:Module Specific:Form Management]][[Category:Topic:Key Concept]]