Please can you help me to solve this problem? We are using Nav 2009 classical version and I tried to use the data migration functions to export some tables out of one company and have it imported into a new company. When I export the table into xml format , I can see the exported XML file containing all field of the original table. However , when I import it into another company, it returned the message that the data has been succfully imported but actually only the first field of the table has been imported. for example, for the customer contact table, only the contact number has been imported but other field such as name, telphone and etc all went missing.
I then tried to use the Excel format to export/import the table. However, when the table was export, the excel file only show the first field of the table but all other dimensions went missing . For the contact table, I can only find the contact number in the exported Excel file but all other information went missing.
can any one help me with this issue?
Thank you in advance