Sharepoint – 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

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

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

SQL queries for Sharepoint 2010 Site and User Permissions

November 14, 2013 mmwheeler

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

Manage all SSRS Subscriptions in Sharepoint

October 4, 2013 mmwheeler

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