Skip to main content

Questions tagged [import]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
9 views

Importing participants gives success message but data is not imported

When importing participant information from the Courses...Import Participants menu, the import process says successfully completed but when I review each contact's records the imported data is not ...
Janice G's user avatar
0 votes
2 answers
22 views

Multiple import impossible: Mandatory key(s) missing from params array: entity_id

This error occurs when importing multiple with version 5.74.4 but not with version 5.70.2 Indeed, in the temporary import table, the entity_id field remains empty I did not test with other versions ...
Alain Rihs's user avatar
1 vote
1 answer
53 views

Importing contacts fails with: Queue runner must be configured before execution

I'm getting the error "Queue runner must be configured before execution" when importing a list of contacts. The file is just a single column of 416 emails. I've tried the advice given ...
twowheeler's user avatar
1 vote
1 answer
30 views

what are the payment gateways are possible in civicrm for NGO in India

Any suggestion about the payment gateways are possible in civicrm for NGO in India
Akhil Raj's user avatar
0 votes
1 answer
37 views

Import Contact ID as the External ID

I need to make the contact ID to match the external ID in order to match the import file for activities. Is there a way to do this upon the import of contact files? I already deleted the contact ...
Mary's user avatar
  • 145
1 vote
1 answer
31 views

How to export a large contacts number via cv or bin/csv/export.php

Both methods seems to have a restriction on a number of contacts processed (25?) cv api Contact.get options={"limit":0} php export.php -e Contact > ~/ex.csv I remember doing some php ...
yurg's user avatar
  • 2,053
2 votes
1 answer
55 views

Anyway to export all data for import into a local instance?

I know we can export contacts and activities but is there anyway to export everything (ex. activity types, custom contact fields, etc) so that I can import everything into a fresh Joomla/Civi install ...
thejason's user avatar
0 votes
1 answer
23 views

Is there a way to import both type of contact types together (Individual and Organisation)?

I am looking for a solution where I can just do importing contact together for both individual and organisation contact types. Please assist me.
Cas's user avatar
  • 83
1 vote
0 answers
25 views

Mismatched contacts SubTypes - Contacts will not be imported when Suptype is not the first Subtype

CiViCRM 5.65.1 on Drupal 9.5.10 PHP Version 7.4.30 When I import users from a CSV file to a certain contact subtype (I want to import or update data of all Supervisors) only those entries from the ...
Christoph Reuter's user avatar
0 votes
1 answer
34 views

Is it possible to update Activities using the Activity Import tool?

After importing activities, is it possible to update them using the import tool? We want to "fill" data in fields that are empty. This is possible in Contacts using the External ID field (...
icaria36's user avatar
0 votes
1 answer
61 views

Import Contacts Issue After Joomla 4.4.0 Upgrade - Stuck at 'Running Queue

I am using CiviCRM 5.64.2. A few days ago, I upgraded Joomla from version 4.3.0 to 4.4.0. Normally, I used to import a list of user data that I receive daily with a CSV file separated by semicolons ...
Fatih ATEŞ's user avatar
1 vote
1 answer
47 views

I am trying to do a Membership Import from a spreadsheet (.csv file). All imports fail with the message "No matching Contact found for (email add.)"

I am trying to do a Membership Import from a spreadsheet (Members.csv) with the following columnns: Membership Type | MEMBERSHIP # | DATE OF PURCHASE | AMOUNT PAID | FIRST NAME | LAST NAME | Mailing ...
aqua's user avatar
  • 11
0 votes
0 answers
10 views

In Donations upload, if I use PREVIOUS button from second step, and select the csv file again and go to the next step, it throws an error

In Donations upload, if I use PREVIOUS button from second step, and select the csv file again and go to the next step, it throws an error. Please tell me a solution for solve this issue if anyone ...
Vishnu MD's user avatar
0 votes
1 answer
20 views

Contacts Import issue at CRM_Contact_Import_Form_MapField::getLocationTypeLabel

Not a question as such, rather an observation. WordPress contacts import from CSV, CiviCRM 5.61.2. (not reproduceable on dmaster). Uncaught TypeError: Return value of CRM_Contact_Import_Form_MapField::...
yurg's user avatar
  • 2,053
0 votes
1 answer
42 views

We need help with importing & mapping a .csv data extract from a 3rd party system

I'm looking for someone who knows CiviCRM's data importing and mapping processes. We have a .csv extract of data requiring some cleansing, importing and mapping. From what we can tell so far the ...
Warwick's user avatar
3 votes
3 answers
110 views

Why would the "civicrm_queue.runner" property be missing?

I am trying to import contacts and getting the following errors: Cannot execute queue "user_job_6". The "civicrm_queue.runner" property is missing. Any idea why? 5.61.4 wordpress ...
themak's user avatar
  • 3,451
0 votes
0 answers
51 views

Getting a TypeError: CRM_Import_Parser::getFieldMetadata() when importing contacts

We tried to update contacts with a csv file on CiviCRM 5.61.2, Drupal 10.0.9 and PHP 8.1.11. We get the following error: TypeError: CRM_Import_Parser::getFieldMetadata(): Return value must be of type ...
Matthieu Rickly's user avatar
0 votes
1 answer
21 views

Cannot use CSV GUI Import to api Fatal error

WP 5.7.8 civi 5.59.4 CSV GUI Import to api 1.12 Have cleared cache and emptied templates_c Have uninstalled and reinstalled but get error below when I try to use ie it doesnt start just get the below ...
LesleyJill's user avatar
2 votes
1 answer
51 views

Why am I getting "Mismatched contact type." when I try to import any contacts?

Wordpress 6.1.1, Civi 5.59.4 I have been getting the error "Mismatched contact type." which is possibly linked to this: https://lab.civicrm.org/dev/core/-/issues/3927 but that appears ...
themak's user avatar
  • 3,451
0 votes
2 answers
147 views

Issues with contact importing - Mismatched Contact Type and more

I'm seeing some issues with contact importing, and I wondered if anyone else is? Civi 5.58.0 on Wordpress with PHP 7.4 We have a process where we fairly regularly reimport existing contacts back into ...
Robin Fenwick's user avatar
0 votes
1 answer
23 views

How to import contact via CSV and trigger CiviRule for Trigger "Address is added"

I set up a CiviRule that when an Address is added for a Contact some relationships are created depending on the zip code for that Contact. Now I create some Contacts via an import of a CSV file. I ...
mplh's user avatar
  • 121
1 vote
0 answers
27 views

web import fails because of empty "name" column in "civicrm_user_job" table

Drupal 9x, CiviCRM 5.56.0. Getting "Cannot execute queue "user_job_XXX". There is no associated UserJob." while contacts import from csv ( civicrm/import/contact?reset=1 ) Perhaps ...
yurg's user avatar
  • 2,053
0 votes
1 answer
27 views

API CSV import creates events that start and end at midnight

Importing the .csv quoted below to create Events. The snippet further down shows the field mappings. Everything comes across correctly except the time components of Start Date and End Date, which get ...
wil_SRQ's user avatar
  • 703
0 votes
0 answers
56 views

Uncaught TypeError on Import

All of a sudden, after doing a number of individual and organization contact imports, the import is erroring out on the second screen. I get a WordPress error that states: There has been a critical ...
Mark's user avatar
  • 227
1 vote
1 answer
48 views

Import data, given Contact ID

I have a CSV with various fields, including Internal ID and Phone. I want to match Internal ID to Contact ID, and add Phone to the set of phone numbers for each contact. I use a simple field mapping ...
Ken Williams's user avatar
1 vote
1 answer
33 views

Issue importing state/province from non-US countries

I'm importing contacts from a legacy system and am running into a wall importing addresses from non-US countries. For instance, for Canada, I'm trying to import a Canadian province. I've tried both ...
Mark's user avatar
  • 227
0 votes
1 answer
55 views

Contribution imports have stopped working

I have been importing contributions from a .csv file every month for a couple of years. It recently stopped working for me. I get the following error message: "Please correct the following errors ...
Imran Chaudhary's user avatar
0 votes
1 answer
39 views

Update "unsubscribe" information for email addresses

I have a data set downloaded from MailChimp (pre-dating when we used CiviCRM) of people who hit "unsubscribe" for their email address. I've used the "CVS Import Helper" extension ...
Ken Williams's user avatar
2 votes
1 answer
117 views

Issue with API CSV importer and activity imports

WP 6.03, CiviCRM 5.51.3, API CSV importer 1.1. I'm attempting to import an activity via this extension since I need to include the assignee (which isn't included in the standard activity import). ...
Lesley Carter - BackOffice's user avatar
1 vote
1 answer
32 views

Contributions Import ... Not

Using Drupal 9.3.22 and CiviCRM 5.52.3 Importing a csv file with 44 contributions and a header row into an existing system. The csv file is uploaded, we set the mappings, and then the next page says ...
Alan Dixon's user avatar
  • 6,881
0 votes
0 answers
27 views

Fields not showing in Matching CiviCRM Field drop down list

hope someone can help with this. We have created a Custom Field set called Shareholder. These fields have been used when adding new shareholders one by one. I would now like to use a CSV file to ...
Mike H's user avatar
  • 1
2 votes
1 answer
407 views

Contribution import fails with <Invalid field 'email'> error

Update: This is a confirmed bug, with issue filed on gitlab. After a CiviCRM update across quite a few versions (from somewhere around 5.39 to 5.51), I've started to get failures when I try to import ...
Phil Morice Brubaker's user avatar
0 votes
1 answer
46 views

How do I set the Organization from the Employer Relationship as a contact's Current Employer for multiple contacts at once?

I have over 1,000 contacts which I imported along with an employer relationship, but these employers aren't showing up as "Current Employer" on the contact summary page because the ...
Katie Goff's user avatar
0 votes
0 answers
25 views

What is 'Invalid (Error Code: 4)'?

Trying to import a small set of contacts with relationships, I got this error: Invalid (Error Code: 4). We have checked all fields and couldn't identify any thing special. Any idea? BTW is there a ...
Guillaume Sorel's user avatar
2 votes
1 answer
40 views

Reimport users after migration to Wordpress

We're in the process of migrating from Drupal to Wordpress. The initial migration went without a hitch and we're now setting up new contribution forms in the new site. The plan is to reimport the ...
christodhunter's user avatar
2 votes
2 answers
69 views

How to import a lot of contacts (above 5000)

I need to import a file with individuals (round 5000) and organizations (round 2000), relationships between them and all of them being added to group. What would you advice: api import? front-end with ...
Guillaume Sorel's user avatar
1 vote
1 answer
75 views

How to import relationships with metadata

I can see that I can import relationships as part of the Contacts » Import form, but it only seems to let me say that Contact A is <predicate> of Contact B. Relationships have: start, end dates, ...
artfulrobot's user avatar
  • 3,932
2 votes
1 answer
124 views

Is it possible to "unmerge" two contacts?

Two contacts in my system were accidentally merged. Is it possible to unmerge them and restore all of their respective data to the original states?
dsmith63's user avatar
  • 419
0 votes
1 answer
13 views

Uploaded a bunch of contacts and many were assigned foreign countries

I uploaded a bunch of contacts with addresses but without country specified. We have mostly United States contacts. Oddly CiviCRM assigned many of them Hungary as their country. Other countries also ...
themak's user avatar
  • 3,451
1 vote
1 answer
85 views

How to import participants with custom field data?

I have a spreadsheet of data from an event we recently held that was hosted on an Aventri website. Have been banging my head on importing this into CiviCRM for a week. I finally figured out how to ...
Jeff Porten's user avatar
0 votes
1 answer
80 views

On importing Contacts, I can't match their Organization to the Employer field in CiviCRM

I have imported a new batch of Organizations. I want to import additional Contacts and match their Organization name in the .csv with the Employer field in CiviCRM. I don't see "Employer" as ...
ArloGueswith's user avatar
0 votes
1 answer
32 views

API csv Import - Error when importing activities "Invalid value for field (activity_type_id) "

Trying to import new activities using API cvs Import. I'm using the ID from the link to edit a custom activity type, like this www.mysite/civicrm/admin/options/activity_type?action=update&id=1028&...
V3rmie's user avatar
  • 377
1 vote
1 answer
182 views

Why is this CiviCRM with wordpress so slow to import data?

I'm testing CiviCRM on a home, not-web-linked, machine. Hence I haven't set up a way to get admin-directed emails. Importing less than 20,000 records with less than 40 mostly-custom fields each has ...
Brian Cady's user avatar
0 votes
1 answer
17 views

Activity import gets the century wrong

When I import activities from a CSV using a date format that includes a 2-digit year (for example, mm/dd/yy), dates such as "01/18/22" get imported as January 18, 1922 instead of January 18, ...
Noah Miller's user avatar
  • 1,057
1 vote
1 answer
268 views

cURL error 6: Could not resolve host when importing contacts

I recently updated CiviCRM in Drupal 7 from version 5.17.3 to 5.42.1 Now when I try to import contacts, I get to final step and click "import now". After a few seconds that I see the popup ...
acaselli's user avatar
0 votes
0 answers
26 views

Custom fields not available when doing CSV import

Tried creating several custom field sets but none of the fields are showing up in the match fields window?
PAUL BERTRAND's user avatar
0 votes
0 answers
37 views

Importing Individual Contacts related/linked to Organizations causes Organizations to convert to Individuals

When importing a list of Individuals through the Contact Importer, I linked them to the Organization they are related to using "Knows" and the Contact ID for the organization, but after the ...
flantascience's user avatar
0 votes
0 answers
30 views

When importing Contributions, every record returns an error: No matching Contact found for ( ##### )

When importing Contributions, every record returns an error: No matching Contact found for ( ##### ) Importing Contacts isn't an issue. We're running Civi v5.39.0. I'm matching by Contact ID and they ...
flantascience's user avatar
0 votes
1 answer
101 views

Error when importing contacts - "Warning: Illegal string offset 'code'"

After importing a CSV of contacts, I'm getting a blank screen with the error message below. Typically, I get a report of how many contacts were skipped due to duplicates. It appears the data is ...
flantascience's user avatar
1 vote
0 answers
193 views

Can't save new or existing contributions after import (Drupal 9, CiviCRM 5.41)

Drupal 9.2.6 CiviCRM 5.41.2 I imported some contributions via the SQL database (there's 16k+ so I don't want to use the UI) but I cannot edit or add a contribution. The triangle just spins, and there ...
Rose Lanigan's user avatar
  • 1,070

1
2 3 4 5
8