Search This Blog

Monday, August 10, 2015

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

If you have any doubt in the post please post comments. I will try to solve your problem.

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
http://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</Defaul

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.