As far as the csv file is concerned, on the local machine does it open the csv files with excel automatically?
Main Topics
Browse All TopicsI run a WSS 3.0 site to store company documents on. The site is running on SBS 2003. The problem is: From within Sharepoint, when an end user clicks on a stored .CSV file, it opens in the browser window and not Excel, leaving the user unable to edit the file. How can I change this behaviour? I would like the drop down to show: "Edit in Microsoft Excel" but since Sharepoint does not recognize the file, that option is not available. The Idea is to allow the end user to open the file in Excel, apply formatting before printing, then close the file without saving changes since the file is a CSV and won't allow formatting changes to be saved.
Second problem: When a .CSV or .PDF file is stored on Sharepoint, the icon is a small white square instead of the Excel Icon. How can I chage the white Icon to the proper Icon for .CSV and .PDF files? Attached are a couple of screenshots of PDF files and CSV files.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Thanks for the reply. I have the icons mapped now and the proper icon shows for CSV files. I also tried PDF and that works as well. As far as clicking the file, I think i have that figured out as well. Clicking on top of the CSV file, the CSV opens within the browser but I didn't notice that I could add an Excel Toolbar by right clicking in the tab area and choosing "Show document tools" which gives me what I need.
I have one more related question. I decided to try to enhance clicking on the CSV files by adding this line: <Mapping Key="csv" Value="iccsv.gif" EditText="Microsoft Office Excel" OpenControl="SharePoint.Op
This added a "Edit In Microsoft Excel" menu item in Sharepoint. But when "Edit In Microsoft Excel" is clicked I get an error that "The document could not be opened for editing. A windows sharepoint services compatible application could not be found to edit the document." Any Ideas on that one? If I could fix that then the drop down menu could be properly used as well. Or do I need to just ditch the extra code and leave the Mapping key simply pointing to the icon file? I did notice with the Icon only mapping I still had a "Edit File" in the Sharepoint drop down with the same error: "The document could not.....
Ideas?
Business Accounts
Answer for Membership
by: MsShadowPosted on 2009-10-22 at 09:38:11ID: 25636139
To change the icon:
ges\csv.gi f" Images should be 15×15 pixels in size. \DOCICON.X ML"
1.Save the image you wish to see as the CSV document icon to "Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\Template\Ima
2.Edit "Program Files\Common Files\Microsoft Shared\Web server extensions\12\Template\Xml
3.Add the following line <Mapping Key="csv" Value="csv.gif"/>
4.run iisreset