Usually when we save any CSV file in SharePoint document library and we open it, the browser actually prompts to "Save" the file first and then gives "Open" file option.
How to make some settings so that browser allows CSV files to get "Open" instantly without saving them?
Here is the solution -
In your SharePoint 2013 server, make the settings in “IIS Mime Types” and in “DOCICON” file to open the CSV files from the browser instead of saving them.
Steps to follow are:
a. Add an entry to DOCICON.XML -
This file is located by default at: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\TEMPLATE\XML\. Open the file DOCICON.XML for editing and add the following line in the ByExtension element:
b. Change the MIME type associated with the CSV Extension in Internet Information Server (IIS)
To do this:
i. Run the “Internet Information Services (IIS) Manager” application from the Start/Administrative tools menu.
ii. Select the server in the left-hand pane.
iii. Select “MIME Types” in the list of options in the middle pane.
iv. Then locate the .CSV entry (it should already exist) and change the MIME type to: application/vnd.ms-excel, and click OK.
Finally, most importantly, reset the IIS by clicking on Start -> Run -> cmd -> Type "IISReset"
For more reference, check these posts as well:
No comments:
Post a Comment