Menu

SuietASSURED Banner

Save

Save

Welcome, Guest
Username: Password: Remember me

TOPIC: Replace a field in Contacts " Company C " ... with the Account Name in Accounts

Replace a field in Contacts " Company C " ... with the Account Name in Accounts 4 days 16 hours ago #58002

  • Petrovlis
  • Petrovlis's Avatar
  • Offline
  • Premium Member
  • Posts: 123
  • Thank you received: 1
  • Karma: 0
I created in Contacts a field called companyC, and i like to fill this field with the Account Name in Accounts.

There are some 1500 to do and manually it takes too long. (Copy and Paste), what I do now, workin fine but takes too much time.

Can it be done in Suite CRM ?? and if not ,maybe in MySQL Front, but here i am not familiar how to create a SQL query with select Account
and select field in Contacts.Replace...

I have MySQL Front as as very complex sql writer, but i am a newbie here.

Thanks for any help
William
Last Edit: 4 days 16 hours ago by Petrovlis.
The administrator has disabled public write access.

Replace a field in Contacts " Company C " ... with the Account Name in Accounts 4 days 14 hours ago #58005

  • Petrovlis
  • Petrovlis's Avatar
  • Offline
  • Premium Member
  • Posts: 123
  • Thank you received: 1
  • Karma: 0
Petrovlis/William again:

I created this in MySQLFront editor,, as a beginning...


SELECT
`accounts`.`name`
FROM
`accounts`
INNER JOIN `accounts_contacts`
ON `accounts`.`id` = `accounts_contacts`.`account_id`
INNER JOIN `contacts_cstm` ON `accounts_contacts`.`contact_id` =
`contacts_cstm`.`id_c`
WHERE
`contacts_cstm`.`companyc_c` = " "


NOW i have to add the REPLACE something like replace/updatecompany_c with Account.Name ,

but HOW ???

Thanks for any help.
William
The administrator has disabled public write access.
Time to create page: 0.040 seconds
Powered by Kunena Forum