I got new assignment in my workplace to integrate NAV 4.0 system with third party system using XML files. Integration will be based on XML file creation and storage of those files in predefined directories (i.e. it has to be a non-web-service approach, but a simple file-based approach).
Integration will cover only items, i.e. item and related data will be exported. System must have an ability to fully setup, what fields and tables (together with items) should be exported, i.e. item, item unit of measure, item sales prices etc. (later there might be more tables and more fields added to the system, so user should be able to setup things without help of developer). I mean that system should be somewhat fields and tables invariant, but all tables will be item related.
The process (export) should be executed with NAS and also there should be manual redo function (in case NAS fails).
Those other systems after handling exported data XML will produce error files in other predefined directories. System should accept those error XMLs (error XMLs will be imported back) from those systems and show that to user.
I am really struggling to give a reasonable estimate for this assignment. Could somebody give me a good wild guess, how much time this would take for a reasonable developer to do?
I'd say you need to implement something very similar to Change Log but with different setup. When global OnModify trigger is fired you put a record in Integration log table. In this table you will also have field like Exported which will be set to true when Nas exported the record. This will allow manual redo and check if everything is working. You will also be able to link error from response xml file with certain record in integration table if you export primary key in outgoing xml file.
It would take about 3 to 4 weeks in my opinion.