I'd like to import an inconsistent list of contact names with associated donations and match the names to contacts. IMO there are 3 options:
- Clean the csv in advance by displaying contact alternatives (ideally showing contact ID for matching)
- Run an import script and use interactive matching logic.
- Use forms for batch entry and interactively match contacts.
The problem is that the person who understands the matching is not the same person who can do the interactive import.
I was wondering if someone has used an excel function / drush or extension of some sort to process a list of names and retrieve likely matches that I could present (with contact ID) in excel so the user would not have to use the autocomplete widget. Would like to avoid a developer.