Tag Info

Hot answers tagged

13

Business Connectivity Services (BCS) is the way to go...here's a nice 3 part series on setting it up as well as programatically working with it: http://www.zimmergren.net/archive/2010/01/18/sp-2010-getting-started-with-business-connectivity-services-bcs-in-sharepoint-2010.aspx Tons of data out there if you want to do additional research...google SharePoint ...


8

Active Directory Import is similar to the Profile import mechanism we had back in SharePoint Server 2007. It's an awful lot easier and quicker to configure than "SharePoint Profile Synchronisation", AKA "User Profile Synchronisation Service" (in services on server) AKA ForeFront Identity Manager (FIM) for SharePoint Server 2010. Enabling AD ...


7

There are two jobs, User Profile to SharePoint Quick Sync and User Profile to SharePoint Full Sync, that synchronize the User Profile database information with the UIL. Sometimes this stops working (properly) and in that case you need to run: stsadm -o sync -listolddatabases 0 stsadm -o sync -deleteolddatabases 0 The first command will list Content ...


7

You don't interact with SharePoint's Database directly, you will rarely need to open SQL Server and see what's in there. You interact with SharePoint's data using SharePoint itself. So you will need to interact with lists and libraries that are responsible for your CRM system. SharePoint provides you with some ways to interact with it depending on where from ...


5

Why the code solutions? Use the native SP2010 document routing possibilities. Define an external Send to location on your source web app (in central admin), point it to the external site (web service url is something like http://destinationsiteurl/_vti_bin/OfficialFile.asmx), set the file action to either copy or move (depending on your needs). Then, in ...


4

As mentioned, you will need to use either Visual Studio for this workflow scenario, or implement a Event Receiver in the document library that will fire whenever item is added or updated. In both cases the program code would run after item has been added/updated and the context of the workflow/event receiver will contain the document in question (or at ...


4

In case you do not want to use BCS (I am personally not a fan of BCS) there are some third party alternatives. This component from Layer2 for example is very easy to use but maybe best suited for lists without a feature based content type: http://www.layer2.de/en/products/Pages/SharePoint-Business-Data-List-Connector.aspx In my opinion BCS has these ...


4

There is no need to sync the SQL table and SharePoint list - instead use Business Connectivity Services (BCS) and create an external list. Read more here: http://msdn.microsoft.com/en-us/library/ee558778.aspx


4

If you do not have Exchange 2013, the solution is to deactivate the Farm Feature "Farm Level Exchange Task Sync". Steps: Open Central Administration Go to System Settings -> Manage Farm Features Deactivate the Feature Farm Level Exchange Task Sync You find a more detailed description in this post!


4

You place a List-WebPart on a page and choose the view that it should use from the drop down menu. Now your WebPart obtains a copy of the list view that you selected. This will remain constant even if you modify the original view in the list itself. So, the behaviour you have described in your question is standard SharePoint behavior: List view changes are ...


3

you can run SharePoint (no matter 2007 or 2010) w/o UPS Service. In that case you will have "simplified" profiles containing only basic params: login name, name, email... No any additional configuration steps required to work that way. Btw, SharePoint Foundation Server uses this model by default (there are no UPS Service at all)


3

This sounds like 'Replicating Directory Changes' permissions was not appropriately applied to your sync account. I aggree with Seb, you should use the Harbar guide.


3

I ran into the same issue, user account was a farm admin, local machine administrator, had local run as rights on the server, cleared the SP cache, pretty much everything you tried I had tried. I found out that the April 2014 CU contained a fix (http://support.microsoft.com/kb/2760265) where the User Profile Syncrhonisation service will not run when using ...


2

Please check last section of below page: http://flylib.com/books/en/3.464.1.67/1/ To import list from SharePoint: Sub ImportListFromSP() Dim ws As Worksheet Set ws = ThisWorkbook.Worksheets(2) Dim src(1) As Variant src(0) = "http://SharePointSiteAddress/_vti_bin" src(1) = "89F90972-FD90-4B04-BCEB-81840A82DA5E" ws.ListObjects.Add ...


2

Microsoft now suggests that you use Access to manipulate SharePoint Lists, but it has issues when you use multiple formats in the same list. It works fine if don't have memo fields, I have found.


2

I have tested this and get the same error. It sort of looks those particular functions are being phased out. ...


2

When using forms based auth, you normally have a session cookie. Your browser has one session, and your outlook has another session. They cannot both be logged in at the same time. Previously I have solved this by using TMG. It does the forms auth on the proxy, and it uses a persistent cookie that can be shared across applications. But you may be able to ...


2

As far as I understood the sync will delete the user from SP profile database. As far as deleting that user's mysite, contents, wp is still a manual process.


2

Office OOTB SP Workspace (former Groove) is the first option (edit - unfortunately there is no SharePoint support in Workspace API so far :( ) http://blogs.msdn.com/b/sharepoint_workspace_development_team/archive/2010/08/06/groove-web-services-api-available-in-sharepoint-workspace-2010.aspx. Another option is completely custom application with own data layer ...


2

no i don't think there is a codeless solution to this.. you most likely will have to do this via custom code. You could create an console application which checks for files in the local folder, and if they do upload it to SharePoint and then set this application as Windows Scheduled Task with an Interval of 1min. Another option would be implementing it ...


2

Without the use of AD the only way is to write an application to synchronise them for you. I would set up a VM with active directory on, to handle this, so you have it there, just for this period, I really hope this is possible for you. The good news is the code for doing this as an application would be almost identical on 2007/2010 so a windows form ...


2

Yup you can get content type of item using following code, public override void ItemAdding(SPItemEventProperties properties) { SPList list = properties.List; string contentTypeName = properties.AfterProperties["ContentType"].ToString(); SPContentType contentType = list.ContentTypes[contentTypeName]; } For more information check this link ...


2

Rename the server at the operating system level by using the System Properties dialog box in Control Panel. Restart Server   Change or create SQL alias (If no ALIAS, create one to point to the old servername so it finds the SQL Server that is on the same server, stand-alone installation.) using cliconfg Restart the server   Run PowerShell-command to rename ...


2

You need to use BCS(BCS can only be used for property augmentation). You have to do follow things creating external content types from data in Microsoft SQL Server tables creating synchronization connections mapping user profile properties Run Full Synchronization. Please follow this video from MSFT, to complete task. ...


1

Here's a step-by-step post on using Copy Web Service.


1

Yes you can. SharePoint synchronizes with any server that uses Active Directory Protocol or LDAP for user profile details. Exchange Server is just the Microsoft version of it. You have other similar LDAP servers like Domino Server or Lotus Notes server from IBM, etc. Inorder to achieve this, you need to add an import connection with the LDAP server. You ...


1

I would recommend you use a Managed Metadata Term Set, which will make the column available throughout your environment, integrate with search and have all the other advantages of Managed Metadata Columns. To update the departments each night, write a SharePoint Timer Job which sources its information from SQL and populates it within the term set. Make ...


1

You are going to have to use web services. You can't use the SharePoint API unless the code is running from the farm you are trying to access. In this case it looks like you are running the code from http://myInternalSite/ and remotely accessing https://MyExternalSite which is not possible directly through the API. SharePoint provides many web services ...


1

You can easily keep the two SharePoint farms in sync using content deployment.You can also schedule it(hourly or daily) for incremental or full deployment. If you want to trigger the job on demand (like SyncToExtranet = true), you can do it via code. One thing to note about content deployment is that it deploys all content(or all new content if configured ...


1

You cant make advanced workflow scenarios in sharepoint designer, for this you need to use visual studio 2010 see the bottom of this site for examples http://technet.microsoft.com/en-us/sharepoint/ff819861



Only top voted, non community-wiki answers of a minimum length are eligible