Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [import]

The tag has no usage guidance.

0
votes
2answers
75 views

Can I export full database and import it in a fresh newer CiviCRM version?

I am experiencing difficulties during CiviCRM upgrade from 4.7.14 to 4.7.31 or 5.1, namely, fields like contact.birth_date get broken. (More: DB Error after upgrading 4.7.x to 5.1 (Drupal)) I have ...
0
votes
2answers
31 views

Cannot find import in menu

I am running 4.7.8 but cannot find the option to Import from CSV for multiple choice options under a custom field - is this possible?. Any assistance would be appreciated. Thanks Steve
0
votes
2answers
48 views

Need clarification on switching CiviCRM hosting from a host/consultant

We are currently hosting with a company that also assists us with are CIVI Crm. We are interested in moving our site to a new host and would like to know if the CIVI will move with it? Without having ...
0
votes
1answer
48 views

Primary Emails not Being seen as primary

I have an a bunch of organizations we imported via csv. The email addresses are checked under the contacts summary as 'primary'. However they are not receiving emails and reminders and in search ...
0
votes
1answer
140 views

Page timeout on contact import

Drupal 7 CiviCRM 4.6.28 Hosted on: Pantheon I have a client that needs to import 15,000-20,000 contacts on CiviCRM. The problem we are running into is that importing any amount over 500 is causing a ...
0
votes
2answers
61 views

HOWTO reliably set default Country on Import?

We are trying to understand why importing contacts from CSV files with Address, City, State, Zip but no Country results in addresses with countries like Uruguay (for some CA residents), Yemen (for ...
0
votes
1answer
37 views

How to import check box field data?

How do I successfully import contact's check box field data? I am using civicrm 4.6.19 and importing from csv. I want to import the "is deceased" field and the communication preferences... Thanks
0
votes
1answer
20 views

ignored import file lines

I have a contacts.csv file with 4330 records. On importing, CiviCRM reports that the file has 1866 records. Separating the file into three files yields proportionately similar results. Why the ...
0
votes
1answer
2k views

What does this import error mean? “Invalid value for field(s) : … Country input value not in country table”

I am getting a crazy import error message: Invalid value for field(s) : Addressee must be one of the configured format options. Check Administer >> System Settings >> Option Groups >> Addressee for ...
0
votes
4answers
55 views

How can I import a list of contacts from MailChimp to the database all at once?

I am looking to import a list of 185 contacts from MailChimp to our database and wanted to know how I can do this in one go. As far as I know I have to export the list from Mail Chimp and then edit ...
0
votes
2answers
23 views

Where does Civi store membership and membership signup info?

We are moving to a new site, and when I tried to import our entire current Civi MySQL database to the new site, I had problems. So I have created a fresh database on the new site and want to try ...
0
votes
3answers
80 views

migrating civi database from current hosting to civihosting.com

We recently signed up for shared hosting at civihosting.com and want to move our current site there. Both sites are running CiviCRM 4.7.29 and WordPress 4.9.1. I cannot get into the CiviCRM ...
0
votes
1answer
50 views

Custom data field - problem with import

I have to import small quantity of contacts with custom date field. Field is set as rrrr (which should be filled with 4-digits year - 2017). Every single time, when this year is added in csv file I've ...
0
votes
2answers
22 views

Is there a way to preserve existing data when importing into multiselect and checkbox fields?

My use case involves lots of importing, and extensive use of multiselect fields (to track things like skills, interests, etc). Sometimes we get new information about, for instance, an existing contact'...
0
votes
1answer
89 views

Civi Event Participant Status ID

I'm trying to create a simple spreadsheet to import event participants, and need to add the Participant Status codes to import. Is there a list anywhere or which codes correspond to which statuses? ...
0
votes
1answer
54 views

How can I assign an External Identifier to each set in a multi-record import?

I'm importing education history for each Individual Contact, which can have from 0 to 5+ sets of multi-records. Each set of multi-records comprises [institution], [degree level], [degree name], and [...
0
votes
2answers
214 views

One of parameters (value: Array) is not of the type Integer - initially observed during import, but same when visiting Contact Record

As per the title - this message was observed first during an import, which failed. I re-imported with a 'tracker' field so i could see exactly where it failed. And rinsed and repeated. Found 2 records ...
0
votes
2answers
337 views

Migrate CiviCRM from Joomla to Wordpress

I don't even know where to start. I have been tasked with migrating an older version of CiviCRM (3.4.8) on Joomla 1.5 to a newer version of CiviCRM on Wordpress. I got a fresh install of CiviCRM done ...
0
votes
1answer
54 views

Error when importing contacts

I'm getting the following import error message when trying to import contacts: Invalid value for field(s): Geo code 1 Can anyone please explain? thanks
0
votes
2answers
59 views

Member since date is being updated on import but we dont want it to!

using CiviCRM 4.4.14. We're trying to update memberships with an import using data from a direct debit processor. In field mapping we're matching the pay out date to 'Membership start date', but some ...
0
votes
1answer
25 views

HTTP 500 error trying to import contacts

Running CiviCRM 5.11 plugin on WordPress. This is a fresh install. Running on a shared hosting service (Arvixe). PHP release is 7.1 The Import file is less than 10,000 records. One time, it was ...
0
votes
1answer
21 views

preferred language not importing with contact data

I have tried this several ways, but can't seem to get the preferred language to come in with the contact import. The initial values I had were basic (English, French, etc.) and didn't match the labels ...
0
votes
1answer
21 views

Importing Notes with Privacy / Privacy level for Notes

We have a client that wants to import private notes. (1) Is it possible to import note with privacy? There is not an option, when importing, to specify a particular row as "Author of"; any imported ...
0
votes
1answer
116 views

simple way to import membership and contributions together

What is the simplest way to import Membership information and corresponding contribution information together from .CSV files?
0
votes
1answer
36 views

noob query : Importing contacts and membership

I am going to freshly import data from excel into civiCRM. I have some contact related information like addresses, educational info, etc and also membership data like membership date, enrolled by whom,...
0
votes
1answer
18 views

Legacy SQL Activity and Contacts Dump Transfer

Because of the excessive problem that happened to me on SQL, I had to create a new CiviCRM installation. How can I transfer the existing Individual profiles and Activities in the old CiviCRM database ...
0
votes
1answer
35 views

all imports seem to geo code

I never check the geocode box when importing. Yet, I found that even small imports were taking a long time. I ran strace on the php process and saw lots of lookups to google. So I disabled both the ...
0
votes
1answer
184 views

How to delete Field Mapping

How do you delete field mapping you saved? Have done a lot of work and learning system and now built up a bunch I won't use again but can't find anywhere in guide/online how to get rid of them.
0
votes
1answer
53 views

Update contact's field to empty value

I have updated some contacts and during import there was a mixup in some fields, i.e. an individual's "Website" field was filled with the value of an Organisation's website. I want to set the value ...
0
votes
1answer
75 views

CiviCRM Multi-value Custom Data empty

My civicrm version 4.6.2. Drupal version 7.51. I visited on this URL of the feature to test is /civicrm/import/custom?reset=1 This feature was not working correctly, such that if a custom field set ...
0
votes
1answer
83 views

import contacts Sorry but we are not able to provide this at the moment

I am using Drupal 7.50 and Civicrm 4.7.11 and received Sorry but we are not able to provide this at the moment. I am trying to import from a csv, individual records, 200 at a time. I imported the 1st ...
0
votes
1answer
97 views

Import Multi-value Custom Data Fails for Household Contact Type

The "Import Multi-value Custom Data" fails when importing data into a multi-value custom field set that applies to only a Household contact type or Household sub-types. When the field set was change ...
0
votes
1answer
21 views

Import to Custom Field with Tab setting

I created a custom field with a Tab setting, but when I go to Import the custom field is not visible as an option for importing. Custom fields that are inline are visible. Is this a limitation or a ...
0
votes
1answer
22 views

How can I import custom data contact references as names rather than id numbers

When I try to export custom data from the front-end and export a contact reference I get the name of the contact rather than the id. But when I try to do the reverse and import an organization with ...
0
votes
1answer
56 views

api csv import - cannot find start page

I have installed the api csv importer https://civicrm.org/extensions/api-csv-import-gui I cannot find where the start page is. I have looked in read me which says civicrm/csvimporter/import ...
0
votes
1answer
63 views

How to import notes?

This might be a silly question - how do I import notes into existing contacts? I tried importing data to the Note field with the related Contact ID, which results in the following warnings - with no ...
0
votes
2answers
33 views

CiviEvent Participant Import

I have about 4,500 rows of participant that I would like to import. In each row is a column for the CiviCRM internal ID and columns for the requisite information about the event. When I upload ...
0
votes
1answer
22 views

Important Event Participants on CiviCRM 4.6.5 no longer supports external ID?

We've been importing event participation in 4.4.6 using their external ID (External Identifier). This appears to be no longer supported in 4.6.5. Any way to get this to function again?
0
votes
1answer
25 views

Details des imports contact evenement et activité

Bonjour, Où peut on trouver la dicumentation qui détaillent les dfférence entre les champ d'import pour les contact activiy et
0
votes
0answers
74 views

Help on Contribution import - Invalid value for field(s) : Receive Date

I've recently wanted to add the time to my import of external (non-Civi) transactions. Before this, I just imported the date, which is OK, but the data is there, so why not import it? I keep getting ...
0
votes
0answers
19 views

Correcting some values during import

I imported certain contact records. Somehow Civicrm filled the country field with country data of its choice for certain records. Now I would like to edit those records. I have exported the records ...
0
votes
1answer
44 views

Howto import CAMT053 XML with CiviBanking

Is somebody importing CAMT053 XML from ING or another bank? We want to import bank statements from ING, a Dutch bank. ING can export to CSV, but that export does not contain postal adresses. The ...
0
votes
1answer
28 views

Hard coding data during import

I'm trying to import some contribution information from our payment processor and need to specify a "financial type" for the Civi Contribution (A mandatory field). Unfortunately, this information ...
0
votes
2answers
77 views

Importing Events

Is it possible to import Events? And if so, where do I start? I've not done anything more advanced than use the CiviCRM UI for imports before now.
0
votes
1answer
33 views

Batch merge error - wrong data type money?

I'm trying to clean up some duplicates using the batch merge tool, and it keeps showing this error: [Error: Processed 2 pair of duplicates out of 9] value: null is not of the right field data type: ...
0
votes
2answers
180 views

Custom Fields not importing into contacts database

Having an issue where I'm trying to import a series of CSV files into the Civi Contact Database. There were new custom fields created to do the import, but when I do the import with all the fields, I ...
0
votes
0answers
88 views

Civi isn't finding matching contacts when importing contributions

I'm trying to import contributions from another source, and Civi gives me a "no matching contact found" error for each record. I've checked my csv data, my Civi data, my field mapping, and my ...
0
votes
0answers
44 views

404 Error: Not found while Importing Contacts

I'm migrating from one host service to another. We've installed the newest version of CiviCRM on the new host, DreamHost. I'm exporting contacts from the old CiviCRM database and importing them into ...
-1
votes
2answers
67 views

Contacts update [closed]

I have problem updating contacts data. I know it has to do something with Dedupe rule that I have to use but I don't know how to ensure myself that I won't have duplicates.