Update new field on all Accounts with the Account Name

[MStritt]

I've created a new text field on my Account table called 'Account Friendly Name'. The default for this new field on all new Accounts created moving forward will be the actual value of the 'Account Name'. For all current Accounts, I need to update the Account Friendly Name with the current Account name. I'm assuming I would need to run a script of some sort, but don't have the ability to do that. Anyone provide sample code to use to update all current Accounts?

Account Friendly Name = u_account_friendly_name

Table / Account [customer_account]

Account Name = name 

Table / Company [core_company]

[Bert_c1]

Try the following in a script:

var dryRun = true;
var accountRec = new GlideRecord('customer_account');  // use correct table name
accountRec.query();
while (accountRec.next()) {
    var companyAccount = new GlideRecord('core_company')
    companyAccount.addQuery('name', accountRec.parent);
    companyAccount.query();
    if (companyAccount.next() {
        accountRec.u_account_friendly_name = companyAccount.name;
       gs.info('setting friendly name to ' + companyAccount.name + ' for ' + accountRec.name);
        if (!dryRun) 
            accountRec.update();
    }
}

provided the 'parent' field on core_company (by name) is the record in customer_account you want the value from.

[MStritt]

Can I add a line in the code that only updates maybe 10 Accounts? Just to make sure it works correctly?

[Bert_c1]

Yes, see updated code posted by @Amit Gujarathi. but add

accountRec.setLimit(10);

Just before

accountRec.query();

Then there is no need for the 'updateLimit' variable in the script.

[Amit Gujarathi]

HI @MStritt ,
I trust you are doing great.
Please find the sample script below :

var dryRun = true;  // Set to false to actually perform updates
var updateLimit = 10;  // Number of records to update
var updatedCount = 0;

var accountRec = new GlideRecord('customer_account');
accountRec.query();
while (accountRec.next() && updatedCount < updateLimit) {
    var companyAccount = new GlideRecord('core_company');
    companyAccount.addQuery('name', accountRec.parent);  // Assuming 'parent' is the correct field
    companyAccount.query();
    if (companyAccount.next()) {
        accountRec.u_account_friendly_name = companyAccount.name;
        gs.info('Setting friendly name to ' + companyAccount.name + ' for ' + accountRec.name);
        if (!dryRun) {
            accountRec.update();
            updatedCount++;
        }
    }
}

gs.info('Updated ' + updatedCount + ' records.');