type of the file that dataport can handle

shafeaa
shafeaa Member Posts: 54
edited 2005-03-03 in NAV/Navision Classic Client
we have 4 types and we need to chose 2 of them in fact i know one of them but i am confuse about the other type

text format (txt)
navision object format (fob)
database(fdb)
Excel file (csv)

i know that dataport handle text format but what is the other types ?

Comments

  • HalMdy
    HalMdy Member Posts: 429
    CSV : text format, semicolon delimited, created by Excel --> Perfect for Import Dataport

    FOB : binary object file from/to Navision, not concerning Data Import/export by dataport. Used to save/restore part of you development (example)

    FDB : your Database file itself.
  • Kowa
    Kowa Member Posts: 926
    edited 2005-04-12
    CSV can come with a comma ( , ) (US) or a semicolon ( ; ) (Europe) separator, depending on the language settings of Excel. :roll:
    Kai Kowalewski
  • ara3n
    ara3n Member Posts: 9,258
    I allways use TAB delimited, when I export from Excel. and that's how I write my dataports, as TAB delimted. The reason I don' t use comma is because some fields can have comma as value and it screws up the column. Major headache.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • StephenG
    StephenG Member Posts: 99
    I always resave the Excel file as "Text (MS-DOS)", TAB delimited.

    Set the Dataport Properties:-
    FieldStartDelimiter <None>
    FieldEndDelimiter <None>
    FieldSeperator <TAB>

    As mentioned above the 'Comma' delimiter can cause problems when neeed in the data. Also the ' " ' can cause problems when included in the data eg. a description for 1/2 inch pipe would be "1/2" Pipe ".
    Answer the question and wait for the answer.

Categories