Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

CRM failed to upload Exel file

Posted on by Microsoft Employee

Hi Guys,

I was trying to upload an excel file (about 3.2MB) to CRM, however I got a generic error which give me no clue how to proceed, do you guys encounter such problem before. Please advise, thanks!

FailedIpload.PNG

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: CRM failed to upload Exel file

    Hi Kentan,

    This happened to me just recently. I found out that there was a unicode character in one of the cells. When I removed that character from the import file, I was able to push the import through.

  • Suggested answer
    PS Profile Picture
    PS 23,577 on at
    RE: CRM failed to upload Exel file

    Can you try zipping the file and then import.

    Also, check that you are importing a CSV(comma,delimited) or xml file and not xls/xlsx

  • Suggested answer
    Nithya Gopinath Profile Picture
    Nithya Gopinath 17,074 on at
    RE: CRM failed to upload Exel file

    Hi Kentan,

    You could find the reason behind this generic SQL error by enabling tracing or by using the diagnostic tool as mentioned in my thread above.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: CRM failed to upload Exel file

    To my blunder, I was "importing" the excel file ad not "upload", I had used the wrong word to describe my problem.

    I was importing the excel file & CRM suppose to map the fields in the excel to the CRM case's attributes. Instead I got a generic error before CRM proceed to the next step.

  • Suggested answer
    Nadeeja Bomiriya Profile Picture
    Nadeeja Bomiriya 6,804 on at
    RE: CRM failed to upload Exel file

    Hi Kentan2608,

    Did you try smaller Excel files? If it works for smaller ones, then change the maximum email attachment size to something like 16MB and see if it works.  Below article shows how.

    www.adoxio.com/.../Dynamics-CRM-Attachment-Size-Limit-Increase

  • Suggested answer
    Nithya Gopinath Profile Picture
    Nithya Gopinath 17,074 on at
    RE: CRM failed to upload Exel file

    Hi Kentan,

    Please enable tracing for dynamics CRM if you have the on-premise version.

    See: support.microsoft.com/.../how-to-enable-tracing-in-microsoft-dynamics-crm

            crmdiagtool2011.codeplex.com

    Hope this helps.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans