Import Event - Replace or Append option

Hi,
PHPRunner adds new records from imported file if primary key values are not exist in the database and replace data for existing key values.

Hi Jane, Thanks for your reply.

However, often we have many records (eg. 10,000) in the table,

and if user need to do a clean upload, then he need to delete records

page by page first eg, 200 pages. This is a lot of work.
So what i meant was, if user selects a check box (eg. delete all before upload) at the import page,

1. then the script will execute "Delete from table_name where condition_in_before_process_event)
   
2. In before process event, we can put $strWhere = " client_id = ".$_SESSION["UserID"]
   
   so that other user's record will not be deleted;
   At the moment there is no option to add a checkbox on the import page thus we can't pre-process the event.
   Thanks for your consideration.
   acpan

Thank you for sharing your idea.

We'll add it to our suggestion list.