(edit: This is for Campaign Standard) I'm creating a custom import template. During the Import File step, I'm doing a Value Remapping on a client-supplied "country" field. Whenever I upload a new file, my Value Remapping disappears. Is this normal? Can it be configured? My client will be regularly uploading new files, so this is unacceptable behavior and I'm not sure why it would be the default.
Use case: My client creates a CSV where the "Country" is a string (e.g. "Unites States"). The only meaningful way that I've found to save the country information is using something like an out-of-box ISO-2 field ("US") such as location/@countryCode. I could create a dummy field such as "countryString" just to hold the data but that seems like an anti-pattern.
Acceptable solutions:
1) Can you save a string such as "United States" directly into an appropriate out-of-box like country or location?
2) Is there a way to persist Value Remapping so it isn't destroyed when you upload a new file?
Screenshot:
I add the values "Unites States > US" and "Canada > CA", save, run my import to success, and the Profile's country field is filled in. HOWEVER: If I upload a new file, Value remapping is blank again, and because location/@countryCode expects the ISO2 format, the Profile's country field will be blank. I have to re-add my Value remapping to get the country back.