Batch Processing

Scriptcase 9 General
#1

I looked through the examples and I can’t find what I’m looking for. I need some kind of batch processing utility.

For instance: I want to read a file between one date and another, then depending on a field value, create a new record in another file.

Does this require code?

#2

Hello townsend:

What you are looking for is a conbination of PHP code and CRON tasks (if you use Linux) or Task Scheduler (if you use Windows). Remember that you can schedule a task to run a php code for example:

In windows Task Scheduler you program a task to be executed everyday at noon to run the following command

PHP.exe <Path to my applications>\MyApp\Myapp_apl.php

That will execute the code inside myapp_apl.php

Hope this helps…

Regards

#3

You can do it in several different ways (where is the file? you have to upload? are you on a control app? a form? a grid? and so on…

But the main idea is, on an event/button/blank application (again, it depends on your situation), you:
(I assume you are trying to read a CSV file)


$fichero=fopen("../kogestdata/PRODUCTO.csv", "r"); //open your file
$n = 1;
while($linea=fgetcsv($fichero, 0, ";", '"')){
// Taking the values from the file into vars
    $nombreProducto=$linea[7];
    $departamentoProducto=$linea[15];
    if($departamentoProducto=="")$departamentoProducto="null";
    else $departamentoProducto="'".$departamentoProducto."'";
    $codigoBarras="null";
    $refProducto=$linea[8];
    if($refProducto=="")$refProducto="null";
    else $refProducto="'".$refProducto."'";
    $stockTeorico=0;
    $iva=21;
    $guuid=$linea[0];
// Create a query string
    $query = "INSERT INTO tpvproducto(nombreProducto, departamentoProducto, codigoBarras, refProducto, stockTeorico, iva, guuid) VALUES ('" .$nombreProducto."',".$departamentoProducto.",".$codigoBarras.",".$refProducto.",".$stockTeorico.",".$iva.",'".$guuid."')";
   
    $n++;
// throw the query against the database   
    sc_exec_sql($query);
}    
// close the file
fclose($fichero);
#4

In addition to Giu’s answer, it might depend on the size of the file to process. If the file is too large then you might need to load the file in chunks to prevent running out of php runtime limits; or be able to set your php defaults.