August 2010 - Webobjects-dev

Re: CSV File Reader
by Kieran Kelleher 31 Aug '10

31 Aug '10

site_archiver(a)lists.apple.com Delivered-To: webobjects-dev(a)lists.apple.com apache commons lang is in a couple of Wonder frameworks IIRC, but you can just drop the jar in your own foundation framework as your first port of call for general swiss army knife java foundation utilities. On Aug 31, 2010, at 6:00 PM, Ricardo J. Parada wrote: > > > That would be a good addition I think. I had already written my own for escaping/unescaping CSV. I would rather use what's out there. > > :-) > > > On Aug 31, 2010, at 5:51 PM, Kieran Kelleher wrote: > >> Does not get any simpler than apache commons lang CSV StringTokenizer.getCSVInstance() which is intelligent enough to understand Excel type CSV with delimiters when there is commas inside the token and no delimiters when there is no commas. It also escapes quotes IIRC. >> >> http://commons.apache.org/lang/api-2.4/org/apache/commons/lang/text/StrToke… >> >> Also of relevance for CSV processing are: >> >> http://commons.apache.org/lang/api-2.4/org/apache/commons/lang/StringEscape… .unescapeCsv(.....) >> >> http://commons.apache.org/lang/api-2.4/org/apache/commons/lang/StringEscape… escapeCsv(....) >> >> -Kieran >> >> PS. Mike, if there was ever another generic jar that Anjo was willing to allow into ERJars it should be apache commons lang extensions. Totally useful and commonly desired extensions to the java language and saves a lot of reinventing the wheel :-) >> >> They even have something like ERXSimpleTemplateParser that uses ${argname} style variables: >> http://commons.apache.org/lang/api-2.4/org/apache/commons/lang/text/StrSubs… >> >> >> On Aug 31, 2010, at 2:40 PM, Joe Moreno wrote: >> >>> Can anyone recommend a simple CSV file reader for WO? >>> >>> It needs to be smart enough to escape commas inside quotes, i.e.: >>> Name, Location >>> John Smith, "Cupertino, CA" >>> >>> I'm sure that this wouldn't be hard to write, but code I don't have to write is code that I don't have to debug. :^D >>> >>> Many thanks, >>> Joe >>> _______________________________________________ >>> Do not post admin requests to the list. They will be ignored. >>> Webobjects-dev mailing list (Webobjects-dev(a)lists.apple.com) >>> Help/Unsubscribe/Update your Subscription: >>> http://lists.apple.com/mailman/options/webobjects-dev/kieran_lists%40mac.com >>> >>> This email sent to kieran_lists(a)mac.com >> >> _______________________________________________ >> Do not post admin requests to the list. They will be ignored. >> Webobjects-dev mailing list (Webobjects-dev(a)lists.apple.com) >> Help/Unsubscribe/Update your Subscription: >> http://lists.apple.com/mailman/options/webobjects-dev/rparada%40mac.com >> >> This email sent to rparada(a)mac.com > _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev(a)lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/site_archiver%40lists… This email sent to site_archiver(a)lists.apple.com

1 0

Re: CSV File Reader
by Q 31 Aug '10

31 Aug '10

site_archiver(a)lists.apple.com Delivered-To: webobjects-dev(a)lists.apple.com Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:subject:mime-version :content-type:from:in-reply-to:date:cc:content-transfer-encoding :message-id:references:to:x-mailer; bh=9HfavkPOe/Hdj9IrLle1DkfPpZXiv1+PrIs4rHImbwQ=; b=m0jffFaMtcnVXcOm0vhujCM1EjrQLtFUOyTEsHtuBmo8AaXljU9S5b4TRUR3WFWqFi HMRkxLqEbej34kmStdD0CgECe2pg1gxfH52lLl0liD2CmZ+VOInIYSnAjSlSpFtCHoZf LkQsNmdcDPgN/AU0+zfh4eNfu/nWuLCwj1e7Y= Domainkey-signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=subject:mime-version:content-type:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to:x-mailer; b=AXqJBLzX0I1LoHMNtTXGAGgBRC6MUrlfpM/NKPzjStvupPIVKMMDqwPVcGsDV7sEBB CQjjbrGEx99R0GQMxpx98ycrA7qV7v6YBv91CNvpkNsOgr8g7VZtigrNeEUYc/c8KYsb 5rghq62pvndebXOMC8pyra1UKJbEJH+AKAPQY= On 01/09/2010, at 4:40 AM, Joe Moreno wrote: > Can anyone recommend a simple CSV file reader for WO? It doesn't get much simpler than opencsv, but it can be a little on the slow side compared to purpose written code if you need to process huge amounts of data quickly. > It needs to be smart enough to escape commas inside quotes, i.e.: > Name, Location > John Smith, "Cupertino, CA" > > I'm sure that this wouldn't be hard to write, but code I don't have to write is code that I don't have to debug. :^D An optimist. :) -- Seeya...Q Quinton Dolan - qdolan(a)gmail.com Gold Coast, QLD, Australia (GMT+10) _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev(a)lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/site_archiver%40lists… This email sent to site_archiver(a)lists.apple.com

1 0

Re: CSV File Reader
by Ricardo J. Parada 31 Aug '10

31 Aug '10

site_archiver(a)lists.apple.com Delivered-To: webobjects-dev(a)lists.apple.com That would be a good addition I think. I had already written my own for escaping/unescaping CSV. I would rather use what's out there. :-) On Aug 31, 2010, at 5:51 PM, Kieran Kelleher wrote: > Does not get any simpler than apache commons lang CSV StringTokenizer.getCSVInstance() which is intelligent enough to understand Excel type CSV with delimiters when there is commas inside the token and no delimiters when there is no commas. It also escapes quotes IIRC. > > http://commons.apache.org/lang/api-2.4/org/apache/commons/lang/text/StrToke… > > Also of relevance for CSV processing are: > > http://commons.apache.org/lang/api-2.4/org/apache/commons/lang/StringEscape… .unescapeCsv(.....) > > http://commons.apache.org/lang/api-2.4/org/apache/commons/lang/StringEscape… escapeCsv(....) > > -Kieran > > PS. Mike, if there was ever another generic jar that Anjo was willing to allow into ERJars it should be apache commons lang extensions. Totally useful and commonly desired extensions to the java language and saves a lot of reinventing the wheel :-) > > They even have something like ERXSimpleTemplateParser that uses ${argname} style variables: > http://commons.apache.org/lang/api-2.4/org/apache/commons/lang/text/StrSubs… > > > On Aug 31, 2010, at 2:40 PM, Joe Moreno wrote: > >> Can anyone recommend a simple CSV file reader for WO? >> >> It needs to be smart enough to escape commas inside quotes, i.e.: >> Name, Location >> John Smith, "Cupertino, CA" >> >> I'm sure that this wouldn't be hard to write, but code I don't have to write is code that I don't have to debug. :^D >> >> Many thanks, >> Joe >> _______________________________________________ >> Do not post admin requests to the list. They will be ignored. >> Webobjects-dev mailing list (Webobjects-dev(a)lists.apple.com) >> Help/Unsubscribe/Update your Subscription: >> http://lists.apple.com/mailman/options/webobjects-dev/kieran_lists%40mac.com >> >> This email sent to kieran_lists(a)mac.com > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list (Webobjects-dev(a)lists.apple.com) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/rparada%40mac.com > > This email sent to rparada(a)mac.com _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev(a)lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/site_archiver%40lists… This email sent to site_archiver(a)lists.apple.com

1 0

Re: CSV File Reader
by Kieran Kelleher 31 Aug '10

31 Aug '10

site_archiver(a)lists.apple.com Delivered-To: webobjects-dev(a)lists.apple.com Does not get any simpler than apache commons lang CSV StringTokenizer.getCSVInstance() which is intelligent enough to understand Excel type CSV with delimiters when there is commas inside the token and no delimiters when there is no commas. It also escapes quotes IIRC. http://commons.apache.org/lang/api-2.4/org/apache/commons/lang/text/StrToke… Also of relevance for CSV processing are: http://commons.apache.org/lang/api-2.4/org/apache/commons/lang/StringEscape… .unescapeCsv(.....) http://commons.apache.org/lang/api-2.4/org/apache/commons/lang/StringEscape… escapeCsv(....) -Kieran PS. Mike, if there was ever another generic jar that Anjo was willing to allow into ERJars it should be apache commons lang extensions. Totally useful and commonly desired extensions to the java language and saves a lot of reinventing the wheel :-) They even have something like ERXSimpleTemplateParser that uses ${argname} style variables: http://commons.apache.org/lang/api-2.4/org/apache/commons/lang/text/StrSubs… On Aug 31, 2010, at 2:40 PM, Joe Moreno wrote: > Can anyone recommend a simple CSV file reader for WO? > > It needs to be smart enough to escape commas inside quotes, i.e.: > Name, Location > John Smith, "Cupertino, CA" > > I'm sure that this wouldn't be hard to write, but code I don't have to write is code that I don't have to debug. :^D > > Many thanks, > Joe > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list (Webobjects-dev(a)lists.apple.com) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/kieran_lists%40mac.com > > This email sent to kieran_lists(a)mac.com _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev(a)lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/site_archiver%40lists… This email sent to site_archiver(a)lists.apple.com

1 0

Re: CSV File Reader
by Lon Varscsak 31 Aug '10

31 Aug '10

site_archiver(a)lists.apple.com Delivered-To: webobjects-dev(a)lists.apple.com I recently used opencvs, worked perfectly for my needs. -Lon On Tue, Aug 31, 2010 at 11:42 AM, Mike Schrag <mschrag(a)pobox.com> wrote: > http://opencsv.sourceforge.net/ > On Aug 31, 2010, at 2:40 PM, Joe Moreno wrote: > >> Can anyone recommend a simple CSV file reader for WO? >> >> It needs to be smart enough to escape commas inside quotes, i.e.: >> Name, Location >> John Smith, "Cupertino, CA" >> >> I'm sure that this wouldn't be hard to write, but code I don't have to write is code that I don't have to debug. :^D >> >> Many thanks, >> Joe >> _______________________________________________ >> Do not post admin requests to the list. They will be ignored. >> Webobjects-dev mailing list (Webobjects-dev(a)lists.apple.com) >> Help/Unsubscribe/Update your Subscription: >> http://lists.apple.com/mailman/options/webobjects-dev/mschrag%40pobox.com >> >> This email sent to mschrag(a)pobox.com > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list (Webobjects-dev(a)lists.apple.com) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/varscsak%40smarthealt… > > This email sent to varscsak(a)smarthealth.com > _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev(a)lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/site_archiver%40lists… This email sent to site_archiver(a)lists.apple.com

1 0

Re: CSV File Reader
by Mike Schrag 31 Aug '10

31 Aug '10

site_archiver(a)lists.apple.com Delivered-To: webobjects-dev(a)lists.apple.com Dkim-signature: v=1; a=rsa-sha1; c=relaxed; d=pobox.com; h=subject :mime-version:content-type:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; s=sasl; bh= eQ0MD8YswMmAzX1r5Rlq3WbKAbw=; b=WK8L7/v0fIf+bZ+ZvfZH7uPGIpzfRy2y qU8pH+jpyBIfuHIXddEjakvzITDf/Dw2IkZZs3AIGz4mR1z6GxYrO6VmFawBwNkW Nu4OQMjtkj/x6TixO4L4rGBLtvbXIY0Fjr6IJDJhWYZlwtYqll96DgmVHX4XnoVp GC3SuLqvxew= Domainkey-signature: a=rsa-sha1; c=nofws; d=pobox.com; h=subject :mime-version:content-type:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; q=dns; s= sasl; b=o+cDJAN7kIEaLIkZKCix0TWchCNvwVI6BrC2rDWTAIVt8jIr8Ha1Bml+ GgUz3eyUcL9aFO5+2ZGLTXp6lXCIGmQnAqTWp0FkbWmyrRp57pUdTnHnWH0s/kcE 3OvVNjVhWSxpb0gGdF2mcF2UJvpXZ0PpwnvxUVnO6OvQlZh8mQo= back in the day, ostermiller used to be GPL and he refused to dual license it ... not sure if that's still true On Aug 31, 2010, at 2:49 PM, Louis Demers wrote: > I use ostermillerutils_1_07_00 oof the page http://ostermiller.org/utils/ > > > On 2010-08-31, at 14:40 , Joe Moreno wrote: > >> Can anyone recommend a simple CSV file reader for WO? >> >> It needs to be smart enough to escape commas inside quotes, i.e.: >> Name, Location >> John Smith, "Cupertino, CA" >> >> I'm sure that this wouldn't be hard to write, but code I don't have to write is code that I don't have to debug. :^D >> >> Many thanks, >> Joe >> _______________________________________________ >> Do not post admin requests to the list. They will be ignored. >> Webobjects-dev mailing list (Webobjects-dev(a)lists.apple.com) >> Help/Unsubscribe/Update your Subscription: >> http://lists.apple.com/mailman/options/webobjects-dev/louisdemers%40mac.com >> >> This email sent to louisdemers(a)mac.com > > Louis Demers eng. > www.obzerv.com > > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list (Webobjects-dev(a)lists.apple.com) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/mschrag%40pobox.com > > This email sent to mschrag(a)pobox.com _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev(a)lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/site_archiver%40lists… This email sent to site_archiver(a)lists.apple.com

1 0

Re: CSV File Reader
by Louis Demers 31 Aug '10

31 Aug '10

site_archiver(a)lists.apple.com Delivered-To: webobjects-dev(a)lists.apple.com I use ostermillerutils_1_07_00 oof the page http://ostermiller.org/utils/ On 2010-08-31, at 14:40 , Joe Moreno wrote: > Can anyone recommend a simple CSV file reader for WO? > > It needs to be smart enough to escape commas inside quotes, i.e.: > Name, Location > John Smith, "Cupertino, CA" > > I'm sure that this wouldn't be hard to write, but code I don't have to write is code that I don't have to debug. :^D > > Many thanks, > Joe > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list (Webobjects-dev(a)lists.apple.com) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/louisdemers%40mac.com > > This email sent to louisdemers(a)mac.com Louis Demers eng. www.obzerv.com _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev(a)lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/site_archiver%40lists… This email sent to site_archiver(a)lists.apple.com

1 0

Re: CSV File Reader
by Mike Schrag 31 Aug '10

31 Aug '10

site_archiver(a)lists.apple.com Delivered-To: webobjects-dev(a)lists.apple.com Dkim-signature: v=1; a=rsa-sha1; c=relaxed; d=pobox.com; h=subject :mime-version:content-type:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; s=sasl; bh= NhLAGR7UCDciuuJynpn5rgF328k=; b=u26mnyfjZWWTqY0ImeirpZ/lv49B/fHT S/o24qYZZkFDfB6h0LoBBe9e9lICrFhcmt3rzC9iV5ja4DrDql2q5U3joF6o/1ZP qj/0X7QFqG4xcpNEKLbzbP8tfgmA5zrv7Rgk8CfczzfwLXCyBGyZXHqYjo50t4W+ Kx1UM+FA4hg= Domainkey-signature: a=rsa-sha1; c=nofws; d=pobox.com; h=subject :mime-version:content-type:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; q=dns; s= sasl; b=mVVUzrcrThg+FOXGDWuvqU1aQTpNnVjzw9LL2GpGyHrQQM7NIuL+eBw/ D/5Jq+YFqL2IKUcdB+u8NpP/036SdnMwpSyX4a7BlzR1rn4nT7j0pEKHZp2JwZU+ 45XgMyqU+Hqv7uMqMDNmKD6UiSrjVrXkQL3uEhKDllCHiylRJKs= http://opencsv.sourceforge.net/ On Aug 31, 2010, at 2:40 PM, Joe Moreno wrote: > Can anyone recommend a simple CSV file reader for WO? > > It needs to be smart enough to escape commas inside quotes, i.e.: > Name, Location > John Smith, "Cupertino, CA" > > I'm sure that this wouldn't be hard to write, but code I don't have to write is code that I don't have to debug. :^D > > Many thanks, > Joe > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list (Webobjects-dev(a)lists.apple.com) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/mschrag%40pobox.com > > This email sent to mschrag(a)pobox.com _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev(a)lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/site_archiver%40lists… This email sent to site_archiver(a)lists.apple.com

1 0

CSV File Reader
by Joe Moreno 31 Aug '10

31 Aug '10

site_archiver(a)lists.apple.com Delivered-To: webobjects-dev(a)lists.apple.com Can anyone recommend a simple CSV file reader for WO? It needs to be smart enough to escape commas inside quotes, i.e.: Name, Location John Smith, "Cupertino, CA" Many thanks, Joe _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev(a)lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/site_archiver%40lists… I'm sure that this wouldn't be hard to write, but code I don't have to write is code that I don't have to debug. :^D This email sent to site_archiver(a)lists.apple.com

1 0

Re: WOWODC 2010 recordings
by Ken Anderson 31 Aug '10

31 Aug '10

site_archiver(a)lists.apple.com Delivered-To: webobjects-dev(a)lists.apple.com Yes, extremely well organized - went off without a hitch! On Aug 31, 2010, at 12:58 PM, Louis Demers wrote: > Hi, > > While we didn't have the occasion to doit it in group, I want to thank you publicly for such a well orchestrated event. Congratulations and thank you very much for the effort you put in. > > Cheers > > > > On 2010-08-31, at 11:53 , Pascal Robert wrote: > >> Ok, so before people start asking the questions. Yes, we recorded most of the sessions, and I have looked at a couple of recordings and it only requires a minimum of editing. 3.5 sessions are missing (the .5 is my talk about Nagios, shame on me!) but 2.5 of them will be recorded again in the next month. >> >> And I want to take the opportunity to say a big "Thanks" to people who presented or attended. It was really great and we didn't have any major problems, so no heart attack for me! A big thanks to our 4 sponsors too, with their help we had a nice community dinner and t-shirts. >> >> Hope to see you next year! In Montreal, Toronto, San Jose, Frankfurt, Paris, London, or somewhere. But hopefully the city need to have a street like St-Denis Street to party :-) _______________________________________________ >> Do not post admin requests to the list. They will be ignored. >> Webobjects-dev mailing list (Webobjects-dev(a)lists.apple.com) >> Help/Unsubscribe/Update your Subscription: >> http://lists.apple.com/mailman/options/webobjects-dev/louisdemers%40mac.com >> >> This email sent to louisdemers(a)mac.com > > Louis Demers eng. > www.obzerv.com > > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list (Webobjects-dev(a)lists.apple.com) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/kenlists%40anderhome.… > > This email sent to kenlists(a)anderhome.com _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev(a)lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/site_archiver%40lists… This email sent to site_archiver(a)lists.apple.com

1 0