Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [export]

The tag has no usage guidance.

0
votes
1answer
13 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 ...
1
vote
1answer
20 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
27 views

Extracting email address for the who database?

How do you extract email addresses from CiviCRM to go into an excel file? Thanks,
0
votes
2answers
47 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 ...
1
vote
1answer
36 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
28 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.
0
votes
2answers
28 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.
1
vote
0answers
10 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). ...
0
votes
2answers
17 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
53 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 ...
1
vote
1answer
43 views

How to change date format in exports

I am using Civi 4.7.29 on Wordpress 4.9.1 When exporting the membership list for postal mailing, the expiration date is shown as YYYY-MM-DD. I would really like it to be MM-DD-YYYY. To export I ...
3
votes
1answer
70 views

Is it possible to export a newsletter to PDF

I have a newsletter that I have sent out to our contacts. I would like to export or save it as a PDF to post on our blog. I tried to copy the the HTML code into the blog, but the tables were not blog ...
1
vote
1answer
45 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
58 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 ...
0
votes
2answers
21 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?
1
vote
1answer
42 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
27 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
0
votes
0answers
13 views

Exporting Participant data is missing information in the Fee Level column

I'm trying to export a list of Participants for an event, and want their Fee Level included so I can see everything they've signed up for. When I search using CiviCRM (such as the "Find Participants" ...
0
votes
0answers
13 views

Adding “Export to CSV” to a table generated in an extension

Is there a known good method of adding the ability of exporting to csv a table generated by a custom extension? Ideally I'd want to stay away from wiring in datatables js and use civicrm's native ...
3
votes
1answer
47 views

Using Export Contacts from Search Builder w/ Field Mapping, mapped field's columns not exported

Website is running 4.7.25 over Drupal. I was able to replicate this on this demo site, which is running at version 4.7.28, as well: http://dmaster.demo.civicrm.org/civicrm Here are the steps to ...
3
votes
1answer
26 views

How to prevent selecting the wrong file format?

When you close an accounting batch, you are asked if you want the exported file in IIF or CSV. We export to CSV every time since we don't use Quickbooks. Just now, however, our office manager ...
1
vote
2answers
28 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 ...
0
votes
0answers
19 views

Image url wont display in export

I have an event and i have included field for contact image upload. I have also created a custom field for file upload and both work and can see the image in admin manage events. My issue is when we ...
2
votes
0answers
47 views

Multi-value Custom fields not showing up for export

I have created custom fields for individuals. When I am trying to export data, those which are single value custom fields, I am able to export. While Multi-value Custom fields are not showing up for ...
3
votes
1answer
58 views

How do I export my contacts as a .csv or .txt file?

How do I export my contacts as a .csv or .txt file? I need this for my records and can not find where I can do this. Please help. Thankyou.
1
vote
1answer
50 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
21 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
1answer
296 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
0answers
13 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?
0
votes
1answer
30 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.
2
votes
1answer
109 views

Getting data automatically from CiviCRM to Google Spreadsheets?

Is there an easy (semi-)automatic way to get data from CiviCRM to Google Spreadsheets? Data on CiviCRM side could come from search results (smart group) or a report. On Google Spreadsheets side I ...
1
vote
0answers
40 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 ...
3
votes
1answer
43 views

Problem exporting due to multiple addresses of one location type (e.g. two 'home' addresses)

I have run into a problem where someone created a Webform using Webform_CiviCRM and for some reason added two address field sets to the contact, with the street address in one of them and the city/...
1
vote
1answer
29 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 ...
2
votes
2answers
302 views

Export all data

How do you export all data, for example, all data for organization records, or for person/individual records? I want to compare data from a database we just moved to Civi and make sure data came thru ...
1
vote
0answers
23 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 ...
0
votes
1answer
44 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 ...
3
votes
1answer
59 views

How to get the WordPress Username in a contacts or membership export

Is it possible to include the WordPress username in the export of contact & membership details? We would like to include it in a mailmerge for new members who joined by post. Thanks Steve
0
votes
1answer
25 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. ...
5
votes
3answers
59 views

CiviCRM Raw Data Files

We use CiviCRM for our nonprofit, and we're trying to figure out how we can export our raw data in order to upload it into some custom apps. Any help would be very much appreciated! Cheers, Jillian
1
vote
1answer
18 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.
0
votes
1answer
12 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 ...
3
votes
2answers
86 views

is there any way to restrict data export?

Is there any way to restrict data export while still allowing users to see all data? I still want to give this permission 'View ANY CONTACT in the CiviCRM database, export contact info and perform ...
2
votes
0answers
27 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 ...
1
vote
3answers
59 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 ...
3
votes
1answer
36 views

Why the change in how Soft Credit information in exports?

After recording contributions in Civi, I always export those contributions. All soft credit information used to be included with the primary "Hard Contribution" data, but now (perhaps as of 4.7?) you ...
0
votes
1answer
31 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 ...
2
votes
2answers
96 views

Exporting relationships

I have an individual who receives from one to many honors. The honors are listed and an organization. I created a relationship and have loaded the relationship. If I look at relationships in the ...
1
vote
1answer
75 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
142 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.