Microsoft.SharePoint.Portal.WebControls.TaxonomyPicker' issue in eventlog

http://support.microsoft.com/kb/2481844

http://www.mssharepointtips.com/tip.asp?id=1105


http://office.microsoft.com/en-001/sharepoint-server-help/introduction-to-the-chart-web-part-HA101889216.aspx

Using a date column in a sharepoint online web chart web part

I added a "web chart" web part to a sharepoint online page from the browser interface.

Next, I decided to run the Data connection wizard to connect my chart to an excel services. In the step 3 of the wizard (Retrieve and filter data), I can preview the Data.

There comes the problem: my Date column display five-digit integers instead of dates. I've tried to change the format of the column in the source excel book to YYYY-MM-DD, is does not solve my issue.

Go into page edit mode for the web part and select Advanced Properties. Click on the link for Series and scroll down to the Data section. Set either the XValueType or YValueType from Auto to Date and click Finish.

Chart web part with Excel services

http://www.dotnetmafia.com/blogs/dotnettipoftheday/archive/2010/09/02/how-to-use-the-chart-web-part-with-excel-services.aspx

Using the Excel Services 2010 REST API

Discover Items in a Workbook
http://myserver/mywebsite/_vti_bin/ExcelRest.aspx/Shared%20Documents/Sales_Report.xlsx/Model

Retrieve Various Items in Different Formats
http://myserver/mywebsite/_vti_bin/ExcelRest.aspx/Shared%20Documents/Sales_Report.xlsx/Model/Range




http://msdn.microsoft.com/en-us/library/ff961897(v=office.14).aspx

Working with SharePoint 2010 Projects on Visual Studio Without Installing The Server

How many times we suffered from the error “A SharePoint server is not installed on this computer. A SharePoint server must be installed to work with SharePoint projects.”  when you try to create sharepoint solution? How many of us tried to create his own SharePoint Server 2010 development environment under Windows 7 OS but he faced this problem?

After spending unreasonable amount of time searching through the internet, reading blog posts and forums the only answer that I found to solve this problem was, “it is not possible, you have to install sharepoint server 2010 on your machine”, and if your operating system is windows 7, then the best thing you have to do is to find and install the beta version of sharepoint server 2010.

First step, from server machine (production server) run regedit and export the folder

[HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Shared Tools/Web Server Extensions/14.0]

Second step, on your local development machine, import the regedit file that you exported before or you can just only double click on exported regedit file. it will create a “Web Server Extensions” folder and the 14 hive registry for you.

 Finally, You will now be able to create a Sharepoint Project in Visual Studio 2010. When asked where the Sharepoint server is, tell Visual Studio it’s on your local machine. You will not be able to deploy locally (unless you actually *do* have Sharepoint installed), but you will now be able to create Sharepoint projects, and will be able to build package them.

NOTE: to be able to work on sharepoint developmentm for sure you will be need to add some sharepoint server assemblies to your project which will be not on your development machine like Microsoft.Sharepoint.dll.

I suggest you to copy those assemblies from your server machine (production server) and add them as references to your projects.

All SharePoint Server 2010 assemblies can be found under:

C:Program Files/Common Files/Microsoft Shared/Web Server Extensions/14/ISAPI

 Testing the environment

Create a project. To test, I simply created a Blank Sharepoint Project (first one was sandboxed, second one was full trust (farm)), and added a webpart with a label displayed.

protected override void CreateChildControls()

{

      base.CreateChildControls();

      Label l = new Label() { Text = "BLAH!" };

      this.Controls.Add(l);

}

Build the solution (so that you generate .pdb files) and then right click on the project in the Solution Explorer and choose “Package”. This will generate a .wsp file.

Now deploy your sandbox and the farm solutions as usual and see the results.

Missing microsoft.sharepoint.dll in Visual Studio 2010 on client Win7 Pro64

Copy microsoft.sharepoint.dll from C:\Program Files\Common Files\microsoft shared\Web Server Extensions\14\ASPI on Sharepoint Server to C:\Program Files (x86)\Common Files\microsoft shared\Web Server Extensions\14\BIN on Win7 Pro64 then reference it from solution.

Windows time sync

w32tm /config /manualpeerlist:"0.north-america.pool.ntp.org 1.north-america.pool.ntp.org" /syncfromflags:manual /reliable:yes /update

w32tm /query /peers

net stop w32time

net start w32time

Least Privileged for SharePoint

1. SQL Server Service Account (sp_sql): run mssql server, mssql agent svc
- Standard Domain User Account

2. SharePoint Setup User (sp_admin): run as logon account when install SP or configure SP
- Standard Domain User Account
- Local admin group of every sp server of the farm
- SQL role: db server security, db creator, db admin

3. Server Farm/DB Access Account (sp_farm) 
- Standard Domain User Account

Create account for every services
-App Pool Account
-App Pool Account for BDC service app, excel app, ..

web part export

Export list from working site

Import list to site. Create custom view and make it as default.

Add web part and select imported list. Select custom view as in step 2.