We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [export]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
2answers
221 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
44 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
32 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
80 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
86 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
55 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
42 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
59 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
62 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
36 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
29 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
48 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
72 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
82 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
158 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
137 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
101 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
54 views

Export participants with Membership data

If I'm right it used to be possible to export participants as csv with Membership data. But it is not there any more in 4.4 and 4.6. Is there a way how that could be done nowadays? We need ...
1
vote
1answer
45 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
28 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
39 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
68 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
616 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
36 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
41 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 ...
1
vote
1answer
64 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
184 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
177 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
1answer
26 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
47 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 ...
1
vote
0answers
18 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
29 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
11 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
67 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
27 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 ...
1
vote
0answers
16 views

CiviCRM is exporting disabled groups, how can I specify that I want enabled groups only?

I have done several exports with "Groups" as one of the fields. In each case, it exports both enabled and disabled groups. Is there any way to specify that I would like to see enabled groups only?
1
vote
0answers
58 views

How to export multiple relationships of contact

i am confusing how to show all relationship in the exported report, there's a example below. Company A have 3 representatives in the relationship field. and using following method to export. find ...
1
vote
0answers
25 views

Exporting Relationship “specifict job titles”

I need to export the "specific job title" field that is located in relationship. I cannot find that field in any of the export drop-downs, nor any field with a language that even sounds like what I ...
1
vote
0answers
43 views

Exposing custom field and custom option group to advanced search export

I have a custom field (tempField) and a custom option group (tempGroup) with options (1, 2 and 3) I want to expose these to the export form. For example, when you choose "Individual -> Phone" field ...
1
vote
0answers
50 views

Exported related contact info for contact sub-type

We've got a site (4.6.11) That has two organisation sub-types ("project" and "project event") there is a relationship between them (event of/ event is). On running a search of project events, and ...
1
vote
1answer
62 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 ...
1
vote
0answers
12 views

Is there a field limit that can be saved in an Export Members function

CiviCRM 4.7.0 and WP 4.4.1 - When doing an Export Members, selecting fields for export and selecting "Use Save Field Mapping" it won't save... unless we limit the number of fields. Can someone give ...
1
vote
0answers
51 views

Export Fails when Merge Households Option Used

I get a DB Error when exporting contact search results using the "Merge Household Members into their Households" option (image below). Only this merge option causes the error. The others do not. I ...
0
votes
2answers
107 views

Can I export full database and import it in a fresh newer CiviCRM version?

I am experiencing difficulties during CiviCRM upgrade from 4.7.14 to 4.7.31 or 5.1, namely, fields like contact.birth_date get broken. (More: DB Error after upgrading 4.7.x to 5.1 (Drupal)) I have ...
0
votes
1answer
36 views

How can I link contacts & activities in a report or export?

My client would like to report or export certain activities for contacts that meet a certain criteria. This doesn't seem possible, which is surprising. Activity search only allows a search of ...
0
votes
2answers
34 views

How do I export contact data records?

I am attempting to export to contact data records from the CiviCRM application. How do I export this information?
0
votes
2answers
29 views

Is there a way to reorder the fields in an export mapping?

I had a request to reorder the fields in an export mapping that had been created previously. Is there a way to do this via the UI? And if not, is it kosher to manually edit the column_number in the ...
0
votes
2answers
30 views

Where does Civi store membership and membership signup info?

We are moving to a new site, and when I tried to import our entire current Civi MySQL database to the new site, I had problems. So I have created a fresh database on the new site and want to try ...
0
votes
3answers
86 views

migrating civi database from current hosting to civihosting.com

We recently signed up for shared hosting at civihosting.com and want to move our current site there. Both sites are running CiviCRM 4.7.29 and WordPress 4.9.1. I cannot get into the CiviCRM ...