Category Archives: SharePoint Development

SharePoint Development Best Practices @ MEA ALM Community

If you are following me on Twitter, you have most probably seen my tweets yesterday about the official launch of MEA ALM Community (Middle East & Africa Application Lifecycle Management Community). Beside being a co-founder and community lead, I’ll be assuming the role of “SharePoint Practice Lead” and will be focusing on SharePoint as a development platform as well as the best practices for building SharePoint solutions using Microsoft Visual Studio ALM tools.

I’m shooting for December 2012 to create a series of videos in Arabic & English to explain how to use Visual Studio 2012 Testing tools for SharePoint.

13

 

14

 

Join us on Facebook : www.facebook.com/meaalmcommunity

Follow us on Twitter : www.twitter.com/meaalmcommunity

Watch our videos on YouTube: www.youtube.com/msmeaalmcommunity

SharePoint Development Videos from TechEd North America 2012

TechEd is Microsoft’s premier technology conference for IT professionals and developers, offering the most comprehensive technical education across Microsoft’s current and soon-to-be- released suite of products, solutions, tools, and services.

TechEd North America 2012 particularly was very special to me because it featured many sessions about SharePoint Development & Testing. I’ve compiled below a list of the must-watch videos for SharePoint Developers, Testers & Architects :

19

 

Download http://video.ch9.ms/teched/2012/na/OSP231.wmv

20

 

Download http://video.ch9.ms/teched/2012/na/OSP337.wmv

1

Download http://video.ch9.ms/teched/2012/na/OSP302.wmv

4

Download http://video.ch9.ms/teched/2012/na/OSP433.wmv

5

Download http://video.ch9.ms/teched/2012/na/OSP432.wmv

6

Download http://video.ch9.ms/teched/2012/na/OSP336.wmv

 

 

Feature and Solution Framework in SP2010–From Ignite Training

As promised, here is another slide deck from SP2010 development training that I delivered last week to partners @ Microsoft Egypt.

Today I’m sharing a presentation about the main building blocks of SharePoint; Features and Solutions.

Your feedback is appreciated.

 

View in brower (PowerPoint Web App)
View on SlideShare
Download from SkyDrive

See Also:

SharePoint 2010 as a Development Platform– From SharePoint Ignite Training
SharePoint 2010 Architecture Slides–From Ignite Training

SharePoint 2010 Architecture Slides–From Ignite Training

During my SharePoint 2010 Ignite Training for developers @ Microsoft Egypt, I delivered two Architecture sessions; I’m sharing the slides here.

First Session: SharePoint 2010 Web Application Architecture

View on PowerPoint Web Apps
View on SlideShare
Download from SkyDrive

Second Session: SharePoint 2010 Service Application Architecture

 

View on PowerPoint Web Apps
View on SlideShare
Download from SkyDrive

See Also:

SharePoint 2010 as a Development Platform – From Ignite Training

Invitation: Enterprise Developers Academy–Microsoft Egypt

7

 

8

Develop your expertise
Get up to speed on all the latest tools available to enhance
your skills and create new, innovative solutions.
Develop your network
Meet and interact with industry leaders and professionals. Share
and exchange tips on development, generate ideas and establish relationships.
Develop new solutions
Discover how you can get more value out of your existing tools and
deliver superior solutions through in-depth discussions and demos.
Don’t miss this exclusive event.

Introduction to SharePoint Development
Date: Wednesday October 27, 2010
Time: 10:00 am – 3:00 pm
Presenter: Ashraf MansourPlace: Microsoft Egypt Building in Smart Village
Description:
Learn to develop for SharePoint Server 2010 using Visual Studio 2010, with demos on developing a sample custom workflow and a sample web part.Seats are limited, to confirm your attendance, please reply back tomohamedw@microsoft.com

SPQuery to External List ignores the RowLimit attribute

Using CAML Queries is the only supported way to query external lists. It comes in very handy If you want to retrieve external data within a sandboxed application, without using a full-trust proxy. However using CAML Queries with external lists comes with some gotchas. Consider the following snippet :

SPQuery query = new SPQuery();
query.Query = “<Method Name=’ReadList’ />” +
“<OrderBy><FieldRef Name=\”CustomerID\”/></OrderBy>” +
“<RowLimit Paged=\”TRUE\”>10</RowLimit>” +
“<Aggregations Value=\”Off\”/>”;

SPListItemCollection items = lstCustomers.GetItems(query);

Unfortunately, this query just ignores the RowLimit and returns all the data from the external data source and not only the first 10 items as specified in the query. This is a known issue!

For more information :

http://social.technet.microsoft.com/Forums/en-US/sharepoint2010programming/thread/7a86ba74-ea19-42f3-bde9-690542c84552

Using external data in Excel Services [MOSS 2007]

Excel Services supports displaying data from external locations if those locations were configured as “Trusted”. Try creating a simple excel document with a Table that displays data from a SQL server table . Now try to view it in Excel Web Access. You will get the following error:

12

After some investigations, I found out that Excel services supports displaying data from external data sources, but not in a table format, only in a pivot table!

To work around this limitation, you need to convert your tables to pivot ones? How ? Download this tool and you are good to go !

13

 

For more info : http://blogs.msdn.com/b/cumgranosalis/archive/2006/11/03/query-tables-work-around-for-excel-services.aspx

http://msdn.microsoft.com/en-us/library/cc514223(office.12).aspx#MOSS2007TenTips_ConfiguringExternalDataConnections

Error when publishing to MOSS 2007 “This file cannot be saved to this location because there is no connection….”

esterday, I was playing with Excel Services on an old MOSS 2007 VM that has no network. When publishing an Excel Spreadsheet to Excel Services, I received the following error:

Microsoft Office Excel This file cannot be saved to this location because there is no connection to the server. Check your network connection and try again. ”

After some quick research, I found out that this problem is related to the System Event Notification Service. To work around this issue, I ran net stop sens from the command line.

10