Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Value Remapping disappears when uploading file

garyh79802400
Level 2
Level 2

(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:

Screen Shot 2018-08-02 at 09.25.33.png

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.

1 Accepted Solution
garyh79802400
Correct answer by
Level 2
Level 2

I think I figured it out. I was confused because the error messages ACS was giving always said e.g. "couldn't find country/@ISOA2".

To import a country using a (correct, English, mixed-case string e.g. "United States"):

1) Add a Reconciliation step. Relations > Add > Country > English Label ((a)labelEN)

2) If you pause and look at transition data, country should now be filled in e.g. "United States (US)"

3) When inserting to DB, associate country/ISOA2 with location/CountryCode

4) When viewing Profile, Country should now be filled in e.g. "United States (US)"

This is sufficient for my needs at the moment as we're only dealing with US and Canada, so low risk of problems w/ foreign language labels.

(edited to use location)

View solution in original post

1 Reply
garyh79802400
Correct answer by
Level 2
Level 2

I think I figured it out. I was confused because the error messages ACS was giving always said e.g. "couldn't find country/@ISOA2".

To import a country using a (correct, English, mixed-case string e.g. "United States"):

1) Add a Reconciliation step. Relations > Add > Country > English Label ((a)labelEN)

2) If you pause and look at transition data, country should now be filled in e.g. "United States (US)"

3) When inserting to DB, associate country/ISOA2 with location/CountryCode

4) When viewing Profile, Country should now be filled in e.g. "United States (US)"

This is sufficient for my needs at the moment as we're only dealing with US and Canada, so low risk of problems w/ foreign language labels.

(edited to use location)

View solution in original post