Customer Engagement & Dynamics CRM Forum

Expand all | Collapse all

excel exports in chrome adding single quotes before and after files

Jump to Best Answer
  • 1.  excel exports in chrome adding single quotes before and after files

    GOLD CONTRIBUTOR
    Posted Feb 20, 2019 10:55 AM
    While attempting to export from the crm, users are experiencing an odd issue. Excel exports from chrome are adding single quotes before and after file names. This prevents users from quickly opening files in excel. Once the users rename the files, excluding the single quotes, all works well. Conversely, everything is working fine with internet explorer: no file renaming is needed.

    Any suggestions?

    Thanks

    ------------------------------
    Rod Carlson
    Database Administrator
    Chicago White Sox
    Chicago
    ------------------------------
    Conference-CRMUG_200x200


  • 2.  RE: excel exports in chrome adding single quotes before and after files
    Best Answer

    TOP CONTRIBUTOR
    Posted Feb 20, 2019 01:23 PM
    Rod,
       This is the same problem as the solution file export in this thread:
    https://www.crmug.com/communities/community-home/digestviewer/viewthread?GroupId=1285&MessageKey=32d6fdee-25b4-4a91-9e1b-34cb7c6549ab&CommunityKey=dc83c23b-ede0-4070-ae7a-dd90859148a6&tab=digestviewer&ReturnUrl=%2fparticipate%2fdiscussion-forum
    Several people have posted workarounds while we wait for the battle of the titans (MS and Google) to resolve it.

    If this answered your question, please click on the arrow button next to Reply Inline and choose Mark Best Answer.
    Thanks.

    ------------------------------
    Nelson Johnson
    Solution Architect
    BroadPoint, Inc.
    Bethesda MD
    Link with me! https://www.linkedin.com/in/nelsonjohnson/
    ------------------------------

    Conference-CRMUG_200x200


  • 3.  RE: excel exports in chrome adding single quotes before and after files

    SILVER CONTRIBUTOR
    Posted Feb 21, 2019 05:50 AM

    Have same issue here – will check the workaround provided in another response. It also happens exporting a solution in my case when using Chrome.




    Conference-CRMUG_200x200


  • 4.  RE: excel exports in chrome adding single quotes before and after files

    GOLD CONTRIBUTOR
    Posted Feb 21, 2019 02:12 PM
    I wrote a Chrome plugin that will fix this automatically.

    Get it and more details here:
    How to fix Dynamics 365 File download apostrophe bug
    Javascript for CRM remove preview
    How to fix Dynamics 365 File download apostrophe bug
    The Problem In Chrome 72 the way the file download process works has changed. For Dynamics users, this means that files are currently being downloaded with a ' character surrounding the files.
    View this on Javascript for CRM >


    ------------------------------
    Nick Hance
    Principal Developer; President
    Reenhanced
    www.javascriptforcrm.com
    www.buildbettersoftware.com
    Green Lane PA
    ------------------------------

    Conference-CRMUG_200x200


  • 5.  RE: excel exports in chrome adding single quotes before and after files

    Posted 5 days ago
    OMG.  Wish I had Googled this sooner.  I had my IT department open tickets with Dynamics back in May and their response was to use Microsoft Edge lol.  This has been driving me nuts since the beginning of the year.  Thank you!!!!!!

    ------------------------------
    TJ Drudi
    Acquisition Sales Manager
    Staples SchoolKidz
    Woodridge IL
    ------------------------------

    Conference-CRMUG_200x200


  • 6.  RE: excel exports in chrome adding single quotes before and after files

    Posted Feb 21, 2019 05:25 PM
    Thank you @Nelson Johnson for bringing up the 'Best Answer' feature!

    If anyone is not familiar with the feature - when you create a new thread, you have the ability to reward an answer that helped you the most (see image below) on that specific thread. Liking posts and awarding best answer help other community members identify posts that were particularly helpful. When you 'like' a person's post, they get extra points. When you award the best answer, that person gets additional points as well as the 'Simply the Best' badge in their achievements area on their profile!



    ------------------------------
    Marghet Hager
    Member Community Manager, D365UG/AXUG/CRMUG
    Dynamic Communities
    ------------------------------

    Conference-CRMUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role