Questions tagged [data-import]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2 votes
1 answer
43 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
  • 385
0 votes
1 answer
9 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,155
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
1 vote
1 answer
46 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 ...
user avatar
  • 650
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
0 votes
0 answers
23 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
28 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 ...
user avatar
  • 1,887
0 votes
1 answer
32 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
39 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,673
0 votes
0 answers
24 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 :)
user avatar
0 votes
1 answer
20 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 ...
user avatar
0 votes
1 answer
33 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
0 votes
0 answers
11 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 ...
user avatar
2 votes
1 answer
14 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 ...
user avatar
0 votes
2 answers
51 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., ...
user avatar
  • 123
1 vote
1 answer
36 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
23 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. ...
user avatar
1 vote
0 answers
21 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 ...
user avatar
  • 325
2 votes
2 answers
30 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 ...
user avatar
  • 41
1 vote
2 answers
69 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
2 votes
1 answer
54 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....
user avatar
  • 650
1 vote
1 answer
60 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 ...
user avatar
1 vote
3 answers
151 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 ...
user avatar
0 votes
2 answers
24 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 ...
user avatar
  • 2,846
2 votes
1 answer
44 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 ...
user avatar
  • 3,155
0 votes
1 answer
21 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
user avatar
3 votes
1 answer
73 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 ...
user avatar
  • 565
2 votes
1 answer
159 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 ...
user avatar
3 votes
1 answer
63 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 ...
user avatar
  • 33
2 votes
1 answer
94 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 ...
user avatar
  • 2,846
0 votes
2 answers
51 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 ...
user avatar
2 votes
0 answers
44 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 ...
user avatar
3 votes
3 answers
123 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 ...
user avatar
1 vote
1 answer
48 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 - ...
user avatar
  • 3,155
2 votes
1 answer
41 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 ...
user avatar
  • 21
3 votes
2 answers
47 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 ...
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, ...
user avatar
1 vote
1 answer
28 views

Primary address being set to the wrong address

I am importing a number of custom contact types. I am importing them with a "Main" address and "Postal Address" location which I created. The default location is set to "Main". However, when I ...
user avatar
  • 325
3 votes
1 answer
40 views

preserving Member IDs on first import?

I have a list of members that I'm importing from our old system. Since they have unique numeric member numbers, I'd like to preserve the original member number and not muddy the waters by making that ...
user avatar
  • 565
4 votes
3 answers
120 views

I keep getting Payment Instrument not valid when trying to import Contributions - after upgrade from LTS 4.6 to 5.3.x

We recently upgraded from LTS 4.6 to 5.3.1 (in July). Via the GUI we can see the Payment Method that we'd like to import -> Moneris -> id=6 Importing with Payment Method: Moneris -> fails: Reason:...
user avatar
1 vote
2 answers
173 views

Address formatting

I'm trying to find a way to change the address format in CiviCRM, to the Australian address format. I've had a good search but can only find this these from 5 years ago. https://civicrm.org/blog/...
user avatar
3 votes
1 answer
72 views

Importing events - location

I found the API CSV IMPORT GUI that allows me to import events. The one thing I can't figure out how to map is the location details - city and state. How do I map those two items?
user avatar
3 votes
0 answers
26 views

CSV GUI Import to api -- Set 'Last update date'?

I'm importing with "CSV GUI Import to api" extension about 6500 contacts. Is it possible to set 'Last update' date during the import from an in the original database existing data field's value? I can'...
user avatar
6 votes
3 answers
246 views

Importing Contacts into multiple groups

I am trying to work out how to import contacts into multiple groups. The list of contacts to import has some contacts listed in multiple groups. I've been unable to work out how. EG Fred Smith is in ...
user avatar
3 votes
1 answer
131 views

Assigning multiple participant roles in civi event, through imports

I would like to assign multiple roles to event participants through imports. I can upload a csv to assign a user role, but if I import a second data source with a different role, it is set aside as a ...
user avatar
  • 31
1 vote
3 answers
42 views

Fresh Installation, with all old data. Current online version CiviCRM 4.6.20. (WordPress)

I am very glad with the nice CiviCRM! This is an perfect online CRM-system! After a lot years now, i would like to upgrade to the current version. But i am very scared if it would work.. The Current ...
user avatar
3 votes
2 answers
35 views

How did my import result in the State for a different country to the one intended

How could a CiviCRM database have 2 Marylands with 2 different state_province_codes but both be identified with the same country_code? 1019 = Maryland 3497 = Maryland 1228 = United States I only was ...
user avatar
  • 157
1 vote
2 answers
26 views

Is it okay to have simultaneous data import?

Is it okay to have more than one user import data at the same time another user is importing data? We have a bunch of segmented data to import split amongst multiple employees - is it okay if two ...
user avatar
  • 3,155
0 votes
1 answer
21 views

What is the recommended way to upload teenage volunteer and their parents data from csv file

What is the recommended way to upload teenage volunteer and their parents data from csv file This is the info looking to upload First Last Email Cell Address City State Zip Home Phone ...
user avatar
  • 33
2 votes
2 answers
56 views

Adding contributions doesn't work for certain currencies

I noticed importing or adding contributions in Serbian dinars (RSD) doesn't work. I tried using API Explorer to create a contribution that way but I get the same error I get when I try to import ...
user avatar
  • 867