Export Table Reference information using a Dataport

dohertyk
dohertyk Member Posts: 94
edited 2007-04-11 in NAV/Navision Classic Client
Hello all,

I am working on something that starts out in Navision 4 SP3 Update 1. And later on will be all SQL 2005 based.

The first part of this is to write a dataport that's going to get the following out of Navision.

- 'Table Name'
- 'Table ID'
- 'Field Name'
- 'Field ID'

And stick it all in a tab delimited file on the users desktop.

Sounds easy, and maybe I'm making a mountain out of a mole hill. But when I sat down to actually do this. I couldn't figure out how to go about it.

I am new to Navision. I've been working with it off and on since November of 2006. (about my 5th month, and I've done only simple projects.)

Any help/guidance is greatly appreciated.

Thanks in advance,

Kevin

Answers

  • kriki
    kriki Member, Moderator Posts: 9,133
    Make a dataport on table "Field" (a system table).

    Dataport properties :
    -FieldStartDelimiter,FieldEndDelimiter = <None> (you need to put the < and > and respect the case I used!)
    -FieldSeparator : <TAB> (you need to put the < and > and respect the case I used!)
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • dohertyk
    dohertyk Member Posts: 94
    kriki wrote:
    Make a dataport on table "Field" (a system table).

    Dataport properties :
    -FieldStartDelimiter,FieldEndDelimiter = <None> (you need to put the < and > and respect the case I used!)
    -FieldSeparator : <TAB> (you need to put the < and > and respect the case I used!)

    Thanks.. It works perfectly.

    But I'm sure you knew that, didn't you.

    Seriously, thanks again.

    Kevin

Categories