Developer forum

lb wrote:

Hi

Where can i find the job definitions behind the integration modules ?

I cannot find them in the SQL Databasen nor in any folder.

In accessDB i have found a table called DBIntegration , but no such file exist in the SQL Database !

I need to change some filenames without loosing the entire field mapping ;o)

Also how can i execute a set of integrationjobs by command ?

/Lars

OK - I found the dbo.job, dbo.map and dbo.Target.File - not very documentry like names ;o)

Still lacks to find out how to execute a row of DBIntegrationjobs in one blow..

/Lars

vme wrote:

You can run Integration jobs by schedule. Go to Control Panel -> Scheduled Tasks -> New Task and select Object Type as "Integration job". This way you can add several tasks and your jobs will be executed one by one.

Hi

Thanx - I know that !

Two obstacles:

1: The Scheduler has NEVER been reliable. I've used for the past 12 months, and currently i'm experiencing that it only runs now and then.

I have been on helpdesk with that problem numerous times, but with no luck.

2:  I need to run 7-10 import jobs one by one and at the users request.

Therefore i need some way to execute any number of import jobs manually !

/Lars

vme wrote:

Well, you can run manually your DBIntegration job by calling this script:



http://your.server.dk/Admin/Public/DBInt_Import.aspx?JobID=1



Set your job's ID instead of 1 of course.

Hi again

Thanx again - i know that ;o)

But what i dont know is how to let the customer execute 5 jobs with ONE click !

Could i put the 5 lines into a javascript ?

/Lars

Sure, something like:

Run!

Remember that each request is queued and not handeled simultaneously, so you may reach connection timeout if it takes more than 90 seconds before step 5 is executed.

Or what about making it a bit sweeter by using Ajax and executing each step when readyState of previous step changes. And of cause, a nice little progress bar that is updated each time a step is done would be cool:)

Sorensen wrote:

Sure, something like:

 

Run!









 function init5Jobs(){

  document.frames["target"].document.location.href = "http://your.server.dk/Admin/Public/DBInt_Import.aspx?JobID=1";

  document.frames["target"].document.location.href = "http://your.server.dk/Admin/Public/DBInt_Import.aspx?JobID=2";

  document.frames["target"].document.location.href = "http://your.server.dk/Admin/Public/DBInt_Import.aspx?JobID=3";

  document.frames["target"].document.location.href = "http://your.server.dk/Admin/Public/DBInt_Import.aspx?JobID=4";

  document.frames["target"].document.location.href = "http://your.server.dk/Admin/Public/DBInt_Import.aspx?JobID=5";

 }

 

Remember that each request is queued and not handeled simultaneously, so you may reach connection timeout if it takes more than 90 seconds before step 5 is executed.

 

Or what about making it a bit sweeter by using Ajax and executing each step when readyState of previous step changes. And of cause, a nice little progress bar that is updated each time a step is done would be cool:)

Hi Lars

Thanx :o)

I tried it out, but it only seems to execute the very last job in line..

Any sugesstions ?

/Lars

Maybe the requests are not queued in IE after all. Never thought I would be wrong:)

Maybe the ajax approach is the way to go. I just made up the following code.

Just copy and paste it in to a new HTML file and replace strUrl with your site URL.

Click to run

 

 

PERFECTO - THANX !

I will return her with my experience when i have the thing running.

(Have +25 jobs that have to be grouped end execuded per group and all in one ;o))

Sorensen wrote:

Maybe the requests are not queued in IE after all. Never thought I would be wrong:)

 

Maybe the ajax approach is the way to go. I just made up the following code.

 

Just copy and paste it in to a new HTML file and replace strUrl with your site URL.

 

var curStep = 1

var maxStep = 5;

var strUrl = "http://your.server.dk/Admin/Public/DBInt_Import.aspx?JobID=";

function step() {

    req = (window.XMLHttpRequest)?new XMLHttpRequest():new ActiveXObject("Microsoft.XMLHTTP");

    req.open('GET', strUrl + curStep, true);

    req.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded');

    req.onreadystatechange = function (){

  if (req.readyState == 4){

   if (req.status == 200){

    curStep++;

    if (curStep <= maxStep){

     step();

    }

   }else{

    if (!confirm("Something went wrong executing step " + curStep + " - " + req.status + "\nContinue?")){

     return false;

    }else{

     curStep++;

     if (curStep <= maxStep){

      step();

     }

    }

   }

  } 

    }

    req.send("");

    progress();

   

}

function progress(){

 document.getElementById("bar").style.pixelWidth = 200/maxStep*curStep;

 document.getElementById("progress").innerHTML = "Now executing step " + curStep;

}













Click to run