Register  |  Login   
HomeUniversal ListSupport ForumsPortfolioContact Us
Forum  
SearchForum Home
  Universal List  Universal List Version 4.x  Error on Import...
 Error on Import Value was either too large or too small for an Int16.
 
 11/18/2007 7:52:49 PM
westdh
1 posts


Error on Import Value was either too large or too small for an Int16.

I am trying to import an xls file - first column is numbered from 1 to 155 any Idea's of what is wrong with failure to import records on this trial version? 

 

Visible By Administrators Only
 
Select File To Import
(Supported Formats: Excel, XML, CSV)
SQL cannot save more than 4,000 characters in any field.
:
LLC Mailing List.xls UploadDelete

Start Import  Cancel


Server Error in '/' Application.

Value was either too large or too small for an Int16.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.OverflowException: Value was either too large or too small for an Int16.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[OverflowException: Value was either too large or too small for an Int16.]
   System.Convert.ToInt16(Char value) +2511673
   System.Char.System.IConvertible.ToInt16(IFormatProvider provider) +9
   System.Convert.ToInt16(Object value) +25
   CookDNN.DNN.Modules.UniversalList.Import.ImportExcel(String FileName, Int32 RowsCount) +200
   CookDNN.DNN.Modules.UniversalList.Import.DrawPreImport() +335
   CookDNN.DNN.Modules.UniversalList.Import.StartImport() +270
   CookDNN.DNN.Modules.UniversalList.Import.DrawActions() +113
   CookDNN.DNN.Modules.UniversalList.Import.Page_Load(Object sender, EventArgs e) +90
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061


Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832
 11/19/2007 5:16:53 AM
host
238 posts
4th


Re: Error on Import Value was either too large or too small for an Int16.

westdh

Please send us an example of file to import. Then we can review it.

 11/29/2007 1:49:17 PM
jillymc
14 posts


Re: Error on Import Value was either too large or too small for an Int16.

I'm getting the same error with an Excel file.

I've tried both putting a number field as the first field to serve as the ID field.and not doing that.

I have one referenced field.  I 've tried both uploading with the IDnumber of the link field in the Excel file and the displayed value.....still get the error.   

I can download excel files just fine, and the downloaded file looks (column-wise) just like the one I'm trying to upload.

Any ideas?

Jill

 11/29/2007 1:56:51 PM
jillymc
14 posts


Re: Error on Import Value was either too large or too small for an Int16.

Where are the uploaded files for import supposed to be saved?   I'm not sure the files are actually uploading. 

Jill

 11/30/2007 10:51:54 AM
jillymc
14 posts


Re: Error on Import Value was either too large or too small for an Int16.

Another quesion.....I have some records in the database I'm trying to import the files into.  Is that a problem.  Does the import have to be into an empty file?   I made the ID numbers of the imported file start at the next number from the existing files.

Jill

  Universal List  Universal List Version 4.x  Error on Import...
Free DotNetNuke dnndir.com DotNetNuke.fr About Us DotNetFreaks Asp.net Directory - Applications, Controls, ASP.NET hosting, Tutorials www.alldnnskins.com DotNetNuke Powered! Snowcovered
 
CookDNN