Questions tagged [import]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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, ...
user avatar
  • 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?
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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, ...
user avatar
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&...
user avatar
  • 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 ...
user avatar
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, ...
user avatar
  • 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 ...
user avatar
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?
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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) : ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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". ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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?
user avatar
  • 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: ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 (...
user avatar
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.
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar

1
2 3 4 5
7