BIRT XLS data source [message #242784] |
Thu, 14 June 2007 22: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 #242817 is a reply to message #242784] |
Fri, 15 June 2007 01:58 |
Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
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
>
>
|
|
|
Re: BIRT XLS data source [message #242912 is a reply to message #242817] |
Fri, 15 June 2007 10:13 |
Eclipse User |
|
|
|
Originally posted by: viktor_sch.inbox.ru
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
|
|
|
Re: BIRT XLS data source [message #242985 is a reply to message #242912] |
Sat, 16 June 2007 02:09 |
Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
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
>
>
|
|
|
Re: BIRT XLS data source [message #243495 is a reply to message #242985] |
Wed, 20 June 2007 12:52 |
Eclipse User |
|
|
|
Originally posted by: viktor_sch.inbox.ru
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
>>
|
|
|
Re: BIRT XLS data source [message #243553 is a reply to message #243495] |
Wed, 20 June 2007 14: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.04663 seconds