Questions tagged [import]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
25 views

Mass update / import bulk email preferences?

So - here is the deal - we have an excel sheet with hundreds of contacts - with which email they would like set as bulk mail. While doing an import, I see no option to indicate bulk mail preferences - ...
1
vote
2answers
70 views

Address formatting

I'm trying to find a way to change the address format in CiviCRM, to the Australian address format. I've had a good search but can only find this these from 5 years ago. https://civicrm.org/blog/...
1
vote
1answer
53 views

Import Contacts creating dupes despite dedupe rules

We are currently updating a member database with returning and new students/contacts. In the past we have been able to import lists updating the returning students, but now new duplicate records are ...
1
vote
1answer
74 views

Add contacts to group using CSV with contact e-mails

I'm looking for a way to add contacts to a group from a CSV file including e-mails of contacts already existing in Civi. When I import into Civi, I use the update option and select primary e-mail, and ...
1
vote
2answers
158 views

How do I use import and export php classes with aegir?

How do I use export.php and import.php to work with multiple sites run with Aegir. All of them share the same files (php classes) and when I specify the site with -s mysite.org I get nothing (...
1
vote
1answer
22 views

Pay Later status on imported contributions

I am trying to do a bulk import of transactions that are all being invoiced now. By indicating the Contribution Status as "Pending," the transactions all import as "Pending (Incomplete Transaction)" ...
1
vote
2answers
41 views

CiviCRM API V3 : Translate Two Digit State to State_Province_id?

I'm using civimigrate for a pretty intense migration into CiviCRM and I have hit something of a puzzler. I have a table with addresses that I am matching to contacts, but I cannot seem to find a way ...
1
vote
1answer
70 views

Import – match to contact by email without creating duplicate email address

Is it possible to use the import function for contacts and match by email, without creating duplicate email addresses for existing contacts? Example: We organize frequent webinars with participation ...
1
vote
1answer
55 views

How can I avoid my import crashing with a Fatal Error due to an existing external ID?

I've had a few separate imports crash with a fatal error in the last month: Sorry but we are not able to provide this at the moment. DB Error: already exists Fatal error: Uncaught ...
1
vote
1answer
62 views

Import participants with fee levels and price sets

Is there any information available on if it is possible to import event participants with price sets, and if so how? There is a field in the field matching that says "Fee Level" but I am not at all ...
1
vote
1answer
31 views

Batch edit one contact field (source) with same information

I have over 50,000 contacts that I would like to batch-edit with the same contact "source" information. What is the best way to do this?
1
vote
1answer
55 views

How do I get csv file of Gmail contacts to import?

I am trying to import a Google Apps Contacts list in csv file format. I go through the steps; it goes through the motions of importing the file, but no contacts are added. We're running CiviCrm 4.7.8. ...
1
vote
2answers
159 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
15 views

name “suffix” is missing from import mapping list

name "suffix" does not appear in the field names to be mapped. I have that data in my contacts.csv file but can't see how to map it.
1
vote
1answer
47 views

Import custom field to fill duplicate contacts

I am importing two custom fields and an email address (which is used to match up with the contact) I have 1000 rows and successfully imported 800. The error reason for the 200, was'record duplicates ...
1
vote
1answer
25 views

Problem with membership import

I completed a membership import. Online screen messages indicate that the import was successful, but none of the members appear on reports and contacts do not have membership relationship. What could ...
1
vote
1answer
58 views

Importing data with households

I've been attempting a data import for households and contacts on a new civi install, and cannot for the life of me figure out how to import the data and keep civi from creating duplicate records of ...
1
vote
1answer
43 views

What is the correct way to import fields with line breaks?

I've noticed that CSV files containing "\n" will import these characters literally. That makes sense for single-line text, but what is the correct way to handle for note fields?
1
vote
1answer
73 views

Meaningless error report when importing multi-value custom fields

I'm trying to import some multi-value custom field and I am getting what is clearly a badly formed error message. I've eliminated most of my errors by careful perusal of my import data and correcting ...
1
vote
1answer
36 views

Batch Update the current relationship in CiviCRM

I need your help. I need to disable a current relationship for 4000 records in the import process without using SQL command line. There is no field for set active/inactive or expiry date of the ...
1
vote
1answer
51 views

Problem Importing Contacts

I get the following errors while importing a contact CSV file. I hope somebody can help with the issue. Civicrm 5 latest with WP 5 latest and the error is same with both PHP 5 and 7.2. "Sorry, due to ...
1
vote
1answer
17 views

Contact Import Longitude missing in mapping

I am trying to import contacts from one CIVI database to another however when doing the field mapping there is a map for latitude but not one for longitude. Am I missing something, if not is there any ...
1
vote
1answer
53 views

Importing membership custom field keeps failing

I'm having problems importing memberships with a custom field. I'm able to import a alphanumeric text field without an error, but a second custom field, set up as a checkbox, keeps being rejected. ...
1
vote
1answer
33 views

Smarty causing contact import to fail

I have CiviCRM 4.6.28 on Drupal 7.56, hosted on Pantheon. We are trying to import lists of contacts, but anything above 250 contacts throws a timeout error, due to Pantheon's time limits. The time ...
1
vote
1answer
24 views

How can I easily import data from external sources like Stripe while dealing with subtle differences in field values?

Here's a specific example. When I export data from Stripe, there is a Status column with the value Paid. This obviously corresponds to CiviCRM's Contribution Status field. However, CiviCRM doesn't use ...
1
vote
1answer
62 views

Cannot get the import of employer-employee relationship to work

I have successfully imported all my organisations and I'm now trying to import my contacts which are employees of these organisations. I've read the relevant sections in the CiviCRM cookbook and the ...
1
vote
1answer
42 views

Import override for latitude and longitude

I'm in the process of importing latitude and longitude information for contacts. This process is straightforward but I don't see an option to upload an option to turn on 'Override automatic geocoding'...
1
vote
1answer
26 views

Importing Contributions - Email Receipt

When importing contributions I would like receipts to go to the contacts that made the payment. What is the best approach to make this happen?
1
vote
2answers
59 views

What should be entered in the campaign field when importing a CSV file?

I'm trying to import a CSV file with donations that need to be linked with a certain campaign. I tried putting the campaign name, then the external id, and even just "matching" but all of them are ...
1
vote
1answer
30 views

Importing without changing primary address

Is there a way to tell CiviCRM not to set newly-imported addresses as primary addresses? For example, let's say I have a database where everyone has nicely-curated "Home" addresses. I make a new ...
1
vote
1answer
29 views

Change log rollback not restricted to a single contact

Not so much a question as a development request... We manually add/edit records but also do a lot of importing into Civi. When some errors were found on a particular contact record we used the '...
1
vote
1answer
20 views

Could not load settings file at: 4.7.0 wordpress

I tried to load my contact to civicrm using the command line however was i tried to execute the import.php i received an error"could not load the settings file at: i tried to further investigate i ...
1
vote
2answers
65 views

Importing and updating pledges

I want to import a bulk pledges to my CiviCRM installation and also I need to updating the pledges in every month. If I do it in manual it is very time consuming process. is there any easy way like ...
1
vote
1answer
79 views

import contribution

I try to import contribution. Procedure - Contribution - import contribution - import the .csv list Error "is not a valid option for field campaign_id" Where do I find the campaign_id? thanks
1
vote
2answers
59 views

Why external ID removed in membership import in update mode?

During Membership import in update mode externalID available in civicrm 2.0 and it seems that it is being removed in CiviCRM 4.6.7. As I have a csv file to import membership with only externalID ...
1
vote
1answer
25 views

Bulk assign contribution page based on contribution type?

Issue: We migrated about 5000 contacts from one CRM to CiviCRM. The organization required historical data to be moved over, but also changed their membership pricing scheme which has been resolved ...
1
vote
1answer
43 views

Importing contributions with soft credits fails with spurious email error

I'm trying to import some contributions. Each contribution has a soft credit field which is an email address. I've set the field mapping to Soft Credit / Email / Solicited. All the rows are failing ...
1
vote
1answer
96 views

Contribution import fails for all records with error “No matching Contact found”

I successfully imported contributions from csv files, up to 4.6.3. Now when I try to import using the same saved mapping, in Joomla with 4.6.6, every record fails with the error No matching Contact ...
1
vote
1answer
60 views

Why after importing contact records were Addressee field values set to “Customized” for records where Custom Addressee had a null value?

I imported a large group of organisations into a sub-org group "Media". Some orgs had a specific generic addressee (ie, Editor) which I imported into the Custom Addressee field. After import I ...
1
vote
1answer
16 views

What might cause an Contact Import to only import core data and not import custom data

Asking this mostly so I can answer it in case it helps others. I had been provided a csv that was doing as described in title ie it had both custom and core fields in it, and the core date eg First, ...
1
vote
0answers
24 views

unexpected 500 errors and networks errors

We have a standalone install of CiviCRM Spark, version 5.16.beta1. This is hosted with civicrm.org. We have imported our contacts, which total about three or four hundred. We are, however, unable to ...
1
vote
0answers
18 views

PHP Date format not available in CiviCRM

I'm hoping someone can help me with a date problem. I'm importing contacts from my Drupal 7 build and our member's birth dates are not showing up. The short custom code as per the php manual is m/d/Y ...
1
vote
1answer
16 views

Problem importing Civi Volunteer Needs

We are working importing Volunteer Needs for various Volunteer Projects via the API csv Extension. When we load the interface, select the entity 'VolunteerNeed' and select file. When we hit continue ...
1
vote
0answers
27 views

DB error: no such table while importing

When importing, we get this error: /wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(192): CRM_Core_Error::backtrace() #1 /wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/...
1
vote
1answer
51 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
31 views

how to import/Export data from old version to updated version of CiviCRM

recently I have updated my CiviCRM Plugin in Wordpress.Now how can I import/export data of the old version to the new version?
1
vote
0answers
38 views

Monthly payments not updating for monthly direct debit

We have a number of members who pay in monthly instalments by direct debit, but recently the contribution page and the membership end date have not been updating. We have received the reports showing ...
1
vote
0answers
23 views

Participant Import: Mandatory key(s) missing from params array: line_total

I am currently trying to import a number of participants that registered through an external service. I first imported all the contacts - then proceeded to import particpants The current fields I ...
1
vote
0answers
25 views

Transaction integrity error during contact import

I've been importing contacts all day without problems then suddenly I started receiving this error: PHP Fatal error: Uncaught CRM_Core_Exception: [0: Transaction integrity error: Expected to find ...
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 ...