.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

Feature Wish List for Proposed BULK EXPORT in T-SQL

Posted By:      Posted Date: October 13, 2010    Points: 0   Category :Sql Server
 

What features would you like to see in BULK EXPORT?

You can also comment and vote at Related Connect items:

https://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=224026&wa=wsignin1.0

https://connect.microsoft.com/SQLServer/feedback/details/512367/new-t-sql-bulk-export-bulk-write-statements

Thanks.

 


Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM


View Complete Post


More Related Resource Links

Export SharePoint List to Excel Spreadsheet Programmatically using C#

  
In SharePoint applications, Custom Lists are used to store business data and Document Libraries to store the documents. But for data manupulation and analysis, Microsoft Excel provides very rich features as compared to SharePoint Lists. That's why people still loves to work on Microsoft Excel Sheets.

Issue with List Definition of same base content type and deployed via same feature

  

I am trying to deploy two custom list definitions using only one single feature.  Below are the details of my issue.

  • Two custom list definitions
  • Each custom list definition has its own custom content type
  • Each custom content type inherits from the base content type Picture (Type = 109)
  • The custom list definitions are grouped together under one single feature
  • The custom content types are grouped together under a seperate single feature

When I deploy my solution in this configuration, the second list definition gets the first custom content type applied to it and the list schema from the first list definition is also applied to the second list definition.

What makes this more interesting, when I seperate both of the list definitions under two seperate features it all works fine.  Custom content types and list schemas get applied correctly.

Can anyone tell me why I can not deploy both list definitions under one single feature?

If you need me to post any of the origional code or XML to this post please let me know.

 

Craig


Feature for XXXXXXXX list template XXX is not installed in this farm. vsewss

  
Hi Do you know why I got the error below and how to solve it ? Feature for XXXXXXXX list template XXX is not installed in this farm.  The operation could not be completed. ThanksMomo

Bulk amount of data in List

  
Hi All, I got a requirement that to display bulk amount data in a List (Around 50000 items). Can any one of you suggest me best performance way?(Displaying this amount data would definitely leads to performance issue). Let me know if you have any Queries.   Regards, Kumar.

How to export data from a sharepoint list to a SQL database

  
hi, is it posible if i add some data in a sharepoint list that i can export these data to my sql server tables. or if i create a dataview for exapmle from databse A in SPD to use in my wss3 site and then export it to database B in sql server? thnx

Feature Upgrade Functionality - Adding a new Content Type and List Instance

  
I've successfully used the upgrade functionality in SP 2010 to upgrade my list structures as needed. So far, these updates have been adding new fields to existing content types. Now, I have some new fields, content types and list instances to add, and am having trouble getting this accomplished. The scenario is this: - A new content type with a single custom field (also new), and a list instance for this new content type - A new field that is a lookup back to the new list instance defined above. This new field is added as an existing content type. - In my feature.xml, I have the Element Manifest specified with both new fields and an AddContentTypeField element for the new field being added to an existing content type:   <ApplyElementManifests> <ElementManifest Location="V1_04\Elements.xml"/> </ApplyElementManifests> <AddContentTypeField ContentTypeId="0x0100..." FieldId="{8028A1C8-1147-4DF7-B5C3-8A1F84A30360}" PushDown="TRUE"/> The result of running the update on this feature is: - My new field that is part of an existing content type is added - My new field that is part of a new content type/instance is added - My new content type and list instance is NOT created, therefore my lookup is broken Any idea why my new Content Type and List Instance is not being created? Do I need to specify there

Feature Upgrade Functionality - Adding a new Content Type and List Instance

  
I've successfully used the upgrade functionality in SP 2010 to upgrade my list structures as needed. So far, these updates have been adding new fields to existing content types. Now, I have some new fields, content types and list instances to add, and am having trouble getting this accomplished. The scenario is this: - A new content type with a single custom field (also new), and a list instance for this new content type - A new field that is a lookup back to the new list instance defined above. This new field is added as an existing content type. - In my feature.xml, I have the Element Manifest specified with both new fields and an AddContentTypeField element for the new field being added to an existing content type:   <ApplyElementManifests> <ElementManifest Location="V1_04\Elements.xml"/> </ApplyElementManifests> <AddContentTypeField ContentTypeId="0x0100..." FieldId="{8028A1C8-1147-4DF7-B5C3-8A1F84A30360}" PushDown="TRUE"/> The result of running the update on this feature is: - My new field that is part of an existing content type is added - My new field that is part of a new content type/instance is added - My new content type and list instance is NOT created, therefore my lookup is broken Any idea why my new Content Type and List Instance is not being created? Do I need to specify there

Export to outlook calendar in a custom list?

  
Howdy, I have a custom list with a calendar view. I think it was originally created as a custom list rather than a straight-out calendar for reasons of functionality. However, obviously this, being only a list, doesn't have the "Export to outlook" or "Connect to outlook" feature. I can't really recreate the list from scratch because it's been used for quite a while with a lot of content and custom fields, so is there a way of adding this feature? Thanks, Clark.

Can't export list to Excel - "You do not have adequate permissions..."

  
Hello, SP 2007 (12.0.0.6318), Office 2010, Win 7 Pro x64. When I try to export a list to Excel, I get this error: "You do not have adequate permissions to modify this list.  Changes to your data cannot be saved." This comes right after I am prompted to enable data connections, and the Import Data dialog. I get this error on two different computers; I have tried several browsers (IE8 32-bit, FireFox, Iron). How do I fix this problem?  Thanks.

SharePoint 2010 Export list Items to Excel, wrong url in iqy file

  
Hi, I have a SharePoint 2010 Environment that uses https://portal.<something>.com. Exporting to Excel of a list uses wrong URL. When I go to the a list, select the list to show the "office ribbon" and then select export to excel, excel will show the error "Excel cannot connect to the SharePoint List". When I take a look at the IQY file that is created it contains the wrong url: http://portal.<something>.com instead of https://portal.<something>.com Changing the URL in the IQY file manualy to https://portal.<something>.com and then opening it will excel is working fine, list data is exported to excel then. Alternate access mapping is configured to use https://portal.<something>.com as default, export to access is working normaly. I already deleted the http://portal.<something>.com alternate access mapping once to see if this fixes the problem. No fix, even not after IISreset or rebooting the server. Where or how is the export to Excel IQY file created and where is it possible to fix the URL it is putting in the IQY file? Grtz, Arjan

Custom list export to excel only selected items

  

I want to export selected items from the list to Spreadsheet, currently its exporting all items in view.

My client does not want to use datasheet>>filter>>export option.

Is there any out of box solution to only the selected items to excel? otherwise what would be best way to achieve using coding?

 


Create dynamic dropdown list when we export data to excel using SSRS.

  

Hi All,

I have assigned a work to create a report, that should render in excel with dropdown list. i.e. report should contain a input parameter as a table names, when user selects the table name, report should show only the field names of the selected table. Some of the field name have look up values that values should be displayed as dropdown when we export to excel.

Can any one have any idea how to proceed with this report?

Thanks,

Karthik 


Import and Export List data in excel sheet

  

Hi ,

I need to import based selective data from excel sheet and export data from sharepoint list, I'm new in Sharepoint.

can anybody guide me? What all possible ways are there and which would be the best.

Thanks


Dev

SP 2007 (WSS 3.0) Export of WebPart DataView on list fails

  

We have created a DataView WebPart on a list in Sharepoint 2007 using SharePoint Designer with the Sharepoint List Toolbar (so we have the Actions button, including Export to Spreadsheet).  When we try to Export to a Spreadsheet (Excel 2003) it fails.  We've tried a couple of different scenarios, we get a different error for each.

If we just create the DataView onto a new aspx page then open the page in IE and try to export the data we get an error box that states and unexpected error has occurred and the data could not be saved.  No spreadsheet is created.

If we create a public view page in Sharepoint then open the resulting .aspx in Sharepoint Designer, remove the automagically created view and replace with a DataView Webpart, then save and reopen the page in IE, attempting the export results in a spreadsheet being created but only the ID numbers exported.  We then get a message box saying that some hidden or read only fields need data but do not have a default value.

As the original list is quite complex and has a variety of different data types we created a much simpler list on a separate subsite and repeated these scenarios, with exactly the same outcomes.

We are using Sharepoint 2007 (WSS 3.0) via Internet Explorer 6.0 on Windows XP SP2 to export the data into Excel 2003 SP3.  This has been replicated on three dif

Sharepoint Export Import List Items

  

Hello,

My requirement is to export the list items in Pages library with its meta data i.e. Created Time and Modified Time.

I am trying Export Import code, but it does not import time. It imports the CreatedBy and ModifiedBY acuurately but createdTIme and Modified Time comes as current time, the time i run the import.

Pls help

Code:

private static void ExportItems()
    {
      string exportFolder = @"C:\exports\";
      string exportFileName = "Export_File.cmp";

      using (SPSite site = new SPSite(sourceSiteUrl))
      {
        using (SPWeb oWeb = site.OpenWeb())
        {
          SPList oList = oWeb.Lists["Pages"];
          SPListItem oItemA = oList.GetItemById(2480);

          SPExportObject exportObject = new SPExportObject();
          exportObject.Id = oItemA.UniqueId;
          exportObject.Type = SPDeploymentObjectType.ListItem;

          SPExportSettings exportSettings = new SPExportSettings();
          exportSettings.LogExportObjectsTable = true;
          exportSettings.LogFilePath = exportFolder + "Exportlog.log";
          exportSettings.SiteUrl = sourceSiteUrl;
          expo

Feature 'df31abb1-d432-4fa5-bdb1-25a2a5dd7e86' for list template '7655' is not installed in this

  

Hi guys!

I recent started developing issues in SharePoint 2007 and I'm find a little bit lost.

Recently, while creating a little windows application that go across a SharePoint portal finding documents, it recives the exception "Feature 'df31abb1-d432-4fa5-bdb1-25a2a5dd7e86' for list template '7655' is not installed in this farm." while try to enter in a list called Caml Query List.

I saw a lot of forums that recomend me to install the U2U feature, remove the list and then uninstall again the feature, but I don't know where I can find this feature and how I've got to do that.

Is this feature on the 12 hive?

I need to use the stsadm.exe aplication to install/uninstall or remove it?

Thanks in advance for the replys!

Cheers!


Bulk editing issue - list cannot be displayed in Datasheet view

  
 

 

On a sharepoint page i click on 'Actions' tab then select 'Edit in Datasheet'  and i see the following error message

 

"The list cannot be displayed in Datasheet view for one or more of the following reasons: A datasheet component compatible with Windows SharePoint Services is not installed, your browser does not support ActiveX controls, or support for ActiveX controls is disabled. "

 

I am using XP professional, IE 6.02 to access the sharepoint site.

 

I was hoping that the hot fix KB938888 would fix that issue, but it did not. bulk editing is a nice feature that i would like to use but i have never been able to. The link to export data to Excel works fine.

 

if anyone has suggestions, thanks in advance

a23rd.


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend