Dataport Header Columns Title

Business Central/NAV Developers Forum
1

Is ist possible in a dataPort, export data and in the same time export with columns names?

2

Yes!

http://www.mibuso.com/howtoinfo.asp?FileID=8

3

How can I do that?

Thanks

4

Did you see the Mibuso link?

5

It’s pretty self explanitory.

You add an Integer dataitem above your main dataitem.
setting the property DataTableView to: SORTING(Number) WHERE(Number=CONST(1)).
In the dataport Field list for the DataItem Integer you can either type in the names your would like the headers to be or use field caption to get the actual names.

http://www.mibuso.com/howtoinfo.asp?FileID=8

6

Thanks for the solution.

But in the Colums Line , I want only the columns names. In TXT file, the last 2 fileds on the first line are the 2 first fields of my records. How can I separate the columns lines from the rest of the lines^?

Thanks

7

You mean your dataitem values are showing immediatly after the column names?

what did you have in DataItemSeparator property of dataport…

8

Yes.

In DataItemSeparator property I have ;

Thanks

9

Did you try changing it to ?