Questions tagged [import]
The import tag has no usage guidance.
263
questions
1
vote
0answers
23 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
18 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
14 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
29 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
20 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
27 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
16 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
46 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
25 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
30 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
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
71 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
73 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
96 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
32 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
50 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
31 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
27 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
28 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
38 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
29 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
22 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
24 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
90 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
22 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
26 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
29 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
31 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 ...
3
votes
1answer
42 views
Is there a simple way to import recurring SEPA mandates that have been processed outside CiviCRM previously and should now be managed using CiviSEPA?
In the CiviSEPA Setup Instructions there is a section regarding importing SEPA mandates, but instead of an answer there is a question... (similar to the one I am asking.)
I have been checking the ...
3
votes
1answer
29 views
How do I locate the Financial Type ID?
I am trying to import hundreds of contribution records and it is requiring I include the Financial Type ID when importing. Simply having the word Donation is not enough! When I visit Administer - ...
0
votes
1answer
24 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 ...
2
votes
2answers
40 views
Contacts visible in mailing list group, not on hold or otherwise dnd, but skipped by mail out
I'm fairly sure I've worked out why this is happening, but want some input to confirm the problem, and hopefully pointers for fixing it.
We totally refreshed our main mailing list in line with GDPR, ...
1
vote
1answer
52 views
Importing membership custom field keeps failing
I'm having problems importing memberships with a custom field. I'm able to import a alphanumeric text field without an error, but a second custom field, set up as a checkbox, keeps being rejected.
...
5
votes
1answer
19 views
How to import time with date
Importing the date works correctly, but the time shown is always 12:00 am even though the import field is, for example 02/07/2018 11:31 am. I tried various formats like the previously mentioned 02/07/...
4
votes
3answers
96 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:...
0
votes
0answers
98 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 ...
1
vote
2answers
67 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/...
2
votes
3answers
32 views
How can I set the maximum number of processes?
I thought I had a fix, but I'm still getting a 500 error on importing a batch of 16 organizations. Host tells me CiviCRM is spawning more than 30 processes, which is the host's limit.
Trying to get ...
2
votes
1answer
29 views
Import exceeding max. number of processes on host
Getting a 500 error on importing CSV content. Consulted with web host, who found the cause of the 500 Internal Server Error. When I click on the import more than 30 processes is spawned from my ...
2
votes
0answers
24 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'...
0
votes
2answers
106 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 ...
1
vote
1answer
50 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 ...
6
votes
3answers
149 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 ...
5
votes
2answers
125 views
Import Contacts with dedupe rules
Recently I have encountered a problem related to the import of contacts and has to do with the dedupe rules.
When you import a list of contacts through a CSV file and select a dedupe rule, the CRM ...
0
votes
4answers
65 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
1answer
31 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
50 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 ...
