Skip to Content
author's profile photo Former Member
0
Former Member

Mass change Account status

Posted on Sep 23, 2015 at 01:43 PM 281 Views

Hi everyone,

We replicated our accounts from CRM to C4C, but unfortunately, they all got created with the status In Preparation (lesson learned). We now want to change them all to Active, but the mass change capability does not support changing the status for the account object.

I tried setting up a workflow rule to Activate the account on every save, then performed a mass change on batches of accounts to update an unimportant field (Language). My thinking was that when the mass change updated every record, the workflow rule would be triggered and the record would be activated that way. Unfortunately, I think there might be a bug because while the mass update worked, the workflow rule only got triggered for one record in each of my batches.

Does anyone know of a way (other than SDK) that I can accomplish this? I find it hard to believe that SAP doesn't support mass changes of account status and that the only way to do it is to go into each and every record.

Thanks in advance!

Lisa

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Ginger Gatling
    Ginger Gatling
    Posted on Sep 23, 2015 at 02:54 PM
    3

    Hi Lisa

    Another colleague just shared this as well:

    She should be able to use the data migration tool for customer, and modify existing records. She’d need the Account ID in C4C and the status value.

    Download the customer data migration template, and fill in the necessary fields in the general tab, then use the Data Migration Tool, accessed via the Integrate and Extend tab of Open Activity List in BC.

    Go to “Migration of Customers”, and select “Migrate customers using the migration tool”. She would upload the Data from Migration tenant, and under Properties, she would select “Modify already existing records”.


    -ginger

    Add a comment
    10|10000 characters needed characters exceeded

    • Vaibhav Chaughule
      Apr 17, 2016 at 12:41 PM

      Hi Ginger,

      Thanks for the post.

      We have a similar query.

      We have a scenario, where we block prospects in day to day working.

      After a period of time we would like to unblock them at one go.

      If there any other way of changing the status of prospects/customers at the user level?

      Business users would not be having migration tool access.

      Regards,

      Vaibhav

    Comment on This Answer
  • author's profile photo Prashanth Rai
    Prashanth Rai
    Posted on Sep 23, 2015 at 02:20 PM
    0

    You could try mass modify using this article published - you could modify any objects in an excel consuming the webservice(In this case Account web service)

    http://scn.sap.com/community/business-bydesign/blog/2015/05/15/mass-changes-of-byd-data-using-excel-and-byd-web-services

    Another approach would be to write a small application(java/C#) to read data from an excel (should have the account list which needs to be updated)and consume the Account webservice to update the status.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Chandan Bankar
    Chandan Bankar
    Posted on Sep 23, 2015 at 03:55 PM
    0

    Hello Lisa,

    Even I will suggest you to go with the approach that Ginger gave using the Migration template. Just use the Modify already existing records option.

    Please note that this option ONLY those values which you will be inserting in the template with respect to the key field for the records would get modified.

    Regards,

    Chandan

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.