Questions tagged [import]

The tag has no usage guidance.

2
votes
1answer
110 views

Input file must be in csv format

I am trying to import a csv file as a test into Civicrm. I first exported the exact same file from Civicrm, and then i tried to import the exact same file. When i click on Continue, i get an error "...
2
votes
3answers
107 views

CiviCRM not recognizing csv file when uploading

CiviCRM is suddenly not recognizing upload file as a csv file. It's now giving an error message that csv file not recognized. What is the problem and how can I overcome it?
2
votes
1answer
58 views

Command line import error message

I'm using the command line import, following info provided here: How do I import contacts through the command line? https://forum.civicrm.org/index.php?topic=34033.0 But getting the following error ...
2
votes
2answers
205 views

Add fields in Matching CiviCRM fields on Import Contact

We are importing contacts into our CRM. Our CSV file contains a District column, but while importing contacts, there's no such field present in CiviCRM--we need to add the district field. URL: ...
2
votes
2answers
76 views

Error in CiviCRM for Drupal7 after Migrate from “Backup and Migrate” module on New Contact Form

After I did a Backup and Migrate to a new system, I am getting two errors on any New Contact form. They are as follows: Notice: Undefined property: CRM_Core_BAO_Tag::$tree in CRM_Core_BAO_Tag->...
2
votes
1answer
75 views

Restoring groups and linked contacts

50 groups were deleted by mistake. Please don't ask how. So from a 2 weeks old backup, we're able to extract a CSV from civicrm_group and civicrm_group_contact group_id, name, contact_id, email We ...
2
votes
2answers
22 views

How do I download duplicates of imported contacts in the past month?

I import contacts almost every day, and I automatically press "skip" on the "For Duplicate Contacts" import option. When the import is complete, I recognize that I have the ability to download the ...
2
votes
2answers
186 views

Contact Import explode issue with matching contacts

I am getting the following warnings when trying to import contacts: Warning: explode() expects parameter 2 to be string, array given in //wp-content/plugins/civicrm/civicrm/CRM/Contact/Import/Parser/...
2
votes
1answer
50 views

Is there an Import option to allow overwriting fields with null (empty)?

I'm trying to do a bulk tidy-up of Address fields in CiviCRM 4.7 by exporting the data, manipulating it in a spreadsheet and re-importing it. This involves moving some values around between postal ...
2
votes
2answers
53 views

Bug in the data import wizard

We need to daily export all donation data from CommitChange and import the data to civicrm using the data import wizard. So the process is: Map the appropriate donation fields to civicrm fields and ...
2
votes
1answer
22 views

Is there a way to include OpenID as a drop down option in the contribution lis? or Is there a way to convert OpenID to external identifier?

When I imported contacts, I listed their identification number as OpenID. Now, I am trying up import the contacts' contributions. Along with their name, amount, date of donation, I am including their ...
2
votes
1answer
104 views

Import and Export failing and returning no error message

I recently moved my CiviCRM install from a local in-house server to a cloud server hosted by Siteground. Everything is working beautifully except for the import and export. My database is around 60,...
2
votes
1answer
44 views

How can I import the “communication style” field when importing contacts?

In my csv I have a field named "Communication style", which I wish to map to the respective field in "communication preferences" for each contact in CiviCRM (formal / familiar). Yet, while importing ...
2
votes
1answer
65 views

How can I specify quantity of tickets on event participant import?

I'm trying to figure out if there is there a way to specify quantity of tickets? Like a person bought 2 tickets but civi participant import processes doesn't seem to let me specify that. Any ...
2
votes
1answer
56 views

How can I import Memberships without membership start date?

I want to import membership in update mode and I don't have start_date so at the time of import it shows me start_date is required field. I have removed membership_start_date required field from /...
2
votes
1answer
62 views

Relationships not available on household imports

We have an import that we do a few times a year that I set up about 2 years ago. Until today, it's never had an issue. We are using v4.6.3, and the last time we did it we were using a 4.5.x version. ...
2
votes
2answers
348 views

When importing memberships, I get “Error: Invalid value for field(s) : Start Date; End date”

I hope someone can answer this! I've tried 30 various date formats, rearranged columns, and every time I do a membership import it fAils. No errors are presented, I'm just returned to "Upload Data (...
2
votes
1answer
22 views

Issue importing multiple contributions for same contact

I am trying to import multiple contributions for a contact. I am using the following fields for the import: contact ID, total amount, date received, and financial type. Civi will only import the ...
2
votes
0answers
23 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'...
2
votes
0answers
52 views

Weird behavior when Importing into primary email

I just did an import (to verify weird behavior reported by a client), matching on first, last and email, with Update checked. The system has home set as default location type (=1). The contact had ...
2
votes
0answers
51 views

Can import update contact addresses be set to update primary address?

We do some snail mailings. We get back NCOA (National Change of Address). I do an import update to get the changes back into the database. The problem is, as far as I can tell, you can't update ...
1
vote
2answers
23 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 ...
1
vote
1answer
32 views

Converting My Data to CiviCRM data formats

When importing data into CiviCRM, do I need to reformat my data in any way so that it is in conformance with CiviCRM data formats?
1
vote
2answers
192 views

Where is “Unique ID (OpenID)” and how is it used?

I am preparing to do an import of a lot of data, and I want to properly map my data into CiviCRM. This is primarily for event participants of various kinds, so I exported the basic participation data ...
1
vote
2answers
45 views

Why can't I import Individual Prefixes into the database?

When importing, Induvidual Prefixes don't seem to "take" and apply. Why is this, and how does one get around it?
1
vote
4answers
54 views

List of fields and explanations?

I am working on importing information from our current donor database to Civi. Is there a table that lists the field names within each table and an explanation of what that is? Specifically I am ...
1
vote
2answers
57 views

Clear data from supplemental address on update

When I import cleaned postal data and the supplemental address information has moved to the first line of the address, the supplemental address data does not clear, even if I put a space in the field. ...
1
vote
4answers
81 views

How can I import e-mails to CiviCRM?

I would like to be able to select and import one or more e-mails from my external inbox, into the Activities of a Case, creating a new activity. Is this possible and if yes, how? Who is familiar with ...
1
vote
1answer
136 views

Importing Custom Field Checkbox Data

I have setup a custom field with 4 options. In my spreadsheet I've tried various combinations of columns which would allow me to import data and select required options. But nothing is working! ...
1
vote
2answers
53 views

Can I import contacts from Outlook into CiviCRM?

Is it possible to transfer a contact list from Microsoft 365 Outlook to CiviCRM using a csv. File? I don't understand this formating business, it's a simple enough question.
1
vote
2answers
69 views

Imports timing out

I'm having troubles with large imports of any sort (contacts, memberships, etc.) if the file is too large (over 2000 rows) the operation seems to time out. The import stops and the wordpress login ...
1
vote
2answers
69 views

Is it possible to move data from a contact type to a component/extension?

I'm still figuring out how to organize our organization's data before importing it into CiviCRM. One question that came up is whether it would be possible (through the UI or through SQL) to move some ...
1
vote
1answer
23 views

Field Source doesn't appear in Import Contributions

I'm trying to import contributions. I found all the fields except the "Source" field. Is there any reason for not appearing? Is there a way to show it? Thanks in advance. :)
1
vote
1answer
77 views

help needed in importing multi value custom fields

For the below custom fields, suppose a contact has two UG degrees B.Tech, BBA and two PG degrees M.Tech and MBA, I want to add additional set of custom field set, and then add the second degree. Like ...
1
vote
1answer
71 views

Custom Fields are not showing when trying to import a CSV

I have created some custom fields. I am trying to import contacts with values for those fields. But the fields are not showing up during the step 2 "matching civicrm field" though other custom fields ...
1
vote
1answer
45 views

How do I import both student and parent information together?

I am trying to find out how to import student and parent information at the same time. I have seen instructions about importing student and then adding the parent information afterwards, but I have a ...
1
vote
1answer
34 views

Where are the saved import mapping configs stored?

I have been working on a local CiviCRM install to test importing contacts from a CSV file to the Civi contacts. I am ready to move this import process to our hosted test site but would not like to ...
1
vote
2answers
178 views

Import from one db to another fails

I exported all the civi tables from one database and saved as a sql file, including a droptable statement. I then tried to import the data into a fresh site with brand new civi installation. The ...
1
vote
1answer
20 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 - ...
1
vote
2answers
51 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/...
1
vote
1answer
46 views

Import Contacts creating dupes despite dedupe rules

We are currently updating a member database with returning and new students/contacts. In the past we have been able to import lists updating the returning students, but now new duplicate records are ...
1
vote
1answer
58 views

Add contacts to group using CSV with contact e-mails

I'm looking for a way to add contacts to a group from a CSV file including e-mails of contacts already existing in Civi. When I import into Civi, I use the update option and select primary e-mail, and ...
1
vote
2answers
63 views

How do I use import and export php classes with aegir?

How do I use export.php and import.php to work with multiple sites run with Aegir. All of them share the same files (php classes) and when I specify the site with -s mysite.org I get nothing (...
1
vote
1answer
20 views

Pay Later status on imported contributions

I am trying to do a bulk import of transactions that are all being invoiced now. By indicating the Contribution Status as "Pending," the transactions all import as "Pending (Incomplete Transaction)" ...
1
vote
2answers
35 views

CiviCRM API V3 : Translate Two Digit State to State_Province_id?

I'm using civimigrate for a pretty intense migration into CiviCRM and I have hit something of a puzzler. I have a table with addresses that I am matching to contacts, but I cannot seem to find a way ...
1
vote
1answer
65 views

Import – match to contact by email without creating duplicate email address

Is it possible to use the import function for contacts and match by email, without creating duplicate email addresses for existing contacts? Example: We organize frequent webinars with participation ...
1
vote
1answer
50 views

How can I avoid my import crashing with a Fatal Error due to an existing external ID?

I've had a few separate imports crash with a fatal error in the last month: Sorry but we are not able to provide this at the moment. DB Error: already exists Fatal error: Uncaught ...
1
vote
1answer
54 views

Import participants with fee levels and price sets

Is there any information available on if it is possible to import event participants with price sets, and if so how? There is a field in the field matching that says "Fee Level" but I am not at all ...
1
vote
1answer
28 views

Batch edit one contact field (source) with same information

I have over 50,000 contacts that I would like to batch-edit with the same contact "source" information. What is the best way to do this?
1
vote
1answer
55 views

How do I get csv file of Gmail contacts to import?

I am trying to import a Google Apps Contacts list in csv file format. I go through the steps; it goes through the motions of importing the file, but no contacts are added. We're running CiviCrm 4.7.8. ...