defect? Imported Organisation with valid value in h_region field do not show on Organisation Details

[Martyn Houghton]

Linked to the post below, we have just imported in a number of organisation including populating their region (h_region) with the ISO Code for the region. The code matches the code added into the External Organisation Region simple list, but does not show the Display Text (or the code).

 

If we select the region from the simple list on the imported organisation it then shows properly, but the region(h_region) field value is identical, so not sure why it does not show immediately after the import.

Any ideas?

Cheers

Martyn

 

 

[Victor]

To conclude this, the issue was caused by incorrect source data that contained an extra CR (carriage return) for the region value.

[Martyn Houghton]

Just in case anyone else has the same issue, we used the following in the source query to trim them out.
 

REPLACE(REPLACE(region, '\r', ''), '\n', '') as region