Microsoft Dynamics NAV (Archived)

Import of .CSV file using Xmlport for Multiple Tables

(0) Share

Report

Posted on by Lester DSouza

Hi,

Can anyone explain how to import a .csv file using Xmlport for multiple table?

Thank you in advance.

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Nareshwar Raju Vane... 5,596 on at

Like (0)

Report

Hi,

Please check this thread: community.dynamics.com/.../156120

Was this reply helpful? Yes No
Rajasekhar@MS 5,569 on at

Like (0)

Report

Hi

You can refer the below links.

msdn.microsoft.com/.../hh165760(v=nav.90).aspx

msdn.microsoft.com/.../hh166968(v=nav.90).aspx

msdn.microsoft.com/.../hh165768(v=nav.90).aspx

Was this reply helpful? Yes No
Alexander Ermakov 28,096 on at

Like (1)

Report

You would anyway need to import the data consequently in one table, than into another. Please refer to the links other members had provided.

Was this reply helpful? Yes No
Lester DSouza on at

Like (0)

Report

Hi,

So is there no way that i can use xmlport for importing a .csv file into multiple tables ? (were i haven't to put the data into a single table).

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

Hi

You need to write a program on OnAfterInsertRecord Trigger of XMLPORT and you need to ensure your csv file contain the required data for all tables which you want to import

Was this reply helpful? Yes No
Lester DSouza on at

Like (0)

Report

Hi Amol,

I wanted to know whether the following xmlport as shown in the screenshot below is the right way or not of importing a .csv file for multiple tables?

Was this reply helpful? Yes No
Verified answer

mmv 11,471 on at

Like (0)

Report

Hi,

This will not work. The above is for a structured data file, e.g. XML. For the CSV, you may need Integer table and handle the import via code.

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

Hi

For reference you can check XMLPORT No 1 Consolidation Import/Export

Was this reply helpful? Yes No