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


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

Problem with List Columns in Foundation 2010 when Importing from Excel

Posted By:      Posted Date: October 07, 2010    Points: 0   Category :SharePoint
 

This is a pretty detailed issue. I will give you all the steps I am doing and hopefully there is a solution.

I recently updated our intranet site from WSS 3.0 to SharePoint Foundation. In WSS 3.0 I added a few of the application templates to use, including Asset Tracking. When I moved to Foundation I decided not to use those (and not sure if I can anyway) and exported the Asset Tracking data to Excel, then imported it to Sharepoint Foundation as a list.

Here is the issue I am having: when I imported from Excel all but one of the columns was created as "multiple lines of text". This means I cannot sort by these columns. I thought I could create similar columns as single lines of text, export back to Excel, copy the data, and import back. This changes the columns again to multiple lines. I even tried just typing in the data as a test and same problem. As long as there is no data, the columns will remain as single line of text; but as soon as I put data in I get this issue.

I can cofirm that these columns do not have more text than should be available in a single line. Any ideas of what I can do to make this work? I am at my wits end on this.

Thanks for any and all help.




View Complete Post


More Related Resource Links

While Importing Excel 2007 file to Datatable - headerrow problem

  

Hi there,

 

I am trying to simply extract an excel data from an uploaded file an put it into a datatable. In this case the excel file has 3 rows but when I fill the datatable I only see row count of 2.

I tried changing HDR:NO; to HDR:YES and vice versa, but no luck. 

What am I doing wrong? (Note: the excel file cannot have a  headerrow)

 

string connstr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + pFilePath + ";Extended Properties=\"Excel 12.0;IMEX=1;HDR:NO;\"";
            OleDbConnection conn = new OleDbConnection(connstr);
            conn.Open();
            DataTable dtTables = conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null);
            string strTablename = dtTables.Rows[0]["TABLE_NAME"].ToString();
            string strSQL = "SELECT * FROM [" + strTablename + "]";

            OleDbCommand cmd = new OleDbCommand(strSQL, conn);

            
            DataTable dt = new DataTable();
            OleDbDataAdapter da = new OleDbDataAdapter(cmd);
            da.Fill(dt);
            //At this point row count=2 which doesn't make sense


 

 

 


Sharepoint 2010 List Added Event Problem

  
Hi All, I have created List Added Event Handler. In that Event I want to Add Custom Field in List as List is created. I get an Error "The Specified Program Requires    a newer version of windows" Is there ant solution for it. I have tried it also creating new instances of spweb and spsite rather than getting it from "Properties" Thanks Saumil Thakkar

User information list properties SP Foundation 2010

  
When trying to view properties of user information list in SPD 2010, I get the following error "SharePoint designer cannot display the content of this view (...)" I am logged in as administrator for both farm and site. I can view content of the list in a browser, but I cannot access the list as a lookup column. It works with WSS 3/SPD 2007 on another server.

User information list properties SP Foundation 2010

  
When trying to view properties of user information list in SPD 2010, I get the following error "SharePoint designer cannot display the content of this view (...)" I am logged in as administrator for both farm and site. I can view content of the list in a browser, but I cannot access the list as a lookup column. It works with WSS 3/SPD 2007 on another server.

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

Using Infopath 2010 to customize a SharePoint 2010 list with columns using Managed Metadata

  

Hello All-

I would like to customize the "new" form on a SharePoint list that has some columns that use managed metadata term sets as options.  Unfortunately, when I do so, I get the message:

"InfoPath cannot generate a form template for the SharePoint list."

The following fields in the SHarePoint list are not supported because of their data type and will not be available in InfoPath Designer:

-MyColumnName (TaxonomyFieldTypeMulti)

This error message seems to be pretty self explanatory, but it boggles my mind that this would be the case.  Can I really not customize my list "new" form in Infopath if I am using columns with managed metadata?  Any workarounds?


Sharepoint 2010 List from Excel Spreadsheet to Display as Options in Infopath 2010

  

I have an Infopath 2010 form where I want the users to be able to display the cost of something based on the results of the data in an excel spreadsheet.

This spreadsheet does not have to stay a spreadsheet, I can import it into a List if that will make this work. So the spreadsheet has types of appraisals along the "X" axis and then individual States along the "Y" axis.

So if I am filling out the form - I want a "residential" appraisal and it is going to be in "California" - that should return the cost.

Any help woudl be appreciated. I am not sure exactly where to start.


SharePoint 2010: Importing a list or document library into a NEW list or library (.cmp)

  

Hello All,

I am trying to migrate from SharePoint 2007 to SharePoint 2010.  My company's current setup has seen very limited use because we have previously been a mulitple-content-management provider shop, but there are some content items we wish to re-use.  We also want to completely redesign our SharePoint setup to better suit the needs of our business, and the various departments.

My problem, therefore, is the seeming fact that you can apparently EXPORT granular backups down to the list and document library level, but when you try to IMPORT those lists, it gives you static.

Steps:

Database-Attach upgrade MOSS2007 content databases into a SharePoint 2010 web application

In Central Administration | Backup and Restore | Granular Backup:  Export a site or list, choosing whichever list from a site that has content in it.

in PowerShell, attempt the command Import-SPWeb -identity <url|GUID> -path <location of .cmp file created above> -force -verbose

I have attempted looking up the list in the content database for the new site to find its GUID, and also putting the URL of the list, down to the .aspx page it is viewed at.

So at this point I am wondering if what I am trying to accomplish is even possible with out-of-the-box SP2010 functionality.  Is it?  If not I ask the universe "wh

SharePoint 2010: Importing a list or document library into a NEW list or library (.cmp)

  

Hello All,

I am trying to migrate from SharePoint 2007 to SharePoint 2010.  My company's current setup has seen very limited use because we have previously been a mulitple-content-management provider shop, but there are some content items we wish to re-use.  We also want to completely redesign our SharePoint setup to better suit the needs of our business, and the various departments.

My problem, therefore, is the seeming fact that you can apparently EXPORT granular backups down to the list and document library level, but when you try to IMPORT those lists, it gives you static.

Steps:

Database-Attach upgrade MOSS2007 content databases into a SharePoint 2010 web application

In Central Administration | Backup and Restore | Granular Backup:  Export a site or list, choosing whichever list from a site that has content in it.

in PowerShell, attempt the command Import-SPWeb -identity <url|GUID> -path <location of .cmp file created above> -force -verbose

I have so far been able to import the list data, and unfortunately the web forms etc. that come with it.

I have a problem with that because I believe the .aspx pages that are copied in cause massive errors (I can no longer view the site after import).

Specifically, the problem: importing the absences list from a MOSS2007 Fab40 Absence tracking p

Problem with download excel 2010 document

  

Hi all,

I have upload functionality in my application. User can upload excel files and the system save the file into a folder and reads all records one by one.

We have a gridview where we display a link to processed excel file. we are also using XSLT version 1.0 for transformations.

There is no problem with uploading and downloading 2003 and 2007 excel documents. Also 2010 excel document is uploading properly but unable to download it.

Following is the namespace in xslt : http://www.w3.org/1999/XSL/Transform"

Can anyone please help in resoving this.


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.

Regrading Sharpoint 2010 problem and solutions

  
http://emanonsolutions.blogspot.com/
We can write your question and problem on this blogger.you get ans.use.

This sharpoint 2010 problem solving threads

  
Hi friend,

you can use this thread to solving problem and solutions.

Installation problem with VWD 2010 on XP sp3.

  

Hi

I have installed Xp sp3 in my system.When ever i install VWD 2010. I will get auto shutdown of System. But it support vs 2005, VWD 2008 Sp1 with sql 2005 very well without any problem. Again whenever i try to Sql server 2008 express. I will get auto shutdown problem.

But i have read on Microsoft site, VWD 2010 and sql 2008 support XP sp3.  My system does not support good graphic and sound in Window 7 OS. I have MSI mother board and AMD dual core processor with 2 GB Ram.

what is the problem ? is there problem with hardware ?


Security Briefs: Add a Security Bug Bar to Microsoft Team Foundation Server 2010

  

Take a peek inside Microsoft's strict development security structure as Bryan Sullivan describes the objective security bug classification system?the "bug bar"?used by internal product and online services teams. He will show you how to incorporate this classification system into your own development environment using Microsoft Team Foundation Server 2010.

Bryan Sullivan

MSDN Magazine March 2010


problem...i want a list item to populate all data in gridview!!!

  

i have a dropdownbox and a gridview

what I want is to have a list item which populates all data in a gridview.

I have tried using list item selected value=0 but to no avail.

what is the easiest way to achieve this?


Excel-like experience - gridview focus problem

  

Hi.

I'm creating a page where people can order several items from a list without having to press "edit" and "save" in between like you normally would in a gridview. The user writes down the quantity, and finally presses a "submit" button that saves the order.

I want the user to have a windows form (or excel) like eperience, so once the user puts in the quantity and moves on to the next item, either by TAB or by clicking on the TextBox, i make some calculations without the user beeing bothered with a full refresh or having to press a buton to execute the event, so I place the controls inside an UpdatePanel and use TextBox.TextChanged. The event runs code that calculates the sum for the row (price * quantity) and shows that in a column called "Sum", and updates a label in a fixed position with the new order total ("Total").

Any ideas on how to achieve this?

Right now I use a GridView with a templatefield for the Quantity and set the TextBox.TextChanged event to fire to make the calculations. The problem is that the focus then changes.


By using SmartNavigation or the ScriptManager.SetFocus I manage to retain focus on the TextBox that executed the Postback, but the user might have moved on to a textbox far down the gridview (thus causing the postback by leaving the previo

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