When running SharePoint in your environment, I don’t know about you, but I always want it to behave like a finely tuned machine giving the best performance possible.
One thing you may not have noticed until someone mentions it to you might go something like this: “Every morning when I come in and log into SharePoint, it seems slow at first, but after that it seems much faster the rest of the day.”
Well how can we prevent this from happening? With another project on CodePlex I ran across called SPWakeUp
This project works on either WSS, MOSS, Foundations, or SharePoint Server 2010. It can be run manually or can be scheduled to run at a certain time each day (which is what I do). I am in the process now of putting it on all of my servers and once I have used it for a while I will write another follow up post describing some more of the functionality.
In the meantime, enjoy! No more first time slowness!
Here recently I had been working on organizing some content under SharePoint 2010 and I kept running across this error when trying to open a list or library in the datasheet view:
This was frustrating so I went to MSDN and fortunately a good discussion was done over this topic:
Thanks to Jenny E for the answer, but to recap, the solution for me was to install the 2007 Office System Driver: Data Connectivity Components.
After I installed the AccessDatabaseEngine.exe file locally and exited and cleared my IE cache, it works perfectly!
I can now edit my lists and libraries in the data sheet view under IE9 x64 version.
As I was researching for a way to do this I ran across several blogs that told me how to add an image for a .csv icon to show up under SharePoint 2010.
Here’s one that I really liked:
(Dave Coleman is awesome BTW)
Which the process here can pretty much be copied with any file extension type you want to connect with any other icon. Dave does a great job explaining this.
So I was originally looking for a way to map the .csv icon here to map to the icon that normal shows up when you save a .csv under excel.
I found out (to my surprise) that if you look under the images folder at:
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\IMAGES
There actually is an image of a .csv (csv16.gif) there, it’s just not associated with anything.
So in order to hook this bad boy up to SharePoint we need to go into:
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\XML
<Mapping Key="csv" Value="csv16.gif" OpenControl=""/>
under the heading <ByExtension> and directly under the entry:
<Mapping Key="css" Value="iccss.gif" OpenControl=""/>
Then do an IIS Reset and upload a .csv file to test it out and see if it works. I have confirmed that this file does exist for both Foundations and SharePoint Server 2010.
Enjoy and happy SharePointing