Fabian Williams SharePoint Blog

Solving problems with SharePoint day and night

SharePoint Saturday Columbus Wrap-up

Reflections

I want to say a special thank you to all the organizers and volunteers that made SharePoint Saturday Columbus (#SPSBUS on twitter) such an amazing success.  Im sure there are more than I am about to include here so forgive me if I do:

Make sure you follow this team above for more SharePoint goodness from Columbus Ohio. Also a special thanks to all the sponsors, without them, this event would not be possible, you may find a list of the sponsors here

I had a fantastic time, I sat in a few sessions, learned a bit about JavaScript, Durandal, and Knockout, all things I need to get better at, SharePint was a blast, especially when the Buckeyes Play ball 🙂 I am looking forward to my next visit to Columbus. As my blog post asks, Request Me To Speak again please for a SPUG or next event. I made some awesome new local friends, and that is always an added bonus.

Fantastic event guys!!! You guys rock. and Im rocking the speaker Hoodie. thanks for posting the pic @spmcdonough 

Request Fabian Williams

My Session

As with most of my sessions that I do, they are entirely interactive with lots and lots of real time demos. My slide deck is here, go grab it, and remember that most of the demos I do typically have a blog post attached, that way you can always come back to learn more.

September 15, 2013 Posted by | Public Speaking, SharePoint Saturdays, Where is Fabian | Leave a comment

Code from Fabian Williams Session at SharePoint Saturday DC Federal on Linq to SharePoint

As promised here is the code… I may blog the experience also

please pick up the code on my SharePoint 2010 Blog. It is in three text file or one zip File.

SPSDCFed2010

Screen shots are below so you can remember where they were in my session

My Deck is also located there.

FabianDeck

 

FabianPlayPenDOTDesignerDOTcs

 ProgramDotCS

 WingingItDOTcs

October 16, 2010 Posted by | SharePoint Saturdays, Where is Fabian | Leave a comment

My SharePoint Deck for my BCS Sessions now on SlideShare.net

February 28, 2010 Posted by | SharePoint 2010, SharePoint Designer 2010, SharePoint Development, SharePoint General, SharePoint How-To, SharePoint Saturdays, Visual Studio 2010 | , , , | Leave a comment

With so many SharePoint Saturdays coming up… the question is which one are you NOT going to attend

I strongly encourage all my blog readers to “attend” and where possible to present as speakers at one of these SharePoint Saturdays coming up (see below). It is a FREE event to attend, all you have to do is register in time; the speaker panel is always star-studded, and you will be surprised just how much knowledge can be soaked up in one Saturday.

February

March

April

June

Have fun! Stay Strong..

February 15, 2010 Posted by | SharePoint 2010, SharePoint Administration, SharePoint General, SharePoint Saturdays, Where is Fabian | 3 Comments

More of my SharePoint 2010 Blog Post on the Horizon…

To my fellow blog subscribers out there and people generally interested in my Blog on SharePoint 2010 especially around Business Connectivity Services (BCS), I have been a bit in a lull.  This is in part due to the fact that I have had quite a bit of SharePoint Saturdays and Conferences since the year started and now that I will be using a release above Beta, I will be limited in what I can release publicly.  In my blogs it is mostly [as I am a visual learner] screen shots or Camtasia videos; and since I am now under NDA again with this most current build, …well u know…

That said, please come out and see me at these SharePoint Saturdays; they are truly worth your time and effort.  From my own perspective, not only do I get to impart a lot of what I know to the greater community, but I sit in on my fellow presenters sessions, and in just conversations with the session participants, I am always pleasantly surprised with what I soak up.  Last week I presented at the SharePoint Technology Conference in San Francisco and what a spectacular event it was.  A great panel of speakers, gracious hosts, and overall a good time.  The next one is in Boston; please register at your earliest opportunity.

So where will I be next; I am doing two sessions at SharePoint Saturday New Orleans [Yes the home of the Superbowl 44 Champions] next week Saturday; if there are still registrations spots open, please sign up. One session is on of course BCS and the other is on Sandbox Solutions (yes Cherie Taylor I know I owe you my session details on Sandbox, you will get it COB today) oh a soap box moment… Sandbox Solutions is the defacto way Microsoft wants you to start building your SharePoint Solutions, why do I say that, well when you start a template, it defaults to what else “Sandbox Solutions”.

Till then… Learn It, Love It, Live It.  and most of all, Have Fun With It!

A little humor before I go…

The pictures below represent just hours before my flight out from DC Metro to San Francisco last week; and no.. no theme song from “The Hangover”.. “you spin my head right round…”

Photo-0329

Above… the main street from my house.. I live on a cul-de-sac with one other house..

Photo-0334

Above… my drive way that i had to dig out of. First week we had 28 inches, this dumping 15 more inches…

Photo-0335

Above… me after shoveling my drive way, I had to shove the (what I hope was just to the middle of the street)…

Photo-0336

Above… who was I kidding, I had to shovel the entire street so i could go catch my flight to San Fran.

February 15, 2010 Posted by | Business Connectivity Services, SharePoint 2010, SharePoint Administration, SharePoint Development, SharePoint General, SharePoint Saturdays, Where is Fabian | Leave a comment

Come out and See Me [Fabian Williams] at SharePoint Saturday Virginia Beach on Jan 9 2010

Just Added as a speaker for SharePoint Saturday Virginia Beach. I am looking forward to sharing the podium with my distinguished SharePoint community experts and evangelists.  I will be presenting on my favorite topic… Business Connectivity Service and I promise… I will not run out of time this go around.

image

Come on out… details below

image

register at https://www.clicktoattend.com/invitation.aspx?code=143142 

And come and learn how “Composites” will save your LIFE!

December 6, 2009 Posted by | Business Connectivity Services, Office 2010 Beta, SharePoint 2010, SharePoint How-To, SharePoint Saturdays, Where is Fabian | , , | Leave a comment

SharePoint Saturday Washington DC – 12/5/2009 – Session on BCS

<Thanks>

First I want to thank Dux, Usher, and Gino for a well put together SharePoint Saturday http://www.sharepointsaturday.org/dc today in the DC Metro Area. Despite today being the first Snow Day of the season for the area, I am told we had over one hundred and eighty (180) attendees.  The speaker list was awesome and I tried to attend as much session I could (albeit i had my kiddies with me there today) and I was very impressed with everyone i saw.

</Thanks>

I was honored to be there and provide my session below

image

As requested by the attendees in my session, I have posted my deck for download on SlideShare the code may be accessed from the Blog https://fabiangwilliams.wordpress.com/2009/12/03/creating-a-sharepoint-2010-external-content-type-with-crud-methods-using-linq-and-a-sql-lob-system/

Hope you all had fun and learned something!

December 6, 2009 Posted by | Business Connectivity Services, Office 2010 Beta, SharePoint 2010, SharePoint How-To, SharePoint Saturdays, Where is Fabian | , , | 2 Comments

Creating a SharePoint 2010 External Content Type with CRUD Methods using LINQ and a SQL LOB System

Synopsis:

First, this lab builds on an article I saw on MSDN which discussed how to create an External List using Business Data. I noticed that they showed methods for the code but showed no foundation or a Use Case, nor did it discuss the LOB System and how the class entity relationship is defined.

In this Lab/Demo we will show a SQL LOB system which holds Personnel data. Imagine if you will, a system such as SAP, PeopleSoft, Dynamics, etc.  Imagine also that this LOB system is the Source of Record for your organization for things such as Human Resource related data which may be consumed by Active Directory, Sales, Marketing, Finance(Payroll) etc.  How can we surface that data in a Read, Create, Update and Delete fashion maintaining fidelity and ease of use?  here is how…

UPDATE: – On 10/14/2012 I have added another blog post Series that will extend this post for SharePoint 2013 employing WCF, .Net Assembly and OData with SharePoint Apps see it HERE

 

First

  • Check out your Database and pay special to the Columns which will be your fields in your Class Definition, also document your data types.
  • Create a Visual Studio Project using the Business Data Connectivity Model Template
  • Connect to your Database
  • Model the Entity
  • Use LINQ to create the methods to LOB Systems
  • Create the External List
  • Test and Verify

clip_image001

Above: First we need to have our database ready. Above we can infer that we will be going against a server called “Tico”, a Database called “FabianPlayPen” and a Table called “Employee” please take time to notice the current data records currently in there. Once you are done, crack open your Visual Studio 2010 Beta 2.

clip_image002

Note: To work with the Beta 2 bits of SharePoint 2010 you MUST use Visual Studio 2010 Beta 2 for the Templates to work.

clip_image003

Above:  Create a new Project of type “Business Data Connectivity Model” the guy you need for BCS.  I have my VS 2010 set for C# only but you can do this with VB.NET also. I have named my Project “SPSDCEmployees”; this is important because I will be using this name in conjunction with the Entity Class to be created later on in this demo/lab.

clip_image004

Above:  Once you have selected and named your Project you are prompted to choose the site for debugging. I have already created a site called “http://tico/sites/BCSAlpha” for this venture and i have so identified it in my dialog box.

clip_image005

Above:  Once the Project is created, the first order of business is to create a connection to our database.  We are doing this as the means to:

  1. Create a connection to our LOB System
  2. Use it through LINQ to SQL as our model to abstract our Class/Entity

image

Above:  Once you click on Add Connection you will be presented with the dialog box above, please indicate your Server Name and the Database you are interested in.  In my example my Server is my doggie’s name “Tico” and the Database is called “FabianPlayPen” very apropos wouldn’t you say?

image

Above:  After connecting your Database we need to include another  Template to our project. This time we are including a “LINQ to SQL” Template as a means to create our Entity

image

Above:  By default and design, when you create a BCS Project an Entity called “Entity1” will be created, shortly we will remove that entity because as part of that process two classes are also created which we will subsequently delete. Reason being, there is a lot of code already inplace that we will need tie into, by deleting the Entity Object and the related Classes and subsequently recreating our own, we have  better control over our build process. In our example we named our New Item “FabianPlayPen” and a file called FabianPlayPen.dbml is crated in our solution.

image

Above:  The blank design window is what you are initially presented with and is the framework where we will model our Entity Class.

image

Above:  I followed the steps below:

  • On the View menu, click Server Explorer.
  • In Server Explorer, expand the node that represents the Employee database, and then expand the Tables node.
  • Drag the Employee table onto the O/R Designer.

image

Above:  The newly created entity is now present in the OR designer nomenclature is the name of the table in the LOB System.  An entity class is created and appears on the design surface. The entity class has properties that map to the columns in the Employee table.  Now that that process is complete, we need to do some clean-up to aid our design process.

image

Above:  In Solution Explorer we dobule click on BdcModel1.bdcm and we get the desing pane above.

  • In Solution Explorer, expand the BdcModel1 node, and then double-click the BdcModel1.bdcm file.
  • The Business Data Connectivity model file opens in the BDC designer.
  • In the designer, right-click Entity1, and then click Delete.
  • In Solution Explorer, right-click Entity1.cs, and then click Delete.
  • Right-click Entity1Service.cs, and then click Delete.

as you see below…

image

Above and Below: The process to delete the associated .cs files.

image

—————————————————————————————–

image

Above: We will now create our new entity which will abstract our Employee LOB System table from our FabianPlayPen database.

  • On the View menu, click Toolbox.
  • From the BusinessDataConnectivity tab of the Toolbox, drag an Entity onto the BDC designer.
  • The new entity appears on the designer. Visual Studio adds a file to the project named EntityService.cs
  • On the View menu, click Properties Window.
  • In the Properties window, set Name to Employee
  • On the designer, right-click the entity, click Add, and then click Identifier.
  • A new identifier appears on the entity.
  • In the Properties window, change the name of the identifier to EmployeeID

See Below

image

imageimage

Below is a representation of our work so far, it includes the newly created Entity and our Identifier. Next we will create our Methods to Create, Read, Update and Delete.

image

Above:  We will begin the process to create a Finder Method. This method is used to basically surface a List of “ALL” items in the database

  1. On the BDC designer, select the Employee entity.
  2. On the View menu, click Other Windows, and then click BDC Method Details.
  3. In the BDC Method Details window, from the Add a Method drop-down list, select Create Finder Method.

image

  1. Visual Studio adds a method, a return parameter, and a type descriptor.
  2. In the BDC Method Details window, click the drop-down list that appears for the EmployeeList type descriptor, and then click Edit as seen below

image

  1. The BDC Explorer opens. The BDC Explorer provides a hierarchical view of the model.
  2. In the Properties window, set the Type Name property to System.Collections.Generic.IEnumerable`1[SPSDCEmployees.Employee, BdcModel1] as seen below

image

image

  • In the BDC Explorer, expand the EmployeeList node and select the Contact node.
  • In the Properties window, set the Type Name property to SPSDCEmployees.Employee, BdcModel1.
  • In the BDC Explorer, right-click the Employee, and then click Add Type Descriptor.
  • A new type descriptor named TypeDescriptor1 appears in the BDC Explorer.
  • In the Properties window, set the Name property to EmployeeID.
  • Set the Type Name property to System.Int32.
  • From the Identifier drop-down list, select ContactID.
  • Repeat step 8 to create a type descriptor for each of the following fieldsAs seen in the below 3 ScreenShots.

    image

    Screen Shot 1

    image

    Screen Shot 2

    image

    Screen Shot 3

    Now we need to create the remainder of the Type Descriptors for the Employee Entity; here is where we go back to our LOB System or our Entity Class created earlier and get the Names and Data Type of the columns to create our TypeDescriptors. Once we have done that it is time to add the code for our  ReadList Method

    image

    Above:  Double-Click on the ReadList in the Employee Entity to enter the code view as seen below.  By default a method is created and we need to remove the entry in the method and replace with our own.

    image

    image

    Above:  Our code is inserted in the ReadList Method

    • A connection string is created to attach to our LOB System
    • An Instance of the Employee List is created and populated with all the data from the LOB System

    That it. Easy isnt it! Next we need to create a Specific Finder Method which is responsible for returning a single item as requested in the SharePoint UX. As before we go back to the BCS Designer to add the Method and add our code… see below next three screen shots.

    image

    image

    image

    1. In the BDC designer, select the Employee entity.
    2. In the BDC Method Details window, collapse the ReadList node.
    3. From the Add a Method drop-down list that appears below the ReadList method, select Create Specific Finder Method.
    4. Visual Studio adds the following elements to the model. These elements appear in the BDC Method Details window.
      1. A method named ReadItem.
      2. An input parameter for the method.
      3. A return parameter for the method.
      4. A type descriptor for each parameter.
      5. A method instance for the method.
    5. In the BDC designer, on the Employee entity, double-click the Readitem method and add the code you see in the second (2nd) screen shot.

    image

    image

    We will create two additional method Create and Update.. lets go with Create first then the Update Method.  As before we begin from the Entity and select new method from the BDC Method Details Pane. Click the Method and add the code as reflected the screen shot.

    image

    image

    image

    image

    image

    Next we create the Update Method

    image

    image

    TEST AND VERIFY

    Finally we get to deploy our solution and see it in action. Click build then Deploy Solution to get our code up to our Farm.

    image

    Above:  Click Build then Deploy Solution…

    image

    Above:  To verify that the solution is uploaded we go to Central Admin under Application Management, Click on Business Data Connectivity to see if the Build was uploaded to the server Farm, see below…

    image

    Above:  Evidenced that our External Content Type is on the Server Farm, we now move to creating our External List to surface the information abstracted by the External Content Type.

    image

    Above:  Under Site Actions, click Create More, then choose External List.

    image

    Above:  Select the External Content Type we created as above…

    image

    Above:  Create a name and ensure that we have the correct Data Source Configuration

    image

    Above:  So… Viola! we have our external content type representative of the SQL Database Table called Employee, neat huh!

    image

    Above:  as part of our verification process we have confirmation that our columns are consistent to the Entity and LOB System. Now lets kick the tires on the newly created methods..

    image

    Above:  Lets click “Add New Item” this will instantiate and fire off the Create Method of our External Content Type. The next four screen shots represent the new form, the entered values, the post and final resultant Read List with the created item.

    image

    Above: The blank auto-generate form when you click Add New Item

    image

    Above:  Filling in the form with what will be the new data

    image

    Above:  Awesomness! we have our newly created item in our List… later we will do a SQL query to validate the record. Next, let us investigate the Update Method…

    image

    Above:  In this example we click on the custom action by the Picker field and we elect the “Edit Item” Once we click it we see the below…

    image

    Above:  The item in question is noted in the Update Form… I am picking  on my buddy Todd Baginski here, he does and awesome work on BCS and other SharePoint 2010 elements. Visit him here

    image

    Above:  Well because his name is synonymous to  good ol Frodo I relocated Todd to the Shire…

    image

    Above:  Confirm the changes above…

    image

    Above:  Finally we check the LOB system and we can see our Create, and Our Update, come to the SPS DC for the Delete… LOL

  • December 3, 2009 Posted by | Business Connectivity Services, SharePoint 2010, SharePoint Development, SharePoint General, SharePoint How-To, SharePoint Saturdays, Visual Studio 2010 | , , | 50 Comments

    Fabian Williams Session on Taxonomy & Information Architecture at SharePoint Saturday San Antonio 11/14/2009

    SharePoint Saturday San Antonio

    www.SharePointSaturday.org/sa

    Session: Taxonomy and Information Architecture 1:30 pm to 2:20 pm

    Track: Management / Social

    Presenter: Fabian G Williams

    Blog: https://fabiangwilliams.wordpress.com

    Twitter: @FabianWilliams

    clip_image001

    Level 100:

    In our session we covered the following Agenda Topics

    • · The Challenge of Unstructured Content
    • · Concepts and Terminologies
    • · Taxonomy and ECM Adoption Techniques
    • · Why should Taxonomy matter to me

    The audience was a mix of MOSS Admins and End User Content Owners; I asked if they frequently hear people say

    • · “I just cannot find the stuff I am looking for”
    • · Our Portal has too much clutter, pages are unstructured
    • · The Intranet is not Important to me
    • · When I search for something, I get too many irrelevant data

    There were quite a few head-nods, and I concluded that if anyone answered “Yes” to any of those questions, then they are in need for an Organizational Structure around their content. We touched on the fact that we see Taxonomy in our everyday life, why do we think we do not need it in our workplace especially when it comes to ECM. We discussed the fact the one of the first Taxonomy that opened eveyone’s eyes came from the Dewey Decimal System where 10 classifications determined the placement of books in a library; try to find a book in a library without it today, #FAIL. Since last week we celebrated Veterans Day I also illustrated that Military Insignia is also a Taxonomy… E1 – E9 is a classification and Lance Corporal in the Marine Corps and Seaman 3rd Class are the same.

    clip_image003

    After discussing the non technical references of Taxonomy, we shifted gears and talked about how easy it was for us to begin using sites like Bing, Yahoo, and Google. Did we have to go to a special class, get a book to read up on it? No, the taxonomy was evident and there are categories for what we are looking for. The difference between a taxonomy centered on ECM however…

    • · Tends to be less rigid
    • · Is content driven
    • · Has redundancy built in and is flexible

    So how does SharePoint help us with that… well, we have objects in MOSS to help us with our data classification

    1. 1. First we have different classification that are broken up in Templates
      1. a. Sites specifically for Documents
      2. b. Sites specifically for Images
      3. c. Wiki/Surveys/Discussion Group templates
      4. d. People Data
      5. e. Business Data
      6. f. Etc
    2. 2. All on a holistic server Farm
    3. 3. All is searchable

    Formula for Taxonomy is: Architecture + Application + Usability

    So how do and Where do I Begin

    • · Have a governance and Taxonomy discussion with an establish team.
    • · Focus on the Business and or Process and not on the Technology
    • · Realize that you may have a mixture of Taxonomy going

    o Strive to separate out Navigation, Process, Role Based, and Document Management as it distinguishes different approaches to the same content

    • · Just to get a 10’000 feet view of your environment; plan to make a Top Level Taxonomy representative of the company which will eventually be broken down into maybe
      • o Flat Taxonomy Model
      • o Hierarchal Model
      • o Network Model

    We discussed the logistical boundaries to the product; at a Site Collection Level you distinguish

    • · Navigation
    • · Branding
    • · Security
    • · Etc

    These are Taxonomy concerns especially as you build out the aforementioned Taxonomy model. We then moved into the heart of how we classify information…dah da dah…..

    • · Site Columns
    • · Content Types

    We went into detail on how Site Columns are the foundation for entering Meta Data into SharePoint which will assist you in

    • · Data Classification
    • · Corporate Vocabulary (IP)
    • · Data Mapping
    • · Search Indexing
    • · Elements to create End User
      • o Views
      • o Groupings
      • o Aggregation
      • o Filtering

    clip_image005

    We demonstrated how to create that new Site Column, and we discussed that in SharePoint 2010 you will be able to have Metadata on External List which are searchable and consumable in Office Suite of Applications.

    clip_image007

    clip_image009

    clip_image011

    We discussed how we could create a Content Type which in turns builds on that Site Column and now “empowers” end users to have dynamic live access to LOB System Data which is now indexable and searchable in SharePoint in their document asset.

    clip_image013

    We ended our discussion looking logically at how Content Types placed at the Site Collection level is consumable to subsequent sites below it. How standardization of data, enforcement of policies, and ease of use is enhanced by the thought that goes into a taxonomy discussion.

    • • Reusable Columns that can be assigned to multiple Lists and sites
    • • Useful for maintaining consistent metadata
    • • Available to all sites within the Site Collection
    • • Site Collection Administrators and Site Owners are also empowered to create their own Document Library Columns in addition to consuming Site Columns in an effort to make their environment extensible and keyed into their Line of Business.
    • • We discussed that Content Types are best approached in this manner
    • • By Audience or Originating Site (example: Human Resources Documents, Sales Documents)
    • • By Function (example Status Report, Expense Report, Sales Tracking)

    And finally we ended the session by asking ourselves the Presidential Question first coined by Ronald Regan…

    “Are you better off with Taxonomy, than you were without it”

    • · Are you able to find what you are looking for easier
    • · Are you working smarter not harder
    • · Can you rattle off your Top Level Site Structure in your head (thereby knowing it is small enough and relevant enough)
    • · Can disparate users find the same content from the safety of their world

    If you answered “Yes” then you are good to go.. Hoooraaahhhh!

    November 14, 2009 Posted by | Office 2010 TP, SharePoint 2010, SharePoint Administration, SharePoint Development, SharePoint General, SharePoint How-To, SharePoint Saturdays, Where is Fabian | 1 Comment