0
votes
2answers
15 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
54 views

SharePoint: Perform a query to load data into external list and display the results in a list within the webpart

I am relatively new to coding and I am trying to complete a project in Sharepoint. I have a webpart which includes Peoplepicker. When the submit button is pressed the first username passed is used as ...
0
votes
1answer
239 views

Is it possible to link existing Sharepoint 2010 lists to SQL server databases?

I created a SQL server database and added a table to it. Then I used Sharepoint Designer 2010 to create an external Content Type using this table. Now I can alter the according Sharepoint list which ...
2
votes
1answer
234 views

Timestamp in Sharepoint external content type not matching value in SQL table

I have an external content type in SharePoint 2010 pulling data from a SQL 2008R2 DB using BCS. All the data comes back fine but the Time stamp column is off by 2 hours when I compare the values ...
1
vote
0answers
418 views

Problems Connecting to SQL Server external list

I'm a newbie. I was exploring how to view/edit SQL Server database tables in Sharepoint. After some research I did a two-step process Create an external content type (using Sharepoint Designer) to ...
0
votes
2answers
124 views

External list not implementing TimeSpan field

I am developing an external content type with sharepoint designer, based on a microsoft sql server table. One of the columns has the time(0) format. This is interpreted by sharepoint designer as ...
1
vote
2answers
92 views

How can i retreive data from Web Server to my Intranet SP site

Would you please let us know the steps to connect a external Web Service that has specific attribute (GetAttributeProductsByID , GetAttributeProductsByName ... etc ) with an Intranet Sharepoint site ...
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 ...
1
vote
2answers
5k views

Can't Create External Content Type linked to SQL Server

In Sharepoint 2010, I am trying to create an External Content Type, and use a connection to a SQL Server. But, in Sharepoint Designer, when I am in the wizard to create an ECT, I'm having trouble ...