Yes, client is not on support and upgrade is out of the scene because of cost & complexity involved.
Anyways, after doing some research, I have come to the following: -
- In Navision, Version 4.0 and higher, there exists a technology named “XMLPorts”. With this technology, it is very simple and easy to import/export documents or files in XML format. Approach would be to build/replicate the same technology in Navision Version 3.60.
a. Problem is only that it is a huge job because there are some DLL files, necessary for running “XMLPort” functionality which are difficult to replicate for Navision 3.60
- Approach would be to build a technology similar to “XMLPort” in Navision Version 3.60 from scratch. This will allow customizations as per user requirements.
a. Problem is it will take longer time as it is to be built from scratch. Hell lot of time!
b. It involves use of technology like XML DOM which itself is quite complex but achievable.
- Approach would be to use the existing “Import Excel” tool made in the client’s current database. In this, coming XML files would be first converted into CSV format files and then using the existing tool, would be imported into Navision system.
a. Problem is converting XML files to CSV format files.
b. Also, this “Import Excel” tool is a very basic tool. So, some enhancements would also be done in this tool itself.
Considering all the approaches while taking up a task, to select the best and most economical approach is the key.
Other products available in the Market
EFS Technology makes available their flagship product LaserNet Output Management. This product can help in converting documents from any format to any required format. Refer to following address for details: -http://efstech.dk/fileadmin/efs_technology/Files/FLASH/LaserNet_Flash_Final.swf
Another company called Digital Vantage Point makes another interesting product for this kind of integration. Refer to following address for details: -
Any suggestions on how to approach from now onwards in this task?
Thanks & Regards,