Questions tagged [import]
The import tag has no usage guidance.
282
questions
1
vote
0answers
6 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
16 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
24 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
12 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
17 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....
0
votes
1answer
26 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 ...
2
votes
1answer
25 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, ...
1
vote
1answer
31 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. ...
0
votes
1answer
10 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
61 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
40 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
15 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.
2
votes
1answer
48 views
Expected one Contribution but found 2
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
33 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
35 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
29 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
38 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
33 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 ...
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
23 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 ...
1
vote
1answer
17 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 ...
2
votes
1answer
46 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
23 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 ...
1
vote
0answers
29 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
17 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
1answer
59 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 ...
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
vote
0answers
33 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
40 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? ...
1
vote
1answer
72 views
Import contacts: can't get past the “Choose Data Source” screen
I am trying to import contacts into our database from a CSV file. On the first import screen, "Choose Data Source", I have set the data source to CSV, picked the file, ticked "first row contains ...
1
vote
1answer
77 views
Meaningless error report when importing multi-value custom fields
I'm trying to import some multi-value custom field and I am getting what is clearly a badly formed error message. I've eliminated most of my errors by careful perusal of my import data and correcting ...
2
votes
1answer
152 views
Need help with export.php (CiviCRM 4.6 & Drupal 7)
I'm using an older version of CiviCRM (4.6) with Drupal 7 on Linux and until now I've not really used the command line stuff for CiviCRM, only for Drupal.
But I now need to do exports & imports ...
1
vote
1answer
52 views
Batch Update the current relationship in CiviCRM
I need your help. I need to disable a current relationship for 4000 records in the import process without using SQL command line.
There is no field for set active/inactive or expiry date of the ...
1
vote
1answer
54 views
Problem Importing Contacts
I get the following errors while importing a contact CSV file. I hope somebody can help with the issue. Civicrm 5 latest with WP 5 latest and the error is same with both PHP 5 and 7.2.
"Sorry, due to ...
3
votes
1answer
40 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 ...
2
votes
2answers
28 views
How do I sync contacts who are not members in Wordpress?
My client organization only has organizational members, but provides services and events to individuals connected to the organization. The WP Member sync, seems limited to only syncing members.
I ...
4
votes
1answer
47 views
Has Contact ID been removed from the Contact Import “Matching”?
I have a v strong memory, and screenshot evidence that we used to be able to 'match' by including the Contact ID in the import.
This was discussed in https://chat.civicrm.org/civicrm/pl/...
0
votes
1answer
31 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 ...
1
vote
0answers
39 views
Monthly payments not updating for monthly direct debit
We have a number of members who pay in monthly instalments by direct debit, but recently the contribution page and the membership end date have not been updating. We have received the reports showing ...
0
votes
1answer
35 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
0answers
28 views
Participant Import: Mandatory key(s) missing from params array: line_total
I am currently trying to import a number of participants that registered through an external service. I first imported all the contacts - then proceeded to import particpants
The current fields I ...
1
vote
0answers
28 views
Transaction integrity error during contact import
I've been importing contacts all day without problems then suddenly I started receiving this error:
PHP Fatal error: Uncaught CRM_Core_Exception: [0: Transaction integrity error: Expected to find ...
2
votes
1answer
91 views
How to send confirmation when importing contributions
When importing contributions, on the 2nd page where CSV columns are linked to database fields, there is no field "send a confirmation". Is there a way to add this field (and generate a confirmation ...
1
vote
1answer
32 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 - ...
2
votes
1answer
32 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 ...
3
votes
1answer
61 views
Import Contact Issue
I am importing CSV files, about 7000 contacts per import, about 20 fields per contact, about 800kb sile size. DB size is about 55k, issue arose at about 20k. Since then, it times out after 2000ish ...
1
vote
0answers
31 views
Is there an easy way to export data from Drupal 7 to wordpress, non critical data, loosing data is fine
Is there a way to do a simple export/import as a CSV file from Drupal 7 to Wordpress?
Data is not critical, if I get the bulk of it it's ok, I don't care.
Drupal site has one single database shared ...
2
votes
1answer
35 views
Import Contacts from CSV
I am attempting to import a csv file that is both regular comma delimited and I have also tried one saved as CSV UTF-8 (Comma delimited). Each time I go through the steps, I get through the match ...
1
vote
1answer
17 views
Contact Import Longitude missing in mapping
I am trying to import contacts from one CIVI database to another however when doing the field mapping there is a map for latitude but not one for longitude. Am I missing something, if not is there any ...
