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 […]
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] // […]
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 […]
Had a request to create a report for Project Server milestones. There was a custom enterprise column added for tasks which contained a location code. My report had to return all values including where location was NULL. The first step was to get a valid NULL parameter in my Site […]
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 […]
I am using SSRS to report against an Oracle database source directly. For a while I was getting the following error. Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed. Apparently there is […]
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. […]
