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.