Menu
Welcome, Guest
Username: Password: Remember me

TOPIC: Update from Module"Countires" to Contacts (Accounts).

Update from Module"Countires" to Contacts (Accounts). 4 months 4 weeks ago #79457

  • Petrovlis
  • Petrovlis's Avatar
  • Offline
  • Premium Member
  • Posts: 153
  • Thank you received: 1
  • Karma: 0
I have a 254 records of all the countries in the world, with fields like Countryname,Currency, some 10 fields in total etc etc.

I make a link (in SQL) to my LOCAL SuiteCRM 7.4 with Contacts.BillingCountry = Countries.Countryname ( i do this with External ODBC in MSaccess)
and then "update to " etc.

It works for one/two (to be updated fields in Contacts) but, ONLY if I update per one Countryname ,as filter, to limit the update.

The Contact records are some 58.000 and that is apparently to ""Big To Handle""

Is there an other way to do this in a simple way ?

Thanks.
William.
The administrator has disabled public write access.

Update from Module"Countires" to Contacts (Accounts). 4 months 3 weeks ago #79468

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 10664
  • Thank you received: 1603
  • Karma: 363
Maybe if you share your SQL it's easier to understand what you're triyng to achieve...

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.
Time to create page: 0.059 seconds
Powered by Kunena Forum