Questions tagged [import]

The tag has no usage guidance.

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

Could not load settings file at: 4.7.0 wordpress

I tried to load my contact to civicrm using the command line however was i tried to execute the import.php i received an error"could not load the settings file at: i tried to further investigate i ...
1
vote
2answers
66 views

Importing and updating pledges

I want to import a bulk pledges to my CiviCRM installation and also I need to updating the pledges in every month. If I do it in manual it is very time consuming process. is there any easy way like ...
1
vote
1answer
84 views

import contribution

I try to import contribution. Procedure - Contribution - import contribution - import the .csv list Error "is not a valid option for field campaign_id" Where do I find the campaign_id? thanks
1
vote
2answers
62 views

Why external ID removed in membership import in update mode?

During Membership import in update mode externalID available in civicrm 2.0 and it seems that it is being removed in CiviCRM 4.6.7. As I have a csv file to import membership with only externalID ...
1
vote
1answer
25 views

Bulk assign contribution page based on contribution type?

Issue: We migrated about 5000 contacts from one CRM to CiviCRM. The organization required historical data to be moved over, but also changed their membership pricing scheme which has been resolved ...
1
vote
1answer
46 views

Importing contributions with soft credits fails with spurious email error

I'm trying to import some contributions. Each contribution has a soft credit field which is an email address. I've set the field mapping to Soft Credit / Email / Solicited. All the rows are failing ...
1
vote
1answer
102 views

Contribution import fails for all records with error “No matching Contact found”

I successfully imported contributions from csv files, up to 4.6.3. Now when I try to import using the same saved mapping, in Joomla with 4.6.6, every record fails with the error No matching Contact ...
1
vote
1answer
61 views

Why after importing contact records were Addressee field values set to “Customized” for records where Custom Addressee had a null value?

I imported a large group of organisations into a sub-org group "Media". Some orgs had a specific generic addressee (ie, Editor) which I imported into the Custom Addressee field. After import I ...
1
vote
1answer
16 views

What might cause an Contact Import to only import core data and not import custom data

Asking this mostly so I can answer it in case it helps others. I had been provided a csv that was doing as described in title ie it had both custom and core fields in it, and the core date eg First, ...
1
vote
0answers
8 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
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 ...
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 ...
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
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/...
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
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?
1
vote
0answers
40 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 ...
1
vote
0answers
29 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
31 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 ...
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 ...
1
vote
0answers
16 views

No import for existing contact

When doing an import for existing contact that I want to update, after selecting Fill (For Duplicate Contacts), I get a Warning, a Notice but no import : Warning: array_pop() expects parameter ...
1
vote
1answer
26 views

OCR for Photo IDs?

I would like to set up an instance of CiviCRM to help independent candidates register to run for office in Indonesia, and one requirement here (like many other countries) is that a candidate has to ...
1
vote
0answers
71 views

Error importing contacts - for key 'UI_external_identifier'

I am having an issue when trying import contacts into civi. We have imported many contacts before but all of the suddden I am getting this error: Database Error Code: Duplicate entry '0385611' for ...
1
vote
0answers
36 views

Add source to all contacts when importing a CSV File

Question in German Wir möchten eine CSV Datei mit Kontakten einer Gruppe hinzufügen. Dies ging auch mühelos.Das einzige das nicht funktioniert hat war diese neue Adressen die Bezugsquelle hinzu zu ...
1
vote
1answer
967 views

Can you share an example of a complex .CSV file for import?

I'm looking for structure information on complex .CSV files that have custom fields, relationships, groups. I'd like to get a better sense of best practices for organizing data ahead of time. If you ...
1
vote
0answers
35 views

importing contacts

I am trying to import 714 contacts to the system. I am able to do it but before the final DONE click it shows 445 total number of rows in the imported date and 1251 total number of contact records or ...
1
vote
0answers
56 views

CiviCRM Member Import Tool Issue

We are attempting a CiviCRM Member import for a client on CiviCRM 4.6.12. The import starts to run but then fails saying no memberships were created. Nothing is logged to the CiviCRM log file. The ....
1
vote
0answers
74 views

Country custom field import error

I have a custom field called "Nationality" of data type "Country". It doesn't accept any kind imported values. I tried with "United States" and "US", it doesn't give an error but it doesn't import ...
1
vote
0answers
45 views

How to import existing membership records

I am trying to import some old and existing membership but fail, which only the start date on 2015 can be imported. In my xls, the other membership records on 01/01/2008, 01/06/1991...etc are all ...
1
vote
1answer
64 views

Why are Activity Imports failing with error message “source contact id not valid”?

I'm running a monthly activity import into a site (4.4.13) [I realise it's due an upgrade to LTS] We have a standard csv tempalte, and existing field mapping. And have been using the same method ...
1
vote
0answers
7 views

Importing and collecting openids

We use CiviCRM 4.6.9 with Drupal 7, and our members login via OpenID. No problems there. However, we have found since we went live about this time last year that the OpenID values are not being ...
1
vote
0answers
23 views

Get error msg from Manager.php

I'm new to CiviCRM, just installed 4.6.5 on my Joomla 3.4.4 testsite. Other software levels: PHP: 5.5.18 MySQLi: 5.5.36 I tried to import contacts, 980 in total, using a .csv file. There are no ...
1
vote
0answers
28 views

Membership import - is there any column heading that will automatically match internal identifier?

I've tried all sorts of things and can't find any column heading for the cvs that will automatically match internal identifier. One would think that if you use what comes up when you manually match ...
1
vote
0answers
68 views

CiviCRM Import contacts only adding some to groups

I have to csv files with organisation contacts in them, when I import a group of contacts it says it has created all the contacts, but will only add 300/350 or 160/240 into the group. I receive no ...
1
vote
0answers
329 views

Problem importing CSV contacts

For reasons too stupid to relate here, I am trying to Export my entire Contacts file from the operating, on-line Drupal/Civi setup as a CSV to my desktop -- no problem. When I try to Import this CSV ...
0
votes
3answers
824 views

CiviCRM 4.7 - DB Constraint Violation - possibly dashboard_id should possibly be marked as mandatory for this API

We have moved our hosting to new hosting provided (CiviHosting). CiviHosting installed a fresh installation of CiviCRM 4.7. We then imported our previous sql dump from our old site which also had ...
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 ...
0
votes
2answers
135 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
32 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
56 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
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
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 ...
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 ...
0
votes
1answer
55 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
2answers
77 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
51 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
21 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
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....
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 ...