Questions tagged [import]
The import tag has no usage guidance.
1
vote
0answers
10 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
78 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
15 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
17 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
53 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
26 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
16 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
37 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
24 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
19 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
34 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
49 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
17 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/...
1
vote
2answers
65 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
49 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
40 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
27 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
26 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
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'...
0
votes
2answers
59 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
39 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 ...
3
votes
2answers
111 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 ...
4
votes
2answers
89 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
48 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
20 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
36 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 ...
1
vote
1answer
51 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 ...
3
votes
2answers
35 views
Is there any way to import files into a custom field for uploaded files?
Is there any way through SQL commands, to import files into a custom field? E.g. photos of contacts?
0
votes
0answers
62 views
API CSV Import extension not work since 4.7.30 upgrade
I am trying to import Entity=Activity (so can set assignee).
I had no problem a few weeks ago before the upgrade (from 4.6.x).
The import preview now complains on all rows. When I download the error ...
0
votes
0answers
164 views
PHPMyadmin export and import drops indexes
In the process of upgrading a CiviCRM db from 4.7.24 to 4.7.31 I created an export of the db to a text file.
The upgrade did not complete and so I decided to do it over. But after emptying the db and ...
3
votes
1answer
44 views
Can you import data from Excel or WORD directly into CiviCRM?
We have donor lists in Excel--can that data be imported to CIVICRM?
0
votes
0answers
26 views
How do I append city/state to existing “type individual” zipcodes?
I have 18K Individuals with Name, Email and Zip. How do I Update these records with the USPS database which will append city, state and lat/long. I have tried importing the USPS database as an UPDATE, ...
1
vote
2answers
53 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
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
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
1answer
21 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. :)
0
votes
2answers
22 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
65 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
119 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 ...
1
vote
1answer
31 views
Smarty causing contact import to fail
I have CiviCRM 4.6.28 on Drupal 7.56, hosted on Pantheon.
We are trying to import lists of contacts, but anything above 250 contacts throws a timeout error, due to Pantheon's time limits. The time ...
3
votes
1answer
20 views
Are there any tricks to importing contact data if you include a column for 'is_deceased'
Are there any tricks to importing contact data if you include a column for 'is_deceased'?
I am asking primarily so I can answer and give others a warning!
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 ...
2
votes
0answers
48 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 ...
3
votes
1answer
37 views
Using API csv Import GU"I extension for Pledges
I have a number of Pledges that need to be loaded and was hoping the the extension would allow me to create a csv file and import the pledges in bulk. A separate line was created for each 'payment' of ...
3
votes
2answers
80 views
Failed to import contacts into groups (with csv import) [duplicate]
I have contacts belonging to different groups.
I made a first csv import successfully : I have all data of contacts and they are all in the same big group.
But then I tried to import them group by ...
1
vote
2answers
31 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
24 views
How can I easily import data from external sources like Stripe while dealing with subtle differences in field values?
Here's a specific example. When I export data from Stripe, there is a Status column with the value Paid. This obviously corresponds to CiviCRM's Contribution Status field. However, CiviCRM doesn't use ...
0
votes
2answers
56 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 ...
1
vote
1answer
43 views
Cannot get the import of employer-employee relationship to work
I have successfully imported all my organisations and I'm now trying to import my contacts which are employees of these organisations. I've read the relevant sections in the CiviCRM cookbook and the ...
