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

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

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

Indeed there is not a standard importer for SEPA mandates. I have migrated SEPA mandates a few times and I use the SepaMandate createfull API. That will create the mandate and the recurring contribution. If you then want to import actual payments you should fill the column contribution_recur_id to ensure they are linked to the mandate.


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

Without seeing some of the actual file that is being imported, it is hard to say for sure. But my guess is that birth date field is an actual date field? And if so, it needs to be formatted as a date and on the first import screen you have to tell Civi how it is imported. The error file that you can click and download will give you more information, as it ...


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

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

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

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


1

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


1

See here: Can't find 'longitude' in import wizard It should be available by default, so yes, open an issue to fix.


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