Questions tagged [export]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
1answer
110 views

Import and Export failing and returning no error message

I recently moved my CiviCRM install from a local in-house server to a cloud server hosted by Siteground. Everything is working beautifully except for the import and export. My database is around 60,...
1
vote
1answer
151 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
87 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?
2
votes
1answer
97 views

Exporting Notes for Contacts Resulting in Incomplete Notes

So I'm new to using CiviCRM and I'm having some difficulty exporting my contacts properly. More specifically, I am unable to export all of the notes from a few of the contacts. I have been using the ...
3
votes
1answer
61 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'...
4
votes
1answer
77 views

Exports in 4.7.6 are not working correctly

If I do any type of search and then try to export my search results, the export CSV only contains one record. Even if the search finds hundreds of records, and I tell the export to export them all, I ...
6
votes
1answer
86 views

Contacts export only contains one entry

In CiviCRM 4.7.5 and 4.7.6 (tested in both) we have a problem exporting event participants. If you 'find participants' > search results screen > select all records, and then click 'export ...
1
vote
0answers
56 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 ...
7
votes
1answer
142 views

Help: Fatal error doing an export (Civi 4.7.4)

I have just upgraded my Drupal 6 site to the latest CiviCRM 4.7.4 All seemed to go well except that when I try to export contact records (using primary fields). I get the following fatal error: ...
0
votes
1answer
53 views

Exporting custom profile questions

Is there a way to export custom profile questions? Either as a event report or just in general?
6
votes
3answers
221 views

Connecting Civicrm to Quickbooks classes / subclasses

I have three organizations that use Quickbooks and some other process to track contributions. I would like to encourage all of them to move to Civicrm. (They are currently using out-of-date MS ...
0
votes
1answer
60 views

Exporting multiple choice fields

Does anyone know how to export a multiple choice field into a spreadsheet in a way that filters each response into a different column? For example, a field has options: apple banana pineapple A ...
1
vote
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 ...
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
52 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 ...
1
vote
1answer
53 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 ...
5
votes
2answers
1k views

Get CSV via REST?

Is there a way to get CSV-formatted output via a REST call? We have a 3rd-party app that can import data periodically from a URL pointing to a CSV file, so the aim is to provide it with a Civi URL (...
1
vote
2answers
119 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 ...
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 ...
5
votes
1answer
139 views

Exported custom date fields formatted incorrectly

The error seems to occur during the export process and affects only custom date fields, not those that are built-in. My custom date field is set to use "mm/dd/yyyy", and stores correctly in the sql ...
3
votes
2answers
81 views

Can I report data from a disabled custom field or option?

I'd like to disable some custom field fields, because we no longer want users to enter that data. But then I can no longer see the field in report filters. Is there another way I can get that data out ...
1
vote
2answers
118 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 ...
2
votes
1answer
63 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, ...
3
votes
1answer
63 views

exporting data with custom field nantionality exports country id instead of country name

I have a custom field nationality and after upgrading to Civi 4.6.9, i noticed that when i export contacts with custom field nationality, first entry has the name but the rest are the country ids, see ...
1
vote
1answer
46 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
61 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
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 ...
3
votes
3answers
127 views

Export Checksum

Is it possible to export a checksum? This is an essential step to using a range of external services - alternate bulk email(Mail Chimp), QR code creation for name tags, etc. But checksum does not ...
3
votes
2answers
95 views

Export contact info from MailChimp

I just tried to export all my contact info from MailChimp. Basically, it worked and I am now the happy owner of a pretty CSV file... but all the data is saved in only one column, one row per contact. ...
3
votes
2answers
33 views

How to deactivate “update this field mapping” for users?

I would like the users to have only permissions for saving a new export mapping, and not updating the existing ones. Where can I modify this permissions? Thank you!
0
votes
1answer
43 views

Is it possible to view multiple payments on a registration as separate Contributions?

I need to export data regularly for the bookkeeping end of our operations, and when there are participants have have multiple payments on their event registration, their payments show up as follows (...
2
votes
0answers
55 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
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
203 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
201 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 ...
4
votes
1answer
37 views

Is there a way to search/export potential duplicates?

I'm about to run dedupe (Contacts > Find and Merge Duplicate Contacts) and I was wondering if there is a way to put all potential duplicates from a certain rule into a group so I could export them as ...
4
votes
2answers
102 views

How can I change what data gets exported using the Accounting Batches feature?

I want to use the accounting batch feature to group together and export transactions data so that I can them import that data into my accounting system (Xero). But Xero has a strictly defined ...
3
votes
1answer
25 views

participant status doesn't export

I just upgraded to Civi 4.6.3 yesterday. I'm running it on Drupal 7. I tried to export some participant records today, including the participant status. Everything exported fine except the participant ...
0
votes
1answer
24 views

Exporting related contact's information on a contact that is a subtype

We have a relationship type that is designated between a "Student" subtype of Individual and a "School" subtype of Organization ("Student of/Student is"). When we do a search for Students and try to ...
3
votes
1answer
70 views

How to export website field for a contact where website is specific website type?

I select some contacts for export. In my field mappings, I add Website but it does not give me the option to choose a specific website type. Is there any way to do this?

1 2
3