web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Define conversion values - Data Management - Import job

(0) ShareShare
ReportReport
Posted on by 10

Hi all, 

We are currently defining some conversions between source values and staging values with reference to the import job setup and mapping details already defined. We are more specifically setting up conversions between the a source field "Accounting string" which is mapped to the staging field "AccountDisplayValue". 

There are hundreds of conversions that needs to be added for the mapping between the source field "Accounting string" and the staging field "AccountDisplayValue". 

Is there an easy way to import/upload the conversions at once instead of creating them one by one? 

I have the same question (0)
  • Kadir Karaman Profile Picture
    125 on at

    Hi Anthonius,

    I'm asking to understand. Do you need "1" source field mapping to "n" target field for import with one import?

    Regards,

  • Anthonius Asfar Profile Picture
    10 on at

    Hi Kadir,

    Just to help you understand. There will be one to many scenario in the conversions but as well a one to one. Find the data below for your reference:

    I have just added some examples down below but please keep in mind that we would need to add hundreds of conversion lines

    Source Value  Staging Value

    1111                11112

    1112                11112

    1113                11112

    2111                21121

    2113                21131

    2116                21161

    3001                30010

    etc

  • Suggested answer
    Kadir Karaman Profile Picture
    125 on at

    Hi,

    I see, as you said there are too many conversions it. Out of the box, I check it but I couldn't see an easy way. I suggest, create a new customization data source entity for below form with excel import/publish to conversion lines(like Open in Excel function). Therefore, you add hundreds lines to excel and import the custom entity line one time this form.

    Screenshot-at-Feb-01-17_2D00_17_2D00_51.png

    Regards,

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 503 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 434 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 278 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans