How To Fix Object Not Set To Reference Of An Object Error During Deploy To SharePoint 2007 in Visual Studio 2007



TODO:

When deploying a feature in SharePoint 2007, Visual Studio 2008, you get the odd and vague error "Object Reference Not Set To An Instance Of An Object" error. 

 

SOLUTION:

The solution that worked for me, was to change th "Load User Profile" to "true", in the Advanced Settings of the Cetnral Admin App Pool.  Mine was set to false by default.

 

NOTES:

I have no idea why this works.

How To Fix Unable To Start Debugging Error



TODO:

I was trying to debug a SharePoint 2007 feature, in Visual Studio 2008, on IIS 7, and was getting the "unable to start debugging on the web server the web server is not configured correctly" error.  I seen many posts on this but what worked for me is documented below.

 

SOLUTION:

Open up you site in IIS.

Right click on the site, and choose Properties.

Click ".Net Compilation"

Under "Behavior", click Debug and set to True.

Now you can debug from Visual Studio

 

NOTES:

There are no notes on this topic.

How To Copy Files From Mac OSX To Remote Desktop (RDP)



TODO:

Have you ever wanted to copy files from your Mac to your RDP session.  In Windows land, you can just ctrl+c the file and ctrl+v it.  That is not the case with the MAC OSX Client.

 

SOLUTION:

Open RDP Preferences.

Click "Drives"

Select the drives/folders you want visible

Exit out

 

NOTES:

You will have to restart your RDP Session for the changes to stick.

After doing so, you will see "folder name on mac name" under "Computer"

How To Insert Data From A Select



TODO:

Have you ever wanted to insert data by selecting values from a table?


SOLUTION:

Consider we have a table called XMLData, and it has a column called Id, Type, RawData

 

INSERT INTO XMLData (RawType, RawData)
SELECT 'Client', RawData FROM XMLData WHERE RawType = 'Customer'

 

NOTES:

The example above will copy records flagged as RawType = 'Customer', and insert them as new records, changing the RawType to 'Client'

Cannot Copy SQL Server Database Due To "Unable to determine if the owner X of job Y has server access"



TODO:

Have you tried to copy a database in SQL Server Management Studio, and receive the following error "SQL Server Scheduled Job 'CDW_X_X2008_X_X2008_5_4' (0x623E46E604C04B4EB2BA2310660B1E3D) - Status: Failed - Invoked on: 2012-07-12 10:20:47 - Message: The job failed.  Unable to determine if the owner (X\Administrator) of job CDW_X_X2008_X_X2008_5_4 has server access (reason: Could not obtain information about Windows NT group/user 'X\Administrator', error code 0x534. [SQLSTATE 42000] (Error 15404))."

 

SOLUTION:

In my case, the DB owner, was associated with the Administrator account of my old server.  I had replaced it with a new server and moved all of the databases over to the new machine.  I simply went to "Logins" under "Security", and renamed the old user to the new user,  executed sp_changedbowner 'newowner' (use sp_helplogins to get list), and lastly went back and re-ran the copy job, and all worked as expected.

 

NOTES:

There are no notes on this topic.

How To Switch Between Windows Within An Application In Mac OS X



TODO:

Have you ever wanted to toggle between multiple windows within the same application, for instance Outlook?

 

SOLUTION:

The CMD+~ (command tilde) key combination will do this.

 

NOTES:

Work for **most** applications

Does My MacBook Pro Take 16GB of RAM When Then Specs Say It Takes 8GB Maximum



TODO:

Have you wondered if your MacBook Pro will handle 16GB of RAM?

 

SOLUTION:

The answer is MAYBE.  I have a MacBook Pro 17", 2.4 GHz Intel Core i7 machine, and it in fact will take 16GB of RAM.  It uses DDR3 1333MHz, 204 pin Crucial memory.  The rule of thumb is to go to the Crucial website.  Once you locate the memory that you need, you can buy it from them, or in my case I went to Micro Center's website and purchased it there. I paid 64.99 per 8GB, pretty cheap, I thought.  Next i simply popped in the new RAM, and it was off and running!

 

NOTES:

I am pretty sure this is not documented or supported by Apple.

How To Display A Root List In a Sub-Site in Share Point Online



TODO:

Have you ever wanted to show a List that was created at the root level site in a sub-site?  For example below we want to show the list "MyList" which was created in Site A in subSite B.

Site A -> MyList

Site A -> SubSite B -> MyList

 

SOLUTION:

To accomplish this, navigate to the root level. 

Create a Web Part Page. 

Export the Web Part Page to the Web Part Gallery.

Navigate to the page in the sub site where you want to see the list, and Add the Web Part from the Web Part Gallery

Now your list will appear in the sub-site.

 

NOTES:

I have ran into issues when using IE 64-bit.  in particular with exporting Web Parts, and also with having the DataSheet View button enabled.

How To Default a Choice Column To Day Or Year In SharePoint 2010



TODO:

Have you ever wanted to default the value of a Choice column to the current month or year?

 

SOLUTION:

1.  Create your column, and make it type "Choice"

2.  Populate it with values (ex.  2011, 2012, 2013...)

3.  For Default Value, choose "Calculated Value"

4.  In the text field for the formula enter "=CONCATENATE(YEAR(Today))"   (without double quotes)

5.  Now when you open your new item, that value will be pre-populated with the current year.

 

NOTES:

There may be another way to do this, but TEXT was giving me errors, so CONCATENATE seems to force TODAY to be a string.

How To Redirect The Office 365 Team Link



TODO:

When you click on the Team Site link in Office 365, it takes you to https://sitename.com/SitePages/Home.aspx.  The issue is, that we really want to go to https://sitename.com/site/Intranet/SitePages/Home.aspx.e.aspx.


SOLUTION:

To accomplish this, I added a CEWP to the sitename.com/SitePages/Home.aspx, that has a simple script that redirects to the page I really want to go to.

 

<script teyp="text/javascript">window.location.href = "https://sitename.com/sites/Intranet/SitePages/Home.aspx";</script>

 

NOTES:

So now the obvious, how do I ever edit the page again?  To do this I used SharePoint Designer.  Simply open the site by placing the root url in the location to open input (sitename/SitePages/).  From there I can now edit the page and the CEWP.