PowerShell

SharePoint – Retrive the internal column name for lists/libraries using PowerShell

I have been using this method for some time now and decided to make a slight change to it.  I have been using the PowerShell method found here to find the internal column names for my lists and libraries.  It works great.  The only problem with this is that I have to modify the script each… Continue reading SharePoint – Retrive the internal column name for lists/libraries using PowerShell

SharePoint

Cannot publish InfoPath custom list form

Today, I ran across an issue when I went to customize a list with InfoPath.  I clicked on the ‘Customize Form’ button and it opened the item view in InfoPath as expected.  After I made my changes I went to publish my form.  I received the following error message: “InfoPath cannot connect to the server. … Continue reading Cannot publish InfoPath custom list form

InfoPath

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

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

Synchronize SharePoint list using Access 2007

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

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

List · SharePoint

Add a time duration to a list/library

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

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

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

List · SharePoint

Highlight line items in a SharePoint list

This is actually a very simple process and only requires a small amount of javascript to do the job. Follow these steps and your will be highlighting in no time!!! Go to your list to be highlighted Edit Page Add a Content Editor Web Part Move the CEWP to the bottom of the page Click… Continue reading Highlight line items in a SharePoint list

SharePoint

Happy Birthday Web Part

I wanted to be able to show all of the employees birthday’s for the current day.  Turns out, this was not a very hard task to accomplish.  I have a field in one of my lists’ that contains a birth date field.  All of the months and days are accurate, but the years are all… Continue reading Happy Birthday Web Part