Microsoft SharePoint se Notas
There are a bunch of SharePoint features in Visual Studio 2010 Beta. You may have already heard about them from reading the blog Short Overview of SharePoint Features in Visual Studio 2010 or by other means. Today I want to introduce one of them, Business Data Connectivity (BDC) designer, which is available in the project template Business Data Connectivity Model. If BDC is new to you, here is a short description. BDC is one of two most important architectural components of Microsoft Business Connectivity Services (BCS) which enables users to read and write data from external systems—through Web and Windows Communication Foundation (WCF) services, databases, and Microsoft .NET Framework assemblies—from within Microsoft SharePoint 2010 and Microsoft Office 2010 applications. This MSDN webpage Business Data Connectivity (BDC) Service has a more descriptive version.
Visual Studio 2010 helps a SharePoint developer to develop, debug and deploy .NET assemblies as external data sources to SharePoint. In the following paragraphs, I will walkthrough with you how to create your first SharePoint external list using Visual Studio 2010. In order to make this walkthrough work on your machine, you need to install SharePoint 2010 Public Beta* and Visual Studio 2010 Beta2#.
*: Please read Setting Up the Development Environment for SharePoint Server before the installation. If you are using SharePoint Foundation 2010 you will need to create a Feature Event Receiver to enable the import of BDC models. How to create a Feature Event Receiver will be covered in a future blog post.
#: Please make sure Microsoft SharePoint Development Tools component is selected when installing. It is chosen by default if you choose Full installation.
Let’s start the journey.
1. Create a new BDC Model project. (Main menu: File -> New -> Project…). In the left column of the New Project dialog, you are able to find node 2010 under tree view Visual C# -> SharePoint. Similarly you can find same node under Visual Basic -> SharePoint. In the middle column of the dialog, you should be able to see Business Data Connectivity Model listed as one of the project templates. See the screenshot as follows. Here I am creating BDC Model project in Visual C#. You are able to do the same things in Visual Basic. 
2. After clicking [OK] button in the New Project dialog, the SharePoint Customization Wizard dialog will be displayed. In this dialog you can customize the local site you want to target and trust level for the SharePoint solution. Since a BDC model is deployed to a farm, a collection of one or more SharePoint servers and one or more SQL servers, only “Deploy as a farm solution” option is enabled. Here is the screenshot of the dialog. 
3. When you click [Finish] button in the SharePoint Customization Wizard dialog, the BDC Model project will be created. There are four main UI panes that help you manage the BDC model visually. They are the BDC Designer Surface, BDC Method Details Pane, BDC Explorer, and Properties Browser.
a. The BDC Designer Surface allows editing entities, identifiers, methods, and associations between entities. And you can do that either from toolbox or context menus.
b. The BDC Method Details pane, where its name is already self-explanatory, lets you edit everything related to a method, from the method itself, its parameters to its parameters’ type descriptors, from method instances to filter descriptors, etc.
c. BDC Explorer lists and organizes metadata objects in the BDC model in a tree view. It lets you to browse and search metadata objects in a graphical way and allows you to copy/cut/paste type descriptors between different parameters or type descriptors.
d. Properties Browser gives you a familiar way of editing components and attributes of BDC Models. We use it to supplement the functions offered by the other three panes and list all the attributes for a particular metadata object for editing. Here is a typical layout of a BDC Model project as described above.
4. If you notice, there is already a default entity generated for you when the project is created. This default entity also has an identifier and two methods ReadItem and ReadList created. One is a Finder method that is to return a collection of data. The other is a Specific Finder method that is to return a specific entry based on the input parameter(s).
5. Now let’s deploy to the SharePoint server. You can either click the deploy menu item in main menu (Build -> Deploy Solution), or in the context menu of the project or the solution. In the output you will see several activities happening including packaging, solution retraction/addition, deployment, etc.
6. Let’s open the target site and see if our model has been successfully deployed. Open the target site with any browser supported by SharePoint, like Internet Explorer 8. Create an external list based on the model we just deployed. Here are the steps to create an external list in case you are new to it.
a. In main menu: Click Site Actions -> More Options…
b. On the Create dialog, select External List, click [Create] button in the right column
c. On the next external list create form, type a name for the list. Check ‘Yes’ to display the list on the Quick Launch for easy access. Then click
to select the model we just deployed in the External Content Type Picker form. Click [Create] on the external list create form. Now the Hello World list is displayed.
In the main menu under List Tools -> Items, you may find only “View Item” option is enabled. Guess why? Yes, it is because the default entity only has a Finder method to view the entire list and a Specific Finder method to view a specific item. In our next blog in this series, we will show you how to add more functions like Add, Update and Delete to the list as well as pull data from external data sources.
Several beta language packs for SharePoint Foundation 2010 Beta and SharePoint Server 2010 Beta are now available through the Download Center. Installing one or more language pack will allow you to evaluate the new Multi User Interface (MUI) features of SharePoint 2010.
The following language packs are available:
- German
- English
- Spanish
- French
- Japanese
- Russian
- Chinese (simplified)
SharePoint Foundation 2010 Language Packs
SharePoint Server 2010 Language Packs
Please follow the instructions on the download page to install language packs. For further reading, please refer to TechNet articles: Deploy language packs (SharePoint Foundation 2010) and Deploy language packs (SharePoint Server 2010).
Jie Li
Technical Product Manager, SharePoint
What is a List View again?
Put simply, a List View is a view for displaying SharePoint list data. The concept of List View has been around since SharePoint v2. While there are other technologies being used for visualizing list data in different scenarios (e.g. Content Query Web Part), List View remains the default component for displaying list data in SharePoint 2010.
List Views can be spotted everywhere in SharePoint. They are used to display information such as your announcements, tasks and calendar schedules.
Examples of List Views
What’s the big change with List Views in 2010?
In 2010, we are introducing a component called the XSLT List View Web Part (XLV) that serves as the new default technology for displaying list data. This honor used to belong to the List View Web Part (LVWP), which was the default from SharePoint v2 to 2007. (Note: LVWPs are still supported in SharePoint 2010, but just not as widely used as the new XLV.)
The new XLV brings a ton of improvements to the SharePoint platform. This blog series aim to cover most of these areas.
What are the key benefits to the new List Views (XLV)?
Replacing the default technology for List Views required fundamental changes to the SharePoint platform. So why did we do it? Let me call out the high level benefits of the XLV compared against LVWP from 2007:
- More Designer Friendly
- Rich customization support through SharePoint Designer (SPD) while preserving browser UI experience
- In SharePoint 2007, two of the main web parts for displaying list data were LVWP and the DataFormWebPart (DFWP). Both had their own advantages and disadvantages. The LVWPs were fully integrated into the browser with in-browser editing support, but lacked rich customization experience as they were not fully customizable inside SharePoint Designer 2007. The DFWPs had a much richer customization story as they were fully editable inside SharePoint Designer, but lacked the in-browser editing capabilities that LVWPs had. With the new XLV, SharePoint combined the best aspects of these two technologies and now allow you to richly customize your XLVs in SPD and also provide the in-browser editing experience. It is important to note that XLV will preserve both SPD customizations and in-browser modifications, and not blow any of that away.
- Extensible and shareable custom styles
- A custom view style that you designed in SPD can now be easily shared with other designers across your site collection.
- Popular designer features such as Conditional Formatting.
- Similar to the Conditional Formatting feature in Excel, designer can now set conditions on when to format items in a list view (e.g. KPIs.)
- More Developer Friendly
- Uses standards-based XSLT instead of CAML
- Much better documentation of XSLT than CAML. (http://www.w3.org/TR/xslt)
- Easily extensible
- Developers no longer have to include large blobs of CAML to define views in their List definitions. Take advantage of shared XSLT used to define out-of-box views and only define custom XSL for the sections you want.
- More End-User Friendly
- Enhanced user experience including Ribbon UI and new multi-selection model.
- Bulk editing and deletion are now supported.
- Inline editing support
- Edit fields in your list view without being directed to another page or dialog.
- More Robust Ways to Access Data
- Display enterprise data through Business Connectivity Services (BCS)
- End users can now interact with business data similar to how they interact with regular SharePoint list data.
- Cross-web list views displaying data from another web
- Display list data joined from different lists
What’s coming up in the blog series?
Many people from different teams in the SharePoint family contributed to the new List View in SharePoint 2010. In this blog series, you’ll get a chance to hear from some of those area experts covering key List View topics.
Here are the topics that will be covered:
- Introduction to the new List View (you are reading it! J)
- List View – New User Experience
- List View Architecture
- List View Customization
- External Lists
- Conditional Formatting
- How to Share Your Custom List View Styles
- How to Create Custom Fields for the new List View
- Related Item View
- How to Create Views Displaying Cross-Web and Joined List Data
The order in which these topics will be published may change. We may also add or modify topics on this list. If there is any areas regarding List Views that you’d like to learn about and isn’t on this list, feel free to suggest them here.
Thanks for reading. I hope everyone is excited about the new List Views. Stayed tuned for more!
If you will be installing the SharePoint Server 2010 Public Beta on Microsoft Windows Server 2008 R2 or Microsoft Windows 7, then you will need to download and install an update from http://connect.microsoft.c
If you have already installed Microsoft SharePoint Server 2010 on a server running Microsoft Windows Server 2008 R2 or Microsoft Windows 7, Microsoft SharePoint Server 2010 does not need to be reinstalled when the update becomes available; however, Service Applications that have been successfully provisioned without the update installed may need to be removed and re-provisioned once the update has been successfully applied.
The Update Center for Microsoft Office, Office Servers, and Related Products went live today, which will enable customers to find an up-to-date list of all of our Service Pack, Public Update, and Cumulative Update releases in one location. While the SharePoint team blog has posted Cumulative Update package information in the past, this will be available on the Update Center moving forward.
A few Update Center highlights:
- Latest Updates Table
- See the latest updates for your version of Office
- List of all releases in a year
- Find information about past releases
- RSS Feed
- Subscribe to our feed and get updated as new releases become available
Before we get into the deep details, I want to share a high-level checklist to setup User Profile syncing on Windows Server 2008. Once the WCF hotfix for Windows Server 2008 R2 is available, this guidance will work on R2. This checklist is for beta only - we plan to improve how this works by RTM.
- Check that your system meets minimum requirements: http://technet.microsoft.c
- Start with a clean OS install
- Check that the WCF hotfix is installed http://go.microsoft.com/fw
- Check that you have done a "Complete" install of SharePoint Server 2010
- Check that the setup/farm admin account has "Replicating directory changes" in your test domain
- Use the farm configuration wizard to setup all the service applications and successfully create a site collection
- Check that statistics (i.e. Number of User Profiles, etc.) appear on the User Profile Service Application page
- Start the User Profile Synchronization Service and status changes to "Started" - this can take some time and this will configure and start the Forefront Identity services for you (do not try to manually set the logon credentials and start the service)
- Setup an Active Directory Connection
- Start a full Profile import
Now onto the full details to setup the User Profile synching...
When using SharePoint 2010 Beta, if you need to synchronize bulk users and groups with AD or LDAP, you’d likely be using the user profile synchronization functionality in SharePoint. This functionality is the backbone to turning the profile store into a ‘person’ store with interesting information from AD/LDAP or BDC sources, including hierarchy and group information that can be used to drive functionality such as audiences or hierarchy driven business processes.
We’ve done an overhaul of this feature in 2010, which is also leading to some growing pains for us through the Beta. We’ve a set of steps that you can follow to successfully bring users and groups into the profile store, and despite the fun and temptation of playing, we highly recommend you follow these steps.
For brevity, I am going to list the steps for AD only. In place of reading these steps as you go along, please give this a full read and then follow the steps. Note that quite a few of these steps are because of known issues in the Beta and we are working towards fixing them for RTM.
Prepping for Provisioning the User Profile Synchronization Service
1. After provisioning the User Profile Service Application, ensure that the service is running by going to the Manage Services on Server page in central admin, and if the User Profile service does not show as started, click start on User Profile Service. Do not try to start the User Profile “Synchronization” Service at this time (it’s listed right underneath the User Profile Service).
2. Permissions (for the account you are logged in as, when provisioning or configuring the user profile synchronization service)
a. In order to run the User Profile Synchronization service, you must be a farm admin. Running the user profile synchronization service requires a farm topology decision (where to run it and when), which is a farm admin operation across the SharePoint services platform.
b. Ensure that the farm admin running the farm timer job (typically the account you specified during install unless explicitly changed after install) is a local admin on the box where you are going to run the sync service.
c. This account should also be added to the user profile administrators with full control privileges.
d. While rare, please ensure that this account is not excluded by policy from being able to logon-locally on the machine where sync will be provisioned and run.
Provisioning the User Profile Synchronization Service
3. Now, start the User Profile Synchronization Service, by going to the Manage Services on Server page in central admin and clicking start on the User Profile “Synchronization” service. When you hit start, service will ask you to associate a User Profile Service Application with it, select the User Profile Service Application you created earlier and hit OK.
4. Wait a few minutes to allow for provisioning, verify that the User Profile Synchronization Service shows Started on the Manage Services on Server page, and then check the following items on the machine where the sync service is running
a. Run services.msc and check if the windows services “Forefront Identity Manager Synchronization Service” and “Forefront Identity Manager Service” are running. Do not start them here manually.
b. Check the folder %Programfiles%\Microsoft Office Servers \14.0\Synchronization Service\MaData to see if there are two subfolders \ILMMA and \MOSS-XYZ (where XYZ is the name of your user profile service application). These folders will be empty at this time.
5. Issue an IISReset on the machine where user profile sync service was provisioned.
Prepping for Connection Creation
6. Before you proceed with creating connections to bring data in, it’s good to pause and spec out what containers you’d be selecting for your connection, where the users are, where the groups are etc. It’s important to get the connections right, before kicking-off sync. We highly recommend that you spec one connection per forest and do not create multiple connections to the same forest.
7. In order to be able to sync with AD, you need to have an account that can be used to call AD and identify what has changed since a given time (in other words, an account that is capable of reading the AD change log). This right is called “Replicate Directory Changes” in AD lingo. This right does not allow for writing or modification of AD objects. You’d need this account name and password when you create a connection. This account can be the same or different than the farm or UPA admin account. Please do not proceed without having an account with these rights, even if you don’t plan to do incremental synchronization. This AD right is required for both full and incremental sync.
Creating a Connection
8. To create a connection with your AD source, you must logon locally on the central admin box. User the Configure Synchronization Connections link in the user profile service central admin page for connection creation.
9. Majority of the items on the connection creation page are intuitive. Specify the fully qualified domain name for the forest, and specify the DC. Ensure that both the forest and the DC are directly reachable from the machine where you provisioned the user profile sync service.
10. You’d likely leave the Authentication provider type to “Windows Auth”.
11. Right below the authentication provider fields, you’d see the account name and password fields for the AD account you procured in step 7.
12. Select Populate Containers and carefully chose the right containers for your connection. For example, find out which containers have the users, if you don’t want to bring in anything else. We have some trouble with this control in IE8, so press F12, and select IE7 in the dev tools window that pops up.
13. If you had additional connections to create, create them all now.
Configure Users or Users and Groups
14. Based on the numbers of users and groups in your system, it can take much longer to sync users and groups, then syncing users only. So to get you started, we’ve provided for a Users-only option under Configure Synchronization Settings link. Select Users-only for the first full run.
Additional Settings
15. We don’t cover the details in this blog, but you can setup additional property mappings and filters at this time, if absolutely needed. If you can live without filtering out data or mapping specific custom properties, it might be best to proceed without them.
Running Sync
16. At this point, you can go to Start Profile Synchronization, select Start Full Synchronization and click ok. Depending upon the number of objects, the first full sync can take many hours to complete. We expect the performance to improve with RTM but after the first full sync, the incremental syncs should be much faster.
What to Expect Next
17. We have bunch of kinks to work out in the status that you see on the right side of the user profile service admin page. For example, if you see the number in the status going down, that means the sync run has just moved from one stage of synchronization to another and are now showing the number for that stage. We are also working on a tool to let you stop a bad run, but in the meantime, it’s not recommended that you stop a sync run brute force. This can get you in a tough state that requires special database-level steps to recover from.
18. If you are running sync for the first time, and you already have the User profile service live, for example users can use their MySites and Profiles, they might see changing organization charts as users come in and managers get attached. This should all clear up once the sync run is complete.
19. Along with the user number shown in the status, you can also search for a known profile or accounts that start with a known domain name in Manage User Profiles page. Note that you are going to not see any users listed here, but they are there, you just have to search for them.
Running Incremental Sync
20. Once the full sync step is complete, you can flip the “Users only” setting to “Users and Groups” and run an incremental sync (or schedule an incremental job).
Today we are announcing the general availability of the public beta of Office 2010, SharePoint Server 2010, Visio 2010, Project 2010 and Office Web Apps for our customers and partners. Millions of people can download the beta at http://www.microsoft.com/2
Office Mobile 2010 has also reached the public beta milestone and is now available on the Windows Mobile Marketplace for Windows Mobile 6.5 phones.
As part of the beta, we are unveiling several new capabilities, including:
- The Outlook Social Connector, a new feature which brings communications history, business and social networking feeds into the Outlook experience.
- At beta, the Outlook Social Connector will support SharePoint social networking and support Windows Live at launch.
- We are also announcing that LinkedIn will be the first social networking site to provide a connector for the Outlook Social Connector.
- We are also releasing the Outlook Social Connector SDK for developers to build connectors to third party social networks.
- Technology and design advancements including deeper integration between Office 2010 and Office Web Apps, improved navigation, visual design and icon updates, a new Office logo and increased performance and stability.
We’re also announcing our plan to deliver Duet Enterprise for Microsoft SharePoint and SAP which will expand the long standing Duet partnership. The joint solution from SAP and Microsoft will enable interoperability between SAP applications and SharePoint 2010 and provide complete flexibility and extensibility to compose solutions that blend the worlds of process and collaboration. Duet Enterprise is built on top of the new Business Connectivity Services in SharePoint 2010. The solution is planned to be released in the second half of calendar year 2010.
SharePoint Public Beta Resources
- General information about SharePoint 2010: http://sharepoint2010.micr
osoft.com/Pages/default.as px - Resources for Developers on MSDN: http://www.mssharepointdev
eloper.com - Resources for IT Pros on TechNet: http://www.mssharepointitp
ro.com - Have a SharePoint 2010 question? Ask it in the SharePoint 2010 forums
Where can I download SharePoint 2010 public beta?
You can download SharePoint and Office 2010 public beta from http://www.microsoft.com/2
Is the SharePoint public beta supported?
The SharePoint public beta is not supported. However, we recommend looking at our resources listed above and asking questions in the SharePoint 2010 forums.
When is the final release of SharePoint and Office 2010?
We are planning to release SharePoint and Office 2010 in the first half of calendar year 2010.
Will there be a migration path from SharePoint public beta to final release?
We do not plan to support a SharePoint 2010 public beta to release bits migration path. The SharePoint 2010 public beta should be used for evaluation and feedback purposes only.
If I’m on SharePoint 2007, how do I get ready for SharePoint 2010?
Take a look here for getting ready guidance.
Is there a downloadable SharePoint 2010 VHD?
We plan to make a VHD available for download sometime in the future. We will announce its availability on our team blog.
How do I get trained on SharePoint 2010?
Please review the Getting Started page, the IT Professional learning guide , the Developer learning guide , and the End User resources to ramp up on SharePoint 2010.
The Microsoft SharePoint Designer Team Blog kicked off a blog series today that will cover a wide spectrum of topics related to the new List View in SharePoint 2010. Today’s topic, as Part 1 of the series, covered Introduction to the new List View.
The server-packages of October 2009 Cumulative Update for Microsoft Office SharePoint Server 2007 and Windows SharePoint Services 3.0 are ready for download. October 2009 Cumulative Updates introduce more rules on Pre-Upgrade Checker, which can help customers to prepare the upgrade of their SharePoint farm to SharePoint 2010.
Download Information
Windows SharePoint Services 3.0 October 2009 cumulative update package
http://support.microsoft.c
Office SharePoint Server 2007 October 2009 cumulative update package
http://support.microsoft.c
Detail Description
Description of the Windows SharePoint Services 3.0 October 2009 cumulative update package
http://support.microsoft.c
Description of the Office SharePoint Server 2007 October 2009 cumulative update package
http://support.microsoft.c
Installation Recommendation for a fresh SharePoint Server
To keep all files in a SharePoint installation up-to-date, the following sequence is recommended.
- Service Pack 2 for Windows SharePoint Services 3.0 and language packs
- Service Pack 2 for Office SharePoint Server 2007 and language packs
- October 2009 Cumulative Update package for Windows SharePoint Services 3.0
- October 2009 Cumulative Update package for Office SharePoint Server 2007
Please note: Start from April 2009 Cumulative Update, the packages will no longer install on a farm without a service pack installed. You must have installed either Service Pack 1 (SP1) or SP2 prior to the installation of the cumulative updates.
After applying the preceding updates, run the SharePoint Products and Technologies Configuration Wizard or “psconfig -cmd upgrade -inplace b2b -wait” in command line. This needs to be done on every server in the farm with SharePoint installed.
The version of content databases should be 12.0.6520.5000 after successfully applying these updates.
You can also refer to April Cumulative Update post for deployment guides, slipstream how-to links and FAQs.
Jie Li
Technical Product Manager, SharePoint
As you probably know, Visual Studio 2010 was announced last week and it contains a lot of great features and project templates for SharePoint developers. Below is a short overview for some of the SharePoint development related features and project templates.
Configurable deployment
With all new SharePoint project templates you can leverage new configurable deployment feature which lets you configure the way you want to deploy or retract your project. Besides using provided, out of the box deployment steps (Run Pre-Deployment Command, Run Post-Deployment Command, Recycle IIS Application Pool, Retract Solution, Add Solution, and Activate Features) you can use SharePoint extensibility to create your own, custom deployment steps and deployment configurations.
Sandboxed and farm solutions
Some SharePoint projects can be deployed either as sandboxed or farm solutions. Sandboxed solutions run in a secure and monitored process that has limited resource access and with farm solutions user must have SharePoint administrator privileges to run or deploy the solution. You can read more about SharePoint sandboxed solution here.
Extending SharePoint Tools
Even though Visual Studio 2010 contains a set of project templates you can also extend them. You can create extensions for projects, project items, define your own project item types and create deployment extensions. You can read more about extending SharePoint tools on MSDN.
Feature and Package Designer
Feature and package designers give you the ability to customize features in your solution and with packaging designer you can customize which features are getting deployed and how. More about feature and package designer is here.
SharePoint Explorer
SharePoint Explorer is a new tool window that gives you a view into your SharePoint server. You can get a hierarchical view of lists, sites and workflows on your SharePoint server.
SharePoint Project and Project Item Templates
The following SharePoint specific project templates and project item templates are available in Visual Studio 2010:
Project Templates
· Empty SharePoint project
· Visual Web Part project
· Sequential and State Machine Workflow
· Business Data Connectivity Model
· Event Receiver
· List Definition
· Content Type
· Module Project
· Site Definition
Project Item Templates
· Empty Element
· Web Part
· User Control
· Application Page
· Association Form
· Initiation Form
· Business Data Connectivity Resource Item
· List Instance
· List Definition From Content Type
· Global Resources File
Besides above mentioned project templates, there are two import project templates for importing .WSP file contents and importing reusable workflows:
· Import Reusable Workflow
· Import SharePoint Solution Package
How to download, install and get started
If you are a MSDN subscriber, you can download Visual Studio 2010 from here. Download will be available to everyone on October 21st.
If you want to know how to download and install Visual Studio 2010 watch Channel9 video.
To get you started, head over to MSDN and read some of the walkthroughs on SharePoint Development in Visual Studio 2010.
Peter Jausovec
(http://blogs.msdn.com/vssh
