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


3

Use the number "1" for yes and a blank for no. One way to see this is if you do an export and then look at how it outputs it.


2

Typically, bots contacts/contributions will follow some standard method of populating information - e.g. a recent bot attack on one of our clients created contacts with "%phone_short%" listed as their main phone number, so using search builder in the GUI allowed me to identify all associated spam contacts and delete them permanently. If these spam contacts ...


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

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

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

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


1

Hoe heb je Nick toegevoegd? Als je de contactkaart in CiviCRM bekijkt dan zie je daar als het goed is een tabje lidmaatschappen staan. Als je daar op klikt dan kan het zijn dat daar een inactief lidmaatschap staat. Overigens helpt het als je vraag in het engels stelt want dan zijn er meer mensen die je vraag kunnen beantwoorden.


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

I managed to resolve this dilemma. The goal was to move a 2 database Drupal/CiviCRM website into the CiviCRM Starterkit platform which requires that Drupal and CiviCRM use a single database. I was not able to import my database dump into the existing Drupal website because although I had set foreign_key check to zero, I was receiving a "Cannot add foreign ...


1

Yes it appears to be a bug. You should file one. Here seems to be the conditions: Importing update or fill, i.e. contact already exists Has no existing email address or any existing has is_primary flag = 0 Has a street address or are also importing one There seems to be no way via import to fix these or to import them correct. Well, if you are also ...


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