Developer forum

As I understand you, you wish to run some SQL after an import has completed - is that correct?

The way to do that is to create a custom destination provider that inherits from the provider you wish to use: so if you wish to import data to DW using the Dynamicweb provider (which is the one that allows you to import users) you do the following:
* inherit from the Dynamicweb provider
* override the RunJob() function
* in your Runjob() function, call the base RunJob() function, check that it returns True (that the job succeeded)
* if it does, you run your custom closing/cleanup code.

I have tried to create a custom destination provider inheriting from the Dynamicweb provider, as described above.

Setting up the job works fine, but when i try to edit the job, i get the following error. 

[NullReferenceException: Object reference not set to an instance of an object.]
   Dynamicweb.Admin.DoMapping.Page_Load(Object sender, EventArgs e) in E:\Program Files (x86)\Jenkins\jobs\Release DW841\workspace\Dynamicweb.Admin\Admin\Module\IntegrationV2\DoMapping.aspx.vb:275
   System.Web.UI.Control.OnLoad(EventArgs e) +92
   System.Web.UI.Control.LoadRecursive() +54
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +772

The code is as follow:

[AddInName("test.DataIntegration.Provider"), AddInLabel("test Dynamicweb DestinationProvider"), AddInDescription("test Dynamicweb DestinationProvider")]
    public class ExampleDestinationProvider1 : Dynamicweb.Data.Providers.DynamicwebProvider, IDestination
    {
        
        public override bool RunJob(Job job, string logFile)
        {
            if (base.RunJob(job, logFile))
            {
                //Clear storage

                return true;

            }
            return false;

        }
    }

Version: 8.4.1.2

Hi Thomas,

You have posted to a very old thread, and I only saw the post because someone else linked to it.

however, you can avoid the error by adding constructors as follows:

 public MyProvider()
        {
        }
        public MyProviderXmlNode xmlNode):base(xmlNode)
        {
           
        }

Regards, Jonas

Hi Jonas,

Thanks for your reply, I have already done that myself :-)

But I have discovered a new problem, when inheriting from the dynamicweb destination provider and adding extra custom settings the constructor throws an exception (Unexpected node), because the DynamicwebProvider constructors validates the settings in the Xmlnode.

Is there a solution for this?

/Thomas

Hi Thomas,

you will have to implement the constructor that takes an XMLnode as input, instead of calling through to the base class.

you can see the current implementation in the code for the DynamicwebProvider (in  Dynamicweb.Data.Providers.zip which can be downloaded under downloads->sourcecode) - then you will have to add the code for your custom settings.

Regards, Jonas