Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Import of .CSV file us...
Microsoft Dynamics NAV (Archived)

Import of .CSV file using Xmlport for Multiple Tables

(0) ShareShare
ReportReport
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

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,696 on at
    RE: Import of .CSV file using Xmlport for Multiple Tables

    Hi

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

  • Verified answer
    mmv Profile Picture
    mmv 11,467 on at
    RE: Import of .CSV file using Xmlport for Multiple Tables

    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.

  • Lester DSouza Profile Picture
    Lester DSouza on at
    RE: Import of .CSV file using Xmlport for Multiple Tables

    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? 

    2248.Untitled.png

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,696 on at
    RE: Import of .CSV file using Xmlport for Multiple Tables

    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

  • Lester DSouza Profile Picture
    Lester DSouza on at
    RE: Import of .CSV file using Xmlport for Multiple Tables

    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).

  • Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Import of .CSV file using Xmlport for Multiple Tables

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

  • Rajasekhar@MS Profile Picture
    Rajasekhar@MS 5,569 on at
    RE: Import of .CSV file using Xmlport for Multiple Tables

    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

  • Nareshwar Raju Vaneshwar Profile Picture
    Nareshwar Raju Vane... 5,596 on at
    RE: Import of .CSV file using Xmlport for Multiple Tables

    Hi,

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans