How to Mass Edit / Delete records after Import ?

nitin27902

Hello,

I just ran an import into EPESI. I just realized that I mapped one of the fields wrongly. As a result, the data in that field was not covered in the import.
What is the suggested solution to Mass Edit all these records ?

I tried running the import again to overwrite these values with the corrected mapping, but, it just resulted in creating duplicate records in the Database.

If we can't Mass Edit, how may I Mass Delete the records I just created ?
Maybe I can delete all the new records created, and re-run the import ?

Thanks a lot for all your help.

Best Regards,
Nitin Jain

ajb

The best solution is to make a backup before importing any data... Now to make a persistent delete of the records you have to play with the database or use code below in EpesiShell (/admin/ -> Run php command).

I can't guarantee that this method will not make any harm. If any user added any type of record (meeting, task), that involve one of records that are going to be deleted, then your EPESI installation will be broken.



        $rs = new RBO_RecordsetAccessor('contact');

        $records = $rs->get_records(array('>:Created_on' => '2013-05-12 0:00:00'));

        foreach ($records as $r) {

            $rs->delete_record($r->id, true);

        }

Of course adjust recordset and created_on date.

Regards,
Adam

nitin27902

Thanks a lot, Adam. I have seen some mass-update and mass-delete tools with other CRM solutions, and I was just checking if we had something similar here.

No issues, though. I'll see what I can do.

Thanks & Regards,
Nitin Jain

Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge