We have data from our business systems in a report which need to be updated automatically. How can a sharpoint list pick's up this data automatically from a local file directory?
View Complete Post
I have to pull external data from a text file to a SharePoint list on a daily base. Additional column content (e.g. attachments) in SharePoint should be kept during update. There should be RSS feeds, email notifications or workflows on external data change
(so delete all items and import new will not work).
I've found this codeless 3rd party solution with automatic background update (and write-back???):
Any other idea? BDC-based? Thanks.
Can some one help me to achieve below task
Save/Update/Delete Sql Server data base table using Sharepoint Designer.
I have seen numerous articles for the above, but they all just gloss over the step I am having a problem with, assuming nobody will have an issue with it.
I'm trying to create an External Content Type so I can use it to display external data (from SQL Server) in an External List. When I get to the step to add the connection and the SQL Server connection dialog box appears, I enter the server and database
names and click OK with the Connect with User's Identity radio button still selected and I get the error message:
login failed for user ''. The user is not associated with a trusted SQL Server connection. I've tried to read up on the different purposes of the radio buttons on offer on this dialog box but don't know which I should really be using and don't think
I can create a target application ID anyway in Foundation (for the other two radio button options) as that has to be done in the secure store services. Can anybody help with this?
I am setting a SharePoint test environment with loads of data.
I could some how manage to use tools to populate data in Sharepoint.
But I couldn't find a way to
1) Modify the sites/lists/listitems in an easy way without me havng to manually perform that
As I had 200GB of data with some thousands of sites and lists, I am not able to manage this data manually.
For my testing to run smoothly, I need to be able to add/delete/modify the metadata, permissions of many objects easily
Can someone suggest me a tool which allows me to do this kind of functionality
Hi friends this is siddiq ,
How can i open sharepoint 2010 lists in access
2010 as tables in 1 data base.I have 2 lists which i want to take into access but both of the lists are creating a seperate database.But i want to take both the lists in one access database
I am in the midsts of planning for an upgrade from 2007 to 2010, and we are looking for quick-wins for the client, one of which obviously being PerformancePoint 2010 integration with SPS 2010. So i am tooling around, following some basic tutorials of creating
scorecards/kpis/filters/dashboards all from the contoso sample data, which is all fine and well, but my client doesn't have a datawarehouse, and doesn't plan on moving to one.
This puts me in the situation where I need to be able to create these pieces from SP Lists instead of an analysis services DB/DW. I go through and create the data connection, and all seems to be working fine...In the data connection windows, I can click
the View tab and preview the data, and actually see all the data thats in the task list I've created and linked to (all demo data, just created a couple of tasks and etc).
Now the trouble comes when I try to create a simple scorecard based off of this list. When I am in the Create tab, and click Scorecard, (Use Tabular > SP List) I can select my data source (Task Tracking Data Source) and thats all well and good.
I then go to the SharePoint Site tab (on the select data source on the wizard), I am able to select my Task Tracking Data source as well. When I get to the KPI scre
SharePoint 2010 introduces a number of new ways to access business data and present it to the user. We'll show you several options that range from no-code solutions to fully integrated Office add-ins.
Donovan Follette , Paul Stubbs
MSDN Magazine July 2010