8

An alternative approach, esp if you have comma separated options for the Groups (ie all groups are in a single cell) would be to make a Custom Field with options that match your Group Names, import like that, then search for each option and via Actions 'add to group'. Or (as Pradeep suggests in comment below) Custom field of type text and then using Search ...


5

Ok next thing to try is to check the civicrm_option_value table. Note it has a name column (in addition to what you can see in the GUI in 5.3.x). In the old days this name column was exposed and could be set independently: here it was set to Offline Credit Card - Importing with Payment method: Offline Credit Card -> works!


5

You should note the exceptions for the contacts with dual residences and manually remove their secondary residence, and only keep their primary residence in the sheet. You can always create their secondary residence address within CiviCRM after the import wizard finishes as a non-primary address. For State/Province names and Country name mismatches, you can ...


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

Yes it is absolutely fine to import data simultaneously but it might take bit long time to complete it. If you want to perform multiple import simultaneously make sure you imports are not linked to each other. I usually prefer to do it one by one after taking backup at each stages. You never know when mysql might crash with an error saying mysql has gone ...


3

It should be okay if multiple users are not updating/uploaded same record type's same item at the same time. Like for example if multiple users are importing a same contact record, that might cause an DB error possibly.


3

Not sure but I don't think you can import both the records in a single go. You might need to create two csv file with each value(B.Tech and BBA) of the custom field and import it one by one.


3

Multi-value custom fields need to be imported separately using https://yoursite/civicrm/import/custom?reset=1 To find that link, go to the normal contact import screen Contacts > Import Contacts, click the help icon at the end of the helptext, then follow the link at the end of the pop-up help.


3

In your spreadsheet, you should have the organization name and all organization info on the same row as the individual/employee info. When mapping the import, for all the organization fields first select "employee of". another drop down menu will appear to select the field (org name, email...) This will import both contacts with their relationship. Note ...


3

This should be fairly simple to script using the Attachment api. For docs, go to https://dmaster.demo.civicrm.org/civicrm/api#docs and select Attachment as the entity which has an example of using create with a custom field.


3

There should be a 'Delete contribution' option in the list of actions: If you don't see it there, check that you have the 'Delete contributions' permission.


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.


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


2

First the available countries and states/provinces need to be defined in the Localization settings. If you cannot do the SQL query, you can see the available values by creating an address manually and seeing the available values. The import allows state abbreviations for at least the United States. (e.g. Arizona - AZ). I use the abbreviations when I do ...


2

This was curious, so I tracked it down. Apparently the list of valid currencies predates the civicrm_currency table. So right now the valid currencies are hardcoded - you can see that in <civiroot>/CRM/Core/Pseudoconstant.php around line 1077 - the currencyCode() function. As a quick workaround, you could add your currency to the list. However, the ...


2

Try this: $result = civicrm_api3('StateProvince', 'get', array( 'sequential' => 1, 'abbreviation' => array('IN' => array("AL", "MD", "FL")), 'country_id' => 1228, )); Note that you should specify country_id as state abbreviations are not globally unique.


2

As far as I understand, provided you are importing to the same Location Type then the match should occur without adding a new email address.


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

It sounds like you're not using the latest version of CiviCRM (4.7.30 at the time of writing). It sounds like you're experiencing the bug that was described and fixed at CRM-19888. It's also related to this much older bug. Please upgrade to 4.7.30 and try again?


2

I may not have quite understood you but if you have access to your database you can look in civicrm_state_province where you will see there is a Maryland MY in Liberia (1122) as well as a Maryland MD in the USA (1228) When importing contacts with State/Province you may be better off if you either import the abbreviation (though even that might not be unique)...


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

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

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

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

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

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/


1

I think when you import if you choose "Primary" rather than "Main" from the drop-down options it will do both for you - set the address as location Main and set it as the primary. This is based on you saying you set Main as the default location. (I may not have entirely gotten your question as you mentioned another custom location but hopefully, this gives ...


1

We created a custom field to import it in so we had them on file, then as members renewed we switched over to using their contact ID's as member numbers and put a notice in their renewal emails that they would notice changes.


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

You could try the l10naddress extension by Megaphone Tech which appears to be aimed specifically at meeting this need for regionalised address formats.


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