Questions tagged [export]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
2answers
70 views

When exporting contacts using custom selected fields, results in “Undefined Index …Mapping.php Line 622”

When trying to export a list of Contacts selecting a previously defined set of Export Fields, system throws this error:"Notice: Undefined index: in /home/.../Core/BAO/Mapping.php on line 622" When ...
2
votes
1answer
61 views

Export Activities associated with CiviCase

We're currently discussing whether it's possible to use the activities recorded in a Case (including the scheduled activities in a timeline), export them into Excel and convert it into a Gantt chart, ...
2
votes
1answer
43 views

How do you display cross-contact searches?

I am trying to create a CSV using both Individual contact and Organisation contact information and I am having difficulty trying to achieve this. As it's most basic it is to print postal labels ...
2
votes
1answer
21 views

When exporting data from CheckBox field, can value of be different from what is displayed?

When exporting data from a custom CheckBox field, can the value of the data exported be different from what is displayed? For example, the checkbox Multiple choice is labeled "Asked" but I would ...
2
votes
1answer
73 views

How to Transfer Big Data to a Different Domain

I received a SQL error while updating CiviCRM. He asked me to restore the old database, but I didn't have a backup at the time. Therefore I could not make a healthy update. Then I applied all the ...
2
votes
0answers
28 views

Search primary details only, turned off - duplicate/additional case export lines

The additional feature to choose whether or not to search primary details only (introduced somewhere in Civi 4.7) has an undesirable effect on case exports - with the preference set to 'no'. As an ...
2
votes
2answers
80 views

Grant Export Custom field Cutoff

On a brand new Drupal 7 / CiviCRM 5.6.0 install I created a custom field group for Grants and added one Contact Reference field and then created 2 grants. When I search for grants and export and try ...
2
votes
0answers
35 views

Mailing labels with multiple relationships

Hoping for a little advice on the best way to address the following situation. We have individuals with relationships to organizations. Each individual can have multiple relationships to ...
2
votes
0answers
17 views

Slow exports when 'groups' field included - trying to debug

I'm having trouble with extremely slow exports when the 'groups' field is included, in 4.6.17. I tracked it down to the main export query, and taking out the irrelevant stuff it breaks down to: ...
2
votes
1answer
57 views

ACL setup to deny export rights

is there any way to set an ACL (or any other permission) that denies some groups the right to export contacts during Advanced Search, while still allowing the search to take place... I'm aware that I'...
2
votes
1answer
67 views

Fatal error when exporting accounting batch to CSV in 4.7

Using Civi 4.7.2 (and then on 4.7.3; I thought I needed to upgrade to fix) with Drupal, I get the following error when I try to export an accounting batch to CSV: Fatal error: Call to undefined ...
2
votes
0answers
54 views

How can I select soft credit fields when exporting contributions?

We just upgraded to CiviCRM 4.6.6 (under Joomla! 3.4.4, PHP Version 5.4.44, MySQL 5.6.23) from CiviCRM 4.5.2. The fields Soft Credit For and Soft Credit Amount no longer appear in the drop-down list ...
1
vote
2answers
114 views

How do you export a multi record set?

On CiviContact we have a number of custom fields set up as multi-record sets. Any ideas on how these can be exported? The import to a multi-record set is hidden on the main import page > tooltips pop ...
1
vote
1answer
105 views

Exporting Contacts to a .csv file

How do I export all contacts to a .csv file?
1
vote
2answers
261 views

Where is “Unique ID (OpenID)” and how is it used?

I am preparing to do an import of a lot of data, and I want to properly map my data into CiviCRM. This is primarily for event participants of various kinds, so I exported the basic participation data ...
1
vote
2answers
45 views

Can you include CiviCRM ID in exported fields?

Our administrator needs to export email addresses for households and individuals complete with CiviCRM ID so that an audit of imported data can be undertaken. However, CiviCRM ID isn't available in ...
1
vote
1answer
36 views

Extracting email address for the who database?

How do you extract email addresses from CiviCRM to go into an excel file? Thanks,
1
vote
2answers
85 views

Exporting Contacts - Reporting?

Is there a way to save different reports? ie. the fields wanted to export? so you don't have to enter those in every single time you do an export?
1
vote
1answer
37 views

New 'Contact Exported' and 'Activity Exported' activity

One of our clients has noticed that every time they export a contact (Adv Search or via a Report) an activity is created against each contact of type 'Contact Exported' with the date and the staff ...
1
vote
1answer
76 views

Export all contacts using SQL Query

I want to export all contacts with all field values through SQL. I'm not able to export from CiviCRM, it throwing 504 Gateway timeout error. What will be the SQL query?
1
vote
1answer
80 views

Exporting Drupal user account ID's through Civi search

I'm trying to export the Drupal User ID's for a particular Civi group, in preparation for GDPR and as a general clear out. I am able to search for all users in Civi which are a CMS user (and therefore ...
1
vote
1answer
51 views

Exporting group contacts to an excel file

How do I export a group to an excel file? Pretty standard. Wanting to export email as well as name, mailing address, city, postal code. Thank you, Shara Using Wordpress
1
vote
2answers
79 views

Exporting Contacts Results in DB Error

I am trying to export about 2000 contacts (exporting primary fields only) and when I click continue I get this error: Sorry but we are not able to provide this at the moment. DB Error: unknown ...
1
vote
3answers
64 views

How do I scrape an old website into a .CSV file for data migration?

I'm organizing my data to prep for CiviCrm. One of the data banks we have is an online directory listing of hundreds of names, contact information and bios. NONE of this is organized into a ...
1
vote
1answer
37 views

Current employer not exporting to CSV

I have tagged a group of contacts and am exporting them to a CSV file. When I do this, of the 30 contacts only about 25 show the current employer in the CSV file. I checked the remaining five and they ...
1
vote
1answer
44 views

is there a quick way to export the complete data from my database?

I am new to civicrm, just got a job with an organisation where this is the pre-existing database. I think the data in there is in a mess and I would like to export all data to excel / csv if possible ...
1
vote
1answer
36 views

How can I export contacts and tags, but only for a particular tag?

Is it possible to export contacts and related Tag information, but only for one particular Tag Set? Thanks.
1
vote
1answer
49 views

Export Gift Aid?

We have a gift aid tab as show on the attached image. I can search using the fields using the advanced search function but cannot export the data held in the gift aid fields. Is there a way I can do ...
1
vote
1answer
88 views

Transferring Data Out of CiviCRM

Some time ago we transferred data from CiviCRM to a different CRM (YourMembership). However, it has become apparent that we have not collected all of the data. We have the web version CiviCRM 4.6.21. ...
1
vote
1answer
105 views

How to export with state abbreviations

We are using Civi 4.7.27 on Wordpress 4.9 When doing exports the state is shown as the full name. We really need to be able to export with the 2 letter state abbreviation. How can we set it to do ...
1
vote
1answer
76 views

Exporting deduped information

I need to do a de-dupe on a set of records. Two groups were brought in with different External ID's for each contact. I need to merge the contacts, but export the External ID that was kept and the ...
1
vote
2answers
176 views

How can I export/import contribution pages and event pages from one site to another

I want to export contribution and event pages from one Drupal7 site to another Drupal7 site. Is this doable, any help greatly appreciated.
1
vote
1answer
150 views

On CiviCRM 4.7.7 Error Exporting

I've moved to a new server with a current version of PHP, have updated WordPress to 4.5.2 and updated CiviCRM to 4.7.7. I still get this error when exporting selected records from an Advanced Search: ...
1
vote
2answers
116 views

Exporting multi-record set data

Hi I am trying to export data held in a multi-record set. A end users would prefer to do this through the Civi interface rather than on the back-end database The multi-value import link is buried in ...
1
vote
1answer
36 views

Fatal error on Export in 5.18.1

I just updated to 5.18.1 to resolve a bug caused when selecting " Exclude contacts with "do not mail" privacy, no street address, or who are deceased." But now I have a new issue: I set up an export ...
1
vote
1answer
55 views

Can I export custom data from a Contact, an Organization and an Activity in one export?

I am trying to set up a custom field mapping to export after I search for Activities. I would like to export data associated with the Activity, but also include data from the Individual Contact and ...
1
vote
1answer
43 views

Getting errors when moving D7/CiviCRM install form localhost xampp portable to another location

I have xampp portable installed on Windows 10. I run about a dozen Drupal, Wordpress and other CMS on there. I can move the whole stack to different drives and machines and it all works perfectly, ...
1
vote
1answer
42 views

Can I see/export the total field mapping in use?

I inherited responsibility for this small non-profit's database. I would like to be able to view and print a list of ALL the fields in use.
1
vote
1answer
93 views

Error exporting activities: Unknown column 'activity_priority.label' in 'field list'

I upgraded a site last night from 4.7.13 to 4.7.27, and there's now an error when exporting activites. The error is: Unknown column 'activity_priority.label' in 'field list']"] I see where this part ...
1
vote
1answer
850 views

How do i export all the data in civicrm?

I need to export all data in the database, activities, relationships, contacts everything. Is there a way to export all data? There is more room for human error if i have to do it individually by ...
1
vote
1answer
39 views

Export tags to separate column?

When exporting information, is it possible to separate each contacts' various tags into separate columns? That way I'd be able to sort the resulting spreadsheet by specific tags, instead of having ...
1
vote
1answer
66 views

Exporting contacts merged to households causes DB error version 4.6.8

Viewed contacts from a Smart Group and went to Export. Merged to household and tried with and without do-not-mail/deceased criteria. Seems to work OK if I select a couple of fields, but if I do ...
1
vote
1answer
196 views

Problem Exporting Contacts

I'm running Civi 4.6.7 on Joomla 3.4.3 and I'm getting an unknown error anytime I try to export. Please see the link below for a video of the process and what I'm encountering. http://screencast.com/...
1
vote
1answer
193 views

Export activities and the activity target contact

I found an old thread on the forum site: - https://forum.civicrm.org/index.php?topic=20506.0 My question is still the same as DaveJ's actually. We want to export the activity target contact with the ...
1
vote
0answers
20 views

Export problems with civi 5.10

We have two sites, both D7.66 both civi 5.10 One wants to export activity data including target contact data from an activity search They have been using this process and mapping for several years ...
1
vote
0answers
31 views

Is there an easy way to export data from Drupal 7 to wordpress, non critical data, loosing data is fine

Is there a way to do a simple export/import as a CSV file from Drupal 7 to Wordpress? Data is not critical, if I get the bulk of it it's ok, I don't care. Drupal site has one single database shared ...
1
vote
0answers
18 views

Exporting spouses only exports one side of relationship

When I export a list of contacts and I include data about their spouse, the spouse data is included for only one of the contacts. Like so: Name Spouse Name City Sam Smith Linda ...
1
vote
0answers
12 views

Fields exporting out of order

There seems to be a problem with home fields exporting out of order as soon as the first a "Home" field is output. I noticed this on my site and replicated it on the demo site (Civi 4.7.29 on Drupal). ...
1
vote
1answer
83 views

Why are export field mappings not available for custom search results?

When using custom searches such as the Include/Exclude search, the resulting contacts can be exported, but there's no option given to select the fields. Fields to be included in the export file are ...
1
vote
0answers
28 views

Export doesn't work for households

I try to export contacts with the option "Merge Household Members into their Households". As export fields I choose Household → Head of Household is → displayname But in the export file, this field ...