This is an '''EXTREMELY''' important part of the System Champions role when setting up a campaign.== Overview ==
Field mapping This is the mechanism by which bxp software can map its fields to the fields in your system. bxp software will call fields using its own unique nomenclature. e.g. strCDA_41_field_3_1. This to bxp software means an '''extremely''' important part of setting up a campaign database 41 field 1, subpart 3. So in BE this would be a complex title block and accessing the surname part (0 = title, 1 = first name, 2 = initial, 3 = surname). Your report / system would probably prefer to see "Surname". Field mapping allows you to tell BE that strCDA_41_field_3_1 = Surname.
All reports, searches and displays back Field mapping is the mechanism by which bxp software maps its data fields to the agentfields in your form. bxp software designates fields using its own nomenclature. e.g. strCDA_41_field_3_1. (Campaign database 41, where export and import of data is concerned will use your name rather than field 1, subpart 3). In BE this represents the BE namesurname in a complex title block. Hence why this setup is Clearly, it’s easier for us to understand Surname so importantfield 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]]
==='''Field Mapping – Manage'''===
Here is where the Data Field, Database 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 each field in this column have unique names.
*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 to ensure that the column names are mapped correctly to the question, and there are no duplicates.
*This is important for importing a data file, for example an excel spreadsheet.
*The headings in the Excel spreadsheet to be imported must match the column names in the '''New Column Name''' in the Database - Field Mapping section of the system, so they can be added to the system successfully.
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.
N.B. Field mapping has had a challenge in the past with reserved or chacters that can cause trouble in Excel. The process of updating the field mapping names will automatically remove, single inverted commas, semi colons and commas. The field names will also be trimmed to remove leading and trailing spaces. So [Name';,`1 ] will become [Name1]
== Field Mapping – Manage == This is where the Data Field, Database Question and the New Column Name are displayed. The New Column Name field can be edited and it is important that each field in this column has a unique name. 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. Always go to Field Mapping – Manage after building a form to ensure that the column names are mapped correctly and that there are no duplicates. This is important when importing a data file, for example an excel spread sheet. The spread sheet headings 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, semi colons and commas. The field names will also be trimmed to remove leading and trailing spaces. So [Name''';,`1 ] will become [Name1] == 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]]