After installing "Interactive User Import version 2.0.10" on DNN version 5.2 I received SQL errors and notice the event scheduler was not created. To fix this issue I ran the following SQL script to resolve the issue.

 -- ADD DNN SCHEDULER ITEM

execute AddSchedule 

   @TypeFullName = 'DataSprings.DNN.Modules.UserImport.UserImportProcess, DataSprings.DNN.Modules.UserImport'

  ,@TimeLapse = 1

  ,@TimeLapseMeasurement = 'm'

  ,@RetryTimeLapse = 30

  ,@RetryTimeLapseMeasurement = 'm'

  ,@RetainHistoryNum = 250

  ,@AttachToEvent = ''

  ,@CatchUpEnabled = 1

  ,@Enabled = 1

  ,@ObjectDependencies = ''

  ,@Servers = NULL

  ,@CreatedByUserID = NULL

  ,@FriendlyName = 'DataSprings_UserImport'

 

GO

HI, thanks for posting this. We have implemented changes to how we add the Scheduler to dynamic user directory but haven't implemented it to other modules that requires the scheduler yet on the newer releases. DNN seems to be changing their scheduler quite constantly and it's often hard to keep up with their changes. They've recently added new columns "CreatedByUserID" and "FriendlyName" to their AddSchedule stored procedures so in older implementations, if you don't have values for these, it won't add in the newere DNN versions. -- David

Hi

I think this is the problem I'm having with IUI and DNN 5.2. Nothing appears in scheduler.

I will try running the script. Any plans for a fix though?

Gus

ok, I ran this script in and it added the job and run the import!


Phew, looks like we're good to go.

Gus