You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@commons.apache.org by Gary Gregory <GG...@seagullsoftware.com> on 2011/02/01 15:50:13 UTC

RE: [csv] Fixes for commons-csv

Hi All,

I've just come across the need to do CSV work but from the JDBC POV.

This made me think of this project and whether a JDBC CSV driver could use [csv] as it's guts.

The higher-level issue though, is whether I would use [csv] at all when I can use a more complete API like JDBC.

This might explain why [csv] never made it out of the sandbox.

My question to Jacopo is: Have you considered going the JDBC route?

Curious,

Gary Gregory
Senior Software Engineer
Rocket Software
3340 Peachtree Road, Suite 820 . Atlanta, GA 30326 . USA
Tel: +1.404.760.1560
Email: ggregory@seagullsoftware.com
Web: seagull.rocketsoftware.comĀ  



> -----Original Message-----
> From: Jacopo Cappellato [mailto:jacopo.cappellato@gmail.com]
> Sent: Friday, January 28, 2011 12:54
> To: Commons Developers List
> Subject: Re: [csv] Fixes for commons-csv
> 
> Hi Gary,
> 
> first of all, thanks for the quick response; please see my comments inline:
> 
> On Jan 28, 2011, at 5:23 PM, Gary Gregory wrote:
> 
> > Hi Jacopo,
> >
> > First, yes, please contribute updates and fixes.
> >
> 
> Great, will do.
> 
> > Would you be willing to contribute more than 'small' things to turn the
> project into a real 1.0 release?
> 
> I think that the answer is "yes": we are using a snapshot for a project
> here at work and it would be great if we could use a real release; I would
> be happy to help in the process.
> 
> Kind regards,
> 
> Jacopo
> 
> >
> > I've not looked at the component in a loooong time so I am not sure what
> would be needed.
> >
> > Gary Gregory
> > Senior Software Engineer
> > Rocket Software
> > 3340 Peachtree Road, Suite 820 . Atlanta, GA 30326 . USA
> > Tel: +1.404.760.1560
> > Email: ggregory@seagullsoftware.com
> > Web: seagull.rocketsoftware.com
> >
> >
> >
> >> -----Original Message-----
> >> From: Jacopo Cappellato [mailto:jacopo.cappellato@gmail.com]
> >> Sent: Friday, January 28, 2011 11:14
> >> To: dev@commons.apache.org
> >> Subject: [csv] Fixes for commons-csv
> >>
> >> Hi all,
> >>
> >> I am a committer of the Apache OFBiz project and I am using commons-csv
> for
> >> a project at work.
> >> I am wondering if there are plans to maintain the common-csv package; if
> I
> >> will submit some patches and small enhancements will they be considered?
> >> If there is interest around this, I  may also be available to help to
> >> resolve some of the Jira task listed here:
> >>
> >> https://issues.apache.org/jira/browse/SANDBOX/fixforversion/12313514
> >>
> >> in order to be able to issue a release.
> >>
> >> Kind regards,
> >>
> >> Jacopo
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: dev-unsubscribe@commons.apache.org
> >> For additional commands, e-mail: dev-help@commons.apache.org
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: dev-unsubscribe@commons.apache.org
> > For additional commands, e-mail: dev-help@commons.apache.org
> >
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@commons.apache.org
> For additional commands, e-mail: dev-help@commons.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@commons.apache.org
For additional commands, e-mail: dev-help@commons.apache.org


RE: [csv] Fixes for commons-csv

Posted by Gary Gregory <GG...@seagullsoftware.com>.
> -----Original Message-----
> From: adrian.crum@sandglass-software.com [mailto:adrian.crum@sandglass-
> software.com]
> Sent: Tuesday, February 01, 2011 12:00
> To: dev@commons.apache.org
> Subject: RE: [csv] Fixes for commons-csv
> 
> Having a JDBC driver would make using CSV files a lot simpler. If the
> "guts" were pluggable, you could use the same driver for SDF files,
> Excel files, Open Doc data, etc.

But then you get into Eclipse ODA territory... 

How configurable does it have to be? 

For example: http://csvjdbc.sourceforge.net/

Gary

> 
> -Adrian
> 
> Quoting Gary Gregory <GG...@seagullsoftware.com>:
> 
> > Hi All,
> >
> > I've just come across the need to do CSV work but from the JDBC POV.
> >
> > This made me think of this project and whether a JDBC CSV driver
> > could use [csv] as it's guts.
> >
> > The higher-level issue though, is whether I would use [csv] at all
> > when I can use a more complete API like JDBC.
> >
> > This might explain why [csv] never made it out of the sandbox.
> >
> > My question to Jacopo is: Have you considered going the JDBC route?
> >
> > Curious,
> >
> > Gary Gregory
> > Senior Software Engineer
> > Rocket Software
> > 3340 Peachtree Road, Suite 820 . Atlanta, GA 30326 . USA
> > Tel: +1.404.760.1560
> > Email: ggregory@seagullsoftware.com
> > Web: seagull.rocketsoftware.com
> >
> >
> >
> >> -----Original Message-----
> >> From: Jacopo Cappellato [mailto:jacopo.cappellato@gmail.com]
> >> Sent: Friday, January 28, 2011 12:54
> >> To: Commons Developers List
> >> Subject: Re: [csv] Fixes for commons-csv
> >>
> >> Hi Gary,
> >>
> >> first of all, thanks for the quick response; please see my comments
> inline:
> >>
> >> On Jan 28, 2011, at 5:23 PM, Gary Gregory wrote:
> >>
> >> > Hi Jacopo,
> >> >
> >> > First, yes, please contribute updates and fixes.
> >> >
> >>
> >> Great, will do.
> >>
> >> > Would you be willing to contribute more than 'small' things to turn
> the
> >> project into a real 1.0 release?
> >>
> >> I think that the answer is "yes": we are using a snapshot for a project
> >> here at work and it would be great if we could use a real release; I
> would
> >> be happy to help in the process.
> >>
> >> Kind regards,
> >>
> >> Jacopo
> >>
> >> >
> >> > I've not looked at the component in a loooong time so I am not sure
> what
> >> would be needed.
> >> >
> >> > Gary Gregory
> >> > Senior Software Engineer
> >> > Rocket Software
> >> > 3340 Peachtree Road, Suite 820 . Atlanta, GA 30326 . USA
> >> > Tel: +1.404.760.1560
> >> > Email: ggregory@seagullsoftware.com
> >> > Web: seagull.rocketsoftware.com
> >> >
> >> >
> >> >
> >> >> -----Original Message-----
> >> >> From: Jacopo Cappellato [mailto:jacopo.cappellato@gmail.com]
> >> >> Sent: Friday, January 28, 2011 11:14
> >> >> To: dev@commons.apache.org
> >> >> Subject: [csv] Fixes for commons-csv
> >> >>
> >> >> Hi all,
> >> >>
> >> >> I am a committer of the Apache OFBiz project and I am using commons-
> csv
> >> for
> >> >> a project at work.
> >> >> I am wondering if there are plans to maintain the common-csv package;
> if
> >> I
> >> >> will submit some patches and small enhancements will they be
> considered?
> >> >> If there is interest around this, I  may also be available to help to
> >> >> resolve some of the Jira task listed here:
> >> >>
> >> >> https://issues.apache.org/jira/browse/SANDBOX/fixforversion/12313514
> >> >>
> >> >> in order to be able to issue a release.
> >> >>
> >> >> Kind regards,
> >> >>
> >> >> Jacopo
> >> >> ---------------------------------------------------------------------
> >> >> To unsubscribe, e-mail: dev-unsubscribe@commons.apache.org
> >> >> For additional commands, e-mail: dev-help@commons.apache.org
> >> >
> >> >
> >> > ---------------------------------------------------------------------
> >> > To unsubscribe, e-mail: dev-unsubscribe@commons.apache.org
> >> > For additional commands, e-mail: dev-help@commons.apache.org
> >> >
> >>
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: dev-unsubscribe@commons.apache.org
> >> For additional commands, e-mail: dev-help@commons.apache.org
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: dev-unsubscribe@commons.apache.org
> > For additional commands, e-mail: dev-help@commons.apache.org
> >
> >
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@commons.apache.org
> For additional commands, e-mail: dev-help@commons.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@commons.apache.org
For additional commands, e-mail: dev-help@commons.apache.org


RE: [csv] Fixes for commons-csv

Posted by ad...@sandglass-software.com.
Having a JDBC driver would make using CSV files a lot simpler. If the  
"guts" were pluggable, you could use the same driver for SDF files,  
Excel files, Open Doc data, etc.

-Adrian

Quoting Gary Gregory <GG...@seagullsoftware.com>:

> Hi All,
>
> I've just come across the need to do CSV work but from the JDBC POV.
>
> This made me think of this project and whether a JDBC CSV driver  
> could use [csv] as it's guts.
>
> The higher-level issue though, is whether I would use [csv] at all  
> when I can use a more complete API like JDBC.
>
> This might explain why [csv] never made it out of the sandbox.
>
> My question to Jacopo is: Have you considered going the JDBC route?
>
> Curious,
>
> Gary Gregory
> Senior Software Engineer
> Rocket Software
> 3340 Peachtree Road, Suite 820 . Atlanta, GA 30326 . USA
> Tel: +1.404.760.1560
> Email: ggregory@seagullsoftware.com
> Web: seagull.rocketsoftware.comĀ 
>
>
>
>> -----Original Message-----
>> From: Jacopo Cappellato [mailto:jacopo.cappellato@gmail.com]
>> Sent: Friday, January 28, 2011 12:54
>> To: Commons Developers List
>> Subject: Re: [csv] Fixes for commons-csv
>>
>> Hi Gary,
>>
>> first of all, thanks for the quick response; please see my comments inline:
>>
>> On Jan 28, 2011, at 5:23 PM, Gary Gregory wrote:
>>
>> > Hi Jacopo,
>> >
>> > First, yes, please contribute updates and fixes.
>> >
>>
>> Great, will do.
>>
>> > Would you be willing to contribute more than 'small' things to turn the
>> project into a real 1.0 release?
>>
>> I think that the answer is "yes": we are using a snapshot for a project
>> here at work and it would be great if we could use a real release; I would
>> be happy to help in the process.
>>
>> Kind regards,
>>
>> Jacopo
>>
>> >
>> > I've not looked at the component in a loooong time so I am not sure what
>> would be needed.
>> >
>> > Gary Gregory
>> > Senior Software Engineer
>> > Rocket Software
>> > 3340 Peachtree Road, Suite 820 . Atlanta, GA 30326 . USA
>> > Tel: +1.404.760.1560
>> > Email: ggregory@seagullsoftware.com
>> > Web: seagull.rocketsoftware.com
>> >
>> >
>> >
>> >> -----Original Message-----
>> >> From: Jacopo Cappellato [mailto:jacopo.cappellato@gmail.com]
>> >> Sent: Friday, January 28, 2011 11:14
>> >> To: dev@commons.apache.org
>> >> Subject: [csv] Fixes for commons-csv
>> >>
>> >> Hi all,
>> >>
>> >> I am a committer of the Apache OFBiz project and I am using commons-csv
>> for
>> >> a project at work.
>> >> I am wondering if there are plans to maintain the common-csv package; if
>> I
>> >> will submit some patches and small enhancements will they be considered?
>> >> If there is interest around this, I  may also be available to help to
>> >> resolve some of the Jira task listed here:
>> >>
>> >> https://issues.apache.org/jira/browse/SANDBOX/fixforversion/12313514
>> >>
>> >> in order to be able to issue a release.
>> >>
>> >> Kind regards,
>> >>
>> >> Jacopo
>> >> ---------------------------------------------------------------------
>> >> To unsubscribe, e-mail: dev-unsubscribe@commons.apache.org
>> >> For additional commands, e-mail: dev-help@commons.apache.org
>> >
>> >
>> > ---------------------------------------------------------------------
>> > To unsubscribe, e-mail: dev-unsubscribe@commons.apache.org
>> > For additional commands, e-mail: dev-help@commons.apache.org
>> >
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: dev-unsubscribe@commons.apache.org
>> For additional commands, e-mail: dev-help@commons.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@commons.apache.org
> For additional commands, e-mail: dev-help@commons.apache.org
>
>



---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@commons.apache.org
For additional commands, e-mail: dev-help@commons.apache.org


Re: [csv] Fixes for commons-csv

Posted by Jacopo Cappellato <ja...@gmail.com>.
Hi Gary,

On Feb 1, 2011, at 3:50 PM, Gary Gregory wrote:

> Hi All,
> 
> I've just come across the need to do CSV work but from the JDBC POV.
> 
> This made me think of this project and whether a JDBC CSV driver could use [csv] as it's guts.
> 
> The higher-level issue though, is whether I would use [csv] at all when I can use a more complete API like JDBC.
> 
> This might explain why [csv] never made it out of the sandbox.
> 
> My question to Jacopo is: Have you considered going the JDBC route?

I am currently using commons-csv simply as a tool to read data from CSV files (then with custom scripts the records are processed and transformed into data for the Apache OFBiz ERP).
I have never considered the JDBC route, even if I am not 100% sure I understand how you would use this,

Kind regards,

Jacopo

> 
> Curious,
> 
> Gary Gregory
> Senior Software Engineer
> Rocket Software
> 3340 Peachtree Road, Suite 820 . Atlanta, GA 30326 . USA
> Tel: +1.404.760.1560
> Email: ggregory@seagullsoftware.com
> Web: seagull.rocketsoftware.com  
> 
> 
> 
>> -----Original Message-----
>> From: Jacopo Cappellato [mailto:jacopo.cappellato@gmail.com]
>> Sent: Friday, January 28, 2011 12:54
>> To: Commons Developers List
>> Subject: Re: [csv] Fixes for commons-csv
>> 
>> Hi Gary,
>> 
>> first of all, thanks for the quick response; please see my comments inline:
>> 
>> On Jan 28, 2011, at 5:23 PM, Gary Gregory wrote:
>> 
>>> Hi Jacopo,
>>> 
>>> First, yes, please contribute updates and fixes.
>>> 
>> 
>> Great, will do.
>> 
>>> Would you be willing to contribute more than 'small' things to turn the
>> project into a real 1.0 release?
>> 
>> I think that the answer is "yes": we are using a snapshot for a project
>> here at work and it would be great if we could use a real release; I would
>> be happy to help in the process.
>> 
>> Kind regards,
>> 
>> Jacopo
>> 
>>> 
>>> I've not looked at the component in a loooong time so I am not sure what
>> would be needed.
>>> 
>>> Gary Gregory
>>> Senior Software Engineer
>>> Rocket Software
>>> 3340 Peachtree Road, Suite 820 . Atlanta, GA 30326 . USA
>>> Tel: +1.404.760.1560
>>> Email: ggregory@seagullsoftware.com
>>> Web: seagull.rocketsoftware.com
>>> 
>>> 
>>> 
>>>> -----Original Message-----
>>>> From: Jacopo Cappellato [mailto:jacopo.cappellato@gmail.com]
>>>> Sent: Friday, January 28, 2011 11:14
>>>> To: dev@commons.apache.org
>>>> Subject: [csv] Fixes for commons-csv
>>>> 
>>>> Hi all,
>>>> 
>>>> I am a committer of the Apache OFBiz project and I am using commons-csv
>> for
>>>> a project at work.
>>>> I am wondering if there are plans to maintain the common-csv package; if
>> I
>>>> will submit some patches and small enhancements will they be considered?
>>>> If there is interest around this, I  may also be available to help to
>>>> resolve some of the Jira task listed here:
>>>> 
>>>> https://issues.apache.org/jira/browse/SANDBOX/fixforversion/12313514
>>>> 
>>>> in order to be able to issue a release.
>>>> 
>>>> Kind regards,
>>>> 
>>>> Jacopo
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: dev-unsubscribe@commons.apache.org
>>>> For additional commands, e-mail: dev-help@commons.apache.org
>>> 
>>> 
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: dev-unsubscribe@commons.apache.org
>>> For additional commands, e-mail: dev-help@commons.apache.org
>>> 
>> 
>> 
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: dev-unsubscribe@commons.apache.org
>> For additional commands, e-mail: dev-help@commons.apache.org
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@commons.apache.org
> For additional commands, e-mail: dev-help@commons.apache.org
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@commons.apache.org
For additional commands, e-mail: dev-help@commons.apache.org