Legacy Dynamics NAV utility
NAV 2013 universal XMLport
For Dynamics NAV 2013 and NAV 2013 R2, not Business Central. Using Business Central? See Import Export PowerTool.
Dynamics NAV 2013 removed dataports, so the Universal DataPort no longer runs there. The NAV 2013 Universal XMLport does the same job: give it a tab-separated file, usually saved from Excel or SQL Server Management Studio, and a table number, and it inserts new records or updates existing ones.
- Imports tab-delimited text files into any NAV 2013 table without development or configuration.
- Faster than pasting from Excel or using the RapidStart data migration tools for large data sets.
- Imports record notes and record links.
- Imports item tracking lines (serial and lot numbers, expiration dates, and warranty dates) on the item journal (table 83), and can run triggers.
- Runs OnInsert and OnModify triggers, supports field validation, and can turn off the change log during the import.
- Works with NAV 2013 and NAV 2013 R2.
How to use it
Import the object, then add the XMLport to the menu as a task or run it from the Object Designer. Added as a menu item, it can also go on the ribbon of the Role Center.

Fields
- Filename: the tab-delimited text file to import. Optional, because NAV asks for the file when you choose OK.
- Import table number: the NAV table to import into. The assist button opens the selected table in another NAV window.
- Enable record inserts: creates new records.
- Enable record updates: updates existing records. The file must include each record’s primary key.
- Validate fields: validate only fields whose name starts with an asterisk (*) in the first row, or validate all fields.
- Disable change log: NAV 2013 logs programmatic changes in the change log. This option turns the change log off during the import and back on afterward, which can make imports much faster.
Sample import
The first row names the fields to import. This example imports into the Location table:

The asterisk before Code tells the XMLport to validate that field when Validate all fields is not chosen. Field names can use NAV format (Phone No.) or SQL format (Phone No_).
Tips
- When importing contacts, include the No. column with empty values, and the XMLport uses the contact number series.
- NAV validates fields from left to right, so order the columns to avoid validation errors. For example, put the item number before the quantity on the item journal.
- Importing into the Item or Resource table adds the base unit of measure to the unit of measure table automatically.
- Excel can add double quotes around some text when saving a tab-delimited file. Check the file before importing.
- Watch for duplicate data when record inserts are enabled.
Using Business Central?
For Business Central, use Import Export PowerTool. This is a completely free app from Insight Works for Business Central.