It is hard to imagine a corporate information system that does not exchange data with external databases. Bank payments and reconciliation statements, tax reports, application configuration—information goes in and out of the system. Data exchange can be implemented in different formats, but the de facto standard of data exchange is XML, which also has native support in NAV.
C/SIDE offers a special type of object for importing and exporting XML data: XMLport. Besides XML, XMLports can transfer data in simple delimiter-separated format, comma-separated values (CSV), or delimiter-separated values (DSV). Throughout this chapter, we will be developing objects for data exchange in different formats. The chapter will cover the following topics:
- Importing data from CSV files
- Importing data from XML files
- XMLport triggers
- Exporting table data
- Designing...
