Questions tagged [export]
The export tag has no usage guidance.
138
questions
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
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 ...
1
vote
0answers
18 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
73 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
45 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
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 ...
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 ...
0
votes
2answers
153 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
38 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
1answer
23 views
Advice for moving from Access to CiviCRM
Our client has asked us to move them from a legacy MS Access based membership system to CiviCRM (on Drupal). Their existing system encompasses many years of memberships, accounts, academic records etc....
0
votes
1answer
49 views
Data too long for column breaks export
The error is e.g.
Data too long for column 'custom_194' at row 1
Our values are 1 character so we set the DB Field Length to 1. However, this makes exports of this same field fail. It is exporting ...
0
votes
2answers
42 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
32 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
65 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
102 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 ...
0
votes
1answer
14 views
How about prioritized locations in export
When sending mass mailings the recipient's email address locations may be handled prioritized if authors want to: Use location x and if contact doesn't hold such an address use main address.
It would ...
0
votes
2answers
27 views
How to export contact list that includes total contributions to date?
I can only either export my contacts, or contributions. Is there a way to export an amalgamated list of contacts including all contributions made by each contact, either that year/per year/within date ...
0
votes
1answer
13 views
Why does my CSV export use semi-colons?
A simple search and then use the export option from the drop down generates me a csv file that isn't - i.e. it's a semi-colon separated values file, not commas. There doesn't seem to be any setting ...
0
votes
1answer
22 views
How to export member type after an advanced search
I am doing an advanced search in our database.
Members Current - Primary
and a proximity search for these members to be within 100kms of a postal code.
my problem:
when I go to export my results I ...
0
votes
1answer
18 views
Exporting data (users) into another location?
is there a way to automatically export a file (with contacts information) outside of the CiviCRM installation to another location?
I'm using CiviCRM on Drupal and before looking at Drupal's side, I'm ...
0
votes
1answer
47 views
Moving all contacts from CiviCRM to Kepla
my organisation is currently switching from CiviCRM to Kepla. I'm wondering about the best way to export all contacts information out of Civi and import it into Kepla. I have been able to export ...
0
votes
2answers
33 views
Export to csv/xls with a template
I have a customer who is an old-aged volunteer and is not so familiar to spreadsheets but still needs to use them until the whole database is imported and I want to make the export from CiviCRM easier ...
0
votes
1answer
54 views
Export all data for Contact
i'm new on civicrm and try to export specific contacts. I found the search menu to select the data and i made an export with " Export PRIMARY contact fields" but some fields are not in the export. How ...
0
votes
2answers
90 views
How to export civievent participant list to a csv file?
How can I add the ability to export to a csv file? Right now the only export option on the actions menu is to a Microsoft Excel file.
0
votes
2answers
35 views
How can I export an Event Income Detail report to CSV/Excel?
We find the Event Income Detail report to be useful. But the Actions menu won't let me export this report into a CSV file for some reason.
How can that be enabled?
0
votes
1answer
63 views
I need to export or copy CiviCRM structures such as membership types, contribution pages and price sets to another website (Joomla)
I am rebuilding a Joomla website with a corrupt database. I would like to recreate the CiviCRM structures in the new website. That would include membership types, price sets and contribution pages.
0
votes
1answer
31 views
Report containing groups and the key contact details for that group
I want to export a list of our groups along with their key contact details. The group entry does not have an address/postcode/email etc linked to it - those details are linked to the key contact.
...
0
votes
1answer
51 views
Missing actions dropdown
I am trying to export a list from CiviCRM and I seem to be missing the actions drop-down. I have used this field before, but it has dissappeared. I have attached an image of what my screen currently ...
0
votes
1answer
51 views
Exporting custom profile questions
Is there a way to export custom profile questions? Either as a event report or just in general?
0
votes
1answer
59 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 ...
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 (...
0
votes
1answer
23 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 ...
0
votes
1answer
31 views
Unable to map fields when exporting to CSV
We are unable to map fields when exporting to CSV. Using Primary Field export gets us the standard csv, but when option to select fields for mapping is checked, seems to go into a loop (see attached ...
0
votes
1answer
75 views
How to export 'employee of' relationship that has multiple staff members?
As a disclaimer, I've read up on this thread: How to export all children of a family?. However, that doesn't seem to solve my problem. Here's my dilemma.
I'm looking to export contacts from our ...
