I was using the SSIS Sharepoint List Adapter and ran into an issue with importing calculated columns and People columns. The import process was inserting USERID;#Username into my People column in the destination database table. It was also inserting datetime;#12/12/2013 into my date fields. I found a handy script component […]
Tag: Sharepoint 2010
Sharepoint 2010 Farm Solution Successfully Deployed but Not Deployed
Ran into an issue with adding a solution to the farm using Add-SPSolution and then Install-SPSolution. The solution showed Successfully Deployed, but Deployment Status was Not Deployed. There may have been an issue with the web.config not syncing across the servers. I was able to force deployment with: stsadm -o […]
SSIS: Upload file to Sharepoint Document Library
Sharepoint 2010 Email-Enabled Discussion List Content Query Web Part
Sharepoint 2010 Backup and Cleanup Scripts with Notifications
Simple scripts that you can automate with the Task Scheduler to backup/cleanup your Sharepoint 2010 farm with email notifications. Backup Script try { $today = (Get-Date -Format dd-MM-yyyy) #Location of the Backup Folder [IO.Directory]::CreateDirectory(“E:BackupDailyFarmBackUp$today”) # This will actually initiate the SPFarm backup. Backup-SPFarm -Directory E:BackupFullFarmBackup$today -BackupMethod full # Backup-SPFarm -Directory […]
Sharepoint 2010 VM Clone Wars
Sharepoint 2010 Personalization Site and Global Navigation Audience Targeting
For whatever reason; the Global Navigation in a Personalization Site template does not support Dynamic FlyOut menus OR Audience Targeting. I had added several custom links in my top navigation bar and audience targeted them according to specific user roles. All users, however, could see every link regardless of the […]
Dynamically Resize Sharepoint 2010 Report Viewer Web Part
Selection is not a valid PerformancePoint content HotFix
There is now a hotfix which addresses my previous post regarding PerformancePoint not setting the location on the web parts without user intervention in manually typing the correct location. The problem was a regression in the June 2011 CU that caused the asset picker to stop functioning properly http://support.microsoft.com/kb/2597936