I needed a way for me and my teammates to see and edit all report subscriptions across a Sharepoint site with SQL Reporting Services in Integrated mode. There are two parts here; the first is a function that returns text between delimiters. This is important to get the site and […]
Category: Computer
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 […]
Arduino Uno R3 with 2.6 TFT LCD
Google Treemap Chart from Sharepoint list
Just a little exercise to pull data from a Sharepoint list and visualize it with a Google Treemap. My Sharepoint list was a simple query to pull Support Groups from BMC Remedy and the # of tickets ‘In Progress.’ The structure is [Title] (or Support Group), [Parent], [TicketsInProgress], [TotalTickets] // […]
Mini-Pinball Tablet Cabinet – Proof of Concept
Inspired by the Mini Pinball machine here: http://www.instructables.com/id/Mini-Pinball-1/ I decided to give this a try with a solderless version. Thanks to Pascal for working with me to reconcile some troubles I had with his PinballButtons.apk. Tips and Caveats: 1. You must install the PinballButtons app from above. 2. You must have the […]
Bulk update of shared datasource for SSRS reports
Accidently killed a shared datasource for 1000 reports. Found a handy query to update all those reports with a re-created datasource. Updated a couple of reports manually in Sharepoint. Ran the following against the ReportServer database. select c.Name as reportname, d.link, d.Name as datasource, d.dsid, d.itemid from Catalog c inner […]
SSIS: Upload file to Sharepoint Document Library
Downloading files from Sharepoint Library with SSIS
SSRS – Query for NULLs and Order by NULLs last
JQuery – Get Value of DIV with Custom Attribute
I have a ProjectServer with a custom field (Project Status Slide) where users have a URL for an image. I needed to retrieve the URL from the custom field and display it inline on the ProjectDetails.aspx page <div GUID=”xxxxxxx-xxxx-xxxx-xxxx-xxxxxxxx”>http://myserver/PWA/Pictures/Slide1.png</div> The source of the custom field resembles the above. I put […]