Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Why is Data Exch. Definition ignoring my Transformation rules?

Posted on by 140

Hi,

I have a csv export setup for payment journals and it is exporting the file I want, mostly correctly

However it seems to ignore my data transformation rules on the mapping.

Data-exch-def.png

I want the first field to truncate at 32 characters. but one of my sample lines has 34 chars so throws an error when i export and the filed is set to 32. So I temporarily set it to 35

field-map.png

in the field mapping i set it to use a custom transform rule

example-rule14.png

The transform rule, when tested using the sample box, successfully truncates to 32 chars

but my output for field 1 looks like this:"Caribbean Welding Supplies Limited"

When it should be "Caribbean Welding Supplies Limit"

Similarly, another substitution rule i put using 'REPLACE' function is being ignored. But if i put a transform on a numeric field using math like multiply, it carries it out no problem.

Any ideas?

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Why is Data Exch. Definition ignoring my Transformation rules?

    Hello,

    Feel free to raise this issue to Microsoft via your partner or CSP if you do not get further traction from the community. We may ask you for some sort of repro steps in standard.

    Thank you.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans