XMLPort Generator Tool for Navision

Recently, I need to import some flat text files into NAV into completely new tables. So first, I created a table containing all the fields in the correct order. Next I had to create an XMLPort to import the values. But, there were over 200 fields in my newly created table, and had 3 more tables with the same thing.

So, there is a little tool available created in .NET to read a table from navision & generate a XMLPort for the same while saving it as text file for importing into Development Environment.

Given below is the link for Downloading the XMLPort Generater Tool

https://drive.google.com/file/d/1dLcWqXWAxN4Araj6SUR3A-3S_xBcteQP/view?usp=sharing

Given below are the steps for how to Run the tool :-

1. Export your table to text file.
2. Run the XMLPort Generater Tool.
3. Copy all the text from the exported Table text file & Paste all of it on the left side of the Tool.
4. Please Mention some details like Table ID, Table Name, XML ID etc.
5. Now click on generate XML Port (It will generate a text onto the right side of the column on the tool)
6. Now finally click on Save to file for saving the generated text into a text file on to the required location.

Note - 
- XMLPort is always import, of type variable text (no xml)
- If you don’t supply anything in the fields, it will create an xmlport of type variable text to your       source table.
- XMLPort name is by default set to “IMPORT %1” with %1 being the source table name

Now Import that generated Text file of XML port into the Development Environment and we are good to go.


Hope this helps in most of the cases where it can save some time & effort...!!