Importacular is able to split a name column into its parts.
Sometimes the data source does not come with clearly defined name fields. For example, you may have the following in a file:
But really you need this:
By selecting the “Use a name parser…” check box in the Constituent area settings, Importacular will automatically split the fields into their parts.
Select the column from your data source that contains the combined name (“Combined Name” in this case).
In the mapping screen Importacular adds several new items for you to use. These have the suffix “(generated)” to show that they have been added.
The split is based on the order of the words in the field. It is also based on over 100,000 US census name records which help determine whether a name is a first, middle or last name.
Look up Constituent by Alias
The other item on the area settings is the ability to look up constituents by alias. When you look up an alias in RE you put the alias in the last/org name search box. This is because you may have “Kentucky Fried Chicken” as the constituent name but an alias of “KFC”. This also works where you have an id as an alias. E.g. your organization may also store a website id as an alias and you want to look up by id.
However, if you map the website id to the last/surname field in Importacular, it will look up by that field but also overwrite it too which is not the desired effect.
By checking the “Add a field in the mappings…” box, it adds a new field that can be mapped against for looking up a record but will not add that value to RE.
In the criteria sets, if you choose to look up by alias, then Importacular will use the value from the mapped field, in this case “Website id” to lookup the record but will not do anything else with this value.
You can, of course, create an Alias Mapping if you wish to add this value to the record.