Recently Viewed...
To help you navigate to pages you most recently visited, select from the links below.
Product Forums
Sharepoint Forums
Newsletter
Dynamic Forms Demonstrations
Page Tags
DNN Modules
SnowCovered Top Sellers

One stop solution for events calendar and events registration! Demo site available for free trial.

'Relationship Building' and 'Communication' are two essential nuts and bolts for a business to prosper. This module allows you to bridge both of these and easily generate continuous awareness of your web site, products and services. Your prospects and customers will greatly appreciate this featur

Version 5 of the perennial best-selling tool for creating data-based solutions in DNN without custom programming. This version focuses on greater flexibility, expandability, and ease-of-use.

Ultra Video Gallery is a brother product of Ultra Media Gallery, UVG allows you to add videos in various format and automatically convert them to flv format, you also can add videos from embed code and play them in our integrated flash video player.

The award winning discussion forum and community solution for DotNetNuke is now even better. When you need to build the best community site, you need the best module, Active Forums!

Powerful, Ajax Enabled, Easy to Use. Document Management has never been better. Open-DocumentLibrary allows DotNetNuke users to share and manage documents in a flexible, intelligent way, offering granular control over Folder and Document access.

Gloss is the first ALL COLORS! skin, featuring a powerful XML-based flash and being 100% W3C CSS XHMTL1.0 compliant. Tune it yourself on the fly, changing colors, backgrounds, containers, text color and size, width and more! Brilliant!Available for DNN4 and DNN5

ALL NEW ! - Minimalist includes skin packs in 12 great colors. Each color has Flat, Gradient and Glass versions. Feature rich XML Flash header, perfect for just about any purpose. 9 Different menu options in each skin pack; 3 horizontal menus, 3 vertical menus and 3 all-new Twin level menus . . .

A 16-in-1 dnn module.Powerful yet easy to use. Capable of producing a multitude of functions including:Image rotator/Numeric rotator/ Mp3 player/Wmv player/ Flash video player /YouTube video player/Multimedia player / Text-to-speech podcast / Flipping book player/Banner topic player/Silverlight albu

Ultra Media Gallery is the most popular photo gallery and media gallery solution for DotNetNuke, UMG offers 10 different flash player to browse your gallery with completely different user interface experience.

    |   Register   |   Friday, January 09, 2009   
Data Springs Product Forums...
Subject: csv import error
Prev Next
You are not authorized to post a reply.

Author Messages
Matthieu
Posts:13
wading in the water
wading in the water

01/18/2008 9:13 AM  

Hi,

When I import a csv file I have this error :

Erreur critique.
Cannot find column 1.

and in the logs views :
AssemblyVersion: 04.05.05
PortalID: 0
PortalName: XXXXX
UserID: 1
UserName: host
ActiveTabID: 119
ActiveTabName: Newsletters
RawURL: /News/Newsletters/tabid/119/ctl/ListImport/mid/457/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://****.********.com/News/Newsletters/tabid/119/ctl/ListImport/mid/457/Default.aspx
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.8.1.11) Gecko/20071127 Firefox/2.0.0.11
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: e83685a7-703d-4454-acb3-70ef3bcf419b
InnerException: Cannot find column 1.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.DataColumnCollection.get_Item
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: Cannot find column 1. ---> System.IndexOutOfRangeException: Cannot find column 1. at System.Data.DataColumnCollection.get_Item(Int32 index) at System.Data.DataRow.get_Item(Int32 columnIndex) at Dataspring.DNN.Modules.OptInEmail.__OptInListImport.lnkImport_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e) at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---
Source:
Nom du serveur: *******


Thanks in advance

Best regards
DevPCI team

Matthieu
Posts:13
wading in the water
wading in the water

01/21/2008 4:44 AM  

After a check of my .CSV file, I found an empty line at the end of the document that was causing this error...

To correct this (and make sure that there was not an other blind line):
I've convert my file in .txt, and replace ";" with Tab caracter. And delete blank lines at the end of my document.
I hope that this will be useful for other users of this module.
Matth.

Chad
Posts:2389
river guide
river guide

01/24/2008 4:21 PM  
Matth,

Thanks for posting this update. Yes we recently discovered another client running into a similar issue so I am going to go and test your suggested solution. We will try add some additional error handling to handle these types of problems.

-Chad
You are not authorized to post a reply.



ActiveForums 3.7

Copyright 2005 - 2009 by Data Springs, Inc.
Terms Of Use | Privacy Statement