Questions tagged [import]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
9 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
  • 1,661
0 votes
1 answer
32 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
2 votes
2 answers
40 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,312
0 votes
0 answers
28 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
15 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
39 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,312
0 votes
0 answers
14 views

Receiving Invalid value for field(s) : on multiple fields when importing membership

I am trying to import lapse/expired memberships that were downloaded to excel from now defunct civi install into our new civi installation on new server. It is failing on all 766 records. Was able ...
CIVIADMIN in MI's user avatar
0 votes
0 answers
13 views

Error importing data to custom fields

I'm trying to input data from a CSV file to custom fields. I'm getting a noticeable error on checkboxes only. I'm separating the multiple options with commas. Dato 1,Dato 2 Example in image: These ...
Suri Gang's Hallen's user avatar
0 votes
2 answers
103 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
21 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
  • 101
1 vote
0 answers
20 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
  • 1,661
0 votes
1 answer
23 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
  • 693
0 votes
0 answers
38 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
  • 163
1 vote
1 answer
25 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
21 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
  • 163
0 votes
0 answers
28 views

Critical web error when trying to import contacts

I have a working installation of CiviCRM on Wordpress. I am trying to import 334 contacts with a CSV file from excel. Even though the file has no errors, I am getting errors related to the classic * &...
Suri Gang's Hallen's user avatar
0 votes
1 answer
32 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
31 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
91 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,614
0 votes
0 answers
26 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
175 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
33 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
23 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
34 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
50 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
54 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,870
2 votes
1 answer
87 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
  • 387
0 votes
1 answer
10 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,312
1 vote
1 answer
43 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
61 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
27 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
152 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
16 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
180 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
24 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
30 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
26 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
69 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
84 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
0 votes
1 answer
50 views

How to import recurring payment data from Stripe and GoCardless so that it updates memberships?

I'm setting up a new CiviCRM site and importing a few thousand contacts and membership records from a bespoke legacy database. Many of the payments for the memberships are handled by Stripe or ...
Graham's user avatar
  • 3,915
2 votes
1 answer
54 views

Custom Fields and new version of csvimporter aka API csv Importer

I installed CiviCRM 5.41.0 and csvimporter 1.7. My overall goal is to import data from csv files. I created some custom fields, imported the standard fields using the standard importer and then ...
EricHow's user avatar
  • 21
0 votes
1 answer
92 views

Error when importing contacts: Invalid value for field(s) : State/Province

I've got CiviCRM installed on WordPress and am getting this error for almost every contact that I import from a list of 250 contacts: "Error when importing contacts: Invalid value for field(s) : ...
flantascience's user avatar
1 vote
0 answers
42 views

How can I import contact records where I only have an email address?

I'm trying to import about 500 contacts from a CSV. About 20% of them only have an email address, some have email and either a first or last name, most have all three. The default import method is ...
Graham's user avatar
  • 3,915
3 votes
0 answers
59 views

Reason column missing from contact import error list

After importing a CSV file of contacts, the rows with errors can be downloaded and fixed. Today I noticed that the "Reason" column is missing from this error list. For example the ...
twowheeler's user avatar
1 vote
1 answer
34 views

How to automatically create/import some 4000 groups in bulk from a csv file

We are considering data migration to CiviCRM. We have two CSV files, one has the details of thousands of "individuals" and another has a list of over 3000 needed "groups". ...
Shoa's user avatar
  • 11
0 votes
1 answer
42 views

What does 'Number of Items to Process For Each Queue Item' mean when using the API Importer extension?

I'm using Civi 5.35 and Drupal 7. We've installed the API CSV Import extension. At ~/civicrm/index.php?q=civicrm/csvimporter/import , I see a place to enter "Number Of Items To Process For Each ...
Joe McLaughlin's user avatar
1 vote
1 answer
34 views

Year only import

Is it possible to do a Contact import where a date column is in year only format (2018,2020 etc)? I tried looking at the Administer -> Localization -> Date Formats and noticed year only is an ...
Kurt Leadley's user avatar
2 votes
1 answer
33 views

Enforcing the uniqueness of fields/entities (e.g. phone numbers)

I'd like to ensure that phone numbers of a certain type (let's say Mobile) are unique across our Civi instance. A given contact should be able to have no more than one Mobile number, and no two ...
Noah Miller's user avatar
  • 1,057

1
2 3 4 5
8