Need to Update a SharePoint list from a client -- Can it be done
-
Greetings, I would appreciate being pointed in the right direction if this is possible to run on a system that does not have SharePoint services installed. First let me say I have very limited experience with SharePoint services other than using it as a table in MS Access. My need is to pull data from an existing database and update a SharePoint list nightly. It will need to be either a Console app, Windows App or PowerShell script that can be scheduled to run from a job server nightly. The job server is a Windows 2008 server without SharePoint installed. In my searching I have seen several references to using the Microsoft.SharePoint.PowerShell in PowerShell, but I can't seem to find that on my system. Similarly in C# console app I am unable to include the Microsoft.SharePoint. I have built a quick solution in MS Access to update the list, but it requires a person to run the process. Thanks in advance
-
Greetings, I would appreciate being pointed in the right direction if this is possible to run on a system that does not have SharePoint services installed. First let me say I have very limited experience with SharePoint services other than using it as a table in MS Access. My need is to pull data from an existing database and update a SharePoint list nightly. It will need to be either a Console app, Windows App or PowerShell script that can be scheduled to run from a job server nightly. The job server is a Windows 2008 server without SharePoint installed. In my searching I have seen several references to using the Microsoft.SharePoint.PowerShell in PowerShell, but I can't seem to find that on my system. Similarly in C# console app I am unable to include the Microsoft.SharePoint. I have built a quick solution in MS Access to update the list, but it requires a person to run the process. Thanks in advance
For anyone else who may need this functionality I found the answer elsewhere. It is very simple once you download the Client Object Model Redistributable from Microsoft. 2013 - http://www.microsoft.com/en-us/download/details.aspx?id=35585[^] 2010 - http://www.microsoft.com/en-us/download/details.aspx?id=21786[^] Follow the help file.