Tag: SharePoint

InfoPath

InfoPath 2007 – Populating from data/dropdown info from SharePoint lists using XML form data

Eric Kirkpatrick1 Comment

This article applies to InfoPath 2007 only as 2010 and 2013 no longer have this limitation. At some point during your career, you will need to connect to a SharePoint list to retrieve information for a drop down list.  This process has changed since 2007 but I thought that I would go ahead and share… Continue reading InfoPath 2007 – Populating from data/dropdown info from SharePoint lists using XML form data

SharePoint

SharePoint – Dropdown Menu/Navigation Does Not Work

Eric Kirkpatrick1 Comment

Have you ever logged on to your SharePoint site and the drop down navigation does not work?  After days of clicking around, I decided to fix the issue, which really was not much of fix. Turns out, this is an issue with my MS Office installation.  All that you have to do is run a repair… Continue reading SharePoint – Dropdown Menu/Navigation Does Not Work

SharePoint

Synchronize SharePoint list using Access 2007

Eric KirkpatrickLeave a comment

If you need to make changes outside of SharePoint to a list, you always have the option to use Access.  Follow these steps and you will be well on your way to using this feature. 1. Open your SharePoint list 2. Click Actions  –> Open with Access 3. A dialog box will pop up on… Continue reading Synchronize SharePoint list using Access 2007

SharePoint

A No-No for having Multiple SPD Workflows for Lists/Libraries

Eric KirkpatrickLeave a comment

Word of warning: If you need to have more than one workflow for a particular list/library, DO NOT copy a SPD workflow and paste back into the same library. What happens is that even if you change all of the properties of the files (names, etc.), there is still a hidden property that SharePoint likes… Continue reading A No-No for having Multiple SPD Workflows for Lists/Libraries

SharePoint

Need to edit multiple items to kick off a workflow? No prob Bob!

Eric KirkpatrickLeave a comment

I was faced with this task recently.  Let me paint the picture for you. I have a document library with over 1,000 items in it.  I added a new column (Named) that needs to have the same information as an existing column (Name).  For whatever reason, the web part I am using for my list… Continue reading Need to edit multiple items to kick off a workflow? No prob Bob!

jQuery

jQuery Security….. Just hide it!

Eric KirkpatrickLeave a comment

We had an issue come up about security with InfoPath forms.  One of the major issues was that we could restrict items in the view, but if you used explorer view, all of the security would be bypassed.  To counter this, we use a CEWP and the following jQuery script: HideViewsScript Please note, you will… Continue reading jQuery Security….. Just hide it!

List · SharePoint

Add a time duration to a list/library

Eric KirkpatrickLeave a comment

Years ago, I setup an InfoPath form for an approval process.  There are around 7 status changes during the duration of this form.  We wanted to be able to see how long a request would take from creation to approval.  This was actually pretty simple.  All that you need is a calculated column.  Follow these… Continue reading Add a time duration to a list/library

SharePoint

Copying files while retaining metadata

Eric KirkpatrickLeave a comment

There may come a time when you will need to move data from one source to another.  You could always use Windows Explorer to do this, but you will not be able to retain any metadata in your library. Recently, I needed to move around 1,200 files (680 MB) from a folder into a new… Continue reading Copying files while retaining metadata

List

Adjust Width of SharePoint Columns

Eric Kirkpatrick2 Comments

SharePoint lists and libraries are great.  However, you may have noticed that sometimes, the column width on certain items just looks funky.  To remedy this, all you need to do is add a little javascript. Go to the list or library that you want to resize and add a Content Editor Web Part. From the script… Continue reading Adjust Width of SharePoint Columns

SharePoint

How to Export a SharePoint User List to Excel

Eric Kirkpatrick11 Comments

There may come a time when you may need to export your user list to excel.  It’s not that difficult. Copy the following path into notepad/word pad: http://yoursite.com/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List=[LISTID]&View=[VIEWID]&CacheControl Minimize the text editor and navigate to Site Actions à Site Setting à People and Groups à All People. Click Settings on the option bar and click… Continue reading How to Export a SharePoint User List to Excel