Export all master + setup data

kenl

Hello,

Any easy way to export all master + setup data?

In Navision 4.0, the backup function will copy ALL table data. How can I export all master and setup data (filter out all transaction) ?

And on the object designer, tables, there is no property to indicate the table Type (master, setup, transaction....). How can we find all master tables?


Thanks

DenSter

You make it sound as though it is a bad thing that a database backup backs up all data....

If you want to export data from any table, you use dataports, or if you're on 4.00 you can use dataports and XMLPorts. You can also write code yourself to retrieve data and write it to a text file. Tons of possibilities, take your pick.

HalMdy

You could also :
- create a new company,
- use Setup Checklist to copy Setup information from the old company.
- make a backup of the old Company only ...

kenl

Hello,

"Setup Checklist" is the function I am looking for :P

From the C/Side reference help, it says
Copy Data consist of tables that meet all of the following criteria:

1. They are common to various companies. The G/L Account table is an example of such a generic table.

2. They are empty in the Setup Checklist table. This is in order to minimize the risk of overwriting existing data.

3. They can contain more than one record. For example, the G/L Account table will be present but not the General Ledger Setup table


For point 1, how does the system know which tables are common? If we create a new table, can we make it into to the copy data table list ?

Thanks

Luc_VanDyck

kenl wrote:

For point 1, how does the system know which tables are common? If we create a new table, can we make it into to the copy data table list ?

The "Setup Checklist" form, uses Codeunit 406 "Setup Checklist Management" to retrieve the table info. In this codeunit, the function MakeChecklist inserts some tables into the Setup Checklist table. You can add your own tables here. Also modify the function TransferContents to copy the data from your added tables.

kenl

Hello Luc Van Dyck,

Thank you so much for you information. =D>