Mass delete contact by report - error

Hi Sugar Club, 

I would like to mass delete contacts from a distribution list in Market, using the Mass delete contact by report functionality (from the Admin dashboard).

However, even if the operation is completed, no contact is removed from either the report or the distribution list.

I receive an automatic email with this error 'ContactId does not exist in report', despite the fact that I have checked several times that the ID actually exists in the report.

What am I doing wrong? How can I achieve the mass delete contacts goal?

Thank you very much in advance.

Kind regards,

Morena 

  • Hi Morena.  Sorry that you're experiencing this.  If you haven't already, would you please put in a support ticket so we can follow our typical issue remediation process?  We would be happy to look at this issue for you.  Thanks, John

  • Hello Morena,

    Please make sure you included the ContactID field in the report, rather than the ID field. Here's the difference:

    -The ContactID field is the field used by Sugar Market to distinguish records. It will always be unique and it's why it's used in functions like Mass Delete.

    -The ID field is used to store the ID of the Lead/Contact in whichever CRM is integrated with Sugar Market. 

    The similarity in field names can be confusing.

    If this isn't the issue, then please do submit a support case as John suggested and we'll be happy to look into it for you. Please include the name or report ID of the report in question. 

    Thanks and best regards,

    Lynn Catterson
    SugarCRM Support

    **Please note the new URL for Sugar Market Login:
    https://market.sugarapps.com/

    Announcement on Sugar Club:
    sugarclub.sugarcrm.com/.../sugar-market-urls-are-being-updated

  • Hi John and Lynn, 

    thank you both for your feedback. 

    I have checked the fields included in my report and I can confirm that I used the ContactID one, and not just the ID one.

    However, as per your suggestion I submitted a support case and Support helped my undestand the issue: the Display Name column had to be changed to ContactId (which is also case sensitive).

    By changing this detail I was able to massively delete eads.

    In case it might be helpful for someone else, I found very useful this guide: https://support.sugarcrm.com/Documentation/Market/Sugar_Market_User_Guide/Reporting/Creating_Auto_Deletion_Reports/#Creating_the_Reports 

    Thank you and best regards,

    Morena Montrone