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. […]
In some cases you may want to audit who has what permissions to various parts of your SharePoint site or farm. This query will give you a list of all of your groups, the roles / permissions of the groups, the users in those groups, and what they have permissions […]
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 […]
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 […]
Recently purchased a 2.6″ Inch TFT Touch LCD Display Module SPI ILI9320 for Arduino UNO R3 on eBay. Took a little digging, but I was able to find a library that actually worked with this thing. Click here to download the .rar.
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] // […]
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 […]
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 […]
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 […]
Discovered this SSIS dataflow task called HTTPDownload. The link here is a dtsx package you can import into Visual Studio. Modify the HTTP Connection Manager with the URL of the file. Note that this has to be specific, so the source file has to be the same if we are […]
