Thursday, June 26, 2014

Change the MAX file size limit for CRM 2013/2011 Data Import Wizard

----------------------------------------------------------------------------------------------------------------------
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
------------------------------------------------------------------------------------------------------------------------