Use Row_Import server event to set value

PHPMaker General Discussion (PHPMaker)
1

I am developing a website dedicated to managing school students
I have two tables, the first one contains the ClassTable
and columns have id,class_name
The second table is the studant table and it has the following columns
id, student_name,class_id
And I tied the spool by
classtable.id=studant .class_idThe problem when importing students from an excel file does not include the names under the chosen class
Note that the excel file does not contain the class column name
I put the following codes in the student table

function Row_Import(&$row, $cnt)
{
    //Log($cnt); // Import record count
    //var_dump($row); // Import row
      
     ///  $r= unserialize( $_SESSION['variable_name']);// ew_ExecuteScalar("SELECT variable_name FROM global WHERE id = 1");
    //return false; // Return false to skip import
   //;
   $value=  print Profile("xxx");
   ///set classid manuale to import function
   $row["class_id"]=$value ;//$this->classid ;
    if (empty($row["m1"]) ) {$row["m1"]=0;}
    if (empty($row["m2"]) ) {$row["m2"]=0;}
    if (empty($row["m3"]) ) {$row["m3"]=0;}
    if (empty($row["m4"]) ) {$row["m4"]=0;}
    if (empty($row["m5"]) ) {$row["m5"]=0;}
    if (empty($row["m6"]) ) {$row["m6"]=0;}
    if (empty($row["m7"]) ) {$row["m7"]=0;}
    if (empty($row["m8"]) ) {$row["m8"]=0;}
    if (empty($row["m9"]) ) {$row["m9"]=0;}
    if (empty($row["m10"]) ) {$row["m10"]=0;}
    if (empty($row["m11"]) ) {$row["m11"]=0;}

    return true;
}

function Page_Importing($reader, &$options)
{
    //var_dump($reader); // Import data reader
    //var_dump($options); // Show all options for importing
    //return false; // Return false to skip import
    $options["offset"] = 1;  //to strat second row
     
      
    $options["headers"] = ["s_id", "studant_name","m1","m2","m3","m4","m5","m6","m7","m8","m9","m10","m11"]; //set header same the database
    return true;
}

function Page_Load()
{

CODE: SELECT ALL

//Log("Page Load");

$value = Get("fk_id"); ///save fk_id to profile

Profile("fkid", $value);



}

thank all

2

mohmmadmustafa wrote:

$value= print Profile(“xxx”);

Wrong syntax and not using the key you used (i.e. “fk_id”):

$value = Get(“fk_id”); ///save fk_id to profile

There is no such URL parameter when you import a file by API. (The parameter only exists on the server side when you load the List page.) You should get the value in another way, e.g. in Page_Load server event of the List page, if Get(“fk_id”) has value, you may save that in a session variable and clear that after importing in Page_Imported server event.

3

thank u for u answer, im try all that, put i will try again about session, mybe a forget something, but i fix this by creat custom file to do import