uploading leads to a wrong list id

[Op3r]

Somehow I manage to mess up my uploading a leads. I uploaded it to a different list id and now its incorporated on that list.

Any way to remove those on the database?

[mflorell]

do a delete or update based on the insertion date

[heinz]

How about updating the list_id via mysql?
The entry_date in vicidial_list should be the same on all the uploaded data.

Code: Select all

UPDATE vicidial_list SET list_id = XXX WHERE entry_date = 'XXXXXXXXXX';


If you need to delete just do the same

Code: Select all

DELETE FROM vicidial_list WHERE entry_date = 'XXXXXXXXXX';


Thanks,
heinz

[Op3r]

No the entry date is not the same so this is just what i did
cos when I tried this

select count(*) from vicidial_list where list_id="312" and entry_date="2009-03-04 04:55:59" ;

it only showed 100+ leads and the leads I uploaded is like 10k

the list id I messed up is 312
so I just deleted all the status "NEW"
The reason why i did this is, I can just re upload the leads on that list id and just do dup check.

delete from vicidial_list where list_id="312" and status="NEW";

but is this the right way?

or I should had just do
select count(*) from vicidial_list where list_id="312" and entry_date="2009-03-04" ;

Im still a n00b on mysql.

[heinz]

Hi

Code: Select all

delete from vicidial_list where list_id="312" and status="NEW";


should work.

you could do this also:

Code: Select all

DELETE FROM vicidial_list WHERE list_id =312 AND entry_date > 20090304;


This deletes all leads which you uploaded today into list_id 312