Input file validation

MarkReeda
MarkReeda Member Posts: 12
in NAV Three Tier
Goodmorning everyone,

I'd like to ask a question about the validation of files to be imported into Microsoft Dynamics NAV 2017. Let me explain better, I often have to import (e.g. through XMLPort) files that come from third parties that have a "table structure" different from mine; concrete example, in my table I could have a field related to VAT that is populated with 22, while for the "external" one ( the one to be imported) is populated with "22%" (or maybe "Twentytwo", or "22 per cent", and so on and so forth). The question is: how can I validate these values? How can I transform them "respecting my standard"? In general I would like to understand if there is the possibility to make some operation during the import of an external file

I hope I've been sufficiently clear.

Thank you so much for your attention

Answers

  • KTA8
    KTA8 Member Posts: 399
    if you call the validate function on that field, you would raise the error.
  • MarkReeda
    MarkReeda Member Posts: 12
    But I don't want to raise the error. I'd like to understand if there is the possibility to modify the field!
  • Slawek_Guzek
    Slawek_Guzek Member Posts: 1,692
    One possible solution is to create a buffer table, with all text fields, import the file into the buffer, and then populate the destination table from the4 buffer, calculating correct values.

    Slawek Guzek - www.yitron.co.uk
    Business Central, MS SQL Server, Wherescape RED;
  • KTA8
    KTA8 Member Posts: 399
    MarkReeda wrote: »
    But I don't want to raise the error. I'd like to understand if there is the possibility to modify the field!

    Yes, you can. But the hard thing is how to find the pattern; maybe you should work with strpos to find that.
  • wolfskin
    wolfskin Member Posts: 84
    Create a table with all third parties text for mapping value between NAV and third parties. Something like this.

    Group | Third Parties Value | NAV Value
    VAT | 22% | 22
    VAT | Twentytwo | 22
    VAT | 2 per cent | 22
    VAT | ... | 22

    Write your code to access this table to get the NAV value.

Categories