Installing the Interactive User Import Scheduler in DNN 5.0.2
Last Post 04-20-2010 10:10 AM by Candace. 6 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Luiz TosiUser is Offline
skipping stones
skipping stones
Posts:8
Avatar

--
04-08-2010 11:31 AM

    <!--[if gte mso 9]> Normal 0 unctuationKerning /> false false false oNotPromoteQF /> EN-US X-NONE X-NONE ontGrowAutofit /> ontVertAlignCellWithSp /> ontBreakConstrainedForcedTables /> ontVertAlignInTxbx /> MicrosoftInternetExplorer4 <!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:1; mso-generic-font-family:roman; mso-font-format:other; mso-font-pitch:variable; mso-font-signature:0 0 0 0 0 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-520092929 1073786111 9 0 415 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin-top:0in; margin-right:0in; margin-bottom:10.0pt; margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} p {mso-style-noshow:yes; mso-style-priority:99; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:"Times New Roman";} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} .MsoPapDefault {mso-style-type:export-only; margin-bottom:10.0pt; line-height:115%;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> <!--[if gte mso 10]>

    Hello guys,

    I have few questions, first of all iam trying to install IUI1.5 on DNN 5.0.2 and iam getting error during installation (scheduler error).

     

    How can i install IUI1.5 on DNN 5.0.2?

     

    Another point, is there way to execute data import right way? or do I have to create schedule ?

     

    Iam asking because i don’t want to figure out how to fix this scheduler issue, i just want to import my users because I can finish entire process, I receive an confirmation message showing "please visit host - schedule" and of course there isn't anything there.

    Best regards,

    Luiz TosiUser is Offline
    skipping stones
    skipping stones
    Posts:8
    Avatar

    --
    04-08-2010 11:46 AM

    here`s there error i got when i try to install:

     

    System.Data.SqlClient.SqlException: Procedure or function 'AddSchedule' expects parameter '@CreatedByUserID', which was not supplied. em System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) em System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) em System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) em System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) em System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) em System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) em System.Data.SqlClient.SqlCommand.ExecuteNonQuery() em DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) em DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) -- ADD DNN SCHEDULER ITEM execute AddSchedule 'DataSprings.DNN.Modules.UserImport.UserImportProcess, DataSprings.DNN.Modules.UserImport',45,'m',60,'m',250,'',0,1,'DataSprings_UserImport', NULL

    David ToUser is Offline
    river guide
    river guide
    Posts:2719
    Avatar

    --
    04-09-2010 06:34 AM
    HI, please go to Host / SQL and execute this:

    execute {objectQualifier}AddSchedule 'DataSprings.DNN.Modules.UserImport.UserImportProcess, DataSprings.DNN.Modules.UserImport',60,'m',30,'m',250,'',1,1,'DataSprings_UserImport', NULL,1

    -- David
    Luiz TosiUser is Offline
    skipping stones
    skipping stones
    Posts:8
    Avatar

    --
    04-09-2010 07:07 AM

    i've bought new 2.0 version and i have installed 15134_0_DataSprings_InteractiveUserImport_PA+02.00.10  and when i try to execute this sentence i got this error:

    System.Data.SqlClient.SqlException: Procedure or function 'AddSchedule' expects parameter '@FriendlyName', which was not supplied. em System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) em System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) em System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) em System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) em System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) em System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) em System.Data.SqlClient.SqlCommand.ExecuteNonQuery() em DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) em DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) execute AddSchedule 'DataSprings.DNN.Modules.UserImport.UserImportProcess, DataSprings.DNN.Modules.UserImport',60,'m',30,'m',250,'',1,1,'DataSprings_UserImport', NULL,1

    during installation i got this error:

     

    Execução SQL resultou nas seguintes exceções: System.Data.SqlClient.SqlException: Procedure or function 'AddSchedule' expects parameter '@CreatedByUserID', which was not supplied. em System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) em System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) em System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) em System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) em System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) em System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) em System.Data.SqlClient.SqlCommand.ExecuteNonQuery() em DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) em DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) -- ADD DNN SCHEDULER ITEM execute AddSchedule 'DataSprings.DNN.Modules.UserImport.UserImportProcess, DataSprings.DNN.Modules.UserImport',45,'m',60,'m',250,'',0,1,'DataSprings_UserImport', NULL

    Regards

     

     

    David ToUser is Offline
    river guide
    river guide
    Posts:2719
    Avatar

    --
    04-09-2010 07:24 AM
    HI, okay now that you have a newer version of DNN, please execute this instead:

    execute {objectQualifier}AddSchedule 'DataSprings.DNN.Modules.UserImport.UserImportProcess, DataSprings.DNN.Modules.UserImport',60,'m',30,'m',250,'',1,1,'DataSprings_UserImport', NULL,1 ,'Interactive User Import'

    -- David
    Luiz TosiUser is Offline
    skipping stones
    skipping stones
    Posts:8
    Avatar

    --
    04-09-2010 08:06 AM

    Great mate has work.

    Last question, what is the correct UTF format of CSV file? because my accents are apearing like codes.

    An example: S�o Paulo

    Regards.

    CandaceUser is Offline
    river guide
    river guide
    Posts:2431
    Avatar

    --
    04-20-2010 10:10 AM

    Hi Luis,

    JWheeler made a suggestion for the accents on your other thread here:

    http://www.datasprings.com/Products...fault.aspx

    Thanks!
    Candace


    ---
  • film izle
  • 720 izle
  • film
  • sinema izle
  • film makinesi
  • T�rk�e dublaj film
  • film izle
  • film izle
  • baglan film izle
  • sinema izle
  • 1080 film izle
  • film mercegi