Import Error Newsletter (Extended)

Posted on 24/05/2007 14:35:20

Hi,

I am having some problems importing user details to the Newsletter extended module, here are the steps I am following:

- Created the following custom fields

    - Name

    - MiddleName

    - Surname

    - Sex

- Set up the Import/Export fields with the above and also 'Recipient´s e-mail address'

Port Format:

"firstName", "lastName", "middleName", Sex, "NewsletterRecipientEmail"

- 'Sex' is a Radio Button with three possible values;

    - 0 Not given

    - 1 Male

    - 2 Female

the Import file is made up as follows:

---

Marcel,Arend,van,1,info1@emailaddress.nl

Jan,Janssen,,0,info2@emailaddress.nl

----

When trying to import I get the following error:

Der_er_sket_en_fejl_under_import._(Linie:1)_Fejl:There_is_already_an_open_DataReader_associated_with_this_Command_which_must_be_closed_first.

After removing Sex from the import Format, and removing it also from the CSV file then import functions normally.

Any idea what the problem could be?

Replies

Posted on 25/05/2007 11:14:45

I'm also getting the following error when trying to use the 'Subscribe' form:

An error occured while attaching module (Dynamicweb.Frontend.Content)

System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement.

   at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)

   at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)

   at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)

   at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)

   at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()

   at Dynamicweb.Frontend.NewsletterExtendedFrontend.NewsletterExtendedSaveRegistration()

   at Dynamicweb.Frontend.NewsletterExtendedFrontend.NewsletterExtended(DataRow& ParagraphRow, PageView& Pageview)

   at Dynamicweb.Frontend.Content.getModule(DataRow& ParagraphRow)

It occurs directly after clicking the submit button, (with or without the password area activated)

Posted on 29/05/2007 08:46:14

Thanks for your participation. Please bear in mind that this forum is intended for questions related to developing Dynamicweb modules and not errors and exceptions in standard software. Please direct these to the helpdesk area of the partner extranet. Thanks.

Posted on 04/06/2007 09:56:58

Sorry, I thought this was for all discussions, thanks.

You must be logged in to post in the forum

Developer forum

Import Error Newsletter (Extended)

Replies