General tips for editing Sharepoint with Office 2003 Programs

Editing Sharepoint documents with Office 2007 products is easy. You navigate to the document in sharepoint then open it...if you wish to edit it there is a nice and large simple 'Edit' button in the top right of the Office application you are viewing the document with.

As appears to be standard with Microsoft products, to do it in older versions is a little more confusing. For a start, you will only be able to do it at all so long as you're using Office XP or above. For another, the only way you will be able to use Sharepoint at all with Office XP/2003 is by ensuring that you have installed the appropriate Office Sharepoint Tool in the first instance.

To do this the process (which may be slightly different dependant on opperating system or Office version) is to goto Control Pannel --> Add Remove Programs --> Select the change button within the place holder for your Version of Office --> Tick the 'Install Advanced features' tickbox --> Click Next --> Expand Office Tools --> Select the 'Run Component from My Computer' option for the Sharepoint Services --> Click update button at the bottom. Once this has been done you have the ability to at least use Sharepoint services.

The next issue you will run into is that you when you open a document, it will only open in 'Read Only' mode. If you edit the file you will find that when you come to saving it, the only option is to save a local copy to your HDD or other personal storrage areas.

To conquer this problem you will have to hold the mouse pointer over the file you wish to edit first to reveal a dropdown box. Once this has appeared, expand the options and select the 'Check Out' option from the list available to you. Confusingly, this will promote the document to the top of the list (if there are more than 1 in the repositry you are viewing). You can then simply click on the document to open it in edit mode.

When you then come to close it, select the 'Check In' option from the Sharepoint toolbar down the right edge of the screen and give an update as to what has been done with the document. Once this is complete, select the close button in the top right of the program window to comlete your operations for that particular session....SIMPLES!

A note for Sharepoint admins...I have also found that a certain kind fellow has posted a solution to this online. It is in the form of a Javascript that runs on the point of clicking the link to open a file. Instead of going directly to the file, the user is presented with a question box which asks them whether or not they wish to edit the document. This solution can be found at:

• Tonstegeman.com

As the programmer mentions, it could very well save on a great deal of tounge bashing down the phone as low skilled users have to figgure out how to do the above procedure.

Deleting dead services

Found an interesting DOS command today thanks to Will off of Superuser.com.

The following command can be used to delete a dead Windows service from the services Microsoft Management Console (MMC). A dead service may occur when after uninstalling a piece of Software whose service had been disabled and not re-enabled prior to the orighinal removal process.

Be warned though, you have to KNOW that the service is dead before you attempt to delete it. If, upon attempting to set a service to run automatically and attempting to start it in the 'Services' MMC, you receive messages such as 'cannot find the associated EXE', it is almost a sure fire indicator that a service is dead...whether this is a good thing or not in terms of your system is for you to decide.

What can be taken for granted is that at this point the service itself is not likely to be having any effect on anything within your operating system. If in doubt, use the Services MMC to find out where the EXE should be storred (usually C:\Program Files\[Folder Named After Associated Software] or similar). Simply right click the service and look in the general tab. Navigate through to this location and make double sure that the particular file or folder no longer exists.

To delete a DEAD service:

• Logon to the terminal with the offending service as administrator
  
• Unless you have a shortcut, open a CMD window from the following location:
  
  Start --> Run
  
  
• Type:
  
  SC query state= all >> "C:\[preferred folder name]\Services_list.log"
  
  
• Hit the Return/Enter key (not too hard!)
  
• Open the log file created by the above CMD statement (which should be saved to the location stated after the double chevrons (the ">>" bit))
  
• Browse through the file created to find the name of the System name of the service you want to remove. Remember, take time to be ABSOLUTELY SURE it is a service which you definately wish to get rid of and that it is one that can be gotten rid of without destroying the backbone of your operating system.
  
• Note it down or highlight and copy it from the 'Services_list.LOG'
  
• Click back to the CMD window.
  
• Type the following command:
  
  SC Delete [Service Name]
  
  
• Hit Return/Enter again.
  

This should result in a message appearing on the screen detailing that the offending service has been removed from your system for good. This method negates the potentially operating system trashing need to trawl through your registry to find the offending entries.

The 'SC' command in DOS appears to be a rather usefull tool with many different uses. Simply open a CMD window and type:

SC /?

...to reveal its further uses. This can be done for most every DOS command should you be at a loss on how to utilise it.

Hope this helps someone. Feel free to drop me a line if it does!!