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 CSV file from F...
Microsoft Dynamics NAV (Archived)

Import CSV file from FTP to NAV Tables

(0) ShareShare
ReportReport
Posted on by Shyamraoo 354

Hi 

I have a client requirement to import the CSV file from FTP to NAV tables and this should be automated using Job Queues. I got some idea through surfing the internet but I have following queries.

1) Do I have to download the CSV file from FTP to my local machine before uploading into NAV?

2) Should I use staging table in XMLport to upload the CSV data and then to copy that information to Main table.

3) How to download the CSV file from FTP using Date modified of that file (have any code for this).

4) Error handling (if we have any validation issue in CSV file).

Please advice.

Thanks,

Shyam

*This post is locked for comments

  • Verified answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Import CSV file from FTP to NAV Tables

    You can get more info about Reading a file from FTP:

    dynamicsuser.net/.../reading-a-file-from-ftp

    forum.mibuso.com/.../how-can-we-export-import-file-from-ftp-server

  • Verified answer
    dkatson Profile Picture
    dkatson 2,263 on at
    RE: Import CSV file from FTP to NAV Tables

    check this http://www.dynamics.is/?p=583

    there you can find ready object for that

  • Verified answer
    Suresh Kulla Profile Picture
    Suresh Kulla 47,791 on at
    RE: Import CSV file from FTP to NAV Tables

    Hello,

    Yes you need to download the CSV file from FTP before uploading, either you can use staging table or upload it directly it depends on your requirement if you want process or validate data then staging table is a good idea that is how you can handle errors.

    To download the file from FTP please check my blog

    www.navisionworld.com/.../how-to-download-ftp-files-using-net_27.html

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

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
EH-09052238-0 Profile Picture

EH-09052238-0 1

#2
Sohail Ahmed Profile Picture

Sohail Ahmed 1

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans