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 Feb 05, 2019 10:49 AM
    ​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 Feb 05, 2019 11:20 AM
    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 Feb 06, 2019 07:54 AM
    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 Feb 06, 2019 08:20 AM
    ​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 Feb 06, 2019 09:29 AM
    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 Feb 07, 2019 12:10 PM
    Edited by Samuel Champoux Feb 07, 2019 12:10 PM
    ​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
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role