Importing CSV file into Nav. Table

kolaboy · 2007-11-20

Hi experts,

I am trying to import a CSV file from excel into navision table. Its is importing but its taking the records of only the last records for a particular Employee no. The employee no. is the primary key.

I have more than one records for each employee no, but the import is taking only one of these records mostly the last record and leaving the rest of the other records out i.e not imported.

How can i import everything into the table. Is there anything i am leaving behind?
Here is my dataport:

OBJECT Dataport 50017 Test
{
OBJECT-PROPERTIES
{
Date=20/11/07;
Time=16:19:02;
Modified=Yes;
Version List=;
}
PROPERTIES
{
FileFormat=Variable;
FieldStartDelimiter=None;
FieldEndDelimiter=None;
FieldSeparator=,;
OnPostDataport=BEGIN
MESSAGE('Import complete');
END;

}
DATAITEMS
{
{ PROPERTIES
{
DataItemIndent=0;
DataItemTable=Table5207;
}
FIELDS
{
{ 0 ;5 ;"Employee No." }
{ 6 ;7 ;"From Date" }
{ 15 ;7 ;"To Date" }
{ 25 ;5 ;Quantity }
}
}
}
REQUESTFORM
{
PROPERTIES
{
Width=9020;
Height=3410;
}
CONTROLS
{
}
}
CODE
{

BEGIN
END.
}
}

Any Idea please.
Thanks
[/code]

Tomas · 2007-11-20

kolaboy wrote:

The employee no. is the primary key.

That's your problem.

Savatage · 2007-11-20

Entry No should be in the primary key of Table 5207. "Employee Absence"

Each Record should have a different "Entry No."

kolaboy · 2007-11-20

I have created and entry no. but still not importing all.
Anything wrong
Thanks

kolaboy · 2007-11-20

Hi experts,
I have solved the problem now. Its working the way i wanted it to be.
I actual make use of the Entry nos. thanks for all your suggestions
Thanks

Savatage · 2007-11-20

When creating dataports it's always a good idea to:
-go to object designer->design->"table"->view->keys

& take a look at the primary

kolaboy · 2007-11-21

Thanks for that advice Savatage.

Importing CSV file into Nav. Table

Answers

Categories