Dataport Issue

Divya

Hi

Please clarify my doubt.

My text file is like below screen... I want to upload this text file into my nav table. wat is the procedure for creating dataport. Please explain.....

                       <Heading1>
                       <Heading2>
                       <Heading2>

S.No   CustomerNo  VechicleNo  ItemNo  Quantity
1.        xxxx             TN0001     0001        5
2.        xxxx             TN0002     0002        15
3.        xxxx             TN0010     0002        15

                       <Heading1>
                       <Heading2>
                       <Heading2>


S.No   CustomerNo  VechicleNo  ItemNo  Quantity
1.        xxxx1            TN0001     0001        5
2.        xxxx1            TN0002     0002        15
3.        xxxx1            TN0010     0002        15

Mrinmay

hi,
Do you want to upload sales order? clarify the heading1,heading2,heading3

Regards,
Mrinmay

Divya

i want to update the data to some customized table.

heading1 heading2 is like "Daily Transaction log" or something like that..
i don't want to update headings in my table. I don't want that headings at all...

kriki

[Topic moved from 'NAV 2009' forum to 'NAV/Navision' forum]

Mrinmay

hi
you have to change the text file first.u have to separate the data properly. While you will create data port take line table as data item then select the dataport field. then in property of the data port put appropreate FieldStartDelimiter,FieldEndDelimiter,FieldSeparator properly how u have changes in text file. remove the headre information. I think it is not required.

Regards,
Mrinmay

Divya

But this is not one time job.. My client will update these information daily..

My question is "Is System will automatically skip headings in text file and pick up data?"..

Like if i specify starting with Row 2 and column 5.. then system pointer should go to that particular record and it should skip headings...

Savatage

see this post to skip the heading:
viewtopic.php?f=5&t=10564

2nd.
import all your data into Variables and then map them to the desired Nav fields.- then you have more control.

so for fields that don't need assigning (columns 1-4 say) you just don't map them anywhere

Divya

THANK U SO MUCH...