Results 1 to 7 of 7

Thread: URGENT: Recover deleted campaigns

  1. #1
    srinivasreddy is offline Member
    Join Date
    Jun 2008
    Posts
    9

    Question URGENT: Recover deleted campaigns

    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.

  2. #2
    eNick is offline Sugar Community Member
    Join Date
    Apr 2008
    Location
    UK
    Posts
    282

    Default Re: URGENT: Recover deleted campaigns

    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?
    T H E S U G A R R E F I N E R Y
    : : : SugarCrm Customisation and Integration Services : : :

    SugarCRM Systems Integration Partner
    Trusted with SugarCRM
    http://www.theSugarRefinery.com ::: sales@{removethis}theSugarRefinery.com

  3. #3
    srinivasreddy is offline Member
    Join Date
    Jun 2008
    Posts
    9

    Default Re: URGENT: Recover deleted campaigns

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

  4. #4
    eNick is offline Sugar Community Member
    Join Date
    Apr 2008
    Location
    UK
    Posts
    282

    Default Re: URGENT: Recover deleted campaigns

    Quote Originally Posted by srinivasreddy
    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?
    T H E S U G A R R E F I N E R Y
    : : : SugarCrm Customisation and Integration Services : : :

    SugarCRM Systems Integration Partner
    Trusted with SugarCRM
    http://www.theSugarRefinery.com ::: sales@{removethis}theSugarRefinery.com

  5. #5
    srinivasreddy is offline Member
    Join Date
    Jun 2008
    Posts
    9

    Default Re: URGENT: Recover deleted campaigns

    Just in SugarCRM, not in Database...

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

  6. #6
    eNick is offline Sugar Community Member
    Join Date
    Apr 2008
    Location
    UK
    Posts
    282

    Default Re: URGENT: Recover deleted campaigns

    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!
    T H E S U G A R R E F I N E R Y
    : : : SugarCrm Customisation and Integration Services : : :

    SugarCRM Systems Integration Partner
    Trusted with SugarCRM
    http://www.theSugarRefinery.com ::: sales@{removethis}theSugarRefinery.com

  7. #7
    srinivasreddy is offline Member
    Join Date
    Jun 2008
    Posts
    9

    Default Re: URGENT: Recover deleted campaigns

    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..

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. HOW-TO guide for Email Campaigns.
    By agupta in forum Marketing/Campaign Management
    Replies: 146
    Last Post: 2012-01-31, 03:08 PM
  2. Campaigns feature requests and bug fixes for non-email campaigns
    By lurkerfilms in forum Feature Requests
    Replies: 2
    Last Post: 2008-08-16, 11:21 PM
  3. Replies: 4
    Last Post: 2006-10-10, 02:08 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •