Installing the Interactive User Import Scheduler in DNN 5.0.2
Last Post 04-20-2010 10:10 AM by Candace. 6 Replies.
|
|
Luiz Tosi
skipping stones Posts:8
|
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 Tosi
skipping stones Posts:8
|
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 To
river guide Posts:2719
|
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 Tosi
skipping stones Posts:8
|
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 To
river guide Posts:2719
|
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 Tosi
skipping stones Posts:8
|
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. |
|
|
|
|
Candace
river guide Posts:2431
|
|
|