mibuso.com
Home› Navision Attain
Options

Importing Item entries

FleurFleur Member Posts: 25
edited 2003-03-26 in Navision Attain
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
Fleur

Comments

  • Options
    maikeljmaikelj Member Posts: 50
    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
  • Options
    Edward_BloomfieldEdward_Bloomfield Member Posts: 155
    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.
    Edward Bloomfield

    Lead Consultant
    Theta
  • Options
    FleurFleur Member Posts: 25
    HI

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

    Thanks
    Fleur
  • Options
    navnavnavnav Member Posts: 16
    Template Name, Batch Name correct ?
  • Options
    FleurFleur Member Posts: 25
    THANKYOU SO MUCH..... IT HAS WORKED AND I AM NOW AN EXTREMELY HAPPY PERSON.......

    :P
    Fleur
  • Options
    FleurFleur Member Posts: 25
    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
    Fleur
  • Options
    Torben_R.Torben_R. Member Posts: 99
    Set the Property CallFieldValidate to Yes. Default is <Yes> but you have to actually set the property.
  • Options
    navnavnavnav Member Posts: 16
    General rule : try always to fill the fields using :
    Rec.VALIDATE(field name, value);
Sign In or Register to comment.