Undoing imports

[Deland01]

Does anyone know if it's possable to Undo an import after you have left the import screen?

I did x2 imports yesterday & need to undo them both. I know there is a users_last_import tabe & its full of data but wasnt sure if there was a way of removing all the data.

I cant just drop the Leads table as I have other leads in there with calls & meeting attached.

Any suggestions?

[pblag]

Hi!

As rule the tables for modules have fields date_entered and date_modified so you can delete all records from tables

so you can use sql script like this

delete from leads where date_entered >= '2007-05-28 14:40:27'

where '2007-05-28 14:40:27' is date and time of first import

please make a backup of database before doing this.

Hope it will help you!

[Deland01]

It certainly does,

I ended up adding another column to Sugar in studio called "Date Created" on the list view page. Sorted all the leads by "Date Created" & then deleted them. Then I did a search for all the leads with a "0" in the "deleted" column in phpmyadmin, sorted this column so all the deleted records were together & removed them from SQL. Same in the leads_cstm table.

I got there in the end but it took me 4 hours to remove all 4000 leads.

I think your way should speed this up x10 fold, so thanks very much.

[Deland01]

How would I exacute the command you wrote? Am I right in thinking I need to open up DOS & do the following:

sugardevuser2 is my DB username

 
mysql -u sugardevuser2 -p 
Enter password: --Type the DB password here--
 
mysql> delete from leads where date_entered >= '2007-05-28 14:40:27'

When I hit enter all what happens is I get another line with an arrow underneath and the command doesnt really do anything:

mysql -u sugardevuser2 -p 
Enter password: --Type the DB password here--
 
mysql> delete from leads where date_entered >= '2007-06-06 09:38:18
  ->