SharePoinTopia

SharePoint Workspace, Property name invalid

2011-07-26T08:52:00.004+10:00

I had a number of users receiving a "Property name invalid" error when trying to sync to a SharePoint site in SharePoint Workspace. After numerous attempts at resolving the issue by running repair, un-install and reinstall with no success, I did some more research around the error message and found it was most likely a result of the XML parsing. After some further monitoring and log surfing i came up with the following solution.

Select Start > Run

Type “cmd” and select run

Run the following commands

Regsvr32 c:\windows\system32\msxml3.dll

Regsvr32 c:\windows\system32\msxml6.dll

Restart the computer

The users were all running Windows XP, Office 2007 and SharePoint Workspace 2010

PowerShell to Migrate Files from the File System to a SharePoint Document Library

2011-07-08T07:48:00.005+10:00

I had the requirement to copy all files and folders from a fileshare directly into SharePoint. Normally i would have just used explorer view however the terminal server that was being used didn't have the web client installed. I used the following poweshell to get the documents migrated
NOTE: this does not migrate security
NOTE: does not check for invalid charcters
NOTE: must be run on a sharepoint server joined to the farm


function ProcessDirectory($directory, $spfolder){
 $directory.GetDirectories()  foreach{
  #create direcotry
  write-host "creating directory" $_.Name
  $newfolder = $spfolder.SubFolders.Add($_.Name)
                #recurse directory
  ProcessDirectory $_ $newfolder
  }
 $directory.GetFiles()  foreach{
  #uploadfile
  write-host "uploading file" $_.Name
  $newfile = $spfolder.Files.Add($_.Name,$_.OpenRead(),$true)
 }
}
#you could use a local drive. If migrating from a remote server mount the share
#net use X: \\fileshare\sharename
#change current directory
x:
#get web
$web = get-spweb "http://companyweb"
#get the document library
$list = $web.Lists["TestMigration"]
$rootfolder = $list.RootFolder
#get DirectoryInfo object
$currentfolder = get-item .
#start process
ProcessDirectory $currentfolder $rootfolder

Unexpected error occurred while communicating with Administration Service

2011-06-08T13:25:00.006+10:00

Ran into the following issue when attempting to access "FAST Search keywords" from the site collection, even though i could access the fast adminstration from Central Administration. After some investigation i found that the web application app pool account had not be added to the FASTSearchAdministrators group on the Administration node of the FAST Farm (as mentioned in the technet article). After adding the account I was still receiving the error, after wading through the ULS logs i found the wcf service was returning with exception: "The trust relationship between the primary domain and the trusted domain failed". There are plenty of blogs out there detailing the exception, long story short it occurs when Principal.Isinrole is called to check permissions and the group used does not exist. I thought the wcf service was probably looking for the optional Security group and when it could not find it locally was going out to the domain, which obviously has issues. My resolution was to create the optional group FASTSearchKeywordAdministrators group (detailed in the technet article). I then added my app pool account to the group and everything started working as it should.

From the article: "The FASTSearchKeywordAdministrators group is not automatically created during installation, but can be created manually if you want to use this level of authorization."

Word Automation Services Job History

2010-11-01T15:57:00.004+10:00

I recently had to make use of the Word Automation Service application to convert word documents to pdf within sharepoint. If you have used the service application before you will be aware that once you queue a document you have to wait for the timer job to run before the document can be converted. There are some solutions which poll the service to see if the conversion process has completed successfully, but what if you what to view the status of previous and failed conversions? I couldn't find anywhere within Central Administration to view the history (let me know if I'm missing something!).

I knocked together the following powershell to output the jobs and their status.


[void][reflection.assembly]::Loadwithpartialname(“Microsoft.Office.Word.Server")  out-null
[Microsoft.Office.Word.Server.Conversions.ConversionJobStatus]::GetAllJobs("Word Automation Services", $null)  foreach {
$status = new-object Microsoft.Office.Word.Server.Conversions.ConversionJobStatus("Word Automation Services", $_.JobId,$null);
$_;
$status;
$status.GetItems([Microsoft.Office.Word.Server.Conversions.ItemTypes]::Succeeded)
$status.GetItems([Microsoft.Office.Word.Server.Conversions.ItemTypes]::InProgress)
$status.GetItems([Microsoft.Office.Word.Server.Conversions.ItemTypes]::NotStarted)
$status.GetItems([Microsoft.Office.Word.Server.Conversions.ItemTypes]::Failed)
$status.GetItems([Microsoft.Office.Word.Server.Conversions.ItemTypes]::Canceled)

}

SP2010 Powershell Access Denied

2010-07-21T10:16:00.002+10:00

If your using power shell to do anything (in my case upgrade user experience) and you get access denied even though you’re an administrator in as many places as you can think of. Add your account to shell admin using add-spshelladmin.

I need to webpart

2008-03-20T23:50:00.002+10:00

You may have noticed that you cant have 2 working "i need to webparts" on the same page. In order to solve this problem i edited the xslt and modified the javascript function name that was called to my own custom function name. I then added my own function to the master page to handle multiple webparts. If storing in the masterpage is not an option you could make a new/edit a js file in the 12 hive or add the script inline in the xslt.(however the script will be printed for every webpart that appears on the page. This does not cause an issue as the browser will use the last function defined). In order to make the changes quickly to all the webparts and to have more control in the future i stored the xslt in a top level document library then added the url to the xsl link property in the webparts i wanted to use this new script. i also exported and saved the new "i need to webpart"(with xsl link) to the webpart gallery for reuse later on.

Picture library with thumbnail fails to covert to xslt data view

2008-03-20T23:10:00.003+10:00

Today i had an issue hen i tried to convert a picture library view to an xslt view to add some custom actions. As soon as i converted the webpart i received an error: "Invalid XSLT stylesheet Error: invalid character". Once i opened the xslt i found that the thumbnail template had not been exported correctly and had malformed xml. Inorder to resolve the issue i simply replaced the thumbnail template with the following....

Conditional Format Javascript MOSS

2008-02-15T07:41:00.003+10:00

I have been able to test the javascript from an earlier post in MOSS and am happy to tell you it still works. I was able to use it to simulate traffic light kpi in a list. depending on the field value I loaded different images from the images folder.

IE Hangs when opening Address Book from sharepoint

2007-06-25T13:40:00.000+10:00

This is only an issue if you are using dual displays. The problem is: if you open your address book from the second monitor IE stops responding and you are not prompted to allow IE access to your address book. The simpile solution is move your browser window on to your main display and reopen the address book. Problem solved. Issue occured using Office 2003 with IE 6 or 7. havent tested with office 2007 yet.

APAC Sharepoint Conference

2007-05-01T21:47:00.000+10:00

I am now officially booked in for the Conference http://www.microsoftsharepoint.com see you there.

Conditional Formatting on a Sharepoint List View

2007-04-24T13:01:00.001+10:00

When using the sharepoint list view there is no way to have conditional formatting unless you convert it to a XSLT view within frontpage. Unfortunately when you do this you loose some features which you had eg. count. There are some issues with the filter functionality in the xslt web part. I have written some javascript which allows you to do conditional formatting on the client side. Just add it to a content editor web part after the view.

I will paste the javascript here shortly
As Promised

<script>
/*******************

Copyright (c) 2007 Tim Leyden          

This script can be used freely as long as all

copyright messages are intact.               

********************************/                                             
function format(textconfieldname, textcondition,formatfieldname,openformattag,closeformattag,tableid,islookupfield){

 var cfindex; //the cell index of condition field
 var ffindex; // the cell index of format field

 var array = document.getElementsByTagName('th');
 for (i=0;i<array.length;i++){
     if(array[i].innerText != null){
     //alert(array[i].cellIndex +" "+ array[i].innerText.substr(array[i].innerText.length-textconfieldname.length,textconfieldname.length));
     if(array[i].innerText.substr(array[i].innerText.length-textconfieldname.length,textconfieldname.length) == textconfieldname){
           cfindex = array[i].cellIndex;
     }
     if (array[i].innerText.substr(array[i].innerText.length-formatfieldname.length,formatfieldname.length) == formatfieldname){
             ffindex = array[i].cellIndex;
     }
}

 }

 var table = document.getElementById(tableid);
 var rows = table.rows;
 for (i=0;i<rows.length;i++){
     var cells = rows[i].cells;
     if (cells[cfindex]!=null){
         if (cells[cfindex].innerHTML == textcondition){
             var name = cells[ffindex].innerHTML;
             if(islookupfield){
                          name = name.replace (/self>(.*)(<\/A>)/,"self>"+openformattag+"$1"+closeformattag+"</a>");
                 cells[ffindex].innerHTML = name;
             }else{
                 cells[ffindex].innerHTML = openformattag+name+closeformattag;
             }


         }
     }
 }
}
/*
example
params    "field to check","value",field to format,"before tag","after tag","Html table id(this stays the same unless you change views","bool is it a lookupfield"
format("VIP","Yes","Phone Number","","","{BEEFD7E9- HTML TABLE ID(use view source to retrieve)-F03FDA1BA528}",false);
this will format the phone number as bold for all people who have the VIP field set to yes
*/
</script>

The script relies on the fact that the list view web part always outputs its html table in the same predictable format. You may need to make some changes to suit your application

A Recycle Bin For Sharepoint 2003 Part 1

2007-04-20T14:15:00.000+10:00

If you have seen the solution posted by microsoft here http://msdn.microsoft.com/msdnmag/issues/05/02/RecycleBinforWSS/default.aspx you may have been scared by the potential storage issue associtated with having a mirror document library. Over the next few days i will post how we implemented a recylce bin on wss

Filter a data view by current username rather then display name

2007-04-19T12:36:00.000+10:00

version info: Sharepoint 2003 and Frontpage 2003

I ran into a situation where a site owner wanted to restrict the items a user could see based on the current username. I am aware that using the standard data view you can filter by current user but this only works on display name which doesn't help if you have two users with the same name. So we added a username column which held 'DOMAIN\User' to identify which list items where allocated to a particular user.

Next you have to go into the web part properties for the list data view and edit the Parameter Bindings
find the line
<ParameterBinding Name="UserID" Location="CAMLVariable" DefaultValue="CurrentUserName"/>

modify this line to:

<ParameterBinding Name="UserID" Location="ServerVariable(AUTH_USER)" DefaultValue="CurrentUserName"/>

now UserID will hold the value 'DOMAIN\User' rather then 'Display Name'

Now go into the data view properties select 'Filter' add a filter where Field: Username equals [Current User]

There you have it. A List filtering on a unique domain user name rather then display name

Which Version?

2007-04-15T09:09:00.000+10:00

Ever Had the experience when you find an article and it seems to cover exactly what your looking for and you search the page up and down for some version info but can't find anything which details which version of the product the post is about. No. Must be just me. Anyway just to clear things up I will be mostly blogging about SharePoint 2003

Although I have been attending some training for 2007 and am very excited about the new product most of my ramblings will be concerning 2003 at least until my employer makes the migration(Hopefully soon). I will try to clearly state what product a post is relevant too.

Why Start Blogging?

2007-04-14T23:20:00.000+10:00

Today i decided that I would start a blog about my SharePoint experiences. Why? Even though I have never blogged anywhere about anything I have read hundreds of blogs and forums on SharePoint material and find it quite helpful. At the same time there are often problems I run into which I cannot find documented anywhere. So I decided that I should give a little back and not let my limited knowledge go to waste but share it in the hope that I might be able to help a fellow sharepointopian