The quantities, characters, or symbols on which operations are performed by a computer, being stored and transmitted in the form of electrical signals and recorded on magnetic, optical, or mechanical recording media.

learn more… | top users | synonyms

5
votes
3answers
2k views

BCS External Content Type with 20,000+ items (O365)

We have a large database of 20,000+ items on a local database that we need to get into Sharepoint Online 2013 in O365 to use as metadata for various documents in multiple locations. New entries and ...
3
votes
2answers
121 views

how to have a list like this

i would like a list that has one more column with a hyper link "details" inside of it. when i click that link for each list item, it should take me to a new item view. if this is the first visit then ...
2
votes
2answers
1k views

Reason people don't use SPContext when executing web.Lists[“ListName”].GetItems(query)

I'm building a Site Definition that will be the core of a SharePoint product. I want to use best practices building the data access architecture. Since I do not know what the URL of the site will ...
2
votes
2answers
1k views

External lists do not display data though data are available

I have external lists connected to a sql server database. Since the last day, some of the lists do not display data; the lists are empty, only headers are shown. (Some lists still display data, ...
2
votes
1answer
2k views

Define XSLTListViewWebPart Custom DataSource

I'm currently working on a personal project which main goal is to create simple and customizable dashboards for everyday life. In order to avoid wrong way, I would like to know how to do to bind a ...
2
votes
2answers
120 views

In jquery rest result for person object as a [object Object]

Would it be possible to get a Person or Group type as a string rather than and [object Object], I am handling everything within the front-end with REST calls to listdata.svc URL's. CODE // DISPLAY ...
2
votes
1answer
165 views

Connecting to IBM DB2 Database through OLE DB?

Is there a way to have a Data Source connection to a IBM DB2 database through OLE DB? I have tried all different kinds of variations of the connection strings from ...
2
votes
1answer
156 views

Most effiecient method of checking/veryfing identical/missing content between 2007 and 2010?

We are currently migrating from sharepoint 2007 to 2010 on a dozen servers, due to technical reasons we cannot employ the usual methods and instead we are using the webservices and requests to ...
2
votes
2answers
267 views

Use sharepoint 2007 as database for an ASP.NET MVC 4 application

I have built an ASP.NET MVC 4 C# application that has Many to One relationships. The application currently uses SQL as data provider. The following is the data connection string I use: <add ...
2
votes
3answers
1k views

How many person/group can be saved in a person/group column?

Is it possible to store some 1000+ users in a SharePoint 'person' column.
1
vote
2answers
768 views

Share Data Between Visual Web Parts on different pages

I have a need to share information from Web Parts on one page, with Web Parts on a second page. SharePoint does not have a default Session State, and let's say for arguments sake I cannot enable ...
1
vote
1answer
28 views

Redeploying List Definitions and preventing data loss

In the initial release, I had 2 solutions: one is timer job and the other is event receivers/lists. In hindsight, the event receivers/lists should've been separated as well. In the newest iteration, ...
1
vote
1answer
21 views

How to create Data Conection Libary with option read and write

I want to create data conection library to transfer a data from MSSQL serwer to Sharepoint list and with read write option. I must edit a data from a MSSQL table to Sharepoint list. Please help.
1
vote
3answers
3k views

Use multi-select lookup field as filters in a data view web part (DVWP)

i have a list and a doc library. the list has a multi-select lookup field to the ID field in the doc library. when a user chooses multiple values in the dispform.aspx list form, i want to display the ...
1
vote
3answers
185 views

Data Modeling, Primary Keys, TOAD?

Is there software i can use to create a data model of sharePoint lists and libraries like there is TOAD for SQL databses
1
vote
0answers
11 views

Data Source Propeties - Analysis Services Business Center

When I try to build rsds file in Report Data Source it showing me an error. Nothing Error show on Test Connection. The Error shows only when I click a button OK. Report Server has encountered a ...
1
vote
1answer
35 views

If I wanted to have SharePoint update with Live Market Data (ie. Bloomberg), is this possible?

I'm trying to figure out if SharePoint has a functionality where it can feed in live Market Data from an external site (i.e. Bloomberg) and update periodically throughout the course of the day.
1
vote
0answers
66 views

SharePoint 2013 Online o365 and Very large external data for a Data dictionary solution

We have a very large SQL data source. That SQL database in on Prem and really secured tight - no update allowed. It's one of many data sources we plan to use to produce an enterprise wide Definition ...
1
vote
0answers
156 views

Binding WPF data grid to Sharepoint listitemcollection

I'm trying to display a sharepoint 2010 list using WPF and the Sharepoint Client object model. This is the grid <Grid> <DataGrid AutoGenerateColumns="True" Height="200" ...
1
vote
1answer
98 views

How to import the data from a Google Public Data Explorer into SharePoint 2010 out-of-box charts

using the new Google PDE I was wondering if there was a way of importing the data into my nicely formatted Chart Web Parts in sharepoint 2010.
1
vote
0answers
51 views

linq to sharepoint error: Cannot insert an entity that already exists

I have a sharepoint list: MyList I insert item to this list by Linq to Sharepoint (context object) like this: context.MyList.InsertAllOnSubmit(data.Items.Select(n => dataConvertor.Convert(n))); ...
1
vote
0answers
221 views

Data Connection Library Event 6932

I am having the worst time connecting to the web service to call in the UserName variable for use in my InfoPath 2007 form. I can do it from a code behind, and want to be able to use this option as ...
1
vote
0answers
43 views

Is my Data Access model acceptable?

I'm creating a SharePoint application and want to do things the right way as often as possible. I'm deploying a series of Lists in a Site Definition, and I want to lock down Data Access to a series ...
0
votes
2answers
33 views

How to round a datatime LocalTime to the onkly datatime. Not to the time with hours

I have got a code: DateTime dzienStart1; DateTime dzienStop1; dzienStart1 = dzienStart.ToLocalTime(); dzienStop1 = DateTime.Now.ToLocalTime().AddMonths(-2).AddDays(-1.0); Whem I look at a date in ...
0
votes
2answers
104 views

Data Migration from .CSV to sharepoint list around 60lakhs record with lookup value

We had a requirement to migrate 6 Millions record from .csv file to 13 sharepoint list including lookup column, we come up with tool using Client Object model but the performance is low ...did any one ...
0
votes
1answer
17 views

Access parent site list data via LINQ from subsite

I have an SP 2010 web part that access list data using LINQ. The data and the web part currently live on the top-level site. Would I be able to easily access that data in a different web part from a ...
0
votes
1answer
27 views

External Data Editing and Modification

Can data in a SQL database be modified (new, delete, edit) through a SharePoint out-of-the-box feature or custom built feature?
0
votes
1answer
21 views

Where is the business data?

I have recently installed Sharepoint 2010 standard edition. I need to embed an excel spread sheet in a web part but cannot find the business data. What should I do? Here is a screenshot
0
votes
1answer
43 views

Data Table distinct value

dtnew1.DefaultView.Sort = "Modified DESC"; DataTable unique = dtnew1.DefaultView.ToTable(); In this code's "unique" table I'm getting all values but post title value is getting repeated. I need a ...
0
votes
1answer
152 views

Extract Infopath form data to CSV with Powershell

I have several infopath forms. Which contain data. I need to resume some of them in a CSV file. I think I can do it with powershell. Loop in the directory and get all files. But to retrieve data, ...
0
votes
3answers
41 views

How to create a form where the information on the XSN file cannot be changed after sent or saved?

Can I create a form where all data become static after saved or sent, and not available to be alteration on the filled data for the creator or anyone else either? Besides, all non filled fields must ...
0
votes
1answer
49 views

BCS Question (scenarios when data source is unreachable)

I have a few real-world (hopefully simple) BCS questions for on-premise database and SharePoint Online (O365) connected by OData web service: In the scenario where the data source is ...
0
votes
2answers
32 views

Storing Data for a Home Page

I'm fairly new to Sharepoint so bear with me! I have a project site and a request has been made to display (formatted) data on the home page relating to the project (ie title, scope, project members, ...
0
votes
2answers
217 views

Getting Item and value from list by Specific Data

I would like getting a specific item from a specific list but i don't have ID, just a field (column) value. Here's my list: On the site, i have only the name...i'd like to recover the paid leave ...
0
votes
1answer
71 views

Time in Sharepoint

We have got two method in Sharepoint to get the time. One is ToUniversalTime() an secound is ToLocalTime() But when we are in server and have got a aplication instaled on server which kind data method ...
0
votes
1answer
38 views

Store cross site collection data

Is there a way to store data (strings, maybe xml) in SharePoint that can be accessible to all the site collections in a web application?
0
votes
2answers
2k views

How can I create a cross-site DVWP in 2010?

This was so easy in SharePoint Designer 2007 - you just used the "Connect to another library..." link and you could quickly create a DVWP on your page that used any list/library in your site ...
0
votes
1answer
180 views

Can I access a SharePoint List or library with an InDesign HTML file?

I'm looking to Use InDesign to create an interactive object that creates "click and reveals" that reveal data from SharePoint data. How would this task be done?
0
votes
1answer
118 views

Trigger the start of a one time workflow via a data entry in a list

I have a workflow that is triggered via any change on a list and it is set to send email. Problem, the condition is set on any data point when I want it to be triggered on one data point when it ...
0
votes
1answer
992 views

How to manage a dynamically updated Excel file in SharePoint

When we have a client that requests a call back, we fill out a web form that automatically populates an excel spreadsheet on a shared drive. Reps will then access the spreadsheet and take appropriate ...
0
votes
1answer
2k views

Importing external data synchronously into a Sharepoint List

Problem : We need external data to be imported synchronously into a Sharepoint list. The data is located in a MySQL database. The Sharepoint server is setup behind a firewall and no direct connection ...
0
votes
1answer
48 views

Additional databse - best practices

Our system needs to synchronize data with external systems by web services. We want additional database to keep needed data and then be able to access it. I wonder how to resolve issue with database ...
0
votes
0answers
8 views

How to migrate existing lists into new sharepoint app?

I have sharepoint app in mind consisting of 2 lists, some automatic workflows, and some manually triggered workflows with corresponding ribbon buttons. Right now client use site + lists + some ...
0
votes
0answers
21 views

Entity Attribute Value(EAV) with SharePoint Lists

So we have a SharePoint application, in wich we will need to add custom fields for each client. We don't know how this could evolve. A collegue sugested that a data model such as EAV, could be a good ...
0
votes
0answers
18 views

Decrement list item on approval

As a self teaching exercise I am trying to make a leave approval system. I have an Employee Directory in the form of a list, each employee has a "Holidays Remaining" column with a default value of ...
0
votes
0answers
29 views

Pulling data from a PDF

I am wondering if it is possible for SharePoint to pull information from a PDF file? Basically, I have a document library where people can upload PDF vouchers which then get routed to different ...
0
votes
0answers
43 views

Select A Document from a SharePoint Document Library in an InfoPath Form

When setting up a Data Connection to a SharePoint document library in InfoPath there is no option to select the "name" field. This means that I cannot populate a drop down where users can select the ...
0
votes
1answer
221 views

SharePoint 2013: “Sorry, this site hasn't been shared with you” After External Content Type (ECT) Data Column is Refreshed -Only affects non SC admins

I am Farm Administrator and Site Collection Admin for a single site collection (the only site collection in our farm). On Prem SharePoint 2013 Server. I have created an ETC using a Secure Store ID ...
0
votes
1answer
69 views

Adding data views and data sources

I am hoping this question has a really simple answer to it. I am currently in SharePoint Designer editing an .aspx page. I added an empty data view, then added a data source for one of my document ...
0
votes
0answers
45 views

Sharepoint 2013: can a page automatically filter content based on credentials?

Is there a way for Sharepoint 2013 to display only certain data on a page based on the credentials of the person logged in? To clarify: My project Director wants to visit a page and automatically ...