Options

Data Import

sbillysbilly Member Posts: 231
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

Comments

  • Options
    Alex_ChowAlex_Chow Member Posts: 5,063
    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.
  • Options
    sbillysbilly Member Posts: 231
    it didn't help me but thanks
  • Options
    navuser1navuser1 Member Posts: 1,329
    Just create an Excel with help of Vlookup function from these file after than import the same into your table through dataport.
    Now or Never
  • Options
    sbillysbilly Member Posts: 231
    Thanks for reply, but I want to use only NAV
  • Options
    navuser1navuser1 Member Posts: 1,329
    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).
    Now or Never
  • Options
    sbillysbilly Member Posts: 231
    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;
  • Options
    navuser1navuser1 Member Posts: 1,329
    Please show your file with data if possible.
    Now or Never
  • Options
    sbillysbilly Member Posts: 231
    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
    
Sign In or Register to comment.