Data Import

sbilly · 2012-09-05

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 · 2012-09-05

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 · 2012-09-06

it didn't help me but thanks

navuser1 · 2012-09-06

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

sbilly · 2012-09-06

Thanks for reply, but I want to use only NAV

navuser1 · 2012-09-06

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 · 2012-09-06

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 · 2012-09-06

Please show your file with data if possible.

sbilly · 2012-09-06

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

Data Import

Comments

Categories