Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Dataport
Microsoft Dynamics NAV (Archived)

Dataport

(0) ShareShare
ReportReport
Posted on by Tshepo 160

Hi,

I am Novice in Nav 2009 Development, I am phasing a challenge here of creating a dataport to export data to text file. This file must have three sections; header, data and footer sections. Data section will be data from a table which I managed to create so I am in need of help of how to create header and footer which are just labels.. please people help or suggest anything that can help me...header contains things like name of the company and footer must have things like number of records in the file

*This post is locked for comments

  • Verified answer
    Tharanga Chandrasekara Profile Picture
    Tharanga Chandrasekara 23,116 on at
    RE: Dataport

    There are few options available to achieve this,

    1. Using a report -

    2. Using a XML port.

    Refer below links for XML

    msdn.microsoft.com/.../dd338612.aspx

    msdn.microsoft.com/.../dd354947.aspx

    msdn.microsoft.com/.../dd301448.aspx

    msdn.microsoft.com/.../dd338612.aspx

    Report

    msdn.microsoft.com/.../dd355202.aspx

    community.dynamics.com/.../export-to-excel-on-dynamics-nav-rtc.aspx

  • Verified answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: Dataport

    hi,

    best try it with a xmlport.

    info links:

    msdn.microsoft.com/.../dd338846.aspx

    msdn.microsoft.com/.../dd338612.aspx

    it's easy to create a multilevel structure with a xmlport.

    when load data and export the xmlport you get the wanted file.

  • Rajasekhar@MS Profile Picture
    Rajasekhar@MS 5,567 on at
    RE: Dataport

    Hi

    You can check in any NA(Canada, USA) databases.

    Regards

    Rajasekhar.Y

  • Tshepo Profile Picture
    Tshepo 160 on at
    RE: Dataport

    hi Jonathan archer

    We are to submit credit information to a credit bureau or consumer reporting agency and the base table for the dataport is loans table (customized table)..so they provided the format and structure they want the information to be like. They want the file to have three sections, header, data and footer. Header section must have letter 'H' denoting header which startPos is 1 and width is 1 and company name which startPos is 2 and width  25 and other staff.

    data section  must have letter 'D' startPos 1 width 1, Customer ID startPos 2 width 14 and some other information. (this section retrieve information from base table)

    Footer section must have letter 'T' startPos 1 width 1, number of records in a file startPos 1 width 10..

    that how a file must look like, I hope you get the picture of what is needed

    Regards

  • Tshepo Profile Picture
    Tshepo 160 on at
    RE: Dataport

    Hi Rajasekha.Y

    In which Nav version will I find report 10083 and codeunit 10090? it seems like the current versions doesn't have such report and codunit, I mean nav 2009 and 2013.

    Regards

  • keoma Profile Picture
    keoma 32,675 on at
    RE: Dataport

    hi,

    please describe in detail what you want to do. which table should be the base for you dataport? which data do you want to export? desribe the structure of the target (xml) file.

    best regards

  • Rajasekhar@MS Profile Picture
    Rajasekhar@MS 5,567 on at
    RE: Dataport

    Hi

    Check the functions AddNumToPrnString,AddAmtToPrnString,AddFedIDToPrnString in the 10090 cu how the field mapping was handled.

    Regards

    Rajasekhar.Y

  • Tshepo Profile Picture
    Tshepo 160 on at
    RE: Dataport

  • Tshepo Profile Picture
    Tshepo 160 on at
    RE: Dataport

    I first tried the report but it seems not working for me as the file they want must have positions

    Regards

  • Suggested answer
    Rajasekhar@MS Profile Picture
    Rajasekhar@MS 5,567 on at
    RE: Dataport

    Hi

    It seems to be you are trying to generate Payment file, what we suggest is instead of creating data port you can also achieve this using report, refer the Report Export Electronic Payments(10083) & code unit Export Payments (ACH) (10090) for this in the NA version.

    Regards

    Rajasekhar.Y

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,605 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans