Questions tagged [import]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
70 views

How to Transfer Big Data to a Different Domain

I received a SQL error while updating CiviCRM. He asked me to restore the old database, but I didn't have a backup at the time. Therefore I could not make a healthy update. Then I applied all the ...
1
vote
0answers
6 views

API csv import unable to import addresses

I am importing a large dataset using the API csv import extension. I have imported the custom fields, contacts, email and phone numbers using the different entities. I have tried to import the address ...
1
vote
1answer
20 views

Importing contacts into Civicrm

I am importing 350 contacts into Civi. This post says that you should always include an import identifier. I don't have admin access so I cannot create a custom field set. I was going to identify the ...
0
votes
1answer
41 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
1
vote
1answer
18 views

Problem importing Civi Volunteer Needs

We are working importing Volunteer Needs for various Volunteer Projects via the API csv Extension. When we load the interface, select the entity 'VolunteerNeed' and select file. When we hit continue ...
1
vote
1answer
13 views

Importing Gift Records

Does anyone know here know how to import .csv files containing contribution information? I know how to import constituent records but don't know how to import their gifts.
2
votes
2answers
32 views

Importing Relationship Data

I know this should be straight forward, but somehow I seem to struggle. Importing a child-parent relationship. I have 10 children records (External ID, Child Name, Child Surname) and 5 parent records (...
3
votes
1answer
57 views

Expected one Contribution but found 25

I am importing contributions from my donors from a .csv file. I have tested the process using a simple .csv file with one row of data for a payment from a donor I have already added to contacts. The ...
2
votes
1answer
36 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 ...
1
vote
2answers
33 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 ...
1
vote
1answer
26 views

API CSV Import -> for ActivityContact -> invalid value for record_type_id

Using API CSV import to try add entries to the civicrm_activity_contact table -> running out of ideas as to what I need to use for record_type_id (see screenshot) - any other ideas are welcome! Trying ...
3
votes
2answers
89 views

Error uploading CiviCRM contacts. Can I revert?

Does anyone know how I can revert a contact import (via the upload contacts script included in the site). The process included merges with existing contacts.
5
votes
1answer
65 views

How can I revert a set of bulk changes to the database?

I made a bulk update of addresses that turned out to be incorrect. I have advanced logging enabled. I can go into each contact's change log and revert the mistake one by one; how can I do this for ...
1
vote
1answer
23 views

Importing using API CSV importer

I am importing a large dataset using the API CSV importer extension. The data needs to be divided into 3 chucnks - contact, address and email. The second two imports I was planning to match up with ...
0
votes
0answers
15 views

Import Contacts to CiviCRM using SQL query

How to import contacts to CiviCRM using SQL query? It should include the Group name too. I have a huge database need to import in CiviCRM, currently getting timeout error if I upload more than 1000 ...
0
votes
3answers
439 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 ...
1
vote
1answer
29 views

Importing Contacts, Memberships and Contributions in 2020

I need to import from an external database 1500 contacts with their memberships and contributions. Everything I read about it in Stackexchange was written between 2015 and 2017. Is the following ...
1
vote
0answers
19 views

Misleading behavior when importing activities

This is on CiviCRM 5.24.1, just installed. The behavior of the Import Activities page is odd. On the Preview page, Step 3 of 4, the buttons Previous, Import Now, or Cancel are displayed. However, no ...
2
votes
1answer
19 views

Import Contribution - last step no longer goes to 'Summary / Error' report

We recently updated to CiviCRM 5.23.1 In the prior version when running it would run through the 4 documented stages 1. Upload Data 2. Match fields 3. Preview 4. Summary But in 5.23.1 the ...
0
votes
1answer
29 views

Custom fields not showing in import and export filter

I have two sets of custom fields related to two sub-types of the same type (organization). Both profiles are active and I can see the custom fields in the contact summaries and in the advance search ...
2
votes
1answer
26 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....
0
votes
1answer
21 views

Advice for moving from Access to CiviCRM

Our client has asked us to move them from a legacy MS Access based membership system to CiviCRM (on Drupal). Their existing system encompasses many years of memberships, accounts, academic records etc....
1
vote
2answers
227 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 ...
2
votes
1answer
29 views

Migrate Import/Export Mappings

Is there a way to migrate the saved Import/Export Mappings to a different CiviCRM installation? It seems there is no way to export them. I already tried copying the .php files located at /bin/migrate, ...
0
votes
1answer
29 views

How to import members spreadsheet

I'm new to CiviCRM and have a somewhat noob question about importing membership data from a spreadsheet. We have this data in a way that each row is a company with organizational data (membership type ...
1
vote
1answer
32 views

Expected import behavior when setting custom field to view only

Checking this option in a custom field View Only? Is this field set by PHP code (via a custom hook). This field will not be updated by CiviCRM. I had read that it would not update upon import. ...
1
vote
1answer
19 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 ...
1
vote
3answers
89 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 ...
0
votes
2answers
45 views

Rebuild Drupal Civi from scratch in WordPress

My situation is I have an Individual database of 11,344 Contacts in Drupal Civi, and I want to turn them all into WP Users. I know I can convert Users into Contacts, but I want to do it the other way ...
0
votes
2answers
20 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 ...
1
vote
1answer
18 views

Bulk Un-checking

I wanted to know if there is a way to un-check a section in individual contacts in a bulk size way rather than going into each individual contact and un-checking the section i need un-checked.
5
votes
3answers
191 views

Scanning business cards to CiviCRM

Anyone working on creating an app to scan a business card and have that information transfer to CiviCRM? Or ideas for how to create this? Thank you.
2
votes
1answer
35 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
votes
1answer
48 views

Contact Import German Date Format support?

CiviCRM 5.20.2/WP: My system is using german locale. The contact import does not offer german date format "dd.mm.yyyy", even it is set for birth class in the date settings (dd.mm.yy). How can I get ...
3
votes
1answer
31 views

Importing VCF files

I’ve got a client with a fair number of Contacts on his personal computer in VCF format. I’m curious if anyone has looked at importing VCF files into CiviCRM?
2
votes
1answer
43 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 ...
2
votes
1answer
43 views

script cli code for importing contacts in civicrm

Can some one give a code to how to import contacts in civicrm by using script line command. I a have a 45000 contacts and importing from civicrm interface i am getting gateway timeout error. I need ...
3
votes
3answers
120 views

Default values for Preferred language, email format, email greeting, postal greeting and addressee

we are in the process of setting up CiviCRM and we are importing a lot of records from a previous CRM. when we do the import, the preferred language defaults to english. how do we get this to be a ...
1
vote
0answers
25 views

unexpected 500 errors and networks errors

We have a standalone install of CiviCRM Spark, version 5.16.beta1. This is hosted with civicrm.org. We have imported our contacts, which total about three or four hundred. We are, however, unable to ...
1
vote
0answers
29 views

PHP Date format not available in CiviCRM

I'm hoping someone can help me with a date problem. I'm importing contacts from my Drupal 7 build and our member's birth dates are not showing up. The short custom code as per the php manual is m/d/Y ...
4
votes
3answers
110 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:...
4
votes
2answers
113 views

Setting primary email and phone upon contact update

We want to update a bunch of contacts with e-mail adresses and phone numbers, for which previously these did not exist. The import works fine, as a result the contacts now have a Home (for example) e-...
2
votes
1answer
74 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 ...
4
votes
1answer
51 views

How are long jobs handled, e.g. Contact import

I'm trying to understand what happens with an import. A file gets uploaded in a POST operation, then there's GET requests polling(?) of civicrm/ajax/status?id=somelongid Which request does the work? ...
4
votes
1answer
24 views

Importing contacts and adding to a group also adds contacts with imported relationships to the same group

I'm importing a CSV of contacts with a relationship to other contacts and adding the new contacts to a group. To my surprise, the group ended up with more contacts than I had imported. I saw that all ...
3
votes
1answer
48 views

What causes this error on importing email addresses?

I'm getting some (maybe 5%) email address imports rejected with the message "Matching this contact based on the de-dupe rule would cause an external ID conflict" The email addresses in question can be ...
1
vote
0answers
33 views

DB error: no such table while importing

When importing, we get this error: /wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(192): CRM_Core_Error::backtrace() #1 /wp-content/plugins/civicrm/civicrm/vendor/pear/pear-core-minimal/src/...
0
votes
1answer
19 views

Importing Notes with external identifier

I'm trying to import notes into CiviCRM with only an external identifier. Inside the current database, the contacts are already assigned these external identifiers correctly within CiviCRM. I was ...
1
vote
0answers
35 views

how to import/Export data from old version to updated version of CiviCRM

recently I have updated my CiviCRM Plugin in Wordpress.Now how can I import/export data of the old version to the new version?
3
votes
1answer
34 views

Import/export database from old CRM version(5.4.0) to New CRM version(5.15.2) in wordrpess

Currently I am using Civi CRM (5.4.0) and want to upgrade it. I downloaded new version and installed it in my wordpress website. I had a separate database for CiviCRM. When I installed & ...

1
2 3 4 5 6