Questions tagged [import]
The import tag has no usage guidance.
352
questions
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 ...
- 21
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::...
- 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 ...
- 1
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
...
- 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 ...
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
...
- 483
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 ...
- 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 ...
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 ...
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 ...
- 658
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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 429
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 ...
- 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 *
&...
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 ...
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 ...
- 429
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). ...
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 ...
- 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 ...
- 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 ...
- 1,367
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 ...
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 ...
- 2,513
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 ...
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 ...
- 2,513
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, ...
- 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?
- 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 ...
- 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 ...
- 227
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 ...
- 195
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&...
- 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 ...
- 59
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, ...
- 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 ...
- 55
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?
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 ...
- 183
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 ...
- 183
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 ...
- 183
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 ...
- 980
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 ...
- 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 ...
- 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) : ...
- 183
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 ...
- 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 ...
- 742
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". ...
- 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 ...
- 2,729
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 ...
- 371
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 ...
- 1,057