|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |  | The International SharePoint Conference 2012 - Blogs, Slides, Downloads & Photos | | | Unfortunately I haven't had time to write my usual rundown for this year's International SharePoint Conference, which took place last week...
So this year's rundown will basically consist of the
following, in an attempt to ‘syndicate content' on the subject
Live Blogging :
http://engageinsharepoint.co.uk/2012/03/international-sharepoint-conference-live-bloggers-wanted-isclondon/
http://thomasvochten.com/categories/live/
http://sharepointfrancois.posterous.com/live-blogging-from-the-international-sharepoi
http://engageinsharepoint.co.uk/author/baddaz/
http://engageinsharepoint.co.uk/author/spdoctor/
Slides :
http://www.21apps.com/sharepoint/isclondonbus301/http://www.criticalpathtraining.com/Members/Pages/Presentations.aspx
http://www.joiningdots.com/blog/2012/04/when-technical-projects-fail/
https://skydrive.live.com/view.aspx?resid=6AF8677B7DC0B21D!2285&cid=6af8677b7dc0b21dhttp://www.paulgrimley.com/2012/04/supporting-sharepoint-internally-slides.htmlhttp://techblurt.com/2012/04/28/international-sharepoint-conference-slides/
Downloads :
http://visualstudiogallery.msdn.microsoft.com/166d71d6-0fb8-433d-bf08-72d5a3efe800
http://visualstudiogallery.msdn.microsoft.com/668d3881-b641-4f30-a513-0f9609892ac5
http://visualstudiogallery.msdn.microsoft.com/51a85e45-4a45-42cd-b21f-ff0c4cf729c1
http://spkbase.codeplex.com/
Subsequent Blog Posts :
http://blog.falchionconsulting.com/index.php/2012/05/international-sharepoint-conference-2012-follow-up/ (Note: Gary Lapointe is a Legend!)http://www.21apps.com/sharepoint/isclondon-a-personal-review/ http://www.sharepoint911.com/blogs/laura/Lists/Posts/Post.aspx?ID=174 http://blogs.msdn.com/b/ukmsdn/archive/2012/05/08/event-international-sharepoint-conference-a-review.aspx http://www.sharepointstudio.com/Blog/Lists/Posts/Post.aspx?ID=46
http://www.sharepointpromag.com/blog/dan-holmes-viewpoint-on-sharepoint-blog-24/sharepoint/sharepoint-presented-international-sharepoint-conference-142929
http://blog.mastykarz.nl/international-sharepoint-conference-london-2012-recap/ http://ghamson.wordpress.com/2012/04/25/last-day-at-the-international-conference-in-london/ http://www.andrewconnell.com/blog/archive/2012/04/30/wrapup-ndash-international-sharepoint-conference-2012-london.aspx http://www.thesharepointbaker.co.uk/2012/04/internation-sharepoint-conference-2012/
http://sharepointsarcasm.sharepoint.com/Pages/default.aspx
http://www.sharepointblog.co.uk/2012/04/the-international-sharepoint-conference/
Photos :
www.mattgrovesblog.com/search/label/ISC photos-from-the-international-sharepoint-conference-2012-Day-1
photos-from-the-international-sharepoint-conference-2012-Day-2
photos-from-the-international-sharepoint-conference-2012-Day-3
Again, huge thanks to @SteveSmithCK, @ZoeWatsonCK and everyone
at @CKUKLtd for another great conference.
| | | | SharePoint 2010 – Export SPList Data into SQL using PowerShell | | |
Following my previous post 'Import SQL Query Data into a SPList using PowerShell' I thought I should also post on how to achieve the reverse and export data from an SPList into a SQL Table
(if only for completeness, if nothing else...)
First task is to make the SQL Connection and prepare the SQL Command ..
######connect to SQL database windows authentication ###########$connection= new-object system.data.sqlclient.sqlconnection #Set new object to connect to sql database $Connection.ConnectionString ="server=<ServerName>;database=<databasename>;trusted_connection=true" # Connectiongstring setting for <ServerName> <databasename> with window authentication#$Connection.ConnectionString ="server=<ServerName>;database=<databasename>;User Id=<username>;Password=<password>;trusted_connection=False; # Connectiongstring setting for <ServerName> <databasename> with SQL authentication <username><password>Write-host "connection information:" $connection #List connection information Write-host "Connecting to database.." $connection.open() #Open Connection$SqlCmd = New-Object System.Data.SqlClient.SqlCommand #setting object to use sql commands$SqlCmd.Connection = $connection
Then retrieve the data from SPList...
######### Get SPList ########$spWeb = Get-SPWeb -identity "http://sp2010server/TeamSite/" # Get SPWeb $list = $spWeb.Lists["<My List Name>"] # Get SPListforeach ($item in $list.items){ ExecuteSQLInsert $item["Title"].replace("'","''") $item["splistColumn2"].replace("'","''") $item["splistColumn3"].replace("'","''") $item["splistColumn4"].replace("'","''") $item["splistColumn5"].replace("'","''")}$connection.Close() $spWeb.Dispose()
...and finally populate the target SQL Table using the data from the SPListItem
(Obviously, you will need to give some consideration in relation to
matching the 'DataTypes' of the SQL Columns, with those of the source SPList)
######### ExecuteSQLInsert function #############function ExecuteSQLInsert($sqlVAL1, $sqlVAL2, $sqlVAL3, $sqlVAL4, $sqlVAL5){$ErrorActionPreference = 'stop' # Prepare script for stopping$SqlCmd.CommandText ="INSERT INTO [sqlTABLE] ([sqlCOLUMN1], [sqlCOLUMN2], [sqlCOLUMN3], [sqlCOLUMN4], [sqlCOLUMN5]) VALUES ('$sqlVAL1', '$sqlVAL2', '$sqlVAL3', '$sqlVAL4', '$sqlVAL5')" # Configure TSQLTry{$SqlCmd.ExecuteNonQuery() #}Catch{Write-Warning "$_" # Report ErrorsWrite-Warning $SqlCmd.CommandTextWrite-host } }
SP2010ImportExportSPListToSQL - Examples.zip
| | | | SharePoint 2010 – Import SQL Query Data into a SPList using PowerShell | | |
Ever needed to quickly transfer SQL data into a SharePoint list?...
A recent task required exactly this, when i needed to migrate some SQL data held in a legacy application into SharePoint.
After a bit of messing around exporting multiple CSV files from SQL and importing them into SharePoint, I was confident that I could speed up the process with the use of a little 'Powershell'...
First task is to make the SQL Connection ..
######connect to SQL database windows authentication ###########$connection= new-object system.data.sqlclient.sqlconnection #Set new object to connect to sql database $Connection.ConnectionString ="server=<ServerName>;database=<databasename>;trusted_connection=true" # Connectiongstring setting for <ServerName> <databasename> with window authentication#$Connection.ConnectionString ="server=<ServerName>;database=<databasename>;User Id=<username>;Password=<password>;trusted_connection=False; # Connectiongstring setting for <ServerName> <databasename> with SQL authentication <username><password>Write-host "connection information:" $connection #List connection information Write-host "Connecting to database.." $connection.open() #Open Connection
Then retrieve the data from SQL Table.. (or theoretically from a 'SQL View', 'SQL Query' or even 'Stored Procedure')
######### SQL query #############$SqlCmd = New-Object System.Data.SqlClient.SqlCommand #setting object to use sql commands $SqlQuery = "SELECT [sqlCOLUMN1], [sqlCOLUMN2], [sqlCOLUMN3], [sqlCOLUMN4], [sqlCOLUMN5] FROM [sqlTABLEorView] " #set SQL query $SqlCmd.CommandText = $SqlQuery # get query $SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter # $SqlAdapter.SelectCommand = $SqlCmd # $SqlCmd.Connection = $connection $DataSet = New-Object System.Data.DataSet $SqlAdapter.Fill($DataSet) $SqlAdapter.Dispose()$connection.Close() $DataSet.Tables[0]
...and finally populate the SharePoint List using the retrieved data.
(Obviously, you will need to give some consideration in relation to matching the 'DataTypes' of the SQL Columns, with those of the target SPList)
######### Add to SPList ########$spWeb = Get-SPWeb -identity "http://sp2010server/TeamSite/" # Get SPWeb $list = $spWeb.Lists["<My List Name>"] # Get SPListforeach ($Row in $DataSet.Tables[0].Rows){ $item = $list.Items.Add();$item["Title"] = $Row["sqlCOLUMN1"]$item["splistColumn2"] = $Row["sqlCOLUMN2"]$item["splistColumn3"] = $Row["sqlCOLUMN3"]$item["splistColumn45"] = $Row["sqlCOLUMN4"] + $Row["sqlCOLUMN5"]$item.Update()}$spWeb.Dispose()
This can greatly speed up the process and also enables to you import data from multiple SQL Tables/Views/Queries and even target multiple SPLists.
SP2010ImportExportSPListToSQL - Examples.zip
|
| | | Build-SPFarm powershell scripts - (Gary Lapoint) | | | Super good post from Gary Lapoint, detailing how he used PowerShell to provision an entire SharePoint 2010 Farm (used throughout the IT track at the ISC conference) International SharePoint Conference 2012 Follow-up
| | | | SharePoint 2010 MSDN Virtual Labs Available Online - (Eric Ligman) | | | Great post from Eric Ligman detailing a collection of free SharePoint Server 2010
MSDN Virtual Labs available to you online that you can and should be
taking advantage of... SharePoint Server 2010 MSDN Virtual Labs Available To You Online, plus more SharePoint 2010 resources
| | | | Removing Unused Service Application App Pools using PowerShell - (JShidell) | | | Good tip from JShidell detailing how to removing Web Application Pools left behind in IIS, when you delete or remove a Service Application in SharePoint 2010, using PowerShell (it deletes the Service Application and its database fine, however it does not delete the Service Application App Pools) Removing Unused Service Application App Pools using PowerShell - (JShidell)
| | | | SharePoint Products and Technologies Protocol Documentation - (Microsoft Download) | | | The Microsoft SharePoint Products and Technologies protocol documentation provides detailed technical specifications for Microsoft proprietary protocols (including extensions to industry-standard or other published protocols) that are implemented and used in SharePoint Products and Technologies to interoperate or communicate with Microsoft products.The documentation includes a set of companion overview and reference documents that supplement the technical specifications with conceptual background, overviews of inter-protocol relationships and interactions, and technical reference information. SharePoint Products and Technologies Protocol Documentation http://www.microsoft.com/download/en/details.aspx?id=25255
| | | | Copy site collection from source farm to target farm - (Bram Nuyts) | | | Great step-by-step guide from Bram Nuyts (@BramNuyts) detailing how to copy site collections between SharePoint Farms using SQL Backup & Restore's and some simple PowerShell Copy site collection from source farm to target farm
|
|
|
|
|
|
|
|
|
|
|
 |
|
|
|
|