[solved] Master Export

lospet
lospet Member Posts: 42
edited 2007-02-12 in NAV/Navision Classic Client
Hello forum,

is there any way of exporting all tables within Navision to an excel file or same other format. I want to create a master template as it is offered by RIM. Such a master template we would use for basic Navision setups at our clients location.

Thanks in advance for every useful hint.

Regards,
lospet

Comments

  • nunomaia
    nunomaia Member Posts: 1,153
    You have in Setup Checklist a tool to export the master tables to Excel
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • Mbad
    Mbad Member Posts: 344
    Export to excell is 4.0 SP1+ i believe.
  • lospet
    lospet Member Posts: 42
    I know about the functions offerd by the setup checklist. With the excel mapping tool i can export tables only by one. What i want is to export all my tables at once to one (or more) xml or excel files.
  • Mbad
    Mbad Member Posts: 344
    Well if you have the code, you should just create what you need? Since you need to output the difinition(ie. pr. table), im pretty sure you wont find an auto batch job.
  • lospet
    lospet Member Posts: 42
    Mbad wrote:
    Well if you have the code, you should just create what you need? Since you need to output the difinition(ie. pr. table), im pretty sure you wont find an auto batch job.


    I got it!!! :D

    I did it this way:
    I imported the data migration tool (i am not sure if it is standard in NAvision) from the RIM package. Then i picked all tables i wanted to export. The good thing is that you can also pick specific fields the table should include. after i defined all my needed tables, I exported the tables to excel and xml. It work all fine. Now i have all my tables in one master template. These master tables are now a good starting point for implementing the basic client requirements.

    Regards,

    Petar

Categories