Wondering if someone can help me with a data migration query.
Scenario:
As a part of Customer data migration, i am also looking to migrate Address types (Pay, Delivery andDocument which is coming from view- CUSTOMER_INFO_ADDRESS_TYPE)
Created a migration job to insert new Customers, Addresses and Address types (third highlighted view as below)
Migration job works fine and creates first default value i.e. Pay
But to pass other two default values (Delivery and Document) I am replacing Pay with other two one- by-one and running the same job few times. Is there any easier way to pass all three value once so that i don’t have to run the same job thrice?
Thanks in advance
/D
Best answer by anmise
CedDinesY wrote:
Hi Guys
Wondering if someone can help me with a data migration query.
Scenario:
As a part of Customer data migration, i am also looking to migrate Address types (Pay, Delivery andDocument which is coming from view- CUSTOMER_INFO_ADDRESS_TYPE)
Created a migration job to insert new Customers, Addresses and Address types (third highlighted view as below)
Migration job works fine and creates first default value i.e. Pay
But to pass other two default values (Delivery and Document) I am replacing Pay with other two one- by-one and running the same job few times. Is there any easier way to pass all three value once so that i don’t have to run the same job thrice?
Thanks in advance
/D
You need to add multiple records for CUSTOMER_INFO_ADDRESS_TYPE_API in the method list for the address type. There are a few different ways you can set this up.
You can use the CUSTOMER_INFO_ADDRESS_TYPE_API.NEW__ and RMB to method list attributes and hard code the address type codes e.g. ‘DELIVERY’ .
Or you can use ‘ViewNameUnique’ for view CUSTOMER_INFO_ADDRESS_TYPE
And then create records for address type for each of the views in the source mapping tab with a default value for each type.
Wondering if someone can help me with a data migration query.
Scenario:
As a part of Customer data migration, i am also looking to migrate Address types (Pay, Delivery andDocument which is coming from view- CUSTOMER_INFO_ADDRESS_TYPE)
Created a migration job to insert new Customers, Addresses and Address types (third highlighted view as below)
Migration job works fine and creates first default value i.e. Pay
But to pass other two default values (Delivery and Document) I am replacing Pay with other two one- by-one and running the same job few times. Is there any easier way to pass all three value once so that i don’t have to run the same job thrice?
Thanks in advance
/D
You need to add multiple records for CUSTOMER_INFO_ADDRESS_TYPE_API in the method list for the address type. There are a few different ways you can set this up.
You can use the CUSTOMER_INFO_ADDRESS_TYPE_API.NEW__ and RMB to method list attributes and hard code the address type codes e.g. ‘DELIVERY’ .
Or you can use ‘ViewNameUnique’ for view CUSTOMER_INFO_ADDRESS_TYPE
And then create records for address type for each of the views in the source mapping tab with a default value for each type.
Wondering if someone can help me with a data migration query.
Scenario:
As a part of Customer data migration, i am also looking to migrate Address types (Pay, Delivery andDocument which is coming from view- CUSTOMER_INFO_ADDRESS_TYPE)
Created a migration job to insert new Customers, Addresses and Address types (third highlighted view as below)
Migration job works fine and creates first default value i.e. Pay
But to pass other two default values (Delivery and Document) I am replacing Pay with other two one- by-one and running the same job few times. Is there any easier way to pass all three value once so that i don’t have to run the same job thrice?
Thanks in advance
/D
You need to add multiple records for CUSTOMER_INFO_ADDRESS_TYPE_API in the method list for the address type. There are a few different ways you can set this up.
You can use the CUSTOMER_INFO_ADDRESS_TYPE_API.NEW__ and RMB to method list attributes and hard code the address type codes e.g. ‘DELIVERY’ .
Or you can use ‘ViewNameUnique’ for view CUSTOMER_INFO_ADDRESS_TYPE
And then create records for address type for each of the views in the source mapping tab with a default value for each type.
Thanks for the detailed process. Worked very nicely!
I would recommend an additional topic. If you have a non-english environment (e.g. french, german, spanish etc.) then you should better use the DB-columns instead of the non-DB-columns otherwise the job will run into errors:
I changed the flags. You can enter a fixed value here or in the source mapping tab for the DB-column.
In my case I used to enter a value into the source column (or default value can also be used) in the source mapping tab for the DB-column:
I would recommend an additional topic. If you have a non-english environment (e.g. french, german, spanish etc.) then you should better use the DB-columns instead of the non-DB-columns otherwise the job will run into errors:
I changed the flags. You can enter a fixed value here or in the source mapping tab for the DB-column.
In my case I used to enter a value into the source column (or default value can also be used) in the source mapping tab for the DB-column:
/Jens
Spot on! I notice I only did DB-column in my first example.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.