Hot answers tagged

4

Confirmation sending can't directly from import. There ARE ways to do it, but it slows down the import considerably, so I'd recommend doing it separately. Here are your options: Bulk confirmation When importing, have an easy way to search for the contributions that were just imported. Perhaps that's already possible because of your data. If not, add a ...


3

I figured it out. The CSV file was malformed. I rebuilt it and it worked perfectly. Richard


3

On the first step you have to check "update" where it says For duplicate contacts.


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


2

The API CSV import extension using the email entity has a way to import these. It looks like you can match on external ID.


2

You have several options, which I detail below - but I think the most important thing to do is check your CiviCRM log. It's likely to tell you what your problem is. Past that: One option is to adjust your php.ini settings to change the max_execution_time to zero. You can also do this in civicrm.settings.php if you prefer. Another is to import your data ...


2

Ashok welcome to CiviCRM stackexchange If you new CiviCRM database has not gone live than i would Create a test instance of CRM 5.4.0 Upgrade CiviCRM to 5.15.2 Dump the Civi database after upgrade. Drop the Civi database or all civi table from CiviCRM database i.e linked to your new Wordpress. Import the CiviCRM database that was dumped at #3 Open CiviCRM ...


2

The way I have done this is a variation on above and is quick, particularly if you have a separate column for each group. I also created a separate temporary custom field to ensure it didn't say there was nothing to import. For each group select the records in that group and save as a new CSV. Do an import, using fill and putting anything in the temporary ...


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 ...


1

This is strange behavior, but it's been the case for at least nine years and probably longer. I think that until the import is overhauled (work that is slowly but surely happening) we shouldn't change behavior out from under folks.


1

It depends on the job. Import jobs (Contacts, Contributions...) work by having one long-running POST request, and then your browser polls for updates on progress. This means your browser/server/interenet connection need to be able to cope with the time that POST request requires. Whether a job completes after apparently timing out depends on how PHP is set ...


1

I am switching to DigitalOcean. Works fine there. Bye bye Arvixe.


1

Karen's answer above certainly showed me what is wrong. It seems that its edits the label and not the name but the check on import is to name and not label. Is this a bug? I am on CiviCRM 5.15.1 at present. I sorted things out for me by deleting the Payment Method that was causing the problem and then recreating it. This was no problem for me as there were ...


1

It means the custom import inherits some code from the contact import, but in a way that isn't strictly valid (the parameters for the run() method are different than the parent). It would need fixing in core, and looks non-trivial, but it's a warning so the import should still run. Does it still run properly?


1

There are a few things that can help you out: Most importantly, the API Explorer (Support menu » Developer » API Explorer). It will build your drush command for you through a GUI. You can see there that adding an option with "limit=0" will return all records. There's documentation built into the API explorer, but there's also API documentation in the ...


1

I used contact_id_a and contact_id_b and relationship_type id and set the is_active to 0 in csv file. But this extension gives me an error "Error with entity "create"! (Duplicate Relationship)". Seems like you have relationship_type_id but not relationship id in the CSV file? If yes, I think you just need to add Relationship id to the columns. The id is ...


1

It sounds like you have selected one of the columns to be "Master Address Belongs To". If the record that column references doesn't exist yet you will get this error. Also FYI it looks like that column needs to be an integer.


1

I had the same outcome when I imported external ID, first, last name and a physical address update. My dedupe rule only contained 'external ID'. When I removed the first and last name the import worked.


1

This may not be the best solution, but I figured that I should report back, in case anyone else can benefit from my experience. In short, I created new user roles in WordPress that correspond to my key contact types, because I was going to need this for ACL anyway. I exported my smart groups with enough information to import the records as new users into ...


1

There are two solutions: 1) You can set the Organization Membership to "trickle down" via a relationships. This is hard to change after the fact. You will need to update the Membership type via the database and then manually update all the Memberships. 2) You can create an advanced search pulling all the Organization Memberships and set the Display ...


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