CiviCRM Community Forums (archive)

Hi,

I am trying to do an import of organizations and individuals.  I have a custom relationship where individuals are "practice managers of" organizations.  Starting small, I've imported one organization and then am trying to import 18 individuals.  When I import the individuals the row that is "practice manager" gets its relationship set up correctly but I am getting 17 organizations with no details.  Do I have to tailor my import files to have only the rows that have a relationship in them?  From what I'm reading, I'm going to have to do the import for every relationship I have (there will be about 10-12) anyway as you can only import one relationship set anyway, but it also sounds like I'm going to have to create a different import file for every one?  Is this actually the case or am I missing something?

I'm thinking it's probably worth my while to go down the path documented in http://civicrm.org/blogs/admin/writing-custom-import-script in this case anyway because of the number of relationships, but knowing if I'm missing something above will help me make a decision one way or the other.

thanks,
Malks.

Hi Pete,

Thanks for you reply.  I had a similar idea and checked the strict duplicate rule for organizations and it looks fine.  I don't think that is the issue as the organization that should be linked doesn't get duplicated.  It's not a show stopper I'm generating all my csv files off a script anyway so will just modify those, just a bit annoying.

Anthony.

I have:

Indiv G who is *not* linked to an Org.

For however many not linked individuals I have (17 in my test import) I get an Org created that is empty of any detail.  Anyone that is linked to an Org is correctly linked to that  Org and the Org is *not* duplicated.

My workaround is to make my import files not have any unlinked individuals which is not unreasonable.  I was following some other instructions that for multiple relationships you could use one file and use "- do not import -" but this doesn't seem to be the case.

Agreed, when I get a chance I might try and work out where to update or comment in the Wiki.  Just to follow up I was working to http://blogs.terrorware.com/geoff/2009/12/01/importing-relationships-into-civicrm/ which suggested you could avoid using multiple files but this doesn't work I think if there are blank relationships.

Thanks for your time.
Anthony.