Importing Item entries

Fleur

Hi

I am import item entries into the item journal table... the import seems to go through without any errors but nothing appears in the journal lines?

It is a basic CSV format and the journal header does exist.

There is no code behind this dataport - all very straightforward, but do In need to specify some code to actually say 'import'

Any ideas?

Thanks

maikelj

Hi Fleur,

If your CSV file doesn't contain errors, then you can check some things
in your dataport:

1: Dataport properties: Import = Yes
2: FieldStartDelimeter and FieldEndDelimiter = <None>
3: FieldSeperator = ;
4: FileName = "your CSV file"
5: FileFormat = Variable

6: The correct dataportfields are filled in. (View => Dataportfields)

If this doesn't help you, in the download section you can download
a dataportgenerator. With this tool you can create any dataport you like.

MaikelJ

Edward_Bloomfield

Hello Fleur,

When you say that nothing appears in the journal lines, do you mean that nothing appears in the journal form or that nothing appears in the Item Journal Line table? If you haven't tried running the table, it might be worth checking. If the Journal Template Name or Journal Batch Name is missing or incorrect in the *.csv file then maybe the lines have been imported into the table, but are not being filtered out in the form.

Hope this is helpful.

Fleur

HI

It seems to appear in the table but not on the form???

Thanks

navnav

Template Name, Batch Name correct ?

Fleur

THANKYOU SO MUCH..... IT HAS WORKED AND I AM NOW AN EXTREMELY HAPPY PERSON.......

:P

Fleur

Another problem..... It now appears in the journal form... but when I try adn post it, it says nothing to post. What I have noticed is that, if i drill into the item number and just reselect it... it posts ok... Obviously this is no good as I need automation as I will have quite a few lines. Am I missing some kind of validation

Torben_R.

Set the Property CallFieldValidate to Yes. Default is <Yes> but you have to actually set the property.

navnav

General rule : try always to fill the fields using :
Rec.VALIDATE(field name, value);