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 […]
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 […]
Update 4/23/2014: I have posted a new method using a Script Task. Had a request to dump a large dataset from a SQL query into a CSV file and then upload that file to a Sharepoint document library. Because the resulting file was large, I zipped the file using a […]
I had a recent request to allow supervisors to post “kudos” emails to a Sharepoint site for display on a “dashboard.” They did not want it to be labor intensive by having to logon and copy/paste email content to a list. To achieve this I created an email-enabled discussion list. […]
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 […]
I have a Sharepoint 2010 standalone farm consisting of a WFE VM and a SQL Server 2008 with SSRS, SSAS on another VM. This farm lives in DataCenter1. Because of network issues and proximity to a data warehouse; I needed to move these VMs to DataCenter2. Once the VMs were […]
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 […]
Came across this blog which shows how to dynamically resize a Reporting Services Viewer Web Part to fit the height of the content/report using JQuery. Here’s the code for completeness. For my execution, I placed this on an HTML page and call it through a Content Editor Web Part. <script […]
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
Feature-creep version! I have added an additional list configuration/lookup column called Color. This allows you to specify an alternate icon/color for your push-pins by item. The format of the Color column in your list should be Single Line of Text and in the form of a URL. In the example […]
