Solved

Migration Import Addresses

  • 28 December 2023
  • 1 reply
  • 119 views
rfedorchuk
Rank
Userlevel 2
Badge +7

Hi all,

I’m running ifs-cloud-23.1.6-penyzy3-3.5.0

I’m trying to import the data from CUSTOMER_INFO_ADDRESS but the CREATE_TABLE_FROM_FILE job is splitting the ADDRESS field like so:

ADDRESS=4291 5th Ave E

S6V 7V6 - Prince Albert

Saskatchewan

CA - CANADA

 

In Excel export it looks like this:

4291 5th Ave E
S6V 7V6 - Prince Albert
Saskatchewan
CA - CANADA

 

How do I keep the information in the same record?

I’m assuming it’s processing a Hidden Tab from Excel .csv file

 

Thanks,

Rob

icon

Best answer by Jens 28 December 2023, 08:09

View original

1 reply

Jens
Rank
Userlevel 4
Badge +8

Hi @rfedorchuk 

the ADDRESS field is a kind of concatenation of the fields ADDRESS1, ADDRESS2, ADDRESS3, ADDRESS4, ADDRESS5, ADDRESS6, COUNTRY, ZIP_CODE, CITY, COUNTY and STATE based on the “Address Presentation” (search for that in the Client navigator) setup.

So if you update one of these fields then the ADDRESS field will automatically be updated as well.

/Jens

Reply


Terms & ConditionsCookie settings