Problem in excel file format while import in dataport

hemantOne · 2010-04-15

Hi,

I create a dataport to import data in with properties-
File Format-variable
Fieldstart and End Delimiter--<">
FieldSeparator--<,>
RecordSeparator--<<newline>>

when i import the data from excelsheet(csv format) only first field value is imported.
Please experts tell me what may be the problem...I also tried with CSV(Ms-Dos) but same result.

Thanks.

garak · 2010-04-15

Could u please post here the first 3 lines of your csv file?

Normally, csv is separated by ";" and not by "," and looks like this:

75193;11000008956;17.12.2009
75194;11000008956;17.12.2009
75195;11000008956;17.12.2009

so, try this:

Fieldstart and End Delimiter -- > <NONE>
FieldSeparator--> ;

Regards

hemantOne · 2010-04-15

Thanks garak,

Let me try this..

hemantOne · 2010-04-15

hi,

so, try this:

Fieldstart and End Delimiter -- > <NONE>
FieldSeparator--> ;

Still the result is same only first value is imported.

garak · 2010-04-15

so, how looks you file. Post here please the first 4 lines or attach the file (if it is not to big)

hemantOne · 2010-04-15

[url][/url]
Hi garak,

Thanks for your reply.
Actuallly csv file is not allowed to be attached here.

hemantOne · 2010-04-15

Dear Garak,

The first row of my csv file looks--

50000,,test,learning,EACH,BUILDING,BUILDING,BENDER VA,0,25,100,DES0047,2,4/14/2010
After some modification i find that--
I took 14 columns in excel,and when import data from dataport the error-
The text
50000,,test,learning,EACH,BUILDING,BUILDING,BENDER VA,0,25,100,DES0047,2,4/14/2010
is too long.

Thanks in advance.

garak · 2010-04-15

ok, your field separator is "," and not ";" like i think.
Is there in a field also a "," so that there are more then 13 "," (14 columns, separated with "," -> 13x ",") :?:

Here an example with your File:

(1).

50000,,test,learning,EACH,BUILDING,BUILDING,BENDER VA,0,25,100,DES0047,2,4/14/2010
50001,,test,learning,EACH,BUILDING,BUILDING,Tender VA,0,25,100,DES0047,2,4/14/2010
50002,,test,learning,EACH,BUILDING,BUILDING,Rende VA,0,25,100,DES0047,2,4/14/2010
50003,,test,learning,EACH,BUILDING,BUILDING,GENDER VA,0,25,100,DES0047,2,4/14/2010
50004,,test,learning,EACH,BUILDING,BUILDING,WENDER VA,0,25,100,DES0047,2,4/14/2010
50005,,test,learning,EACH,BUILDING,BUILDING,UENDER VA,0,25,100,DES0047,2,4/14/2010
50006,,test,learning,EACH,BUILDING,BUILDING,PENDER VA,0,25,100,DES0047,2,4/14/2010

Here a example table where the datas should store (ok, all code fields)

(2).

OBJECT Table 50000 test
{
  OBJECT-PROPERTIES
  {
    Date=15.04.10;
    Time=11:45:12;
    Modified=Yes;
    Version List=;
  }
  PROPERTIES
  {
  }
  FIELDS
  {
    { 1   ;   ;Code1               ;Code20         }
    { 2   ;   ;Code2               ;Code20         }
    { 3   ;   ;Code3               ;Code20         }
    { 4   ;   ;Code4               ;Code20         }
    { 5   ;   ;Code5               ;Code20         }
    { 6   ;   ;Code6               ;Code20         }
    { 7   ;   ;Code7               ;Code20         }
    { 8   ;   ;Code8               ;Code20         }
    { 9   ;   ;Code9               ;Code20         }
    { 10  ;   ;Code10              ;Code20         }
    { 11  ;   ;Code11              ;Code20         }
    { 12  ;   ;Code12              ;Code20         }
    { 13  ;   ;Code13              ;Code20         }
    { 14  ;   ;Code14              ;Code20         }
  }
  KEYS
  {
    {    ;Code1                                   ;Clustered=Yes }
  }
  FIELDGROUPS
  {
  }
  CODE
  {

    BEGIN
    END.
  }
}

and here the example Dataport

(3).

OBJECT Dataport 50000 test
{
  OBJECT-PROPERTIES
  {
    Date=15.04.10;
    Time=11:46:20;
    Modified=Yes;
    Version List=;
  }
  PROPERTIES
  {
    FieldStartDelimiter=<None>;
    FieldEndDelimiter=<None>;
    FieldSeparator=,;
  }
  DATAITEMS
  {
    { PROPERTIES
      {
        DataItemTable=Table50000;
        DataItemTableView=SORTING(Code1);
      }
      FIELDS
      {
        {      ;     ;Code1                }
        {      ;     ;Code2                }
        {      ;     ;Code3                }
        {      ;     ;Code4                }
        {      ;     ;Code5                }
        {      ;     ;Code6                }
        {      ;     ;Code7                }
        {      ;     ;Code8                }
        {      ;     ;Code9                }
        {      ;     ;Code10               }
        {      ;     ;Code11               }
        {      ;     ;Code12               }
        {      ;     ;Code13               }
        {      ;     ;Code14               }
      }
       }
  }
  REQUESTFORM
  {
    PROPERTIES
    {
      Width=9020;
      Height=3410;
    }
    CONTROLS
    {
    }
  }
  CODE
  {

    BEGIN
    END.
  }
}

So, when i run the Dataport (not from design mode), the textfile (1) will be imported in table (2).
So, there must be something other wrong in your dataport or textfile.

Regards

hemantOne · 2010-04-15

Thanks garak for your continuous support.

When i save my csv file as text(tabseparated) it works fine.I found in mibuso that sometimes in csv files that type of problem comes while importing data..

Again very very thanks.

Problem in excel file format while import in dataport

Comments

Categories