Open Forum

Expand all | Collapse all

Data Exch. Field table getting big

Jump to Best Answer
  • 1.  Data Exch. Field table getting big

    TOP CONTRIBUTOR
    Posted 11 days ago
    ​Hi,

    I am using NAV 2018 Currency exchange rate update tool each day and now I just got aware that the Data Exch. Field table had millions of records in it and is the biggest table we have now.

    Isn't that table supposed to empty itself after the data exchange is done?

    ------------------------------
    Samuel Champoux
    IT Director
    Drummondville QC Canada
    ------------------------------


  • 2.  RE: Data Exch. Field table getting big

    TOP CONTRIBUTOR
    Posted 11 days ago
    I use another Data Exchange for payment exports and just tested it and the table is empty after exporting.
    Maybe it's a bug or a problem with the currency exchange rate import code.

    ------------------------------
    Samuel Champoux
    IT Director
    Drummondville QC Canada
    ------------------------------



  • 3.  RE: Data Exch. Field table getting big

    GOLD CONTRIBUTOR
    Posted 10 days ago
    The answer is yes, at least during exports. Codeunit 1210, ExportToFile calls whatever XMLPort is specified on the Data Exchange Definition in the field "Reading/Writing XMLport", and then it cleans up after itself.

    However, I do not have direct experience with using that engine for currency imports. If you can reply with a screen snap of your data exchange definition so I can see what codeunits and xmlports are being used, I can take a look at the code in Cronus and give a better answer. All of that should be under the General Tab.

    ------------------------------
    Kyle Hardin
    NAV Developer
    ArcherPoint Inc.
    Duluth GA
    ------------------------------



  • 4.  RE: Data Exch. Field table getting big

    TOP CONTRIBUTOR
    Posted 10 days ago
    ​This is the base NAV2018 exchange rate service, if you set it up on Cronus it should be the same.
    Here's how it looks on my system:​



    ------------------------------
    Samuel Champoux
    IT Director
    Drummondville QC Canada
    ------------------------------



  • 5.  RE: Data Exch. Field table getting big
    Best Answer

    GOLD CONTRIBUTOR
    Posted 10 days ago
    I've been through codeunits 1203 and 1280, and there isn't any data cleanup code in there. I have CU10; I also downloaded CU14 just to see if any bugs had been fixed and I can't find anything there either.

    My suggestion would be to involve your friendly neighborhood developer and get a delete added.

    ------------------------------
    Kyle Hardin
    NAV Developer
    ArcherPoint Inc.
    Duluth GA
    ------------------------------



  • 6.  RE: Data Exch. Field table getting big

    TOP CONTRIBUTOR
    Posted 9 days ago
    Edited by Samuel Champoux 9 days ago
    ​Thank you, I can add the delete myself, I was just wondering if it was normal or if I missed a setup somewhere :)

    ------------------------------
    Samuel Champoux
    IT Director
    Drummondville QC Canada
    ------------------------------