Hot answers tagged

6

I was able to create a script to revert in bulk. I needed to look up the log_conn_id value associated with the bulk change I made. I made the change using the API import, but any change that happens in a single connection can be reverted. Simply change the value of $log_conn_id in the script below, and change $tablesToRevert to include the table(s) that ...


5

Make sure you have 'Pay Later' Column set to 1 and Status column set to 'Pending' for the contribution rows that are pending from pay later. If you don't have status column that its set as Completed by default


4

In case it helps anyone, this is what I did: Initial set-up: - a working Joomla site, with Civicrm and Joomla tables in the same database - a separate installation of Wordpress on the same server (articles and static content already imported from the Joomla site and redirects set up as required) Aim: migrate the Joomla Civicrm tables and data to the ...


3

Since Imran is on CiviCRM Spark, I had a quick look at the issue. I think it was caused by the field mapping, where the import was trying to import the "Contribution Status", but there wasn't a status for "paid out", causing the import to fail. So I changed the import mapping to ignore the import status (since the file only completed contributions), and it ...


3

How large is your import? It seems to happen on larger imports and this has occurred on and off in Civi for some time in my experience. Something is causing it to hang. You can still get to the summary page by replacing Preview with Summary in the URL. That will show you any records that could not be imported, etc. You can also look at MySQL and check that ...


3

We had a similar problem importing from an old (non CiviCRM system) and I wanted to make the old membership numbers the Contact ids on the new CiviCRM system. Fortunately membership numbers 1 & 2 were not in use so no clash with the initial admin and organisation contact records. There were some gaps in the old membership numbers and I was also quite ...


3

You need to choose 'Update' for 'For Duplicate Contacts' option on the import screen if you want to update the contact using import. Cheers Pradeep


3

It's not a direct answer, but this looks like a pretty quick and suprisingly awesome way to convert to csv: https://www.hostpapa.com/knowledgebase/convert-vcf-files-csv-email-contacts/ EDIT: in case above link goes bad: In windows all users have a C:\users\your name\Contacts folder. If you navigate there in windows explorer the ribbon gives you an import ...


2

In the absence of clear error information, I went into trial and error mode. I disabled each mapping in turn. In the end, I found it was the attempt to import "contribution status" that triggered the failure. It is likely that the contents didn't match required values in the database. Though, in this case, the error message seemed to have nothing to do ...


2

Welcome to civicrm stackexchange. Couple of options here. One option is to split your file into smaller chunks. If you have the ability to alter the php settings on the server you can change these to increase the time over which the import can run the option you probably want to look at is max_execution_time - in your php ini file. Depending on your ...


2

That's almost certainly a timeout issue - you can increase your timeout in php.ini, but I wouldn't use the UI at all for a million contacts. Consider using a command-line import, where there should be no timeouts. There are several approaches you can take. Use the command-line API CSV import. This is pretty solid but you need to import each file multiple ...


2

It seems a probable bug. I ran an import of a file containing same field as my custom field and the field was updated by the information mentioned in csv and did not retain its default value. So, Yes, the issue was replicated. The value of custom field is only retained when we create a contact through CiviCRM and not importing, so it looks to be an ...


2

The issue was unrelated to the log error, which we will debug at a future time. The problem was caused by my preferred use of a semicolon ";" as a delimiter instead of a comma ",". I frequently use the semicolon because clients frequently include commmas in names and addresses. Apparently this disambiguation was a problem for the CSV Import Helper.


2

Was this all driven by wanting to move from Drupal to WordPress? If so, you can do this at the database level since most of Civi's data is independent of the CMS. See https://docs.civicrm.org/sysadmin/en/latest/misc/switching-cms/switch-cms/


2

We use the Form Processor at a few of our clients for scenario' s like yours. In most cases we use this in a configuration with CiviCRM on another server and outside traffic (including the Form Processor API request) coming in through CiviProxy (https://docs.civicrm.org/civiproxy/en/latest/). For this we use the CiviMRF framework (https://github.com/...


2

I have submitted a PR for this issue. Can you please try applying patch from here? Thanks Pradeep


2

Export the records from MS Access into a csv file and than import it into CiviCRM using CiviCRM UI import like Contact, Contribution, Membership etc. You map those contact using external identifier for reference.


2

This has been answered before indeed: noob query : Importing contacts and membership and here: https://docs.civicrm.org/user/en/latest/membership/manual-entry-of-memberships/ Thanks for the exchange:-)


2

It turns out that the field 'email contact' when importing is actually contact id. So there you go!


2

The "normal" import tools tend to focus on a single entity (contact, contribution membership, participants...) indeed, so as you identified, it needs several separate imports and trying to find some common keys so civi knows how to link them If you have complex/composite structures to import, it might be easier to write a simple php script that calls all ...


2

API explorer says "Activity Assignees". And as noted in comment it must have the upper case A's.


2

Apart the right answer of Pete (thanks) here above, I have found something else who explain the problem I have : I had two relationships in my import scheme: the one for the "Member of" relation and the second for the "Employee of" relation. This cannot work... and I need to make two separate imports for each relation.


1

Deleting the custom fields sets and creating them again solved this issue. :-{


1

Assuming your location types and phone types etc have the same ids, you should just be able to copy over the two tables, mysqldump <dbname> civicrm_mapping civicrm_mapping_field > somefile and then import the file into the other site's mysql database. But note that will **** OVERWRITE **** any mappings that you had already set up in the new site. ...


1

You can create profile with the fields you want to updated and then use bulk update action from search action to update multiple records. Doc: https://www.cividesk.com/blog/post/batch-update-using-profiles Thanks Pradeep


1

To get that field to appear in the dropdowns, then on the first page of the import steps you need to choose Update or Fill for "For Duplicate Contacts".


1

Importing contact and its details involves more efforts unless you don't want historical data of the contact like contribution, event registration, activity etc. Would suggest to use the same database for your wordpress and clear CiviCRM cache. The menu items position may differ based on how old is your CiviCRM compared to newly fresh installed CiviCRM but ...


1

As I understand your question you want to import existing data with the form processor. Is that right? If so it is possible because the form processor creates an API in CiviCRM and this API can be called with REST from external systems. The API entity is FormProcessor and the action is the name of your form processor. You need some bit of custom ...


1

Maybe, the easiest way is, to open the csv in Excel (or LibreCalc) and do some magic with formulas? Something like =SUBSTITUTE(C9;".";"/") Or even much easier: Open the file in Excel (or LibreCalc) and do some search and replace in the column? That's the way I would do it, if the file isn't to big for Excel and it isn't a work I had to do every day.


1

Note that if you have advanced logging turned on, there's an option to revert - though changing an import would require you know the names of all the tables touched by the import. See the script on this answer for doing the reversion. The tables you'd revert would always include civicrm_contact, but also potentially civicrm_address, civicrm_email, ...


Only top voted, non community-wiki answers of a minimum length are eligible