Import excel file with Page_Importing event
Posted: Fri Oct 07, 2022 12:14 am
Already when I use the code for phpmaker 2022 it works successfully:
// Page Importing event phpmaker2022
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["headers"] = ["Management","SectID","GENDER","School_name","SchoolID","stage","almada","alsaf",
"alfaqrat1","alfaqrat2","alfaqrat3","alfaqrat4","alfaqrat5","alfaqrat6",
"alfaqrat7","alfaqrat8","alfaqrat9","alfaqrat10","alfaqrat11","alfaqrat12",
"alfaqrat13","alfaqrat14","alfaqrat15",
"alfaqrat16","alfaqrat17","alfaqrat18","alfaqrat19","alfaqrat20","alfaqrat21",
"alfaqrat22","alfaqrat23","alfaqrat24","alfaqrat25","alfaqrat26","alfaqrat27",
"alfaqrat28","alfaqrat29","alfaqrat30",
"percentage","percentage1","number_students","week_id"
];
$options["offset"] = 12; // Skip the first 10th records
return TRUE;
}When using the phpmaker2023 code the import fails
I noticed there is a difference between codeine
phpmaker2023 :($builder, &$options)
phpmaker2022 :($reader, &$options)
// Page Importing event phpmaker2023
function Page_Importing($builder, &$options) {
//var_dump($builder); // Import data builder
//var_dump($options); // Show all options for importing
//return FALSE; // Return FALSE to skip import
$options["headers"] = ["Management","SectID","GENDER","School_name","SchoolID","stage","almada","alsaf",
"alfaqrat1","alfaqrat2","alfaqrat3","alfaqrat4","alfaqrat5","alfaqrat6",
"alfaqrat7","alfaqrat8","alfaqrat9","alfaqrat10","alfaqrat11","alfaqrat12",
"alfaqrat13","alfaqrat14","alfaqrat15",
"alfaqrat16","alfaqrat17","alfaqrat18","alfaqrat19","alfaqrat20","alfaqrat21",
"alfaqrat22","alfaqrat23","alfaqrat24","alfaqrat25","alfaqrat26","alfaqrat27",
"alfaqrat28","alfaqrat29","alfaqrat30",
"percentage","percentage1","number_students","week_id"
];
$options["offset"] = 12; // Skip the first 10th records
return TRUE;
}