Great Ideas. Always Flowing.

We are not happy until you are happy. Client satisfaction guaranteed. Whatever your needs and requirements, we have the skills and resources for the job!

Quick login...


Or... now make it easy with Facebook Integration
Connect via Facebook



Top Sellers

Frustrated over the lack of customization for your user's registration fields? Dynamically setup your DNN Portal with custom registration fields, layout, questions, and other core integration options......

Ultra Video Gallery is a brother product of Ultra Media Gallery, UVG allows you to upload videos in various format and automatically encode them to flv or H264 format, you also can add videos from internet or record live videos from your webcam.

Build high performance, completely customizable data-entry forms and views driven by your DNN and external databases. New built-in tools make it a snap to quickly create data entry forms, data views, and even database tables. Plus, add your own HTML, CSS, Javascript, SQL commands, stored procedures,

The most advanced DotNetNuke shopping cart on the planet. Easy to use e-Commerce, Secure Shopping Cart Software and SEO friendly. B2C / B2B Ecommerce Sites.

One stop solution for events calendar and events registration! FREE DOWNLOAD is available now!

Import job not showing up in Scheduler
Last Post 04-01-2010 07:28 AM by David To. 9 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
pixelPeteUser is Offline
skipping stones
skipping stones
Posts:9
Avatar

--
10-27-2009 08:21 PM

    Hi,
    Just installed the Interactive import module and went through the setup steps.  Configured my first import job: steps 1-5 all seem ok. 

    The import preview displayed the correct records but the Scheduler has not received the job.  There is no trace of it in the history or in the currently scheduled tasks. 

    Any suggestions on where to look for the solution?

    Peter

    pixelPeteUser is Offline
    skipping stones
    skipping stones
    Posts:9
    Avatar

    --
    10-28-2009 04:17 AM

    UPDATE

    1. Have tried re-installing - no effect.
    2. Have tried your www.betasprings.com beta site - file uploads fine and records are created correctly (according to the emailed report)
    3. Have tried to limit the import to just 4 fields with five records on my server - still fails to start the scheduler . . .
    4. Is there something I have to do to get the scheduler notification working i.e. is there something I have not installed?
    David ToUser is Offline
    river guide
    river guide
    Posts:2719
    Avatar

    --
    10-28-2009 07:05 AM
    HI, what version of DNN and IUI are you running? Did you enable logging in your import step? Also, go to Host / Schedule, find the UserImport scheduler, click on "History" and see what is in the log. Any errors or messages? You might need to kick-start the scheduler by editing it and just changing the time and it will kick in right away. -- David
    pixelPeteUser is Offline
    skipping stones
    skipping stones
    Posts:9
    Avatar

    --
    10-28-2009 11:19 AM

    Hi David,
    I am using DNN 5.1.4 and your latest install (I just bought the 30 modules) so it is DataSprings_InteractiveUserImport_PA 02.00.10.

    The thing is that there is no InteractiveImport task in the DNN Scheduler - that is the problem.  The tasks that are running are:

    DotNetNuke.Entities.Users.PurgeUsersOnline, DOTNETNUKE
    DotNetNuke.Services.Log.SiteLog.PurgeSiteLog, DOTNETNUKE
    DotNetNuke.Services.Scheduling.PurgeScheduleHistory, DOTNETNUKE
    DotNetNuke.Services.Log.EventLog.PurgeLogBuffer, DOTNETNUKE
    DotNetNuke.Services.Log.EventLog.SendLogNotifications, DOTNETNUKE
    DotNetNuke.Services.Search.SearchEngineScheduler, DOTNETNUKE
    DotNetNuke.Services.Cache.PurgeCache, DOTNETNUKE
    DotNetNuke.Modules.Forum.StartEmailQueuedTasks, DotNetNuke.Modules.Forum
    DotNetNuke.Modules.Forum.CleanupEmailQueuedTasks, DotNetNuke.Modules.Forum
    Hyper.Modules.EventsCalendar.SendReminder, EventsCalendar
    DotNetNuke.Modules.Events.EventNotification, DotNetNuke.Modules.Events
    OnyakTech.Axon.ProcessSMTPJobs,OnyakTech.Axon
    OnyakTech.Axon.ProcessPOPJobs,OnyakTech.Axon
    OnyakTech.Axon.ProcessThreads,OnyakTech.Axon
    DataSprings.Modules.RecentPages.RecentPagesPurge,DataSprings.Modules.RecentPages
    DataSprings.DNN.RoleReminder.RoleReminderSchedulerClient,DataSprings.DNN.RoleReminder

    I also installed a number of your other modules and two of them started scheduler tasks but not Interactive Import. 

    Yes I did enable logging.

    Peter

    pixelPeteUser is Offline
    skipping stones
    skipping stones
    Posts:9
    Avatar

    --
    10-28-2009 09:21 PM

    Hi David,
    I've worked around the issue.  It is an installation fault. 

    1. I did a bulk install of your modules by FTPing them to the Install/Module folder and then using the Install Available Modules option.  As you know, error reporting using this methodology is pretty poor in DNN.
    2. In an effort to get things working, I deinstalled the InteractiveImport and used the Install Extension Wizard which then helpfully reported the following two errors:
      • Info  Start Sql execution: 01.00.00.SqlDataProvider file
        Warning 
          
        SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Procedure or function 'AddSchedule' expects parameter '@CreatedByUserID', which was not supplied. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) . . . . and;
      • Info    Start Sql execution: 02.00.00.SqlDataProvider file
        Warning 
          
        SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Procedure or function 'AddSchedule' expects parameter '@CreatedByUserID', which was not supplied. . .
    3. Knowing the "ADD SCHEDULER" routine had failed, I then created a new Interactive User Import process manually in Host/Schedule by nominating the Full Class Name and Assembly as "DataSprings.DNN.Modules.UserImport.UserImportProcess,DataSprings.DNN.Modules.UserImport"
      with an object dependency of "DataSprings_UserImport " (as described elsewhere in these forums http://www.datasprings.com/Products...fault.aspx )

    All seems to be fine now, I have my users in and that was the primary object. 

    FINAL QUESTION
    Is there something wrong with your installation procedure that caused the errors noted in 2 above or is there something fundamentally wrong with my installation?  Please let me know as I am now moving on to other DataSprings modules and I'd rather avoid the hassles I've just been through!

    Cheers,
    Peter

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

    --
    10-29-2009 07:24 AM
    HI, problem is that DNN 5.0 and higher added a new column called "CreatedbyUserID" and cannot accept null values. We didn't realize this under after the release of IUI. So you can edit the last sqldataprovider file and add the following code at the end to error trap for this:

    -- ADD DNN SCHEDULER ITEM

    if not exists (select TypeFullName from {objectQualifier}schedule where TypeFullName = 'DataSprings.DNN.Modules.UserImport.UserImportProcess, DataSprings.DNN.Modules.UserImport')
    if exists (select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = '{objectQualifier}Schedule' and COLUMN_NAME = 'CreatedByUserID')
    execute {objectQualifier}AddSchedule 'DataSprings.DNN.Modules.UserImport.UserImportProcess, DataSprings.DNN.Modules.UserImport',60,'m',30,'m',250,'',1,1,'DataSprings_UserImport', NULL,1
    else
    execute {objectQualifier}AddSchedule 'DataSprings.DNN.Modules.UserImport.UserImportProcess, DataSprings.DNN.Modules.UserImport',60,'m',30,'m',250,'',1,1,'DataSprings_UserImport', NULL
    GO

    -- David
    Tareq MahmudUser is Offline
    wading in the water
    wading in the water
    Posts:20
    Avatar

    --
    11-29-2009 03:57 AM

    I am having the same problem. Instead of telling us what to change can you please put up a new build. I did add the script as you mentioned it still does not work. I am using DNN 5.1.4

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

    --
    12-10-2009 07:04 AM
    HI Tareq, sorry for the late response but can you email us using the "Contact Us" and reference this forum and I'll send you the install with the modified sqldataprovider that will check for DNN 5.1 and higher, etc. Thanks. -- David
    Oliver CrowUser is Offline
    skipping stones
    skipping stones
    Posts:5
    Avatar

    --
    03-31-2010 02:39 PM

     

    I had this problem installing Interactive User Import v2.00.10 on DNN 5.2.3. 
     


    Just for reference, here are the install error messages that I got trying to install Interactive User Import v2.00.10 on DNN 5.2.3 without this fix:

    Warning SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Procedure or function 'dnn_AddSchedule' expects parameter '@CreatedByUserID', which was not supplied.
    ... at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) -- ADD DNN SCHEDULER ITEM execute dnn_AddSchedule 'DataSprings.DNN.Modules.UserImport.UserImportProcess, DataSprings.DNN.Modules.UserImport',45,'m',60,'m',250,'',0,1,'DataSprings_UserImport', NULL

    Info Start Sql execution: 02.00.00.SqlDataProvider file
    Warning SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Procedure or function 'dnn_AddSchedule' expects parameter '@CreatedByUserID', which was not supplied.
    ... at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) -- ADD DNN SCHEDULER ITEM execute dnn_AddSchedule 'DataSprings.DNN.Modules.UserImport.UserImportProcess, DataSprings.DNN.Modules.UserImport',1,'m',30,'m',250,'',1,1,'DataSprings_UserImport', NULL
    Info End Sql execution: 02.00.00.SqlDataProvider file


    For the solution to this problem see also this post:

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

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

    --
    04-01-2010 07:28 AM
    HI, all our modules work fine with the latest versions of DNN. The problem is only when a module requires the service of the Scheduler. We always use the "AddSchedule" stored procedure which is a DNN stored procedure. However, by the time we release our product (let's say IUI 2.0) and DNN was still in version 5.0, then the "AddSchedule" will work fine because DNN 5.0 didn't have the extra column @CreateByUserID. So anyone using older versions of DNN, the install will add the scheduler but if they upgrade their DNN and install, it will error out. By the time we fix the install to support DNN 5.1 for example, DNN 5.2 may come out and they add another column called @FriendlyName and the install will error out for this version.

    For the moment, we are chasing our tails trying to keep up with all the versions of DNN out there and even in our test environment, we may not have the latest DNN version and not be aware of certain changes. But this only effects the "AddSchedule" routine since we are using their stored procedure.

    But the module itself still works for higher DNN versions onward. This usually only effects modules that uses a scheduler routine and is using the DNN stored procedure which they sometimes change going forward. But when a customer encounters this, we do help out and post on the forum how to add the schedule manually or run the SQL "AddSchedule" routine with the updated column item.

    Going forward, we are considering using code within the VB.NET itself as opposed to using the DNN "AddSchedule" routine to prevent this trouble from happening. But this only started happening in DNN 5.0 and higher when they started adding new column fields. -- David
    You are not authorized to post a reply.


     
     

    Join our mailing list...

    Get current news and events the easy way
     
     
       
    Subscribe Me

    Recent Blogs...

     
    Copyright 2005 - 2011 by Data Springs, Inc.
     
  • 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