Microsoft SharePoint 2007: Pulling Column Data from one list to another based on a common list field

I found a little trick the other day that has helped me with a project I am currently working on. It's a relatively simple workflow but it is very powerful. What I am going to explain is how to pull in list fields from one list to another, your current list, based on a single lookup value. This workflow has probably saved me multiple hours’ worth of work and is pretty simple, once you get everything right. Basically, what we are trying to do is pull in multiple fields from some list on your site to your current list, using a single link between the two lists in the form of a lookup value on your current list. I am…

Definitive Logic is a Strong Supporter of the Federal Mobile Computing Summit

Definitive Logic was a sponsor at the Federal Mobile Computing Summit in Washington, DC. This was a great venue to showcase our mobile platforms we've built over the past couple years. It's very encouraging for us to see so many government technologists and subject matter experts interested in extending their employee and citizen facing services to the mobile platform. The goal of "bring your own device" (BYOD) is closer than we think and will enable quick and effect use of all mobile platforms but most importantly provide the same services on a platform that is familiar and friendly to the user. Other interesting and relevant topics were discussed at the conference such as sharing data and services through APIs, enabling…

Timer Job Workaround

Timer Job Workaround with SharePoint Designer Workflows Recently I was challenged with creating a SharePoint workflow within SharePoint Designer that would run once a week and log the state of an item. This log would help identify the changes in an item over time.  Now normally I would have done this through a timer job in Visual Studio (Creating Custom Timer Job in SharePoint 2010), but this was not an option in the environment I was working in. After some Google-ing and testing in my development environment, I found a way to accomplish this through two SharePoint Designer workflows.  The following is an overview on how I accomplished it. Design At first I modeled the workflow to follow these steps:    …

PL/SQL Web Stack Tips — Part 1

The Oracle 10g, PL/SQL, mod_plsql web stack has some crippling limitations as compared to more modern alternatives. Nevertheless, if it's what you're working with, there are a few easy tricks you can implement to "modernize" the request-handling layer of your PL/SQL web application. Before we start, the specific limitations this post series will address are:

The Skills and Tools You Need to Make Your SharePoint Project Successful

Introduction SharePoint can be a wonderful tool for an organization to facilitate its business processes, reporting, and collaboration. However, many SharePoint projects do not reach their potential or go underutilized (SharePoint as just another network share). This risk can be contributed to not having the right staff with right skills and right tools to make the project successful. With Definitive Logic’s successful SharePoint integration and implementation projects, DL has identified the right skills and tools to accomplish such projects. The Right Skills While it’s obvious that a SharePoint developer should know SharePoint and Visual Studio, it’s not so obvious what technologies SharePoint is founded on that a developer should understand. The following are some of the core concepts a SharePoint…