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.
Regards,
Hemant
They can conquer who believe they can.
0
Comments
Normally, csv is separated by ";" and not by "," and looks like this: so, try this:
Fieldstart and End Delimiter -- > <NONE>
FieldSeparator--> ;
Regards
Let me try this..
Hemant
They can conquer who believe they can.
Still the result is same only first value is imported.
Hemant
They can conquer who believe they can.
Hi garak,
Thanks for your reply.
Actuallly csv file is not allowed to be attached here.
Hemant
They can conquer who believe they can.
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.
Hemant
They can conquer who believe they can.
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).
Here a example table where the datas should store (ok, all code fields)
(2).
and here the example Dataport
(3).
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
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.
Hemant
They can conquer who believe they can.