Hot answers tagged

7

Do a search that finds all contacts (for example, Find Contacts and then search without entering anything), then select "All nnn contacts" and choose Export from the drop down menu. You can select all primary fields or specific fields to export.


4

The latest version of the GDPR extension does this. It records when contacts have been exported for audit purposes.


3

An alternative method for quick copies is this: Press the Export button. Save the resulting JSON text to a file. Copy the file to the new server. Go to Support menu » Developer » API Explorer v3. Select an Entity of FormProcessorInstance and an Action of Import. In parameters, set Specification File to the absolute file path (on disk) to the JSON file. ...


2

If you have something like a file with a blank line at the top that might get output before the export data and cause the output to be interpreted as http content-type text instead of a download. Check civicrm.settings.php or extensions or files in the CMS that might have changed. You could also try running this from the root folder of your CMS: find . -type ...


1

One way would be to use the quick search or any other search and simply enter "%" as a search criteria. This would bring up all contacts in the database and you could export them afterwards. If you want to include deleted contacts use the advanced search with the same criteria but tick the box "Search in Trash (deleted contacts)". In the ...


1

If you have a very simple d7 front end with minimum common modules than it won't be difficult to upgrade from d7 >> d8 >> d9. To Upgrade Civi i would do incremental upgrade i.e 4.6 > 4.7(latest) 4.7 > 5.8(latest) 5.8 > 5.22(latest) 5.22 > 5.37(latest) Would upgrade Civi first than drupal.


1

If you add the Summary Fields extension then you can choose to have a field for 'total amount', total this financial year, count this financial year, etc etc, which then makes exporting much easier as it is 'just' another custom field https://civicrm.org/extensions/summary-fields https://civicrm.org/extensions/joinerys-more-summary-fields https://civicrm....


1

In addition to CiviReport, the SQL Tasks extension can handle this.


1

Civireports can send a file automatically so set up a CiviReport with the filter of your choice, then under the "Access" tab, you can enter an email to send the report to. From there, check out Scheduled Jobs to configure the report to send the .csv file at whatever interval you wish (pete with appreciation to Justin for writing most of the answer)


1

You could start with API Explorer v4: Set the Entity to CustomGroup and Action to get. In the Chain section, set Entity to CustomField and Action to get. The next box should autopopulate to {where: [[custom_group_id, =, $id]]} Basic example From there, you can limit the fields returned both for the CustomGroup and the CustomFields and maybe sort them. ...


1

The more general issue about state has come up before, e.g. https://lab.civicrm.org/dev/core/-/issues/724 and https://lab.civicrm.org/dev/core/-/issues/1709. It's not a full solution but you can manually update the abbreviations in the database in the civicrm_state_province table, but you'd have to change the column size in the table definition, and someday ...


1

Thanks to @samuelsolv for his answer to Export contact info from MailChimp Apparently, the separator for import/export of csv files is a "localization" setting, at this path: /civicrm/admin/setting/localization?reset=1


1

Welcome to CiviCRM Stack Exchange Michael ^^ In the upper left corner of the Advanced search you will find a dropdown field called "Display Results As". If you select memberships the search will yield a list of memberships instead of contacts. You should then be able to select "Export Members" from the action menu and include all ...


1

You can achieve this using Drupal + views, and can include all the necessary fields of the contact. From Civi you can use Civi reports and download them as csv using reset=1&output=csv&force=1 in url. Could also use getrows for reporttemplate entity rest api You may need to check with user permission on both the options. HTH Pradeep


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