Announcements
No record found.
Hi
I have a requirement where I need to validate every fields(ie.. every value in the excel) in excel before importing into AX table.
How should I do that?
*This post is locked for comments
Hi Dhana,
If you are using the Excel add-in, there will be a validation. If you are using Data Import Export Framework, the validation will be done by the system.
If you need to enable coding to validate it during a manual script, you can use the validateField and validateWrite methods on the table.
Addition to Andre's comment: .. It mainly depends on the kind of Import (Code/Excel addin/DMF) and the kind of Validation (master table relationships, other conditional validations).
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CP04-islander 39
Michel ROY 14
imran ul haq 8
