Questions tagged [data-import]
The data-import tag has no usage guidance.
74
questions
0
votes
0
answers
9
views
Importing participants gives success message but data is not imported
When importing participant information from the Courses...Import Participants menu, the import process says successfully completed but when I review each contact's records the imported data is not ...
- 31
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.
- 83
0
votes
1
answer
62
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 ...
- 446
2
votes
1
answer
42
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?
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::...
- 2,105
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 ...
1
vote
1
answer
37
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 ...
4
votes
3
answers
119
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,471
2
votes
1
answer
53
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,471
1
vote
1
answer
69
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 ...
- 1,241
1
vote
0
answers
27
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 ...
- 2,105
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,951
1
vote
0
answers
25
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 ...
- 31
0
votes
1
answer
176
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 ...
- 131
1
vote
2
answers
213
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 ...
- 43
2
votes
1
answer
131
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?
- 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 ...
- 3,471
1
vote
1
answer
131
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 ...
- 670
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, ...
- 1,057
0
votes
0
answers
26
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
52
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 ...
- 2,037
0
votes
1
answer
107
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
48
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 ...
- 4,105
0
votes
0
answers
35
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 :)
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 ...
- 81
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 ...
- 2,749
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 ...
- 81
2
votes
1
answer
16
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 ...
- 41
0
votes
2
answers
83
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., ...
- 123
1
vote
1
answer
117
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,034
0
votes
0
answers
34
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. ...
- 91
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 ...
- 385
2
votes
2
answers
34
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 ...
- 41
1
vote
2
answers
97
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 ...
- 147
2
votes
1
answer
70
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....
- 670
1
vote
1
answer
106
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 ...
- 633
1
vote
3
answers
197
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 ...
- 11
0
votes
2
answers
38
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 ...
- 3,014
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 ...
- 3,471
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
3
votes
1
answer
96
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 ...
- 921
2
votes
1
answer
199
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 ...
- 21
3
votes
1
answer
69
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 ...
- 33
2
votes
1
answer
142
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 ...
- 3,014
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 ...
- 707
2
votes
0
answers
52
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 ...
- 49
3
votes
3
answers
152
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 ...
- 53
1
vote
1
answer
67
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 - ...
- 3,471
2
votes
1
answer
59
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 ...
- 21
3
votes
2
answers
54
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 ...
- 665