| BIRT XLS data source [message #242784] |
Thu, 14 June 2007 18:15  |
Eclipse User |
|
|
|
Originally posted by: viktor_sch.inbox.ru
Hello everybody!
I faced some problem. I need to obtain data from XLS file. was trying to
establish connection via Plain Text Data Source, but it uses comma delimiter
whereas Excel uses only semicolon delimiter for CSV files. In other way I
save XLS file in DBF format, but all opensource jdbc drivers i've found
don't provide functionality I need. So the question becomes how can I
obtain data from XLS file? I don't want to use scripted data source or other
hardcoding ways. Any peace of advise is thankfull.
Best Regards,
Viktor Stolbin
|
|
|
|
|
|
|
| Re: BIRT XLS data source [message #243553 is a reply to message #243495] |
Wed, 20 June 2007 10:13  |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
Viktor,
BIRT 2.1.2 used
org.eclipse.datatools.connectivity.oda.flatfile.ui_3.0.2.200 608301.jar
and
org.eclipse.datatools.connectivity.oda.flatfile_3.0.2.200608 311.jar
for the flat file driver. I would check these out of CVS and compare to
the lastest versions for DTP. If you want you may be able to just
checkout the above driver and hard code the comma separator to a ;.
Jason
Viktor Stolbin wrote:
> OK.
> And please could you make my searches in BIRT plugins more resultative by
> passing me a direction I should move. In other words, what plugins should I
> examine for FF Driver?
>
>
> "Jason Weathersby" <jasonweathersby@alltel.net> ???????/???????? ? ????????
> ?????????: news:f4vgmk$dgc$1@build.eclipse.org...
>> Viktor,
>>
>> I do not think they are backward compatible, but you may be able to
>> checkout the ff driver for 2.1 and modify it.
>>
>> Jason
>>
>> Viktor Stolbin wrote:
>>> Unfortunately we can't use 2.2 because our customers have an enterprise
>>> standart - Eclipse 3.2, but BIRT 2.2 as I know use Eclipse 3.3 SDK. So
>>> can I take 2.2 flat file driver and use it in BIRT 2.1?
>>>
>>>
>>> "Jason Weathersby" <jasonweathersby@alltel.net> ???????/???????? ?
>>> ???????? ?????????: news:f4srlr$gg7$2@build.eclipse.org...
>>>> Viktor,
>>>>
>>>> The 2.2 flat file driver can use semicolon seperated files.
>>>>
>>>> Jason
>>>>
>>>> Viktor Stolbin wrote:
>>>>> Hello everybody!
>>>>>
>>>>> I faced some problem. I need to obtain data from XLS file. was trying
>>>>> to establish connection via Plain Text Data Source, but it uses comma
>>>>> delimiter whereas Excel uses only semicolon delimiter for CSV files. In
>>>>> other way I save XLS file in DBF format, but all opensource jdbc
>>>>> drivers i've found don't provide functionality I need. So the question
>>>>> becomes how can I obtain data from XLS file? I don't want to use
>>>>> scripted data source or other hardcoding ways. Any peace of advise is
>>>>> thankfull.
>>>>>
>>>>> Best Regards,
>>>>> Viktor Stolbin
>
|
|
|
Powered by
FUDForum. Page generated in 0.04085 seconds
Home