web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Navision - New Datapor...

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

Answered

Navision - New Dataport : Quickest way to translate Datafields

(1) Share

Report

Report

Posted on by Nerbo

21

Hello,

Periodically I want to export to .csv a list of records from a filtered table. Example :

Customer Pallettype Date

------------------------------------

Nike Europal1 2023-05-26

Adidas Europal2 2023-05-24

Asics Europal1 2023-05-24

But I don't want to export directly these raw fields. I shall convert them so that my .csv export fits with a 3rd party app that will import the .csv

Nike shall be 0215-NIKE

Adidas shall be 3548-ADIDAS

Asics shall be 4782-ASICS

Europal1 shall be EURO 90 X 120

Europal2 shall be EURO 100 X 100

Could you please help me to figure out what's the more conveniant way to perform these fields translations ? Doable by SourceExpr Property ?

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Inge M. Bruvik 1,161 Moderator on at

Like (0)

Report
Copy link

Link copied!

I think the easiest way would be to write code in the OnBeforeExport trigger for the pallet field.

Then you can make sure that the correct value is being exported.

Edit your dataport and press F9 to get access to the code for the triggers.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 2,155 Super User 2026 Season 1

#2

YUN ZHU 1,043 Super User 2026 Season 1

#3

Dhiren Nagar 955 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans