Resolve impex region upload

[Former Member]

Hi everyone, I think I have an easy question but I don´t have enough experience with impex files, the thing is that I´m trying to upload an address with a Region.

 INSERT_UPDATE Address;streetname;streetnumber;postalcode[unique=true];town[unique=true];country(isocode);region(isocode);phone1;email;reference;shippingAddress;owner(B2BUnit.uid)
 ;Paseo de la Reforma;233;53227;CDMX;MX;DF;+81 9583 8863;xxxxx@gmail.com;Cerca iglesia San Mateo;true;xxxxxx

The thing is that hybris find another region with the same isocode (DF) but for other country and didn´t update the address, so, how can I indicate in the impex that I´m referring to the region in MX country.

Thanks for your advice

[andyfletcher · Accepted solution]

Try

  region(country(isocode),isocode)

as your header

The data would then be

 <COUNTRY_CODE>,<REGION_CODE>

e.g.

 MX,DF

[Former Member]

So,Andrew, I tried with the header like you post but it doesn´t work,I get a

doesn´t provide enough value at position 1 message

, then I get it work with the following header region(country(isocode[default='MX']),isocode) thank you for your advice.

[andyfletcher]

It's difficult to tell without seeing what data you are trying to import but did you actually specify the region code in the data?

e.g. this works for me

 INSERT Address;owner(Customer.uid);region(country(isocode[default=US]),isocode)
 ;test@example.com;US-DC

or

 INSERT Address;owner(Customer.uid);region(country(isocode),isocode)
 ;test@example.com;US,US-DC