Admin Archive

jQuery Rotating Banner Errors – IE vs Chrome

Posted October 18, 2012 By Kevin Bennett

So we created a Rotating Banner that pulls from the Blog Posts in the Sharepoint Blog but were having an issue with it showing in IE and Firefox but not in chrome. The actual solution I will post later but wanted to capture the fix incase it comes up someplace else.

In the jQuery SPServices Operation of GetListItems we needed to change:

jQuery(xData.responseXML).find("z\\:row, row").each(function(i)

I think it actually will do 2 searches of the List Items but since there are so few (max 4 or 5) I don’t think it matters much.

Be the first to comment

I know even as I was doing it that I was just being lazy. The issue was that each day I run a bitlocker script to update a chart of bitlockered machines on our intranet. The hard part (..right) was that I needed to manually create an Item in a Summary Graph so the numbers look pretty for my manager. In this list I had title, date, Bitlocker Yes, Bitlocker No. So basically I just needed to enter 4 things each morning. Being that I am a sys admin with the motto of work smarter and not harder 4 items to enter was WAY too much for me to bother with. So of course I set date to default to Today but needed a way to set the title to “MM-DD Report” (don’t judge me on originality, my manager liked it).

Simply added to the Title Column Default Setting Calculated with

=TEXT([TODAY],"MM-DD") & " Report"

So now I only have to enter 2 columns.
Now to figure out How to auto populate those other 2 fields and I might be able to sleep in an extra 5 minutes.

Be the first to comment

Update a SharePoint List from a CSV File

Posted September 15, 2012 By Kevin Bennett

So in the last post over on I created a CSV file for all the domain computers that had a Bitlocker key assigned to it.

Going with the work smarter not harder mantra this post will take that CSV file and update a list on our sharepoint site so I can create a graph.

Note that this must be run from a location where the Sharepoint Snap in is installed, this is usually where Sharepoint is installed so I would save this to a common drive and run from my app server.



# Check if the Sharepoint Snapin is loaded already, and load if not
if ( (Get-PSSnapin -Name Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue) -eq $null )
Add-PSSnapin Microsoft.SharePoint.PowerShell

#Setting our variables, Site name, List name, file to import and Caml
$spWeb = Get-SPWeb -Identity “https:///Departments/IT/”
$list = $spWeb.Lists[“Bitlocker”]
$csv = Import-Csv Q:\BitLockerComputerReport.csv

#sets up to remove current items from list
$query=new-object Microsoft.SharePoint.SPQuery
$query.ViewAttributes = “Scope=’Recursive'”

#removes current items from list
$items | % { $list.GetItemById($_.Id).Delete() }

#adds Report to SharePoint List
foreach ($row in $csv)
$item = $list.Items.Add();
$item[“Name”] = $row.Name;
$item[“OS”] = $row.OperatingSystem;
$item[“Location”] = $row.Location;
$item[“Bitlocker”] = $row.HasBitlockerRecoveryKey;
$item[“Virtual”] = $row.adminDescription;

#Dispose of SPWeb, to keep things clean and no memory leaks


Again, you need to change your site name, list name and make sure your list has the correct columns. I would task this to run after the script that creates the CSV file.

Next I have one more post in this series where I take the raw csv file and upload to a sharepoint library incase the bosses want to play around with the numbers (as they always do).

Be the first to comment

How To: Using SharePoint Calculated Columns to Display Current Month List Items

1. create two computed columns (both calculated columns return Date Only values):

      a. Created First Day Of Month

            i. =DATE(YEAR([Created]),MONTH([Created]),1)

      b. Created Last Day Of Month

            i. =DATE(YEAR([Created]),MONTH([Created])+1,1)-1

I then added the below filters to view:

Be the first to comment

Real quick before I forget:

Got the following error day on our Development Sharepoint 2010 server when I attempted to delete a Web Application.

“The located assembly’s manifest definition does not match the assembly reference. (Exception from HRESULT:0x80131040)”

Did an IISRESET on the application server and was able to delete

I believe this was because I was making changes to the web application and maybe it wasnt in sync with the DB?



Be the first to comment
%d bloggers like this: