How to efficiently Copy Content Blocks and Templates from Outbound to Real-time Marketing

(0) Share

Report

Posted on by KE Communication bh

105

Is there a way to batch export/import Templates and/or Content Blocks?

My client just started using Real-time Marketing and now that it has Content Blocks we need all CB from Outbound in Real-time Marketing. We are taling about 100+ Content Blocks.

Is there another way than creating every single CB again in Real-time and copy and pasting HTML Code for every single content block?

All responses (4)

Answers (1)

KE Communication bh 105 on at

Like (0)

Report

RE: How to efficiently Copy Content Blocks and Templates from Outbound to Real-time Marketing

Thank you!!! That was it! *facepalm"
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: How to efficiently Copy Content Blocks and Templates from Outbound to Real-time Marketing

Hi KE Comm,

Please check the Environment is the same as your Marketing Environment.
KE Communication bh 105 on at

Like (0)

Report

RE: How to efficiently Copy Content Blocks and Templates from Outbound to Real-time Marketing

Tahnk you, this looks awesome, however I have now run into the issue that Power Automate does not find the table...

Are there any setup steps in Power Automate that I need to take first?
Verified answer

Community Member Microsoft Employee on at

Like (1)

Report

RE: How to efficiently Copy Content Blocks and Templates from Outbound to Real-time Marketing

Hi KE Comm,

Yes. The data of Content blocks in the Outbound is stored in the 'msdyncrm_contentblocks' table. Real time in stored in the 'msdynmkt_fragments'. These two tables' schema is similar and you can copy the field's value from 'msdyncrm_contentblocks' to 'msdynmkt_fragments'. I used the Power Automate to test.(You could also use another tool or code.)

Steps:

1. Create an Instant could flow and select manually trigger a flow.

2. List all rows from the 'msdyncrm_contentblocks' table.

Note: When you search Content blocks in the Table name, there would be two tables. You could select one and peek the code to check its table logical name.

3. Loop the Step2's result and set the value with each row's field value.

4. Save and run the flow is ok.

Result:

Outbound Content block:

Real Time Content Blocks: