Adding Parameters To Excel SQL Query
The other day, I was asked to make an Excel spreadsheet that was populated by a SQL stored procedure parameterized. This spreadsheet is supposed to run each month to analyze the previous month’s sales and commissions. I wrote a stored procedure that automatically pulled the previous month’s data. Now, they wanted to specify the Start […]
Dealing with corrupt WebConfigModification entries.
Recently, I came across a problem. I had created a new SharePoint Designer Custom Action and I created a feature solution package to deploy it to the production farm. In testing it in a dev environment, I kept getting errors from the code I was using to make the appropriate web.config entries. A custom SPD […]
It Happens To Everyone
A co-worker pointed this out to me. Seems like someone was making a change to SharePoint.Microsft.com without testing and got the Unexpected Error! I’m sure it was unexpected! The site was down for only a little while but it gave both of us a chuckle. Thanks Matt!
A(nother) Business Case for Twitter
I can’t see why some companies continue to block Twitter access to their employees. Especially developers. For me, Twitter has been an invaluable resource. A wealth of 140 character wisdom. An constant supply of what is new in the SharePoint (or insert your favorite topic here) world. This example just happened to me yesterday. I […]
Removing OPTIONS with jQuery
Here’s a usability solution that was necessitated by my desire to present a logical, workable solution to my end-user. I’m still learning jQuery so my solution may not be the most elegant – but it works. I welcome any improvements! The Setup I have a SharePoint site that is displaying the results of an SQL […]
One of the reasons I like developing for SharePoint is that I get to work with many different technologies and platforms. When I am designing a custom list for (display, edit or new), There are times where I may have a delimited string in a field that I want to display differently on the screen. […]
A SharePoint Design Question
Normally, I write solutions to problems. This time around, I need some suggestions to get ideas on how to design a solution to a problem. The credit department where I work accumulates/produces documents to support the credit limit they grant our customers. We have categorized them as : Financial Statements Agency Reports Parent Guarantees Other […]
Notes to SharePoint Migration
The company I work for purchased the Quest Notes Migrator for SharePoint. Overall, it has saved me lots of time migrating from Lotus Notes. The main reason is that I have absolutely zero experience with Notes. Now, the Quest tool allows me to migrate all of the rows into SharePoint pretty painlessly. I was having […]
Exporting List Data
If you have list data that you want to use in another application, what are some ways to get to that data? That was the question posed by a recent requirement from a client. Fortunately, SharePoint presents us with some creative ways to get to the list data. Export to Excel. This is a good, […]
Why does making a Lookup site column an indexed field break my CAML Query?
when the EmailSource field is NOT set as an indexed column, this query would return all list items where EmailSource didn’t have a value. As soon as I set EmailSource as an indexed column, the query would always return zero items, even though I knew it should return some list items.