Skip to main content
OverflowAI is here! AI power for your Stack Overflow for Teams knowledge community. Learn more
3 votes

In a data export how can I only include the country name if not the local country?

You can use Smarty in Search kit using 'Rewrite text' and use the below snippet {if [address_primary.country_id] neq 1228} [address_primary.country_id:label] {/if} The above code will not display ...
Pradeep Nayak's user avatar
1 vote

Contact Export Failure on Multiple Contacts

So in the DB itself the table "civicrm_uf_match", the "id" & "uf_id" contained different numbers Example: id = 3 uf_id = 7 I matched the numbers to be the same and ...
Juggy69's user avatar
  • 81
1 vote
Accepted

Anyway to export all data for import into a local instance?

You can use the CiviCRM Configuration Loader extension which will export / import a good deal of entities including contact types, relationship types, activity types, custom fields, campaign types, ...
Andy Burns's user avatar
  • 3,681
1 vote

Database error when exporting Activities: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535

You will need to convert all the CiviCRM tables to utf8mb4 or as a workaround convert civicrm_contact table to utf8mb4 by running below query. ALTER TABLE civicrm_contact CHARACTER SET utf8mb4 COLLATE ...
Pradeep Nayak's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible