0
votes
2answers
13 views

How to decide between native SharePoint Lists or External Content Types?

We need some guidance on where we should house data for an application that will have all the data entry performed through SharePoint. Our team is building a HelpDesk ticketing system in SharePoint. ...
0
votes
1answer
37 views

Is this do-able in SharePoint 2010?

I'm very new to SharePoint so please forgive me if its a dumb question. I have a SQL Server database storing a set of manual tests and grouping information of the tests. I want to have a list to ...
0
votes
0answers
22 views

SP2013 reporting in MicroStrategy

I want to use MicroStrategy to build my repots. Normally i use sqlServer and microstrat with the ODBC links but i don't know how to do that with sp. Can i execute some SQLs directly in the ...
1
vote
0answers
14 views

Submitting list data to SQL

I'd like to submit data from a Sharepoint List to my SQL Database. I want the user to be able to create a new list item, attach a file and then once added it will write to an SQL Database. How would ...
0
votes
1answer
45 views

list updation in list loadvent

I have a custom list that contains a row of data. The data in the list is created from the data in the table in the SQL table. I need to check the data in database table and the data in the list is ...
0
votes
3answers
2k views

Populate Data From SharePoint List to a SQL Table

Is there a way that i can populate a custom share point list into a table in SQL server Database . I have a custom list which i modified it and made it as an info path form and on submit i want that ...
0
votes
1answer
376 views

Event Receiver Item Added for Multiple Files uploaded

I am trying to add few details for a item that is added to a list to SQL database table using a stored procedure, it works perfectly but when I upload multiple files it adds all of the items into the ...
8
votes
5answers
304 views

Should I use lots of SharePoint Lists or a SQL Database to store the data for my new bespoke application?

I am working on a project to create a new bespoke intranet website for around 50 users. The data volumes are relatively small, but in order to model the data I need to store (about the 100 or so ...
1
vote
1answer
322 views

Use REST to sum a column?

I want to retrieve items from a SharePoint list using REST, and then sum one of the columns. I'm brand new to REST, and didn't see a way to do this on MSDN. Is it possible to sum a column in a REST ...
1
vote
2answers
503 views

Update a list via SQL with MOSS2007?

How can I go about applying an update statement to a on MOSS2007 deployment? Essentially I'd like to write something similar to the following across it: update <list_name> set ...
1
vote
2answers
2k views

External Data field - problem with refreshing (SP 2010)

I have created a custom list with a field (column) of 'External Data' type, connected to my external content type. External Content Type's source is an SQL view. My problem is, when I make changes on ...
0
votes
2answers
3k views

SSIS Import Sharepoint 2010 List to SQL Server

Is there a way to do this via code? How so? I simply want to import data from a list in SharePoint 2010 to a SQL 2005 or 2008 server. I know there are several 3rd party plug-ins that work, but I ...
4
votes
3answers
7k views

How do I populate a SharePoint list from a SQL table?

I would like to know the best way to get data from a SQL view into a temporary SharePoint list from within SharePoint.