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.