Default file size limit for the CRM 2011 Data Import Wizard (and how to modify it)

  • Article

Within a project where we needed to import some old data (e.g. some excel files from a third party system) we received an error during import.

We tried to upload the file using the Data Import Wizard. During the import the following error occurred.

image

 

More details can be seen within the CRM Platform trace.

Error: The import file is too large to upload.
Error Number: 0x80040375
Error Message: The import file is too large to upload.
Error Details: The import file is too large to upload.
Source File: Not available
Line Number: Not available
Request URL:
Stack Trace Info: [CrmException: The import file is too large to upload.]
   at Microsoft.Crm.Application.Pages.Import.ImportFileUploadPage.ProcessFile()
   at Microsoft.Crm.Application.Pages.Import.ImportFileUploadPage.ConfigureForm()

The error indicates that the file size was above the default max import file size of 8 MB. In order to change the default setting please apply the following steps.

Step 1
Make sure that you modify the different timeout settings. The below KB includes additional information.
A time-out occurs when you import large customization files into Microsoft Dynamics CRM
https://support.microsoft.com/kb/918609

Step 2
Verify the current value for the "Max" file size for data upload. By default the value is set to "8".

Use MSCRM_CONFIG
select ColumnName, IntColumn from ServerSettingsProperties
where ColumnName = 'ImportMaxAllowedFileSizeInMB'
Go

To change the value you would need to apply the below statement. It will change the default value from 8 to 10. As a result the max file size for data import will now be 10 MB.

Use MSCRM_CONFIG
UPDATE [MSCRM_CONFIG].[dbo].[ServerSettingsProperties]
SET [IntColumn] = '10'
WHERE ColumnName = 'ImportMaxAllowedFileSizeInMB'
Go

 

The range for the 'ImportMaxAllowedFileSizeInMB' is between

<Min>1</Min>
<Max>32</Max>
<Default>8</Default>

 
Best regards
Dynamics CRM Team