How Bit Field Types Are Imported

Each bit Attribute type with two valid string values that are mapped within Microsoft Dynamics CRM Online to be stored as 1 or 0. field type in Microsoft Dynamics CRM Online has two valid string values that are mapped within Microsoft Dynamics CRM Online to 1 and 0.

• If the source value for each bit field in a record matches a valid Microsoft Dynamics CRM Online string value for the field, the record will be imported.
• If the source value for any bit field in the record does not match, the record will not be imported.

To prevent records from failing to import, you can either:

• Manually edit a data map A file that contains information about how data from a source system corresponds to data in Microsoft Dynamics CRM Online. to map values in your source data to existing Microsoft Dynamics CRM Online values for the field. The data map requires using the integer for the value, rather than the string.

  More information: Work with Data Maps.

• Before importing data, customize the bit field in Microsoft Dynamics CRM Online to include the two string values used in your source data.

Bit value mapping and import is not case-sensitive.

If you use the Import Data Wizard to create a new field of bit Attribute type with two valid string values that are mapped within Microsoft Dynamics CRM Online to be stored as 1 or 0. type, data will only be imported as True or False. This means your source data must have either a 1 or 0 in the column, and cannot use strings for the two values. After importing your data, you can customize the new bit field in Microsoft Dynamics CRM Online and change the values to strings. To work around this limitation, you might want to use Microsoft Dynamics CRM Online to create any new required-bit fields, and then use the Import Data Wizard to import data to the field.

Suggested Preparation in Source Files

To avoid import errors, make sure that the values for bit fields match the existing values in Microsoft Dynamics CRM Online, or manually edit the data map for the import to map your values to valid Microsoft Dynamics CRM Online values.

Mapping in the Data Map (optional)

In a data map, to map bit values, create a <PicklistMaps> section, with one <PicklistMap> for 1, and another for 0. For a detailed example showing the process, see How List Values Are Imported.