type of the file that dataport can handle

shafeaa

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 ?

HalMdy

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

CSV can come with a comma ( , ) (US) or a semicolon ( ; ) (Europe) separator, depending on the language settings of Excel. :roll:

ara3n

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.

StephenG

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 ".