Software – Page 2 – markwheeler.com

Submitting Date/Time with InfoPath to Web Services

February 18, 2016 mmwheeler

I created an Infopath for users to request teleconference numbers. I have two lists; Schedule and Conference List. Schedule list had these columns: Title, Start Date, End Date, Attendees, Status, Assigned. Conference List had these columns; Source (which will be set to Title above), Title, Phone Number, Start Date, End […]

Working around SharePoint 2010’s 5,000 item view limits

January 8, 2016 mmwheeler

Update 1/13/2016 – Changes to script. The original script hides the list view pagination. Changes marked as Pagination Fix below. I have a SharePoint list that has exceeded the 5,000 item limit threshold. This, of course, causes a couple of views to go bonkers. I indexed several list columns but […]

Managing SharePoint User Group Memberships with JQuery and SPServices

December 16, 2015 mmwheeler

Create a simple interface to add/remove a single user to/from multiple groups at once. When you identify/select a user, it will show you two select lists. The right side will list all of the groups the current user is a member of while the left box shows all the groups […]

Query for SharePoint Groups and Members with JQuery and SPServices

December 15, 2015 mmwheeler

The following code returns all SharePoint permissions groups and the respective members. This uses JQuery 1.xx and SPServices. // Add JQuery and SPServices references. // GroupMember

BMC Remedy Assigned Group Incident Transfer(s) Query

January 22, 2015 mmwheeler

Had a request from a customer for a report showing the number of Remedy incidents transferred from his managed group to other groups during a given date range. I figured out a pseudo lead/lag query for SQL Server 2008. This creates an output that aligns the current row with the […]

SSIS: Upload file to Sharepoint Document Library (revisited)

April 24, 2014 mmwheeler

A while ago I showed how to upload a file to a Sharepoint Document Library using a File Task in SSIS. Here’s another solution…Simply cut and paste the following into a Script Task in your SSIS package. This is the simple version as the local file, Sharepoint URL and service account credentials […]

Import InfoPath XML to SQL Table with SSIS

March 10, 2014 mmwheeler

Had a request to import InfoPath forms into a SQL table for consolidating reporting purposes. In this scenario the InfoPath form data is stored in the form XML itself. The InfoPath form is for tracking project activities and has 6 fields: Project Leader, Week End Date, Accomplishments, Milestones, Risks, Lessons […]

SSIS package to Send Email based on SP Task List Due Dates

February 26, 2014 mmwheeler

Had a request to send notification emails against a SharePoint Task List when the Due Dates were 90, 60, 30 and 5 days out. Steps: 0. You will need to create the 6 variables show on the left. 1. I am dropping and importing the SP List Data each time […]

Adding StripLines with Report Builder

February 6, 2014 mmwheeler

I have a Forecast/Trending Chart that has past and future dates. I needed to denote Today with a vertical StripLine on the chart. (Click on images for larger version.) You can add a Marker with an expression easily. In your series properties; create an expression for your Marker. In my […]

JQuery Sharepoint Document Library for most Recent File(s).

January 11, 2014 mmwheeler

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. […]