Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

DataPort

Posted on by 3,027

Hi

  How to Upload Jv data from Excel using DataPort. Which fields are necessary

Thanks

*This post is locked for comments

  • Paras mehan Profile Picture
    Paras mehan 3,518 on at
    RE: DataPort

    all the fields are necessary and set it in sequence. Otherwise system through an error.

  • jsshivalik Profile Picture
    jsshivalik 3,027 on at
    RE: DataPort

    Hi

       I want to know are there any necessary fields which must be taken when uploading Excel Data for Journal lines . If narration also to be entered then separate Uploader needs to be created or single DataExport can be created. Is there any sample available if JV with narration to be entered

    Thanks

  • Suggested answer
    Paras mehan Profile Picture
    Paras mehan 3,518 on at
    RE: DataPort

    Hi,

    you have to set according to your import file data sequence.

    As there is posting date, document no., amount.

    then you also have to mention this all fields in dataport in sequence.

    Regards,

    Paras Mehan

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,162 Most Valuable Professional on at
    RE: DataPort

    A Datasport must be designed accordingly to your CSV file and the fields of the table where you want to load the data.

  • jsshivalik Profile Picture
    jsshivalik 3,027 on at
    RE: DataPort

    Hi

       Which fields are compulsory.

    Thanks

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,162 Most Valuable Professional on at
    RE: DataPort

    You can import data from a Dataport by saving the XLS file as CSV and create the dataport accordingly.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans