Hot answers tagged

3

It turns out that the "Search Primary Details Only" setting causes this problem (found under Administer-> Customize Data and Screens-> Search Preferences). It seems that if this setting is off, the listings and export will default to the address which was created earlier. See here for details: Contact Search Results Address Type This is a weird behaviour ...


3

How are you recording the enquiry? As an activity? If so, you could add a custom field "exported" (Yes/No field, default No), then search for exported=no, export, and update exported=yes. There are various problem scenarios you might want to think about: eg if an export is lost after you generate it (eg email bounces), do you need to be able to reproduce ...


3

The short answer is "Yes" but it's not as useful as you might think. First - consider a contact with 10 donations, 5 events attended, 3 memberships, etc. If you exported this all in one table, it would be hundreds of columns, with data flattened to the point of uselessness. On the other hand, if you export contacts in one table, donations in another, etc.,...


2

Typically, bots contacts/contributions will follow some standard method of populating information - e.g. a recent bot attack on one of our clients created contacts with "%phone_short%" listed as their main phone number, so using search builder in the GUI allowed me to identify all associated spam contacts and delete them permanently. If these spam contacts ...


2

This Log Export extension "logs to a files within the ConfigandLog directory whenever an export happens, who performed it what columns involved and the relevant entity IDs" There is a blog about it here


2

We use Civi & QuickBooks. Our QBs is only used for accounting. If we need to see donation details, we look in Civi. We do not record contribution detail in Quickbooks. We do not see a need to have that data stored in two places. We just record the deposit in QBs. We use Class in QB for our Functional Expense allocations (Program, Restricted, and ...


2

Ashok welcome to CiviCRM stackexchange If you new CiviCRM database has not gone live than i would Create a test instance of CRM 5.4.0 Upgrade CiviCRM to 5.15.2 Dump the Civi database after upgrade. Drop the Civi database or all civi table from CiviCRM database i.e linked to your new Wordpress. Import the CiviCRM database that was dumped at #3 Open CiviCRM ...


2

I wrote this little snippet of code in a larger extension, which will automatically append the postal code suffix to postal codes when exporting postal codes: /** * On export, append the postal_code_suffix to the postal_code. */ function tweaks_civicrm_export(&$exportTempTable, &$headerRows, &$sqlColumns, &$exportMode, &$componentTable,...


2

This was fixed in today's release (5.18.1)


1

The export issue is actually a confirmed bug, see https://lab.civicrm.org/dev/core/issues/464 I have had moderate success using hook_civicrm_export in a custom extension for a client where email location type is really important to their workflow.


1

There are a few things that can help you out: Most importantly, the API Explorer (Support menu » Developer » API Explorer). It will build your drush command for you through a GUI. You can see there that adding an option with "limit=0" will return all records. There's documentation built into the API explorer, but there's also API documentation in the ...


1

If you do a search of contacts exporting contacts will be one of the options in the action menu? So step by step: Navigate to Search>Find Contacts Click on the Search button (use one of the filters if required) Select all contacts (or just a few if you want to) If you click on the Actions box just under the selection you will see export contacts as one of ...


1

Without more information, it's hard to answer your question definitively. There are a number of ways to export contact data. However, the most common way is covered in the documentation under Exporting Your Contacts. There's much more detail there, but the general principle can be summed up in the first three steps: Search for contacts. Carry out a ...


1

You have discovered a bug in the Membership Details report. The first step in a situation like this is to see whether anyone else has reported the issue on the CiviCRM issue tracker. A link to the issue tracker is at the bottom of every CiviCRM screen. As of this posting, it doesn't look like anyone has created an issue, so you can write one up. You could ...


1

This is coming thanks to the work being done on the Form Builder https://civicrm.org/blog/josh/improvements-to-the-export-interface-are-in-the-works


1

Multi-value (also called multi-record) custom fields can't be exported by the normal export. See https://docs.civicrm.org/user/en/latest/organising-your-data/creating-custom-fields/#multiple-record-fieldsets. However you can get round this using a report then exporting as CSV. Two caveats. Not all reports will include the multiple values. Constituent detail ...


1

I think I have a method that solves 90% of what you're trying to accomplish. Firstly though, I think the reason that some nonprofits want to have the full information in quickbooks is (1) so they can pull P&L reports on specific programs, which can only be done with classed contributions (2) many organizations want to have the full data in quickbooks, ...


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