Dataport Import Problem From CSV File.

Purvesh_Maisuria
Purvesh_Maisuria Member Posts: 71
edited 2010-11-22 in NAV/Navision Classic Client
Hello All,

I have a problem in IMPORTING data from CSV file with the help of DATAPORT.

Data in .CSV File which i want to import in my table posecode1.


This are dataport fileds i set.
Enabled SourceExpr StartPos Width
Yes Code 0 0
Yes City 0 0
Yes "Search City" 0 0

This is Dataport's Property I setted. I Also try FieldSeparator = <,> or <TAB> or < >(Space).


Result Result After dataport execution in the Postcode table is like this,


i want data in like this as a regular format.

Code City Search City
A B C
D E F
G H I

If Anyone have solution, please help me to solve this problem.

Thanks in Advanced
Purvesh Maisuria.

Comments

  • cernst
    cernst Member Posts: 280
    A CSV file is separeted by ; so try that as FieldSeparator.
    _____________________
    NAV Freelance Consultant
  • Purvesh_Maisuria
    Purvesh_Maisuria Member Posts: 71
    Hi cernst,

    I Already do that but it is not working, infect i put <None>, <COMMA>, <TAB>, <,>, <;> it give me same output.

    Thanks 4 Try & Reply.

    Purvesh Maisuria.
  • matttrax
    matttrax Member Posts: 2,309
    Unless it is the default, you only use the < and > in the FieldSeparator property to denote special separators like <TAB>. Otherwise you just use a comma. Your dataport is probably looking for the exact text of <,> and not finding it, thus treating the entire line as one field. So remove the < and >.
    Matt Traxinger - ArcherPoint
  • Purvesh_Maisuria
    Purvesh_Maisuria Member Posts: 71
    Hi Matttrax Sir,

    Grand Salute To U. =D>. Its Working Just Fine Now, Thanks 4 Giving Such a Exact Solution. Actually I Tried With ; without < and > But forgot to try , without < and > bz i tried lots of option like <COMMA>, <;>, <,>, <TAB>, <NEWLINE>, ; , TAB, lots of but not try ,(simple comma). By the Way Thanks Once Again 4 Sach a Wonderfull Reply, Hope U will solve problems of mine in future. Thanks Sir. =D>

    Thanks & Regards.
    Purvesh Maisuria.

Categories