Stack Exchange Network

Stack Exchange network consists of 175 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 [import]

The tag has no usage guidance.

1
vote
2answers
155 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
14 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
41 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
24 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
52 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
19 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
38 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
16 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
50 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
31 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
51 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
39 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
25 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
50 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
44 views

Bulk re assigment of relationships

If you have a large number of contacts managed by one 'volunteer rep' as a relationship, when that rep leaves then there is a lot of cumbersome manual data entry. I have looked and I can't find any ...
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
2answers
39 views

Upload CSV zipcode

When attempting to upload a CSV file containing zip codes with a leading zero the leading zero is dropped when attempting to save the file for import. How do I keep a leading zero in a CSV import file?...
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
61 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
76 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
57 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
23 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
42 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
93 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
57 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
17 views

What causes this error on importing email addresses?

I'm getting some (maybe 5%) email address imports rejected with the message "Matching this contact based on the de-dupe rule would cause an external ID conflict" The email addresses in question can be ...
1
vote
0answers
34 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
18 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
22 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 ...
1
vote
0answers
16 views

No import for existing contact

When doing an import for existing contact that I want to update, after selecting Fill (For Duplicate Contacts), I get a Warning, a Notice but no import : Warning: array_pop() expects parameter ...
1
vote
1answer
23 views

OCR for Photo IDs?

I would like to set up an instance of CiviCRM to help independent candidates register to run for office in Indonesia, and one requirement here (like many other countries) is that a candidate has to ...
1
vote
0answers
63 views

Error importing contacts - for key 'UI_external_identifier'

I am having an issue when trying import contacts into civi. We have imported many contacts before but all of the suddden I am getting this error: Database Error Code: Duplicate entry '0385611' for ...
1
vote
0answers
33 views

Add source to all contacts when importing a CSV File

Question in German Wir möchten eine CSV Datei mit Kontakten einer Gruppe hinzufügen. Dies ging auch mühelos.Das einzige das nicht funktioniert hat war diese neue Adressen die Bezugsquelle hinzu zu ...
1
vote
1answer
655 views

Can you share an example of a complex .CSV file for import?

I'm looking for structure information on complex .CSV files that have custom fields, relationships, groups. I'd like to get a better sense of best practices for organizing data ahead of time. If you ...
1
vote
0answers
31 views

importing contacts

I am trying to import 714 contacts to the system. I am able to do it but before the final DONE click it shows 445 total number of rows in the imported date and 1251 total number of contact records or ...
1
vote
0answers
45 views

CiviCRM Member Import Tool Issue

We are attempting a CiviCRM Member import for a client on CiviCRM 4.6.12. The import starts to run but then fails saying no memberships were created. Nothing is logged to the CiviCRM log file. The ....
1
vote
0answers
71 views

Country custom field import error

I have a custom field called "Nationality" of data type "Country". It doesn't accept any kind imported values. I tried with "United States" and "US", it doesn't give an error but it doesn't import ...
1
vote
0answers
39 views

How to import existing membership records

I am trying to import some old and existing membership but fail, which only the start date on 2015 can be imported. In my xls, the other membership records on 01/01/2008, 01/06/1991...etc are all ...
1
vote
1answer
58 views

Why are Activity Imports failing with error message “source contact id not valid”?

I'm running a monthly activity import into a site (4.4.13) [I realise it's due an upgrade to LTS] We have a standard csv tempalte, and existing field mapping. And have been using the same method ...
1
vote
0answers
6 views

Importing and collecting openids

We use CiviCRM 4.6.9 with Drupal 7, and our members login via OpenID. No problems there. However, we have found since we went live about this time last year that the OpenID values are not being ...
1
vote
0answers
23 views

Get error msg from Manager.php

I'm new to CiviCRM, just installed 4.6.5 on my Joomla 3.4.4 testsite. Other software levels: PHP: 5.5.18 MySQLi: 5.5.36 I tried to import contacts, 980 in total, using a .csv file. There are no ...
1
vote
0answers
28 views

Membership import - is there any column heading that will automatically match internal identifier?

I've tried all sorts of things and can't find any column heading for the cvs that will automatically match internal identifier. One would think that if you use what comes up when you manually match ...
1
vote
0answers
64 views

CiviCRM Import contacts only adding some to groups

I have to csv files with organisation contacts in them, when I import a group of contacts it says it has created all the contacts, but will only add 300/350 or 160/240 into the group. I receive no ...
1
vote
0answers
293 views

Problem importing CSV contacts

For reasons too stupid to relate here, I am trying to Export my entire Contacts file from the operating, on-line Drupal/Civi setup as a CSV to my desktop -- no problem. When I try to Import this CSV ...
0
votes
3answers
724 views

CiviCRM 4.7 - DB Constraint Violation - possibly dashboard_id should possibly be marked as mandatory for this API

We have moved our hosting to new hosting provided (CiviHosting). CiviHosting installed a fresh installation of CiviCRM 4.7. We then imported our previous sql dump from our old site which also had ...