How to add all fields of a table in to XML port ?

Fiammenghi
Fiammenghi Member Posts: 17
in NAV Three Tier
Hi,
up to now we used Nav 2009 , 2 tier, and we had dataport.
Now we are migrating to Nav2017, dataport are no more there, but we have xmlport.

On 2009 and dataport, you could choose a table, open the field list, select all fields, and you were able to add in one shot all fields of a table as dataport fields.

On 2017 and xml port, as far as i noticed you have to add all fields of a table one by one.
As i have to migrate more than 300 tables data from 2009 to nav 2017, i was wondering if there is a way to create "automatically" a xmlport that add all fields of a table. Someone showed me Rapid starts, but i find them very time comsuming.

I was considering also to write a program in C# that create the XMLPORT in .txt file and then import the object and compile it. but i have a problem,

Look at this simple xml port, what are the highlighted values ?
In case i create a program that build the dataport as a text file, how should i create the highlighet value ?

Any other suggestions ?

Manythanks in advance
Fabrizio





Answers

  • vaprog
    vaprog Member Posts: 1,173
    They are GUIDs (Globaly Unique IDentifier). Just use the library function to generate a random one.
  • Fiammenghi
    Fiammenghi Member Posts: 17
    Many thanks for your prompt reply

    Fabrizio
  • Slawek_Guzek
    Slawek_Guzek Member Posts: 1,692
    Hi

    1. Create a small codeunit in NAV which will have just one line of code in OnRun trigger
    wkky2l9oh22g.png
    Every time you run it it will show you a new GUID

    or

    2. In Visual Studio you have a function Create GUID in Tools menu

    or

    3. in SQL Server Management Studio clinke New Query, type and run SELECT NEWID() query

    Slawek
    Slawek Guzek - www.yitron.co.uk
    Business Central, MS SQL Server, Wherescape RED;
  • vaprog
    vaprog Member Posts: 1,173
    edited 2017-09-28
    I just happened to stumble upon GitHub: Dynamics-NAV-Tools/XMLPort Generator/

    Don't know if it is useable, though.

Categories