Hot answers tagged

7

If you using CiviMail for sending newsletter than you can view the html snippet that was sent as a email body. To view the html you can go navigate to Mailings >> Scheduled and Send Mailing. Find the mailing/newsletter name you want to convert into PDF and then click on report link besides the name. You will be redirected to CiviMail Report: [Name of ...


6

Hmm, I export this all the time. Maybe it isn't named what you think it's named. It's called "Internal Contact ID" in the pull down menu. If you don't find this what version of Civi are you using?


6

Line 435 in CRM/Export/BAO/Export.php that your error message is referring to says: if (!empty(self::defaultReturnProperty($exportMode))) { This will give an error in all PHP versions below 5.5. From the PHP manual (http://php.net/manual/en/function.empty.php): Prior to PHP 5.5, empty() only supports variables; anything else will result in a parse ...


6

Yes, Date fields in export do not respect Date formats set in Localization >> Date Formats. Can you try Format Date Column in Export extension? This extension allows to set Export Date format under Localization >> Date Formats and uses this to format the date fields while exporting.


5

I don't know of any hidden export pages, but if you can talk the data into appearing in a report then you can export as CSV from there. We've created a few custom reports to allow this on our multi-record custom data.


5

This is a bug and will be updated in the next release. In the meantime, you can use this PR to fix. Further info on Jira.


5

If you mean exporting after doing eg a Search or Advanced Search, then on the screen where you select which fields to export, you can check a box to save that common set of fields for future exports (see image below). Then, the next time you go to do an export you can select to "Use Saved Field Mapping" and select the previously saved set of fields.


5

OpenID was designed to provided a universal login to all your online accounts. You can read more about it at http://openid.net/get-an-openid/what-is-openid/ . It was created in 2005 around the same time as CiviCRM and I think the standalone version of CiviCRM would let you sign in using OpenID. There are modules/plugins that will let people sign into your ...


5

Yes, it is now possible. I didn't hear from Kboy so I wrote an extension myself: https://github.com/progressivetech/net.ourpowerbase.exportpermission


5

Do you mean to export all the contact's email address from CiviCRM into csv file? If so you can do Find Contacts and export the result into csv format. Navigate CiviCRM >> Search >> Find Contacts Select list of contacts to export and from action dropdown select 'Export Contacts' options. On export screen select 'Select fields for export' and proceed On '...


4

Based on your description, I think the export format might be controlled by the "Complete Date and Time" and "Complete Date" settings at Administer > Localization > Date Formats. The default values for those fields are: Complete Date and Time - %B %E%f, %Y %l:%M %P Complete Date - %B %E%f, %Y The help text on that screen reads: Use this screen to ...


4

Have you tried Reports > Contact Reports > Relationships? The contact IDs of both Contacts A and B are concatenated with the name in parenthesis, and you also have the option to add the contact ID for Contact A as a column as well as other fields you might need. Hope this helps, Tamar


4

You can do a search (of any kind) and the resulting screen will have an Actions select menu. Select any or all of your contacts and then you can select the Export Contacts in the Actions menu. See https://docs.civicrm.org/user/en/4.6/common-workflows/exporting-your-contacts/ You can also run any number of reports and save the result as a CSV.


4

The User Guide has instructions and screenshots here for exporting contacts: https://docs.civicrm.org/user/en/latest/common-workflows/exporting-your-contacts/ Search for the contacts and select the Export Contacts action from the drop-down list.


4

We needed to do something similar, though not GDPR related. Because the Export does not access the Drupal user fields, we created a simple View (page display) to give us this data, based on CiviCRM Contact. We also used the Views Export Data module and 'attached' the csv to the Page above. Note the page is not required, you can simply use the csv display ...


4

Aivars, If the problem you facing is something related to report then i would suggest to fix the report rather wasting time exporting-importing data/structure from 2 different instances. The problem you facing has nothing to do with db structure. The error in report might be Any installed extension might be conflicting with report code, so you can probably ...


3

You might consider using css to hide the fields not in used, in this case you can still have them available for reporting,


3

Please try Constituent Summary report where you can set the filters to select all the "UK Tax Payer? is equal to yes" This will give you all the list and you have an option of exporting to CSV or PDF


3

I agree with Pete that there's no way to do what's being requested currently out of the box. I'd probably take a different approach though, and change this at the form layer. I'd make an extension that checked permissions, then removed the applicable "update this mapping" checkbox using hook_civicrm_buildForm.


3

There is no way afaik to do this currently. You might need to make an extension that adds field to the civicrm_mapping table that would then permit you to create a Permission that you can then apply.


3

The same thing happens to us. I just create an issue and proposed a patch as a provisional workaround. https://issues.civicrm.org/jira/browse/CRM-17822 [Edited] Seems that the issue is fixed for 4.6.12 version.


3

Yes we can import data directly to sage but using custom format I did take a copy of CSV.php file and created a custom_export.php and then did the changes But you can also directly change CSV.php file and do the required changes - In most case sage file will need only minimum fields like which can do by altering the SQL Type - Account Ref - Nominal - ...


3

When I tried in the demo site, I did an Advanced Search->Display Results as Activities and filter by the field you want and search. If you export the result and check either Export primary fields or Select fields for export, in the csv created will be the contact and activity information. You will see Activities in the lasts columns. If you tried that and ...


3

Yes, you can export tags for contacts with a particular tag. It doesn't seem you can export just one particular tag, but you could easily do this as a post-process once you've exported to CSV. Checked on http://dmaster.demo.civicrm.org/ - Search => Advanced Search "Basic Criteria" group => Tags => Volunteer Submit "Search" Click "All 61 Records" Select "...


3

You might want to check out this recording of a CiviCon session? https://www.youtube.com/watch?v=6K3awPdA7h0. Not sure if it will answer all your questions but I am sure it will give you a good idea :-)


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.,...


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 ...


2

Perhaps a slightly less cumbersome approach might be to create smart groups for the participants in each event for which you want to pull this information (that might be a useful thing to have in any case - for example, if you need to email your participants), and then run a membership report or search for contacts by event participant group. You might even ...


2

I have a website type called Twitter Website, for storing Twitter "handles". Each website/handle contains 'twitter.com' (i.e., like www.twitter.com/joemcl ) So using Search -> Search Builder, I search for Contacts Website Like %twitter% , then select all search results, select Actions, then Add Contacts to a Group (or better perhaps, choose New Smart Group)...


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