CiviCRM Community Forums (archive)

I just searched this "Using Import" forum for [batch] and didn't find what I was looking for... but maybe I'm just not using the right terminology.

I have several CSV files, one or two per CiviCRM instance (one instance for each of a large organization's individual chapters).  What I would like to be able to do is upload all the files to one (temporary) place on my server, then script the import of each of these files into its appropriate corresponding CiviCRM instance (i.e. without having to log in to each instance, specify the name of the import file to upload from my PC, specify whether the first row contains column names, specify what do do in case of duplicate records, specify what import profile to use, click continue, visually inspect the mapping to see that it's correct, click continue again, etc.)

Does such a capability exist?

you might want to search the Blog for Eileen's post about using TableWizard and Migrate for managing complex importing - not sure if it will provide a short cut for applying same approach to several instances but could be worth checking

you might want to search the Blog for Eileen's post about using TableWizard and Migrate for managing complex importing - not sure if it will provide a short cut for applying same approach to several instances but could be worth checking

Are you referring to http://civicrm.org/blogs/eileen/civi-migrate-proof-concept ?

If so, that (being a solution for Drupal) doesn't help me, as I need a solution for Joomla... and unfortunately I need it by Friday :-(

So, I have the choice of manually importing 36 files, or learning enough PHP to read the uploaded CSV files and using the API to put the data in the right fields (which consist of a combination of the standard FirstName, MiddleName, LastName, InddividualSuffix, StreetAddress, City, State, Zip, Gender, and Birthdate... plus some custom fields that are in their own custom group).

From http://civicrm.org/blogs/lobo/implementing-batch-import-api I get the impression that this API is still being tested... is there an example PHP script that uses this API?  I'm willing to be it would be faster for me to copy/modify an existing example, rather than trying to write one from scratch.  In the software business, that's called "re-use", not "plagiarism"  :-)