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
2
votes
1answer
9 views

How can I export a zip code with the suffix in the same field?

I send my addresses to a mailing house for a bulk magazine mailing. They require my zip+4 in one field. I can fix this in LibreOffice or Excel, but I have to be careful that my spreadsheet app doesn'...
0
votes
0answers
15 views

Extract All Records

I have uploaded over 75,000 records into the database. I am trying to extract all records into a file but it will not let me. Which report will give me every record in detail?
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 ...
2
votes
2answers
26 views

Error “Cannot unset string offsets” exporting using custom field mapping

I'm running civiCRM 5.17.5 under Joomla 3.9.12 When I select a specific smart group with a saved field mapping for export, and select "Exclude contacts with "do not mail" privacy, no street ...
3
votes
2answers
37 views

Exporting primary addresses exports non-primary addresses for some contacts

I'm exporting contacts with both home and billing addresses, where the home address is set as primary. Even though I've selected primary as the address type for all address fields in the export fields ...
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 ...
3
votes
1answer
25 views

Import/export database from old CRM version(5.4.0) to New CRM version(5.15.2) in wordrpess

Currently I am using Civi CRM (5.4.0) and want to upgrade it. I downloaded new version and installed it in my wordpress website. I had a separate database for CiviCRM. When I installed & ...
2
votes
1answer
98 views

Need help with export.php (CiviCRM 4.6 & Drupal 7)

I'm using an older version of CiviCRM (4.6) with Drupal 7 on Linux and until now I've not really used the command line stuff for CiviCRM, only for Drupal. But I now need to do exports & imports ...
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 ...
3
votes
0answers
19 views

Thank you letter export to Word - maintaining fonts

CiviCRM 5.7.6, WordPress 5 My client has a message template for thank-you letters (contribution) that utilizes Google Fonts. The fonts export and render perfectly in PDF, but do not work in the Word ...
2
votes
1answer
30 views

How can I export Contact Contribution and event data?

Our database was handled very roughly over last couple of years and tested features recklessly. Mixed events payments with contribution payments etc. Numerous price sets. Bot attack was also another ...
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 ...
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?
2
votes
1answer
34 views

“Post Code Suffix” in Reports is the same as “Postal Code”

I'm running CiviCRM 5.10.4 on top of Drupal 7.63 on Debian, with localisation. My contacts have UK-style postcodes with the first half (e.g. "M19") stored in "Postal Code" and the second (e.g. "3JD") ...
3
votes
2answers
52 views

Extracting a report/pulling a search result to CSV but setting an exported flag to indicate this

I am looking for a way to mark data as exported in some way. The scenario is that we are receiving and capturing data for enquirers (people making enquiries) on behalf of a third party. The 3rd ...
2
votes
0answers
26 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 ...
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
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 ...
0
votes
0answers
15 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 ...
2
votes
1answer
70 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 ...
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 ...
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
32 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
106 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
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
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.
0
votes
2answers
52 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
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). ...
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 ...
2
votes
1answer
67 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
110 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
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 ...
0
votes
2answers
27 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
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
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
3
votes
1answer
63 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 ...
4
votes
1answer
30 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
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 ...
2
votes
1answer
76 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
118 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
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
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
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?
0
votes
1answer
45 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
150 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
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 ...
2
votes
1answer
50 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/...