XMLPort Generator

Views (11)

Community Member

Like(0)

Report

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, I created a little tool in .NET to read my table export and generate my XMLPort for me.

Feel free to use the tool if you have any use for it

A few bullet points:

– export your table to text and put it in the right column
– 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

Oh, if you are interested, here is the source code.