Dataport

(0) Share

Report

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

All responses (11)

Answers (2)

Verified answer

Tharanga Chandrasekara 23,118 on at

Like (1)

Report

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 32,727 on at

Like (1)

Report

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 5,569 on at

Like (0)

Report

RE: Dataport

Hi

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

Regards

Rajasekhar.Y
Tshepo 160 on at

Like (0)

Report

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 160 on at

Like (0)

Report

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 32,727 on at

Like (0)

Report

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 5,569 on at

Like (0)

Report

RE: Dataport

Hi

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

Regards

Rajasekhar.Y
Tshepo 160 on at

Like (0)

Report

RE: Dataport
Tshepo 160 on at

Like (0)

Report

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 5,569 on at

Like (0)

Report

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