ConcourseSuite Support

Support
Corporate
PUBLIC PROFILE

Back to topics

Discuss Data Import and Export

Undo Imports & unable to delete

You need to be logged in to post messages

Undo Imports & unable to delete

11/1/2005 4:28 AM EST

I have imported a number of contacts into centric. After that I found out that the search functionality does not provide a means to search through the notes (of an account), and since my imported data was having my selection criteria in the notes field, I now cannot retrieve them.

I have seen that I can view the results of the import, unfortunately there I cannot delete or modify the imported contact.

Finally, even when I go through all my contacts one by one on the contacts search view, I cannot delete them anymore - they simply do not vanish.

Any idea how to proceed from here?

Thanks
Boris

1. 11/1/2005 5:42 AM EST

After closing the browser (new session) I can manually delete the contacts.

However I choose to access the database directly and deleted the contacts from there. You will have to delete the referenced table entries first before you can delete the contacts themselves. For later reference, here is what I did:

connect to postgresql, login etc... then execute the following commands (replace the query criteria by the criteria of your choice):

delete from contact_address where contact_address.contact_id in
(
select contact_address.contact_id from contact_address, contact
where contact_address.contact_id = contact.contact_id
and contact.notes like '%bubu%'
)
;

delete from contact_emailaddress where contact_emailaddress.contact_id in
(
select contact_emailaddress.contact_id from contact_emailaddress, contact
where contact_emailaddress.contact_id = contact.contact_id
and contact.notes like '%bubu%'
)
;

delete from contact_phone where contact_phone.contact_id in
(
select contact_phone.contact_id from contact_phone, contact
where contact_phone.contact_id = contact.contact_id
and contact.notes like '%bubu%'
)
;

-- finally delete the contacts after we have deleted all references entries
delete from contact where contact.notes like '%bubu%';

Cheers
Boris

1 result found