About Ian Hayse

A lengthy career working as a SharePoint developer, admin, and architect. I'm now working in the Power Platform and Azure spaces. What happened to InfoPath?

Copy List from 2007 to 2010

I’m recreating a site in SharePoint 2010 and didn’t want to create each List and Library.

I tried exporting a List from SharePoint 2007, then import into SharePoint 2010. No go.
SharePoint 2010 doesn’t like .STP files.

I opened MS Access 2010, imported my SharePoint 2007 List, then created a new List in my SharePoint 2010 site using imported 2007 List.

Like this:
In Access 2010
External Data tab
In the Import and Link section, click on More, then click on SharePoint List.
Choose the Import the source data…. option.
With your new table open, look in the Export section of External Data tab.
Click on More, click on SharePoint List, when the Export – SharePoint Site box opens, enter your destination URL and List name.
Click OK.

You should now have your List duplicated to your SharePoint 2010 site.

Copy DLL from GAC

If you are looking for a way to copy a file / DLL from the GAC, here is your answer:
http://www.tipscentre.net/Details/Copy-DLL-From-GAC-Assembly.aspx

Click Start then click RUN.
Type “C:\windows\assembly\gac” and then press enter key.
GAC folder will be opened.
Go one step up by clicking the “UP” icon in the standard button toolbar.
Then search for your required dll file.
If you find the required dll then just copy it.
Enjoy!

Client does not have permissions to send as this sender At

Error when trying to send an email from PowerShell on Windows Server 2008 R2.

Client does not have permissions to send as this sender
At …………….

FullyQualifiedErrorId : SmtpException,Microsoft.PowerShell.Commands.SendMailMessage

Make sure your IP address is added to the SMTP relay service. My overly friendly Exchange Admin was able to add this to the box.

InfoPath Validate Attachment Control

To validate an Attachment control in InfoPath 2010 you can do one of the following.

Using the controls properties:
Right click on the Attachment control.
Select File Attachment Properties.
In the Validation section, select Cannot be blank.
Click Ok
Test it.

Using a Rule:
(Assume you have a Submit button)
Click on your Submit button.
In the Ribbon, click on Manage Rules.
In the Rules window, click on New.
For the Condition, select your Attachment control, then select is blank or is not blank.

is blank = no attachment
is not blank = a file is attached
 

My Site Emails Not Sending

In SharePoint 2010 I noticed I wasn’t receiving updates when people posted stuff on my MySite.

Turns out, my Active Directory Sync is not working, and my email account was not being populated in my User Profile.

Fix it!

Central Administration –> Manage User Profiles
Find the person having the issue.
Update the email address.
Cruise over to the mysite, post a note, look in your inbox for an email.

the language of this installation package is not supported by your system

When trying to install SharePoint Designer 2010 on my PC, I ran into an error saying Designer 2007 was installed on the box.

The problem was, I had SharePoint Designer 2007 installed, and it’s a 32-bit install. When I tried to uninstalled Designer 2007 I was getting this error:

The language of this installation package is not supported by your system

No matter what google-related-fix I tried, I couldn’t uninstall it.

What I did to fix things:
Installed Office 2007
Installed Designer 2007

Uninstalled Desinger 2007
Uninstalled Office 2007

Then I was able to install SharePoint Designer 2010.