David Underwood’s Professional Blog

Let’s say that you’ve created a custom list in SharePoint 2007 and now you want the columns that you’ve added to be available when a new item is created or when items are edited. How do you go about doing this?

Open your list settings. Click on “Advanced Settings” under the “General Settings” section. From there ensure that “Allow management of content types?” is set to “Yes” and click OK. Back at your general list settings page you can now see a heading for “Content Types.” Click your content type (in my case “Project”) and you will see a listing of the columns available for the content type. Under the “Columns” heading you can click the link “Add from existing site or list columns” and add in your custom columns. These columns will now appear in your new item and edit forms!

Formula is: =IF($G1=”visa”,true,false)
Do this somewhere in row 1, then copy the format everywhere you need it. The
$ sign locks the formula on column G, while the row number is floating.
–
Best Regards,

Luke M

reply

Thank you, but I’m asking specifically about conditional formatting.
ExcelObsesse posted on Friday, December 07, 2007 3:06 PM

Thank you, but I’m asking specifically about conditional formatting. So,
going into format –> conditional formatting,  I need to enter a formula to
automatically highlight the entire row rather than just the individual cell.
Thoughts? Thanks again!

reply

That is the formula to use with the conditional format.
Luke posted on Friday, December 07, 2007 3:13 PM

That is the formula to use with the conditional format. You can copy
conditional formats from one cell to another.

Once you have the conditional format in once cell, copy, then select desired
area(or all, with Ctrl+A) to be affected, and right-click, paste special.
Choose format.

http://www.eggheadcafe.com/software/aspnet/31287951/conditional-formatting-fo.aspx

O’Reilly Book, Chapter 26
Active Directory and PowerShell

Snippet to Create User
ExpertsExchange

Managing AD With PowerShell
MSDN Blog

CSVDE and LDAP Properties

LDAP Schema
Florida State

Running PowerShell Scripts
O’Reilly

How To User PowerShell to Bulk Import Users
MS Server Admin

This is a great feature for the sysadmin… create a new folder and rename it to:

GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}

Read some more here:

http://news.cnet.com/8301-13860_3-10423985-56.html

Read CSV Into an ADO.NET RecordSet

http://www.daniweb.com/forums/thread38676.html#

DateTime Examples C#

http://www.geekpedia.com/tutorial98_Using-the-DateTime-object.html

C# Dictionary

http://www.vcskicks.com/dictionary.php

Dictionary<string, int> dictionary = new Dictionary<string, int>();

dictionary.Add(“1″, 1);

int j = dictionary["1"];

C# List Examples

http://dotnetperls.com/list

List<int> list = new List<int>();
list.Add(2);
list.Add(3);

Decimal.TryParse and Convert.ToDecimal
http://stackoverflow.com/questions/89203/difference-between-convert-todecimalstring-decimal-parsestring

One factor that you might not have thought of is the Decimal.TryParse method. Both Convert.ToDecimal and Parse throw exceptions if they cannot convert the string to the proper decimal format. The TryParse method gives you a nice pattern for input validation.

decimal result;

if (decimal.TryParse(”5.0″, out result))

; // you have a valid decimal to do as you please, no exception.

else

; // uh-oh. error message time!

This pattern is very incredibly awesome for error-checking user input.

String List string[] to an ArrayList in C#
http://www.daniweb.com/forums/thread82407.html#

string str= "12,13,14,15";

string[] strs = str.Split(',');
ArrayList strsList = new ArrayList();
foreach(string s in strs)
strsList.Add(s);

I found this nice article on using cursors to loop through a result set in a stored proc and take actions based on the value in the looped row:

This method will loop through all rows of a table regardless of what type the primary key is.

use YourDatabaseNameHere
go

declare @Field1 int
declare @Field2 int
declare @Field3 int

declare MyCursor cursor fast_forward for
select Field1, Field2, Field3 from YourTableNameHere

open MyCursor
fetch next from MyCursor
into @Field1, @Field2, @Field3

while @@fetch_status = 0
begin
— Perform Operations
declare myTest int
myTest = @Field1 + @Field2 + @Field3

– Advance the Cursor
fetch next from MyCursor
into @Field1, @Field2, @Field3
end

close MyCursor
deallocate MyCursor
go

This was on the following site: http://www.bunkerhollow.com/blogs/matt/archive/2009/03/10/ms-sql-loop-through-table-scripts.aspx

Twitteresque quick posts of links and information!

Why doesn’t my new column show up when I add or edit my list?
When adding a column to a list in SharePoint and using a template you may not see it in the New Item or Edit Item forms.
Sharepoint 2007

I found this neat article online when looking to combine two Quicktime files before encoding as a Flash video using the FLV encoder…

I am creating a site for our church utilizing Wordpress as a CMS and wanted to generate a quick favorite icon. Icon Composer to the rescue! I grabbed a gif of the PCUSA logo off a Google image search, did some conversion in Illustrator, dropped my resultant PNG into Icon Composer and boom! a nice favicon.

I’m including the files as a download for other churches to use.

Icon Composer is part of the Apple Developer Tools

Download the PCUSA Logo Pak here

In Windows 7 while using SQL Express 2005 on my local dev machine and attempting to restore a database I received the following error:

the operating system returned the error ‘5 access is denied. ‘…

I found a nice posting on the MSDN social site at this link which helped to solve my problem.

Just wanted to say that I had the same problem – I could not restore from a .bak file.

error 5(error not found).
RESTORE HEADERONLY

Using SQL Configuration Manager I changed my Logon to ‘Local System’ and this worked a treat.

So take heart – it does work!!!!

My steps in detail.

1. open up SQL Server Configuration Manager (I am using SQL Server 2005)

2.right click on SQL Sever Express (I assume it is the same for the full version of SQL Server)

3.Choose Properties

4. in the Logon tab – click the built in account radio button and choose ‘Local system’ from the drop down.

This worked for me

I am not sure if this is the most elegant or correct solution but it worked for me for the moment on my dev machine to get my database restored.

Thanks