I have an email-enabled document library where reports in PDF format are delivered daily. I need to display the most recent reports embedded on a Web Part page. The filenames are structured as name_datestamptimestamp.pdf Different reports are sent here so I have to discern a part of the filename (eg. […]
Category: Computer
SQL queries for Sharepoint 2010 Site and User Permissions
Manage all SSRS Subscriptions in Sharepoint
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 […]