Dataport imports 3 records instead of 945

ben5000

Hi all,

I'm new to Navision and I try to import data within Navision using dataport.

The fact is that when I run the dataport I get only 3 records instead of 945...

Here are the details of my configuration:

Field designer:


Table definition:


DataItem:


DataItem properties:


Dataport properties:


Import file format:
AAA,AAA,AAA,AAA,AAA,AAA,AAA,AAA,AAA
AAA,AAA,AAA,AAA,AAA,AAA,AAA,AAA,AAA
AAA,AAA,AAA,AAA,AAA,AAA,AAA,AAA,AAA
AAA,AAA,AAA,AAA,AAA,AAA,AAA,AAA,AAA

Any idea of what's wrong in my configuration?

PS: The 3 imported fields are always the same
PS2: I work under Navision 5

Thanx a alot.

Savatage

i quick guess is table keys.

if the keys are the same for alot of items then they are just replacing each other.
you have autoreplace to no also so it's probably just skipping thru the datafile.

matttrax

Also you have your properties set to have double quotes around them.

Your data file shows AAA,AAA when the dataport is expecting "AAA","AAA"

Not sure if that was just a type or not.

ben5000

Savatage wrote:

i quick guess is table keys.

if the keys are the same for alot of items then they are just replacing each other.
you have autoreplace to no also so it's probably just skipping thru the datafile.

Thank you this solved my problem!

Thanks to everyone.

Jamessantino31 -> AAA is a symbol for alphanumeric characters it could be "adaz 12" as well...

Savatage

Great 2 hear - please edit the first post & set the Attibute to "Solved"