Hey folks! I've created a custom object (Districts) and want to connect contacts (record type: officials) to these districts, and I'm doing so with a junction object (District Officials). I need to upload ~6000 districts and ~7000 officials, and upload their affiliations as well. I.e. "June Ledford is a district official with both Chatham County & Wake County". How do I do this? I have the list of districts and list of officials, and know I need to pull their contact id & district id, but, how do I keep these affiliations in my data (aside from manually manipulating in a CSV file which sounds like a nightmare)? I don't currently have any options but Data Wizard, but, maybe could, if it would solve my problems. Everything I find on searches is from 10+ years ago, so, not even sure it's relevant any more. Thank you!
Hi Eric- Thanks for your response- external IDs is in the plan, thanks. What do you mean "Get an issue"? I don't understand what an umbrella grouping is, or "MD relations"? Could you elaborate?
