Questions tagged [import]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
2answers
180 views

Import from one db to another fails

I exported all the civi tables from one database and saved as a sql file, including a droptable statement. I then tried to import the data into a fresh site with brand new civi installation. The ...
6
votes
1answer
230 views

How Do I Import 75+ Groups

What's the best way to batch import a list of groups? The list contains 75+ entries, so having a team member manually enter each group is not the best use of time.
3
votes
1answer
39 views

How to convert/import participants with partial payments

I've tried importing participants in the standard way, then importing contributions for their event deposits (partial payments), then using API CSV import to connect them via a ParticipantPayment ...
2
votes
1answer
46 views

GitHub repository location for Import scripts via Kettle

In post: http://forum.civicrm.org/index.php?topic=35438.0 JonGold states that he'll share the import scripts for using Kettle to import via cli.php and then tag the new imports, again using cli.php. ...
4
votes
1answer
77 views

MailChimp Integration imports First Name, but not Last Name

CiviCRM 4.4.14 (Drupal) I am trying to use the MailChimp integration extension but on importing a list from MailChimp, only the first name is imported. I've gone through all the settings but cannot ...
2
votes
1answer
78 views

Restoring groups and linked contacts

50 groups were deleted by mistake. Please don't ask how. So from a 2 weeks old backup, we're able to extract a CSV from civicrm_group and civicrm_group_contact group_id, name, contact_id, email We ...
5
votes
1answer
196 views

How do I import an activity with multiple target contacts?

Has anyone got tips for the best implementation for this that's friendly to a savvy end-user? I can script it in an ETL tool, but that's not an option for them. "Import Activities", as best I can ...
5
votes
1answer
119 views

How do we preprocess CSV columns when using CiviCRM builtin import functionality?

We use CiviCRM's import data functionality (and api-csv-import-gui) to import partner's contributions from CSV files. This is working great because the CSV columns can be mapped to CiviCRM fields via ...
5
votes
2answers
124 views

How can I import Memberships without e-mail addresses or external IDs?

We are transitioning a small organization to CiviCRM 4.5, with about 2000 total contacts and about 150 memberships. The contacts imported without any problem, but when we went to import the ...
5
votes
1answer
192 views

Can Civi/WordPress an Civi/Drupal (same versions) share a database?

This would make it a lot easier to manage a transition between an existing Drupal site and a new WordPress site. In my case, all core programs and the existing databases are on the same server. It ...