URGENT: Recover deleted campaigns

[srinivasreddy]

Is there any way of recovering deleted campaigns?

Unfortunately over 2000 campaigns were deleted. How can I get them back? In campaign's table, I have just 34 records. But in campaign_log table, I have about 2000 records. Are these the deleted records? In this table, there are no modified_user_id and assigned_user_id fields. If this is the table I am looking for, How can I recover my campaigns?

Thanks in advance.

[eNick]

You have a backup, right?

The campaign and the campaign log table are different entities - you won't be able to rebuild one from the other.

Sugar normally soft-deletes stuff (ie. just sets the deleted flag to true) rather than physically purges stuff so it sounds like they "got deleted" by someone running a "delete from...." sql command?

However, are you sure 2,000 got deleted? It is normal for the campaign_log table to have more rows than the campaign table. The log table contains links between the campaigns and all the leads & opportunities etc generated by that campaign. How do you know you're missing some?

[srinivasreddy]

Not they are not deleted using any SQL command. Can I get all those deleted(soft) campaigns?

[eNick]

Not they are not deleted using any SQL command. Can I get all those deleted(soft) campaigns?

1) Ok, let's take a step back - what makes you think you've lost any?
2) Have you actually looked for them in the database? Or just in Sugar itself?

[srinivasreddy]

Just in SugarCRM, not in Database...

I haven't looked for data in database...

[eNick]

Well, you'll need to look for them in the database.

They should have "deleted=1" set against them and you can restore them by setting "deleted=0"

I'm still not clear on why you think you've lost them. It's got to be difficult to lose 2,000 campaigns!

[srinivasreddy]

I had another problem,

I was entered nearly 2000 contacts in the contacts section by logging through admin. I was created 4 users underneath it. All the contacts that are entered using admin login will be visible to all the users. From the last two days, i did not see any of the contacts in one of the user contacts. How to restore the 2000 contacts in to that user?

Thanking you in advance..