Data Import

sbilly

Hi all,
I have a file that contains two lines, the only difference between them is the field of time.
Here is an example:
Name1,ID1,StartingTime
Name,ID1,EndingTime

I want to import these two lines via a dataport in one line within a table like this :
Name1,ID1,StartingTime,EndingTime

Any idea plz.
Thanks

Alex_Chow

Other than writing a dataport to do it for you, I suggest you just do it.

ID1 can be your identifier, just FIND it and make modifications to it when you read Ending time or the 2nd occurance.

sbilly

it didn't help me but thanks

navuser1

Just create an Excel with help of Vlookup function from these file after than import the same into your table through dataport.

sbilly

Thanks for reply, but I want to use only NAV

navuser1

sbilly wrote:

Thanks for reply, but I want to use only NAV

It's Ok. Tell me what data do you have in Navision (table) which matches to file no. 2 (Name,ID1,EndingTime).

sbilly

The table is initially empty, and the file contains the two lines that I want to import in one line in the table.


the file contains:

Name1,ID1,Time1
Name1,ID1,Time2
Name2,ID2,Time3
Name2,ID2,Time4
.
.
.

And the fields of the table are:
Name,ID, StatingTime,EndingTime


I want for example that:
table.Name := Name1;
table.ID := ID1;
table.StatingTime := Time1;
table.EndingTime := Time2;

navuser1

Please show your file with data if possible.

sbilly

navuser1 wrote:

Please show your file with data if possible.

Hamlaoui Med Amine,00000050,07:19:54
Hamlaoui Med Amine,00000050,14:03:29
Habbechi Hajer,00000061,07:39:46
Habbechi Hajer,00000061,14:01:22