Finding files ( SharePoint migration )

Scripted migration means logs full of errors, and sometimes the meaningful stuff is on a line or 2 above:

awk "{lines[NR] = $0} /ps1:45 char:37/ {print lines [NR-7]} {delete lines[NR-7]}" imp2

This handy little awk line gets the line 7 lines above the string you are looking for ( in this case it’s ps1:45 char:37

another way is to use grep –b 3 searchedstring inputfile.txt

which gets all 3 lines before the string, and –a will get the lines after

TF250008: This SharePoint site is not currently associated with a team project in Team Foundation Server

When you get this nasty message in the SharePoint collection of the project.

You get loads of these square error boxes all over the page.

Anyway the fix for it is to connect to the SharePoint collection to the TFS project.

Follow the instructions here:

http://msdn.microsoft.com/en-us/library/dd386320(VS.100).aspx

When the instructions say:

To add a SharePoint site as a portal to an existing team project

1. In Team Explorer, right-click the name of the project, point to Team Project Settings, and then click Portal Settings.

”Team Explorer” Is the window in Visual Studio when you connect to TFS.

Print previous line

Print previous line

Ok This was a test for a plugin for Chrome called AddThis to publish links,
No bad.

Create a complete content source with rule etc.

Get the search application

$searchapp = Get-SPEnterpriseSearchServiceApplication "Search application"

Create the content source

New-SPEnterpriseSearchCrawlContentSource -SearchApplication $searchapp -Type web -name IT -StartAddresses http://it

Add the inclusion rule

New-SPEnterpriseSearchCrawlRule -SearchApplication $searchapp –path http://it/* –CrawlAsHttp 1 -Type InclusionRule

And reduce the hit rate
New-SPEnterpriseSearchSiteHitRule myHost -Behavior 0 -HitRate 40

Ta Daaaaa!

 

Problems

I don;t know why but I never get on with Identity,

New-SPEnterpriseSearchCrawlRule -SearchApplication $searchapp -Identity http://it -CrawlAsHttp 1 -Type InclusionRule

   1: PS C:\Users\alman> New-SPEnterpriseSearchCrawlRule -SearchApplication $searchapp

   2:  -Identity http://it -CrawlAsHttp 1 -Type InclusionRule

   3: New-SPEnterpriseSearchCrawlRule : A parameter cannot be found that matches para

   4: meter name 'Identity'.

   5: At line:1 char:72

   6: + New-SPEnterpriseSearchCrawlRule -SearchApplication $searchapp -Identity <<<<

   7:  http://it -CrawlAsHttp 1 -Type InclusionRule

   8:     + CategoryInfo          : InvalidArgument: (:) [New-SPEnterpriseSearchCraw

   9:    lRule], ParameterBindingException

  10:     + FullyQualifiedErrorId : NamedParameterNotFound,Microsoft.Office.Server.S

  11:    earch.Cmdlet.NewSearchCrawlRule

found that using the path switch worked better:

New-SPEnterpriseSearchCrawlRule -SearchApplication $searchapp –path http://it/* –CrawlAsHttp 1 -Type InclusionRule

Unable to Open Excel in Sharepoint 2010 "The workbook cannot be opened" Error

error

I’ve got this error , pretty much the same as everyone else.

http://blogs.msdn.com/b/jjameson/archive/2010/05/04/the-workbook-cannot-be-opened-error-with-sharepoint-server-2010-and-tfs-2010.aspx

http://geekswithblogs.net/AmanGarg/archive/2011/04/23/unable-to-open-excel-in-sharepoint-2010-the-workbook-cannot.aspx

In the log as described I got the error

   1:  

   2: Insufficient SQL database permissions for user 'Name: BEILUX\svc_spdservice 

   3: SID: S-1-5-21-2123242984-1537360481-1219115889-45643 ImpersonationLevel: None' 

   4: in database 'WSS_Content_8080_DEV1_CORP_d3e5b5ca599743afba85046cee6e5a71' on SQL 

But just running the PowerShell did’nt work

$webApp = Get-SPWebApplication http://myServer

$webApp.GrantAccessToProcessIdentity("MyDomain\svc-spserviceapp")

So I had to also grant dbo to the service user svc_spdservice. I know in the  jjameson blog it is not needed after the powershell but it was for me.

TimerJob part 1

I’m trying to create a timer job and I know I’m going to make every mistake in the book, so here is mistake one :

When you create the empty SharePoint project do NOT choose sandbox or you get this error:

The type or namespace name 'SPJobDefinition' does not exist in the namespace 'Microsoft.SharePoint.Administration' (are you missing an assembly reference?)

oh and BTW this seems to be the best guide so far to create a timerjob

http://blog.sharepointupshot.com/posts/category/developmentguides/403/

Colligo Contributor OutLook Add-In For SharePoint

Colligo outlook addin for SharePoint is a great product, how microsoft just did’nt do it properly in the first place is a mystery, but hey Colligo’s gain.

I’ve had a few problems with large lists, realy large lists ,12000 plus. I know MS say don;t go over 5k but…. Anyhoo you can look to see how Colligo keeps the data in a SQLite DB locally.

To improve performance I tried adding my own indeces, unfortunately it did not like it at all. In the end we found a way to bring the list size down.

If you want to look at the data yerself get SQL Lite browser from here:

http://sqlitebrowser.sourceforge.net/

then open up the Collgio DB which is usualy here :

C:\Documents and Settings\{current user}\Local Settings\Application Data\ColligoOfflineClient\Storage5

Then you can browse and see the list lookups.

Get A List Of Indexed Content Sources In SharePoint PowerShell

Want to see the list of SharePoint Search content sources on the command line with PowerShell?

$contentsource = Get-SPEnterpriseSearchCrawlContentSource -SearchApplication $searchapp

Get-SPEnterpriseSearchCrawlContentSource -SearchApplication $searchapp

Name             Id   Type                 CrawlState      CrawlCompleted
----             --   ----                 ----------      --------------
Local SharePo... 2    SharePoint           Idle            9/29/2011 10:16:0

http://instit... 26   Web                  Paused          11/17/2011 11:30:...
http://intran... 27   Web                  Idle            11/4/2011 8:24:28 PM
http://intran... 28   Web                  Idle            11/4/2011 8:30:38 PM
http://intran... 29   Web                  Idle            11/4/2011 8:27:08 PM
rp               30   Web                  Paused          11/17/2011 11:30:...

OutLook Form Designer For the Clueless

To set one field with the value of another :

Sub CommandButton9_Click
  Set TextBox9 = Item.GetInspector.ModifiedFormPages("P.2").Controls("TextBox9")
  TextBox9.Text =  Item.GetInspector.ModifiedFormPages("P.2").Controls("TextBox1").Text
end sub

To create a new appointment do this :
Dim objOL 'As Outlook.Application
Dim objAppt 'As Outlook.AppointmentItem
Const olAppointmentItem = 1
Const olMeeting = 1
Const olFree = 0

Set objOL = CreateObject("Outlook.Application")
Set objAppt = objOL.CreateItem(olAppointmentItem)

objAppt.Subject = "My Test Appointment"
objAppt.Start = #8/19/03 3:50:00 PM#
objAppt.Duration = 1
objAppt.Location = "Followup"
objAppt.Body = "Test Verbiage"
objAppt.ReminderMinutesBeforeStart = 1
objAppt.BusyStatus = olFree
objAppt.Save()
Set objAppt = Nothing
Set objOL = Nothing
End Sub

( copied from http://www.pcreview.co.uk/forums/create-calendar-appointment-vbscript-command-button-t1836976.html )

but to display it before sending use objAppt.Display()   ( handy for debugging )


To display the current user:
Sub DisplayCurrentUser()
 Dim myNamespace 'As Outlook.NameSpace
 Set myNameSpace = Application.GetNameSpace("MAPI")
   Set TextBox4 = myNameSpace.CurrentUser
MsgBox myNameSpace.CurrentUser
End Sub
Also handy in there for debugging is the MsgBox.

when creating a new appointment though using the already filled in start and end on the screen

you cannot just do this :


    With objAppt
        .Subject = "My Test Appointment"
        .Start =  Item.GetInspector.ModifiedFormPages("P.2").Controls("TextBox1").Text
 ( BTW the start field is called TextBox1 ), you do that you get TypeMismatch: Cannot coerce parameter value. OutLook cannot translate your string  :

So what you have to do is substring it to get just the day/month/year eg
    With objAppt
        .Subject = "My Test Appointment"
        .Start =   Mid(TextBox9, 5, 10)

SharePoint Search: An efficient DDoS machine

Crawler Impact Rules in SharePoint PowerShell is :

New-SPEnterpriseSearchSiteHitRule -Identity myHost -Behavior 0 -HitRate 40

The TechNet article lists it:

http://technet.microsoft.com/en-us/library/ff608048.aspx

Yet when you run it you get :

New-SPEnterpriseSearchSiteHitRule : A parameter cannot be found that matches parameter name 'Identity'.At line:1 char:44+ New-SPEnterpriseSearchSiteHitRule -Identity <<<< itwiki -Behavior 0 -hitrate2+ CategoryInfo : InvalidArgument: (:) [New-SPEnterpriseSearchSiteHitRule], ParameterBindingException+ FullyQualifiedErrorId : NamedParameterNotFound,Microsoft.Office.Server.Search.Cmdlet.NewSearchSiteHitRule

If you remove the -Identity and just use :

New-SPEnterpriseSearchSiteHitRule myHost -Behavior 0 -HitRate 40

All is right, and on you go.

Begin At The Beginning...

Ok after much resistance, I'll start.
Much of this will disapear, only to live in search indexes until the end of what ever.

But having over the years benefitted from other peopl sharing their errors, and troubles and fixes, I think I better also start giving a little too.