Excel sheet lookup value is mandatory error while import export through data entity

(0) Share

Report

Posted on by Sam D.

152

Hi ,

I am getting an error while doing export and import in ax2012 by DIXF . Can please suggest me what should i do to resolve it.

I am creating Processing Group where i Add entity and select those all field which i need and then generate the sample files and use it as sample path in the DIXF , but it showing error when i go to the GENRATE SOURCE MAPPING

This excel error is displaying

suggest me the solution to resolve it.

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Martin Dráb 239,451 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Use the "Sheet lookup" field (the right-most field in the grid in your screenshot) to select a sheet that you want to use.

Was this reply helpful? Yes No
CU01020909-0 4 on at

Like (0)

Report
Copy link

Link copied!

Hi Martin,

I know this is an old thread, but I have the same issue.
The Sheet lookup list is empty!

On my TEST server, when I select the sample file path, it filles the Sheet lookup field automatically.
But on Production server it comes as empty (Check the attached screenshot)

The deferent only is:
- On TEST server it includes all DIXF components (Service, AOS, and Client)
- On Production server, I have a separate database server, so I installed only AOS on Production server, but the Service and Client components on DB server.

Was this reply helpful? Yes No
Martin Dráb 239,451 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@CU01020909-0 Please create a new thread about your problem of the lookup not working in production. There we can also talked about where a client should be installed (it's likely not related to your problem but it's something you should reconsider anyway).

Was this reply helpful? Yes No