Questions tagged [import]
The import tag has no usage guidance.
329
questions
0
votes
0
answers
12
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,275
2
votes
1
answer
18
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
35
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,275
1
vote
1
answer
21
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,688
2
votes
1
answer
36
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?
- 355
0
votes
1
answer
8
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,222
1
vote
1
answer
20
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
24
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 ...
- 171
0
votes
0
answers
8
views
Using ABS(), * and multiple fields in SQL contacts import query does not work
I am trying to import contacts using the SQL Query method but in place of a SELECT * I would like to work on the imported fields by for example doing a SELECT *, ABS(member_is_active) as is_active, ...
0
votes
1
answer
10
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
75
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
10
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,012
1
vote
1
answer
30
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
20
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
16
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 ...
- 173
0
votes
0
answers
20
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 ...
- 173
0
votes
1
answer
26
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 ...
- 173
1
vote
0
answers
46
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 ...
- 838
0
votes
1
answer
27
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,664
2
votes
1
answer
31
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
42
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) : ...
- 173
1
vote
0
answers
38
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,664
3
votes
0
answers
52
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 ...
- 710
1
vote
1
answer
26
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
30
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,719
1
vote
1
answer
29
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 ...
- 361
2
votes
1
answer
27
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,012
1
vote
1
answer
44
views
Is there a bulk method to put emails on hold?
Bounce processing has not been working - but I do have a list of addresses that have been bounced. What I want to do is bulk update all those matching contacts and put their emails on hold.
I cant see ...
- 1,252
2
votes
1
answer
52
views
API csv Import GUI with Formprocessor fails with smarty errors
I created a rather complicated form processor which works (through api), but when I tried to clone it (rename it to create so csv api picks it up) and tried to do the csv import.
I get the following ...
- 867
0
votes
2
answers
58
views
Importing a future membership start date: Invalid value for field(s) : Start Date 01/25/2021
I get the above statement when I try to import a membership. I have coded the date in different ways, and eventhough the fields match with my definition I get the same answer. Really I wonder why this ...
- 101
1
vote
2
answers
48
views
Importing Contribution should update Membership period
I'm trying to do an "Import Contribution", Member Dues, but the membership period in not extended by the expected year. How can I manage that automatically? Should be possible! I have ...
- 101
1
vote
1
answer
38
views
Unable to Create New Contact Field
I'm currently setting up the CIVICRM platform, now at the stage of importing data I am unable to create new contact fields, I followed the instructions available to create custom fields however none ...
- 11
0
votes
0
answers
17
views
How to import values for Custom Fields configured as "Field Set allow multiple records?"
I think no through regular Contact Import; I can't see how through API CSV Import; if anyone has any other thoughts that would be great.
Seamus told me to try -> /civicrm/import/custom?reset=1 and ...
- 14.9k
1
vote
1
answer
35
views
How to create a group from CSV file?
I have a CSV file with email addresses. Part of these addresses are in CiviCRM.
How can I create a CiviCRM group that includes contacts with emails matching those in CSV file?
- 1,012
0
votes
0
answers
30
views
Field Mapping Not Saved When Importing Multi-Value Custom Data
I'm using the Import Multi-value Custom Data screen (civicrm/import/custom?_qf_MapField_display=true) and it does work, but it is not saving the field mapping. There is the following error:
Warning: ...
- 837
1
vote
2
answers
40
views
contact import process
I am importing 955 contacts and assigning them a tag or a group (or both). Time estimate showing is 20 minutes.
During the import the connection times out.
After waiting a long while, I go back to ...
- 325
1
vote
1
answer
30
views
possible bug: when using External ID as matching method, imported contributions can get matched to contacts in the trash--would expect error instead
I have a client whose accounting team has run into the following issue (admittedly an edge case but causes a lot of confusion and troubleshooting time for the team so we want to fix). Following the ...
- 444
3
votes
2
answers
106
views
How do I import contact records with phone numbers without overwriting existing phone numbers?
If I import a spread sheet with contacts and phone numbers and:
I choose to update duplicate contacts
I choose the same phone location and phone type of an existing, matching contact
Then, the ...
- 1,174
1
vote
0
answers
17
views
API csv import unable to import addresses
I am importing a large dataset using the API csv import extension.
I have imported the custom fields, contacts, email and phone numbers using the different entities.
I have tried to import the address ...
- 799
1
vote
1
answer
34
views
Importing contacts into Civicrm
I am importing 350 contacts into Civi. This post says that you should always include an import identifier. I don't have admin access so I cannot create a custom field set. I was going to identify the ...
- 171
2
votes
2
answers
91
views
Importing Relationship Data
I know this should be straight forward, but somehow I seem to struggle.
Importing a child-parent relationship.
I have 10 children records (External ID, Child Name, Child Surname) and 5 parent records (...
- 23
1
vote
1
answer
19
views
Importing Gift Records
Does anyone know here know how to import .csv files containing contribution information?
I know how to import constituent records but don't know how to import their gifts.
- 11
1
vote
2
answers
67
views
Warning "mismatched contact IDs" when trying to update existing individual records
I'm updating the CiviCRM database with a list of individual records. All these individuals exist already in the database, but I need to create the link with existing organisations.
I've already done ...
- 137
1
vote
1
answer
49
views
API CSV Import -> for ActivityContact -> invalid value for record_type_id
Using API CSV import to try add entries to the civicrm_activity_contact table -> running out of ideas as to what I need to use for record_type_id (see screenshot) - any other ideas are welcome! Trying ...
- 14.9k
5
votes
1
answer
83
views
How can I revert a set of bulk changes to the database?
I made a bulk update of addresses that turned out to be incorrect. I have advanced logging enabled. I can go into each contact's change log and revert the mistake one by one; how can I do this for ...
- 37.3k
1
vote
1
answer
65
views
Importing using API CSV importer
I am importing a large dataset using the API CSV importer extension.
The data needs to be divided into 3 chucnks - contact, address and email.
The second two imports I was planning to match up with ...
- 799
1
vote
1
answer
106
views
Importing Contacts, Memberships and Contributions in 2020
I need to import from an external database 1500 contacts with their memberships and contributions.
Everything I read about it in Stackexchange was written between 2015 and 2017.
Is the following ...
- 2,275
1
vote
0
answers
22
views
Misleading behavior when importing activities
This is on CiviCRM 5.24.1, just installed. The behavior of the Import Activities page is odd. On the Preview page, Step 3 of 4, the buttons Previous, Import Now, or Cancel are displayed. However, no ...
- 710
2
votes
1
answer
21
views
Import Contribution - last step no longer goes to 'Summary / Error' report
We recently updated to CiviCRM 5.23.1
In the prior version when running it would run through the 4 documented stages
1. Upload Data
2. Match fields
3. Preview
4. Summary
But in 5.23.1 the ...
- 421
0
votes
1
answer
60
views
Custom fields not showing in import and export filter
I have two sets of custom fields related to two sub-types of the same type (organization). Both profiles are active and I can see the custom fields in the contact summaries and in the advance search ...
- 2,275