Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [data-import]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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
  • 73
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
2 votes
1 answer
33 views

Data prep to import to Spark

We are working with 2 data sets: export from Mailchimp as a csv, export from Excel as a csv. I would like to start importing to CiviCRM Spark with clean data sets. Any tips?
Lee Leonhardt'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,050
0 votes
0 answers
21 views

Trying to import a CSV using custom data, but requires CiviID or External ID in the data

I have a CSV of gmail messages including: date, to, from, subject, message. I wish to import it into Civi but it is missing required field "Civi ID or External ID" both of which are not tied ...
User123123123's user avatar
1 vote
1 answer
35 views

Using Civi to Store historical mailing data, and auto updating

I was asked to implement a system within civi where we can upload historical record of email messages. I then found out these are supposed to be auto updated with new messages every time a certain ...
User123123123'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,441
2 votes
1 answer
49 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,441
1 vote
1 answer
68 views

Porting an old installation to a fresh CiviCRM

We have a very old installation, it is totally upgraded, but has been around for more than 10 years and survived both major Civi-upgrades and server migrations. I'm starting to feel that all the ...
thoni56's user avatar
  • 1,241
1 vote
0 answers
26 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,050
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,851
1 vote
0 answers
24 views

Missing column in contact import screen

I cannot figure this out. The column for mapping a contact import is just missing. I have disabled all the themes, switching to the basic WP theme, and the backend theme. I have disabled all the ...
BubbaWanders's user avatar
0 votes
1 answer
165 views

Importing Multi-value Custom Data

I'm trying to import custom fields from one civiCRM installation (on Drupal 7x) to another (WordPress, civi 5.52) using the "Import Multi-value Custom Data" tool. All my column names in the ...
Tom's user avatar
  • 131
1 vote
2 answers
194 views

Membership Import Fails on Queue Runner After Upgrade to 5.52

We recently upgraded all our sites running Civi 5.50 to 5.52. Now we cannot complete membership imports. We weren't timing out previously on data sets of up to 1,000, sometimes more. But now we cannot ...
Hardwick's user avatar
2 votes
1 answer
117 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,441
1 vote
1 answer
123 views

importing multi select options into Activity custom fields

I'm trying to import a set of Multi Select Options on a Custom Field that's attached to Activities, but I can't find a way to do it. I've tried replacing the csv field with the label strings, the ...
Marsh's user avatar
  • 650
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
0 votes
0 answers
25 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
48 views

Can I use civi import/export to update a set of activities and attach them to cases?

I'm updating a set of activities in CiviCRM. previously these have been recorded ad-hoc on the database, but in future they'll be part of a case. To update previous details and bring them into the ...
Craig Almond's user avatar
  • 2,037
0 votes
1 answer
89 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
45 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
  • 4,055
0 votes
0 answers
34 views

How to create import of csv file using civicrm entity?

I want to create a csv file import action using the civicrm entity. Can you tell me how this is done? Thanks for your attention :)
Vladimir Marakhovskii's user avatar
0 votes
1 answer
23 views

Custom field saves, for all entries, instead of wanted data a number that is not in original data

I'm having an odd problem with a custom field within a custom data set. The field is made for personal identification number, data type is integer and it's a single line input field. Every time I ...
slovojed's user avatar
0 votes
1 answer
46 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
0 votes
0 answers
12 views

Issue with contact import Street Address -- drops address if over 25 chars in length

I am working on a test system as we work through the process to import data from BasicFunder into CiviCRM. I've hit a strange issue with import of Contact address data. A number of imported records ...
Robert Dick's user avatar
2 votes
1 answer
15 views

Importing Contacts from Access

I understand I need to convert a table into a csv file, but the contact table in question has both an individual and their spouse in the same record. Now I can build a query that would only show me ...
Arlyn Henken's user avatar
0 votes
2 answers
79 views

CiviCRM 5.29.0 - import relationships

(2020 12 02; 13:27 US/PST: I've edited this question to more accurately reflect the data available for import.) Can anyone point me at an example of two of importing a set of relationship data (e.g., ...
dvhirst's user avatar
  • 123
1 vote
1 answer
109 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?
Aivars's user avatar
  • 1,034
0 votes
0 answers
26 views

Importing Contributions - Data errors

Hope you are all keeping well in this strange times! We are currently trying to import some contributions in into the system from a CSV file (updating) but can't get past an error that is coming up. ...
TCVTerry's user avatar
1 vote
0 answers
22 views

How to store (and import) historical data (date, integer#1, integer #2, etc.)

I want to store data (date, integer #1, integer #2, integer #3) for an organizational contact in CiviCRM. Each month a new record record with the same format will be created for each contact, but with ...
EricLB's user avatar
  • 385
2 votes
2 answers
33 views

Importing localized content to Civicrm database

I have tried to use the import process in civicrm for importing my urdu data fields into civicrm. After I map the fields in my csv to fields available in civicrm db i get error file. I am attaching ...
Shah's user avatar
  • 41
1 vote
2 answers
96 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 ...
Patrick's user avatar
  • 137
2 votes
1 answer
69 views

import mapping dont save for custom fields on contact subtypes

As the title. If I create custom field set against a contact subtype, then import fields from a csv (saving the mapping for later use), none of the mapped fields are saved for the custom fieldset. i....
Marsh's user avatar
  • 650
1 vote
1 answer
94 views

I need some help resolving db error:unknown error CSV Import helper when selecting a CSV from my desktop

I prepared a CSV for upload. I'll have to make multiple passes on the upload because I have single entry items and multiple entry data in the spreadsheet. I have created all of my custom fields. I ...
LyonsDigital's user avatar
1 vote
3 answers
191 views

Issue exporting and importing Contacts / Membership data

first time posting and really hope someone can help me! We are trying to EXPORT our data from an old installation of CiviCRM on a drupal server IMPORTED into a new installation of CiviCRM on ...
Lucasmang's user avatar
0 votes
2 answers
36 views

Import donations from an external source using Form processor

We have a customised platform where we have been receiving donations before moving to CiviCRM. This platform will continue to be in use. We would like to import all the donations and the contract ...
Tapash's user avatar
  • 3,004
2 votes
1 answer
48 views

How do you import contributions as Pending (Pay Later)?

After reviewing Pay Later status on imported contributions - I followed the answer - created a column listed as Is Pay Later - and added the value 1 to all contributions. Did it again as Yes - both ...
themak's user avatar
  • 3,441
0 votes
1 answer
22 views

lid wel beend maar niet gepresenteerd

Ik heb gisteren Nick Poelenjee toegevoegd als lid Den Haag. Ik zie hem niet terug bij de lidmaatschappen. Als ik hem opnieuw wil aanmelden dan zegt het systeem hem wel te kennen. Hoe los je dit op
Cor Vogelesang's user avatar
3 votes
1 answer
90 views

Importing contributions: "Expected one Contribution but found 25"

I am getting an error when I import contributions. I have successfully imported contributions before from other data sets. This dataset is a little more rich and I have now added a 3 custom fields to ...
kapn's user avatar
  • 919
2 votes
1 answer
195 views

503 Error with large CSV import

I’m hoping to use CiviCRM to manage campaign contacts for voters across many counties and need to upload BOE data to do it. It’s about 210 MB in total, but I have it broken up into CSVs under 30 MB ...
WillHiebs's user avatar
3 votes
1 answer
67 views

How do I bulk import Communication/Privacy preferences?

I want to import a large group of people and some of them have opted out of SMS communications and some have opted out of email communications. I have tried multiple ways of entering the fields in my ...
Cynthia's user avatar
  • 33
2 votes
1 answer
134 views

How can I export Contact Contribution and event data?

Our database was handled very roughly over last couple of years and tested features recklessly. Mixed events payments with contribution payments etc. Numerous price sets. Bot attack was also another ...
Tapash's user avatar
  • 3,004
0 votes
2 answers
61 views

Is there a best practice or recipe for migrating a two database CiviCRM installation into one database?

I am replicating a Drupal 7 CiviCRM installation into a Pantheon CiviCRM Kickstart site. I have gone through the tedious effort of moving the Drupal content and settings from a default Drupal profile ...
Andrew Wasson's user avatar
2 votes
0 answers
51 views

Importing Justgiving Data into civi

We have done a bit of searching and it looks like there is or was a just giving import by veda (https://github.com/veda-consulting/uk.co.vedaconsulting.module.justgivingImports) that looks to be out ...
Des Quinn's user avatar
3 votes
3 answers
147 views

Import Contacts with Email field issue

If I import contacts via a CSV file and indicate a home email, the email address does get imported without any issue. However, in order to send an email to the contact (in my case sending to an ...
Thinkwell's user avatar
1 vote
1 answer
60 views

Mass update / import bulk email preferences?

So - here is the deal - we have an excel sheet with hundreds of contacts - with which email they would like set as bulk mail. While doing an import, I see no option to indicate bulk mail preferences - ...
themak's user avatar
  • 3,441
2 votes
1 answer
56 views

Deleting Contributions

I imported 50 new contributions but it did not import correctly. How do I delete a contribution? Previous suggestions have been to follow this process: Contributions > Find Contributions > *Enter ...
SHops's user avatar
  • 21
3 votes
2 answers
53 views

Mass upload of file to records

I have a bunch of certificates which are scanned as images that needs to be uploaded into the correct record to be attached in the Certificate file field. Can this be 'imported' like how you can ...
Clement Leong's user avatar
1 vote
2 answers
48 views

Data Importation Issue

Procedural question... I have a record set of individuals related to various organizations. The employee/individual info set is handled well, EXCEPT FOR organization name... i can get work phone, ...
drummondislebsd's user avatar