I am looking for “After Insert Record” event on import page for any table similar to “After Record Added” on Add page or “After Record Updated” on Edit page.
Because, I have to import a large volume of records into table and I am planning to use excel import function in PHPR project. It’s really awesome feature built in PHPR. Let me explain why I am in crucially need.
I have a table “STATE” where fields are (sid (INT), state_name (Varcher), country_name (varchar) and country_id (INT)). sid is as PK and country_id as FK from country. I want to import a large set of state’s name with corresponding country_name from a excel file where both PK and FK fields are left empty. I created mysql trigger to populate FK id from COUNTRY table after insert based on the country_name field data. I also created a mysql stored procedure which will delete country_name data automatically after insert completed. I don’t need country_name in STATE table anymore while FK is there.
I can call my mysql stored procedure from After Record Added/After Record Updated events from both Add and Edit pages but I cannot call similarly from Import Page due to absence of After Insert Record event in import page.
Please help me. And I suggest including this feature into the next version. It would be really helpful.