Menu
▾
▴
phpesp-devel
|
From: angek p. <ang...@ip...> - 2002-03-26 09:26:38
|
Matthew, I've also sent this email to the list so that others may contribute their thoughts. I've tested your patch (on windows box using IE and Netscape plus on Linux box using Netscape and Konqueror) and it looks pretty good. The only minor issue I found was with Konqueror. It was not capable of displaying the $filename.csv name in the save as dialog box but rather It showed the file name "manage.php". It's contents however were that of the csv file. I've also had a quick look at the code and it also seems very good. I do however have a few suggestions: I don't believe that the download cvs facility should be replacing the exporting of the cvs file to the /tmp dir (or any other dir) but complement it. By this I mean that the saving of the csv file to a dir on the server should also occur when the csv file is being downloaded. I can think of quite a few scenarios where a central repository of result files might come in very handy. I also don't think that a survey with no results should be downloadable. If a survey has no results it should return an error statement as the current phpesp version does. My final comment is a challenge. Assuming that others feel the same way as I with regard to leaving a copy of the csv file on the server I'd like to see this process check to see if the csv file exists and if it does, not to overwrite it - as is the current case- but rather check the files size And if different create another copy of it with the current date appended to the end of the filename (or any other way where the csv files from a particular Survey can be distinquished from one another). So for example, assume that many of the surveys I create for my company run for a year. Each quarter the results are downloaded and analysed / compared to the previous Quarter's results. In this instance I would have 4 csv files on the server belonging to the same survey named quartely_survey_310302, quartely_survey_300602, Quartely_survey_300902 and quartely_survey_311202. Guys your thoughts please. Kon -----Original Message----- From: Matthew Gregg [mailto:gr...@co...] On Behalf Of Matthew Gregg Sent: Tuesday, 26 March 2002 2:34 PM To: Kon Angelopoulos Subject: Re: [phpesp-dev] Re: Re: Export Download Strange, just guessing but... It's a UNIX text file. Are you on Windows? Could be line ending differences. I converted it to DOS line endings and attached it again. On Tue, Mar 26, 2002 at 01:42:45PM +1100, Kon Angelopoulos wrote: > Thanks Matthew, > > When I viewed it, it was literally all over the place. > > Talk soon > > Kon Angelopoulos > Emerging Technologies Developer, Education > Spherion Group Ltd. -- brought to you by, Matthew Gregg... one of the friendly folks in the IT Lab. --------------------------------------\ The IT Lab (http://www.itlab.musc.edu) \____________________ Probably the world's premier software development center. Serving: Programming, Tools, Ice Cream, Seminars |
|
From: Kon A. <an...@cp...> - 2002-03-26 22:25:28
|
Guys,
the prefered mime type for excel is: application/vnd.ms-excel=20
Kon=20
|
|
From: Matthew G. <gr...@mu...> - 2002-03-26 22:32:28
|
But what if I'm not importing into Excel? I would prefer a more generic mime type. Unless of course "application/x-csv" is totally wrong. --On Wednesday, March 27, 2002 09:25:18 AM +1100 Kon Angelopoulos <an...@cp...> wrote: > > Guys, > > the prefered mime type for excel is: application/vnd.ms-excel > > Kon one of the friendly folks in the IT Lab. --------------------------------------\ The IT Lab (http://www.itlab.musc.edu) \____________________ Probably the world's premier software development center. Serving: Programming, Tools, Ice Cream, Seminars |
|
From: Kon A. <an...@cp...> - 2002-03-26 23:04:56
|
I totally agree I just don't think application/x-csv is a valid type Kon > -----Original Message----- > From: Matthew Gregg [mailto:gr...@mu...] > Sent: Wednesday, March 27, 2002 9:32 AM > To: Kon Angelopoulos; php...@li... > Subject: RE: [phpesp-dev] Re: Re: Export Download > > > But what if I'm not importing into Excel? I would prefer a more generic > mime type. Unless of course "application/x-csv" is totally wrong. > > --On Wednesday, March 27, 2002 09:25:18 AM +1100 Kon Angelopoulos > <an...@cp...> wrote: > > > > > Guys, > > > > the prefered mime type for excel is: application/vnd.ms-excel > > > > Kon > > > > one of the friendly folks in the IT Lab. > --------------------------------------\ > The IT Lab (http://www.itlab.musc.edu) \____________________ > Probably the world's premier software development center. > Serving: Programming, Tools, Ice Cream, Seminars > |
|
From: James E. F. <jf...@ac...> - 2002-03-27 01:10:42
|
-- Quoting RFC 2046 -- 4.1.4. Unrecognized Subtypes Unrecognized subtypes of "text" should be treated as subtype "plain" as long as the MIME implementation knows how to handle the charset. Unrecognized subtypes which also specify an unrecognized charset should be treated as "application/octet-stream". -- End Quote -- The "official" list of types is at: http://www.isi.edu/in-notes/iana/assignments/media-types/media-types and the closest type is "text/tab-separated-values". Perhaps we should use: "text/comma-separated-values". It works fine with Netscape 4.79 (linux) and Mozilla (linux). Plenty of people use the "application/x-foo" type for unregistered types... (pdf, gzip, etc) -James On Wed, 27 Mar 2002, Kon Angelopoulos wrote: > I totally agree > I just don't think application/x-csv is a valid type > > Kon > > > > -----Original Message----- > > From: Matthew Gregg [mailto:gr...@mu...] > > Sent: Wednesday, March 27, 2002 9:32 AM > > To: Kon Angelopoulos; php...@li... > > Subject: RE: [phpesp-dev] Re: Re: Export Download > > > > > > But what if I'm not importing into Excel? I would prefer a more generic > > mime type. Unless of course "application/x-csv" is totally wrong. > > > > --On Wednesday, March 27, 2002 09:25:18 AM +1100 Kon Angelopoulos > > <an...@cp...> wrote: > > > > > > > > Guys, > > > > > > the prefered mime type for excel is: application/vnd.ms-excel > > > > > > Kon > > > > > > > > one of the friendly folks in the IT Lab. > > --------------------------------------\ > > The IT Lab (http://www.itlab.musc.edu) \____________________ > > Probably the world's premier software development center. > > Serving: Programming, Tools, Ice Cream, Seminars > > > > _______________________________________________ > phpESP-devel mailing list > php...@li... > https://lists.sourceforge.net/lists/listinfo/phpesp-devel > |
|
From: Matthew G. <gr...@mu...> - 2002-03-27 01:13:14
|
This is turning into a difficult question indeed :) The /etc/mime.types file on my box lists this: text/comma-separated-values The Official listing of Media(mime) Types at IANA http://www.isi.edu/in-notes/iana/assignments/media-types/media-types list no CVS type at all, but does list test/tab-separated-values which is where I'm assuming text/comma-separate-values derives from. The RFC on the MIME Information Page http://www.hunnysoft.com/mime/ List no such mime type and suggest the following: "Unrecognized subtypes of "text" should be treated as subtype "plain" as long as the MIME implementation knows how to handle the charset. Unrecognized subtypes which also specify an unrecognized charset should be treated as "application/octet- stream"." A thread on Google groups http://groups.google.com/groups?hl=en&frame=right&th=c4a57c10fa3fda60&seekm =Pine.GHP.4.21.0011201856130.3313-100000%40hpplus03.cern.ch#link1 suggests text/comma-separated-values over application/octet-stream. Argh... --On Wednesday, March 27, 2002 10:04:49 AM +1100 Kon Angelopoulos <an...@cp...> wrote: > I totally agree > I just don't think application/x-csv is a valid type > > Kon > > >> -----Original Message----- >> From: Matthew Gregg [mailto:gr...@mu...] >> Sent: Wednesday, March 27, 2002 9:32 AM >> To: Kon Angelopoulos; php...@li... >> Subject: RE: [phpesp-dev] Re: Re: Export Download >> >> >> But what if I'm not importing into Excel? I would prefer a more generic >> mime type. Unless of course "application/x-csv" is totally wrong. >> >> --On Wednesday, March 27, 2002 09:25:18 AM +1100 Kon Angelopoulos >> <an...@cp...> wrote: >> >> > >> > Guys, >> > >> > the prefered mime type for excel is: application/vnd.ms-excel >> > >> > Kon >> >> >> >> one of the friendly folks in the IT Lab. >> --------------------------------------\ >> The IT Lab (http://www.itlab.musc.edu) \____________________ >> Probably the world's premier software development center. >> Serving: Programming, Tools, Ice Cream, Seminars >> > one of the friendly folks in the IT Lab. --------------------------------------\ The IT Lab (http://www.itlab.musc.edu) \____________________ Probably the world's premier software development center. Serving: Programming, Tools, Ice Cream, Seminars |
|
From: Matthew G. <gr...@mu...> - 2002-03-27 01:13:58
|
This is turning into a difficult question indeed :) The /etc/mime.types file on my box lists this: text/comma-separated-values The Official listing of Media(mime) Types at IANA http://www.isi.edu/in-notes/iana/assignments/media-types/media-types list no CVS type at all, but does list test/tab-separated-values which is where I'm assuming text/comma-separate-values derives from. The RFC on the MIME Information Page http://www.hunnysoft.com/mime/ List no such mime type and suggest the following: "Unrecognized subtypes of "text" should be treated as subtype "plain" as long as the MIME implementation knows how to handle the charset. Unrecognized subtypes which also specify an unrecognized charset should be treated as "application/octet- stream"." A thread on Google groups http://groups.google.com/groups?hl=en&frame=right&th=c4a57c10fa3fda60&seekm =Pine.GHP.4.21.0011201856130.3313-100000%40hpplus03.cern.ch#link1 suggests text/comma-separated-values over application/octet-stream. Argh... --On Wednesday, March 27, 2002 10:04:49 AM +1100 Kon Angelopoulos <an...@cp...> wrote: > I totally agree > I just don't think application/x-csv is a valid type > > Kon > > >> -----Original Message----- >> From: Matthew Gregg [mailto:gr...@mu...] >> Sent: Wednesday, March 27, 2002 9:32 AM >> To: Kon Angelopoulos; php...@li... >> Subject: RE: [phpesp-dev] Re: Re: Export Download >> >> >> But what if I'm not importing into Excel? I would prefer a more generic >> mime type. Unless of course "application/x-csv" is totally wrong. >> >> --On Wednesday, March 27, 2002 09:25:18 AM +1100 Kon Angelopoulos >> <an...@cp...> wrote: >> >> > >> > Guys, >> > >> > the prefered mime type for excel is: application/vnd.ms-excel >> > >> > Kon >> >> >> >> one of the friendly folks in the IT Lab. >> --------------------------------------\ >> The IT Lab (http://www.itlab.musc.edu) \____________________ >> Probably the world's premier software development center. >> Serving: Programming, Tools, Ice Cream, Seminars >> > one of the friendly folks in the IT Lab. --------------------------------------\ The IT Lab (http://www.itlab.musc.edu) \____________________ Probably the world's premier software development center. Serving: Programming, Tools, Ice Cream, Seminars |
|
From: Matthew G. <gr...@mu...> - 2002-03-27 01:14:03
|
This is turning into a difficult question indeed :) The /etc/mime.types file on my box lists this: text/comma-separated-values The Official listing of Media(mime) Types at IANA http://www.isi.edu/in-notes/iana/assignments/media-types/media-types list no CVS type at all, but does list test/tab-separated-values which is where I'm assuming text/comma-separate-values derives from. The RFC on the MIME Information Page http://www.hunnysoft.com/mime/ List no such mime type and suggest the following: "Unrecognized subtypes of "text" should be treated as subtype "plain" as long as the MIME implementation knows how to handle the charset. Unrecognized subtypes which also specify an unrecognized charset should be treated as "application/octet- stream"." A thread on Google groups http://groups.google.com/groups?hl=en&frame=right&th=c4a57c10fa3fda60&seekm =Pine.GHP.4.21.0011201856130.3313-100000%40hpplus03.cern.ch#link1 suggests text/comma-separated-values over application/octet-stream. Argh... --On Wednesday, March 27, 2002 10:04:49 AM +1100 Kon Angelopoulos <an...@cp...> wrote: > I totally agree > I just don't think application/x-csv is a valid type > > Kon > > >> -----Original Message----- >> From: Matthew Gregg [mailto:gr...@mu...] >> Sent: Wednesday, March 27, 2002 9:32 AM >> To: Kon Angelopoulos; php...@li... >> Subject: RE: [phpesp-dev] Re: Re: Export Download >> >> >> But what if I'm not importing into Excel? I would prefer a more generic >> mime type. Unless of course "application/x-csv" is totally wrong. >> >> --On Wednesday, March 27, 2002 09:25:18 AM +1100 Kon Angelopoulos >> <an...@cp...> wrote: >> >> > >> > Guys, >> > >> > the prefered mime type for excel is: application/vnd.ms-excel >> > >> > Kon >> >> >> >> one of the friendly folks in the IT Lab. >> --------------------------------------\ >> The IT Lab (http://www.itlab.musc.edu) \____________________ >> Probably the world's premier software development center. >> Serving: Programming, Tools, Ice Cream, Seminars >> > one of the friendly folks in the IT Lab. --------------------------------------\ The IT Lab (http://www.itlab.musc.edu) \____________________ Probably the world's premier software development center. Serving: Programming, Tools, Ice Cream, Seminars |
|
From: Kon A. <an...@cp...> - 2002-03-27 01:34:38
|
Excellent, This is exactly the same process I took, that's why I said that it may not be a valid type. However, having tested your original patch, which used a Content_Type of text/plain-text, on IE5, IE5.5, IE6, Netscape 4.72, Netscape 6.2.1, I found no problem with it. All presented the save as dialog box and downloaded the file correctly. I can certainly perform the same tests using application/x-csv and text/comma-separated-values and see how I go with them. I'll present the results to the list on Thursday night (that's Aussie time) and we can take it from there. Would everyone be cool with that? If anyone can do it before then let me know. Kon > -----Original Message----- > From: Matthew Gregg [mailto:gr...@mu...] > Sent: Wednesday, March 27, 2002 12:14 PM > To: Kon Angelopoulos; php...@li... > Subject: RE: [phpesp-dev] Re: Re: Export Download > > > This is turning into a difficult question indeed :) > > The /etc/mime.types file on my box lists this: > text/comma-separated-values > > The Official listing of Media(mime) Types at IANA > http://www.isi.edu/in-notes/iana/assignments/media-types/media-types > list no CVS type at all, but does list > test/tab-separated-values > which is where I'm assuming text/comma-separate-values derives from. > > The RFC on the MIME Information Page > http://www.hunnysoft.com/mime/ > List no such mime type and suggest the following: > > "Unrecognized subtypes of "text" should be treated as subtype "plain" > as long as the MIME implementation knows how to handle the charset. > Unrecognized subtypes which also specify an unrecognized charset > should be treated as "application/octet- stream"." > > A thread on Google groups > http://groups.google.com/groups?hl=en&frame=right&th=c4a57c10fa3fd > a60&seekm > =Pine.GHP.4.21.0011201856130.3313-100000%40hpplus03.cern.ch#link1 > > suggests text/comma-separated-values over application/octet-stream. > > Argh... > > > > > > --On Wednesday, March 27, 2002 10:04:49 AM +1100 Kon Angelopoulos > <an...@cp...> wrote: > > > I totally agree > > I just don't think application/x-csv is a valid type > > > > Kon > > > > > >> -----Original Message----- > >> From: Matthew Gregg [mailto:gr...@mu...] > >> Sent: Wednesday, March 27, 2002 9:32 AM > >> To: Kon Angelopoulos; php...@li... > >> Subject: RE: [phpesp-dev] Re: Re: Export Download > >> > >> > >> But what if I'm not importing into Excel? I would prefer a > more generic > >> mime type. Unless of course "application/x-csv" is totally wrong. > >> > >> --On Wednesday, March 27, 2002 09:25:18 AM +1100 Kon Angelopoulos > >> <an...@cp...> wrote: > >> > >> > > >> > Guys, > >> > > >> > the prefered mime type for excel is: application/vnd.ms-excel > >> > > >> > Kon > >> > >> > >> > >> one of the friendly folks in the IT Lab. > >> --------------------------------------\ > >> The IT Lab (http://www.itlab.musc.edu) \____________________ > >> Probably the world's premier software development center. > >> Serving: Programming, Tools, Ice Cream, Seminars > >> > > > > > > one of the friendly folks in the IT Lab. > --------------------------------------\ > The IT Lab (http://www.itlab.musc.edu) \____________________ > Probably the world's premier software development center. > Serving: Programming, Tools, Ice Cream, Seminars > |
|
From: Matthew G. <gr...@mu...> - 2002-03-27 01:48:01
|
Ok, lets see if this thing can reply just once this time. Serves me right using Beta software. I'm cool with Thrusday. One other thing to try in your testing. Past dealings with pushing files to IE lead me to belive that it may ignore mime-types and go strictly with filename extentions. So try changing the extention around and see what the browsers do. For example try sending the filename as "somthing.doc" with a csv mime-type. I bet IE will associate it with Word. Thanks. --On Wednesday, March 27, 2002 12:34:20 PM +1100 Kon Angelopoulos <an...@cp...> wrote: > Excellent, > > This is exactly the same process I took, that's why I said that it > may not be a valid type. However, having tested your original patch, > which used a Content_Type of text/plain-text, > on IE5, IE5.5, IE6, Netscape 4.72, Netscape 6.2.1, > I found no problem with it. All presented the save as dialog box and > downloaded the file correctly. > > I can certainly perform the same tests using application/x-csv and > text/comma-separated-values > and see how I go with them. > I'll present the results to the list on Thursday night (that's Aussie > time) and we can take it from there. > > Would everyone be cool with that? > > If anyone can do it before then let me know. > > Kon > >> -----Original Message----- >> From: Matthew Gregg [mailto:gr...@mu...] >> Sent: Wednesday, March 27, 2002 12:14 PM >> To: Kon Angelopoulos; php...@li... >> Subject: RE: [phpesp-dev] Re: Re: Export Download >> >> >> This is turning into a difficult question indeed :) >> >> The /etc/mime.types file on my box lists this: >> text/comma-separated-values >> >> The Official listing of Media(mime) Types at IANA >> http://www.isi.edu/in-notes/iana/assignments/media-types/media-types >> list no CVS type at all, but does list >> test/tab-separated-values >> which is where I'm assuming text/comma-separate-values derives from. >> >> The RFC on the MIME Information Page >> http://www.hunnysoft.com/mime/ >> List no such mime type and suggest the following: >> >> "Unrecognized subtypes of "text" should be treated as subtype "plain" >> as long as the MIME implementation knows how to handle the charset. >> Unrecognized subtypes which also specify an unrecognized charset >> should be treated as "application/octet- stream"." >> >> A thread on Google groups >> http://groups.google.com/groups?hl=en&frame=right&th=c4a57c10fa3fd >> a60&seekm >> =Pine.GHP.4.21.0011201856130.3313-100000%40hpplus03.cern.ch#link1 >> >> suggests text/comma-separated-values over application/octet-stream. >> >> Argh... >> >> >> >> >> >> --On Wednesday, March 27, 2002 10:04:49 AM +1100 Kon Angelopoulos >> <an...@cp...> wrote: >> >> > I totally agree >> > I just don't think application/x-csv is a valid type >> > >> > Kon >> > >> > >> >> -----Original Message----- >> >> From: Matthew Gregg [mailto:gr...@mu...] >> >> Sent: Wednesday, March 27, 2002 9:32 AM >> >> To: Kon Angelopoulos; php...@li... >> >> Subject: RE: [phpesp-dev] Re: Re: Export Download >> >> >> >> >> >> But what if I'm not importing into Excel? I would prefer a >> more generic >> >> mime type. Unless of course "application/x-csv" is totally wrong. >> >> >> >> --On Wednesday, March 27, 2002 09:25:18 AM +1100 Kon Angelopoulos >> >> <an...@cp...> wrote: >> >> >> >> > >> >> > Guys, >> >> > >> >> > the prefered mime type for excel is: application/vnd.ms-excel >> >> > >> >> > Kon >> >> >> >> >> >> >> >> one of the friendly folks in the IT Lab. >> >> --------------------------------------\ >> >> The IT Lab (http://www.itlab.musc.edu) \____________________ >> >> Probably the world's premier software development center. >> >> Serving: Programming, Tools, Ice Cream, Seminars >> >> >> > >> >> >> >> one of the friendly folks in the IT Lab. >> --------------------------------------\ >> The IT Lab (http://www.itlab.musc.edu) \____________________ >> Probably the world's premier software development center. >> Serving: Programming, Tools, Ice Cream, Seminars >> > one of the friendly folks in the IT Lab. --------------------------------------\ The IT Lab (http://www.itlab.musc.edu) \____________________ Probably the world's premier software development center. Serving: Programming, Tools, Ice Cream, Seminars |
|
From: Kon A. <an...@cp...> - 2002-03-27 02:41:57
|
Thanks for that, I'll keep it in mind Kon > -----Original Message----- > From: Matthew Gregg [mailto:gr...@mu...] > Sent: Wednesday, March 27, 2002 12:48 PM > To: Kon Angelopoulos; php...@li... > Subject: RE: [phpesp-dev] Re: Re: Export Download > > > Ok, lets see if this thing can reply just once this time. Serves > me right > using Beta software. > > I'm cool with Thrusday. > One other thing to try in your testing. Past dealings with pushing files > to IE lead me to belive that it may ignore mime-types and go > strictly with > filename extentions. So try changing the extention around and > see what the > browsers do. For example try sending the filename as > "somthing.doc" with a > csv mime-type. I bet IE will associate it with Word. > > Thanks. > > > --On Wednesday, March 27, 2002 12:34:20 PM +1100 Kon Angelopoulos > <an...@cp...> wrote: > > > Excellent, > > > > This is exactly the same process I took, that's why I said that it > > may not be a valid type. However, having tested your original patch, > > which used a Content_Type of text/plain-text, > > on IE5, IE5.5, IE6, Netscape 4.72, Netscape 6.2.1, > > I found no problem with it. All presented the save as dialog box and > > downloaded the file correctly. > > > > I can certainly perform the same tests using application/x-csv and > > text/comma-separated-values > > and see how I go with them. > > I'll present the results to the list on Thursday night > (that's Aussie > > time) and we can take it from there. > > > > Would everyone be cool with that? > > > > If anyone can do it before then let me know. > > > > Kon > > > >> -----Original Message----- > >> From: Matthew Gregg [mailto:gr...@mu...] > >> Sent: Wednesday, March 27, 2002 12:14 PM > >> To: Kon Angelopoulos; php...@li... > >> Subject: RE: [phpesp-dev] Re: Re: Export Download > >> > >> > >> This is turning into a difficult question indeed :) > >> > >> The /etc/mime.types file on my box lists this: > >> text/comma-separated-values > >> > >> The Official listing of Media(mime) Types at IANA > >> http://www.isi.edu/in-notes/iana/assignments/media-types/media-types > >> list no CVS type at all, but does list > >> test/tab-separated-values > >> which is where I'm assuming text/comma-separate-values derives from. > >> > >> The RFC on the MIME Information Page > >> http://www.hunnysoft.com/mime/ > >> List no such mime type and suggest the following: > >> > >> "Unrecognized subtypes of "text" should be treated as subtype "plain" > >> as long as the MIME implementation knows how to handle the charset. > >> Unrecognized subtypes which also specify an unrecognized charset > >> should be treated as "application/octet- stream"." > >> > >> A thread on Google groups > >> http://groups.google.com/groups?hl=en&frame=right&th=c4a57c10fa3fd > >> a60&seekm > >> =Pine.GHP.4.21.0011201856130.3313-100000%40hpplus03.cern.ch#link1 > >> > >> suggests text/comma-separated-values over application/octet-stream. > >> > >> Argh... > >> > >> > >> > >> > >> > >> --On Wednesday, March 27, 2002 10:04:49 AM +1100 Kon Angelopoulos > >> <an...@cp...> wrote: > >> > >> > I totally agree > >> > I just don't think application/x-csv is a valid type > >> > > >> > Kon > >> > > >> > > >> >> -----Original Message----- > >> >> From: Matthew Gregg [mailto:gr...@mu...] > >> >> Sent: Wednesday, March 27, 2002 9:32 AM > >> >> To: Kon Angelopoulos; php...@li... > >> >> Subject: RE: [phpesp-dev] Re: Re: Export Download > >> >> > >> >> > >> >> But what if I'm not importing into Excel? I would prefer a > >> more generic > >> >> mime type. Unless of course "application/x-csv" is totally wrong. > >> >> > >> >> --On Wednesday, March 27, 2002 09:25:18 AM +1100 Kon Angelopoulos > >> >> <an...@cp...> wrote: > >> >> > >> >> > > >> >> > Guys, > >> >> > > >> >> > the prefered mime type for excel is: application/vnd.ms-excel > >> >> > > >> >> > Kon > >> >> > >> >> > >> >> > >> >> one of the friendly folks in the IT Lab. > >> >> --------------------------------------\ > >> >> The IT Lab (http://www.itlab.musc.edu) \____________________ > >> >> Probably the world's premier software development center. > >> >> Serving: Programming, Tools, Ice Cream, Seminars > >> >> > >> > > >> > >> > >> > >> one of the friendly folks in the IT Lab. > >> --------------------------------------\ > >> The IT Lab (http://www.itlab.musc.edu) \____________________ > >> Probably the world's premier software development center. > >> Serving: Programming, Tools, Ice Cream, Seminars > >> > > > > > > one of the friendly folks in the IT Lab. > --------------------------------------\ > The IT Lab (http://www.itlab.musc.edu) \____________________ > Probably the world's premier software development center. > Serving: Programming, Tools, Ice Cream, Seminars > |
|
From: Kon A. <an...@cp...> - 2002-03-27 01:10:46
Attachments:
winmail.dat
|
Guys, As far as I'm concerned I'm not fussed at all about appending the current date to the end of the csv file. This was a hypethetical scenario to illustrate a point. I certainly copy then archive all my surveys but the point I tried to make was that not everyone will do this (as we've seen on some of the posts to the general list). We certainly can't control how people use this product but we should be striving to ensure that this product can deal with such issues. Kon |
|
From: Matthew G. <gr...@mu...> - 2002-03-27 01:18:03
|
Whoops.. Sorry for the duplicates. My mail client froze. Then decided to go into a sending fit. --On Tuesday, March 26, 2002 08:13:01 PM -0500 Matthew Gregg <gr...@mu...> wrote: > This is turning into a difficult question indeed :) > > The /etc/mime.types file on my box lists this: > text/comma-separated-values > > The Official listing of Media(mime) Types at IANA > http://www.isi.edu/in-notes/iana/assignments/media-types/media-types > list no CVS type at all, but does list > test/tab-separated-values > which is where I'm assuming text/comma-separate-values derives from. > > The RFC on the MIME Information Page > http://www.hunnysoft.com/mime/ > List no such mime type and suggest the following: > > "Unrecognized subtypes of "text" should be treated as subtype "plain" > as long as the MIME implementation knows how to handle the charset. > Unrecognized subtypes which also specify an unrecognized charset > should be treated as "application/octet- stream"." > > A thread on Google groups > http://groups.google.com/groups?hl=en&frame=right&th=c4a57c10fa3fda60&see > km =Pine.GHP.4.21.0011201856130.3313-100000%40hpplus03.cern.ch#link1 > > suggests text/comma-separated-values over application/octet-stream. > > Argh... > > > > > > --On Wednesday, March 27, 2002 10:04:49 AM +1100 Kon Angelopoulos > <an...@cp...> wrote: > >> I totally agree >> I just don't think application/x-csv is a valid type >> >> Kon >> >> >>> -----Original Message----- >>> From: Matthew Gregg [mailto:gr...@mu...] >>> Sent: Wednesday, March 27, 2002 9:32 AM >>> To: Kon Angelopoulos; php...@li... >>> Subject: RE: [phpesp-dev] Re: Re: Export Download >>> >>> >>> But what if I'm not importing into Excel? I would prefer a more generic >>> mime type. Unless of course "application/x-csv" is totally wrong. >>> >>> --On Wednesday, March 27, 2002 09:25:18 AM +1100 Kon Angelopoulos >>> <an...@cp...> wrote: >>> >>> > >>> > Guys, >>> > >>> > the prefered mime type for excel is: application/vnd.ms-excel >>> > >>> > Kon >>> >>> >>> >>> one of the friendly folks in the IT Lab. >>> --------------------------------------\ >>> The IT Lab (http://www.itlab.musc.edu) \____________________ >>> Probably the world's premier software development center. >>> Serving: Programming, Tools, Ice Cream, Seminars >>> >> > > > > one of the friendly folks in the IT Lab. > --------------------------------------\ > The IT Lab (http://www.itlab.musc.edu) \____________________ > Probably the world's premier software development center. > Serving: Programming, Tools, Ice Cream, Seminars > > _______________________________________________ > phpESP-devel mailing list > php...@li... > https://lists.sourceforge.net/lists/listinfo/phpesp-devel > one of the friendly folks in the IT Lab. --------------------------------------\ The IT Lab (http://www.itlab.musc.edu) \____________________ Probably the world's premier software development center. Serving: Programming, Tools, Ice Cream, Seminars |
|
From: Matthew G. <gr...@mu...> - 2002-03-27 01:18:09
|
Whoops.. Sorry for the duplicates. My mail client froze. Then decided to go into a sending fit. --On Tuesday, March 26, 2002 08:13:01 PM -0500 Matthew Gregg <gr...@mu...> wrote: > This is turning into a difficult question indeed :) > > The /etc/mime.types file on my box lists this: > text/comma-separated-values > > The Official listing of Media(mime) Types at IANA > http://www.isi.edu/in-notes/iana/assignments/media-types/media-types > list no CVS type at all, but does list > test/tab-separated-values > which is where I'm assuming text/comma-separate-values derives from. > > The RFC on the MIME Information Page > http://www.hunnysoft.com/mime/ > List no such mime type and suggest the following: > > "Unrecognized subtypes of "text" should be treated as subtype "plain" > as long as the MIME implementation knows how to handle the charset. > Unrecognized subtypes which also specify an unrecognized charset > should be treated as "application/octet- stream"." > > A thread on Google groups > http://groups.google.com/groups?hl=en&frame=right&th=c4a57c10fa3fda60&see > km =Pine.GHP.4.21.0011201856130.3313-100000%40hpplus03.cern.ch#link1 > > suggests text/comma-separated-values over application/octet-stream. > > Argh... > > > > > > --On Wednesday, March 27, 2002 10:04:49 AM +1100 Kon Angelopoulos > <an...@cp...> wrote: > >> I totally agree >> I just don't think application/x-csv is a valid type >> >> Kon >> >> >>> -----Original Message----- >>> From: Matthew Gregg [mailto:gr...@mu...] >>> Sent: Wednesday, March 27, 2002 9:32 AM >>> To: Kon Angelopoulos; php...@li... >>> Subject: RE: [phpesp-dev] Re: Re: Export Download >>> >>> >>> But what if I'm not importing into Excel? I would prefer a more generic >>> mime type. Unless of course "application/x-csv" is totally wrong. >>> >>> --On Wednesday, March 27, 2002 09:25:18 AM +1100 Kon Angelopoulos >>> <an...@cp...> wrote: >>> >>> > >>> > Guys, >>> > >>> > the prefered mime type for excel is: application/vnd.ms-excel >>> > >>> > Kon >>> >>> >>> >>> one of the friendly folks in the IT Lab. >>> --------------------------------------\ >>> The IT Lab (http://www.itlab.musc.edu) \____________________ >>> Probably the world's premier software development center. >>> Serving: Programming, Tools, Ice Cream, Seminars >>> >> > > > > one of the friendly folks in the IT Lab. > --------------------------------------\ > The IT Lab (http://www.itlab.musc.edu) \____________________ > Probably the world's premier software development center. > Serving: Programming, Tools, Ice Cream, Seminars > > _______________________________________________ > phpESP-devel mailing list > php...@li... > https://lists.sourceforge.net/lists/listinfo/phpesp-devel > one of the friendly folks in the IT Lab. --------------------------------------\ The IT Lab (http://www.itlab.musc.edu) \____________________ Probably the world's premier software development center. Serving: Programming, Tools, Ice Cream, Seminars |
|
From: Kon A. <an...@cp...> - 2002-03-28 04:21:07
|
I've finished my testing results as follows: Using Content-Type: application/x-csv : no problems with IE5, IE5.5, IE6 and NS6.2.1 or NS4.72 Using Content-Type: text/commas-separated-values : as above Using Content-Type: text/plain : no problem with IE5, IE5.5, IE6 but NS6.2.1 and NS4.72 displays results in browser instead of offering download. Changing the file extension to .doc : IE5, IE5.5, IE6 offered the file as a download but associated it with Microsoft Word, NS6.2.1 and 4.72 also offered and saved the file as a .doc file. James, your call..... Kon > -----Original Message----- > From: Kon Angelopoulos [mailto:an...@cp...] > Sent: Wednesday, March 27, 2002 1:42 PM > To: Matthew Gregg; php...@li... > Subject: RE: [phpesp-dev] Re: Re: Export Download > > > Thanks for that, > > I'll keep it in mind > > Kon > > > > > -----Original Message----- > > From: Matthew Gregg [mailto:gr...@mu...] > > Sent: Wednesday, March 27, 2002 12:48 PM > > To: Kon Angelopoulos; php...@li... > > Subject: RE: [phpesp-dev] Re: Re: Export Download > > > > > > Ok, lets see if this thing can reply just once this time. Serves > > me right > > using Beta software. > > > > I'm cool with Thrusday. > > One other thing to try in your testing. Past dealings with > pushing files > > to IE lead me to belive that it may ignore mime-types and go > > strictly with > > filename extentions. So try changing the extention around and > > see what the > > browsers do. For example try sending the filename as > > "somthing.doc" with a > > csv mime-type. I bet IE will associate it with Word. > > > > Thanks. > > > > > > --On Wednesday, March 27, 2002 12:34:20 PM +1100 Kon Angelopoulos > > <an...@cp...> wrote: > > > > > Excellent, > > > > > > This is exactly the same process I took, that's why I said that it > > > may not be a valid type. However, having tested your original patch, > > > which used a Content_Type of text/plain-text, > > > on IE5, IE5.5, IE6, Netscape 4.72, Netscape 6.2.1, > > > I found no problem with it. All presented the save as dialog box and > > > downloaded the file correctly. > > > > > > I can certainly perform the same tests using application/x-csv and > > > text/comma-separated-values > > > and see how I go with them. > > > I'll present the results to the list on Thursday night > > (that's Aussie > > > time) and we can take it from there. > > > > > > Would everyone be cool with that? > > > > > > If anyone can do it before then let me know. > > > > > > Kon > > > > > >> -----Original Message----- > > >> From: Matthew Gregg [mailto:gr...@mu...] > > >> Sent: Wednesday, March 27, 2002 12:14 PM > > >> To: Kon Angelopoulos; php...@li... > > >> Subject: RE: [phpesp-dev] Re: Re: Export Download > > >> > > >> > > >> This is turning into a difficult question indeed :) > > >> > > >> The /etc/mime.types file on my box lists this: > > >> text/comma-separated-values > > >> > > >> The Official listing of Media(mime) Types at IANA > > >> http://www.isi.edu/in-notes/iana/assignments/media-types/media-types > > >> list no CVS type at all, but does list > > >> test/tab-separated-values > > >> which is where I'm assuming text/comma-separate-values derives from. > > >> > > >> The RFC on the MIME Information Page > > >> http://www.hunnysoft.com/mime/ > > >> List no such mime type and suggest the following: > > >> > > >> "Unrecognized subtypes of "text" should be treated as subtype "plain" > > >> as long as the MIME implementation knows how to handle the charset. > > >> Unrecognized subtypes which also specify an unrecognized charset > > >> should be treated as "application/octet- stream"." > > >> > > >> A thread on Google groups > > >> http://groups.google.com/groups?hl=en&frame=right&th=c4a57c10fa3fd > > >> a60&seekm > > >> =Pine.GHP.4.21.0011201856130.3313-100000%40hpplus03.cern.ch#link1 > > >> > > >> suggests text/comma-separated-values over application/octet-stream. > > >> > > >> Argh... > > >> > > >> > > >> > > >> > > >> > > >> --On Wednesday, March 27, 2002 10:04:49 AM +1100 Kon Angelopoulos > > >> <an...@cp...> wrote: > > >> > > >> > I totally agree > > >> > I just don't think application/x-csv is a valid type > > >> > > > >> > Kon > > >> > > > >> > > > >> >> -----Original Message----- > > >> >> From: Matthew Gregg [mailto:gr...@mu...] > > >> >> Sent: Wednesday, March 27, 2002 9:32 AM > > >> >> To: Kon Angelopoulos; php...@li... > > >> >> Subject: RE: [phpesp-dev] Re: Re: Export Download > > >> >> > > >> >> > > >> >> But what if I'm not importing into Excel? I would prefer a > > >> more generic > > >> >> mime type. Unless of course "application/x-csv" is totally wrong. > > >> >> > > >> >> --On Wednesday, March 27, 2002 09:25:18 AM +1100 Kon Angelopoulos > > >> >> <an...@cp...> wrote: > > >> >> > > >> >> > > > >> >> > Guys, > > >> >> > > > >> >> > the prefered mime type for excel is: > application/vnd.ms-excel > > >> >> > > > >> >> > Kon > > >> >> > > >> >> > > >> >> > > >> >> one of the friendly folks in the IT Lab. > > >> >> --------------------------------------\ > > >> >> The IT Lab (http://www.itlab.musc.edu) \____________________ > > >> >> Probably the world's premier software development center. > > >> >> Serving: Programming, Tools, Ice Cream, Seminars > > >> >> > > >> > > > >> > > >> > > >> > > >> one of the friendly folks in the IT Lab. > > >> --------------------------------------\ > > >> The IT Lab (http://www.itlab.musc.edu) \____________________ > > >> Probably the world's premier software development center. > > >> Serving: Programming, Tools, Ice Cream, Seminars > > >> > > > > > > > > > > > one of the friendly folks in the IT Lab. > > --------------------------------------\ > > The IT Lab (http://www.itlab.musc.edu) \____________________ > > Probably the world's premier software development center. > > Serving: Programming, Tools, Ice Cream, Seminars > > |
|
From: James E. F. <jf...@ac...> - 2002-03-28 05:10:16
|
On Thu, 28 Mar 2002, Kon Angelopoulos wrote: > I've finished my testing > results as follows: > > Using Content-Type: application/x-csv : no problems with IE5, IE5.5, IE6 and > NS6.2.1 or NS4.72 > Using Content-Type: text/comma-separated-values : as above Ok the choice is between: 1) text/comma-separated-values (my choice) 2) application/x-csv http://phpesp.sf.net/demo/test.php?sid=2574&userid=devel -James |
|
From: James E. F. <jf...@ac...> - 2002-03-28 05:14:58
|
> http://phpesp.sf.net/demo/test.php?sid=2574&userid=devel Results: http://phpesp.sf.net/demo/test.php?sid=2574&results=1 |
|
From: Matthew G. <gr...@mu...> - 2002-03-28 14:33:55
|
Yeah! Great idea to use ESP for stuff like this. --On Thursday, March 28, 2002 12:14:53 AM -0500 "James E. Flemer" <jf...@ac...> wrote: >> http://phpesp.sf.net/demo/test.php?sid=2574&userid=devel > > Results: > http://phpesp.sf.net/demo/test.php?sid=2574&results=1 > > > > _______________________________________________ > phpESP-devel mailing list > php...@li... > https://lists.sourceforge.net/lists/listinfo/phpesp-devel > ---- one of the friendly folks in the IT Lab. --------------------------------------\ The IT Lab (http://www.itlab.musc.edu) \____________________ Probably the world's premier software development center. Serving: Programming, Tools, Ice Cream, Seminars |
|
From: Kon A. <ang...@ip...> - 2002-03-28 22:07:26
|
Totally agree..... and it seems that text/comma-separated-values will be it Kon On Fri, 29 Mar 2002 01:33, Matthew Gregg wrote: > Yeah! Great idea to use ESP for stuff like this. > > > --On Thursday, March 28, 2002 12:14:53 AM -0500 "James E. Flemer" > > <jf...@ac...> wrote: > >> http://phpesp.sf.net/demo/test.php?sid=2574&userid=devel > > > > Results: > > http://phpesp.sf.net/demo/test.php?sid=2574&results=1 > > > > > > > > _______________________________________________ > > phpESP-devel mailing list > > php...@li... > > https://lists.sourceforge.net/lists/listinfo/phpesp-devel > > ---- > > one of the friendly folks in the IT Lab. > --------------------------------------\ > The IT Lab (http://www.itlab.musc.edu) \____________________ > Probably the world's premier software development center. > Serving: Programming, Tools, Ice Cream, Seminars > > _______________________________________________ > phpESP-devel mailing list > php...@li... > https://lists.sourceforge.net/lists/listinfo/phpesp-devel |
|
From: James E. F. <jf...@ac...> - 2002-03-29 15:15:06
|
Committed patch. The content-type is now "text/comma-separated-values". -James On Fri, 29 Mar 2002, Kon Angelopoulos wrote: > Totally agree..... > and it seems that text/comma-separated-values will be it > > Kon > > On Fri, 29 Mar 2002 01:33, Matthew Gregg wrote: > > Yeah! Great idea to use ESP for stuff like this. > > > > > > --On Thursday, March 28, 2002 12:14:53 AM -0500 "James E. Flemer" > > > > <jf...@ac...> wrote: > > >> http://phpesp.sf.net/demo/test.php?sid=2574&userid=devel > > > > > > Results: > > > http://phpesp.sf.net/demo/test.php?sid=2574&results=1 > > > > > > > > > > > > _______________________________________________ > > > phpESP-devel mailing list > > > php...@li... > > > https://lists.sourceforge.net/lists/listinfo/phpesp-devel > > > > ---- > > > > one of the friendly folks in the IT Lab. > > --------------------------------------\ > > The IT Lab (http://www.itlab.musc.edu) \____________________ > > Probably the world's premier software development center. > > Serving: Programming, Tools, Ice Cream, Seminars > > > > _______________________________________________ > > phpESP-devel mailing list > > php...@li... > > https://lists.sourceforge.net/lists/listinfo/phpesp-devel > > _______________________________________________ > phpESP-devel mailing list > php...@li... > https://lists.sourceforge.net/lists/listinfo/phpesp-devel > |
|
From: Kon A. <ang...@ip...> - 2002-03-28 09:24:19
|
My choice is also text/comma-separated-values Kon |
|
From: James E. F. <jf...@ac...> - 2002-03-26 15:33:05
|
On Tue, 26 Mar 2002, angek productions wrote: > I'd like to see this process check to see if the csv > file exists and if it does, not to overwrite it - as is > the current case- but rather check the files size And > if different create another copy of it with the current > date appended to the end of the filename (or any other > way where the csv files from a particular Survey can be > distinquished from one another). > > So for example, assume that many of the surveys I > create for my company run for a year. Each quarter the > results are downloaded and analysed / compared to the > previous Quarter's results. In this instance I would > have 4 csv files on the server belonging to the same > survey named quartely_survey_310302, > quartely_survey_300602, Quartely_survey_300902 and > quartely_survey_311202. > > Guys your thoughts please. I would suggest for this case that at the end of each quarter, you end the survey, copy it, and activate the new copy. If you are doing data analysis in a separate program, then you should have no problem appending one quarters data to the rest. This way you would have multiple surveys named something like: quarterly_survey_q1_02 quarterly_survey_q2_02 quarterly_survey_q3_02 quarterly_survey_q4_02 quarterly_survey_q1_03 ... However, it may still be a good idea to not overwrite existing data files. Perhaps a confirmation screen, or a screen with a box to enter an alternate filename, would be a nice feature. -James |
|
From: Matthew G. <gr...@mu...> - 2002-03-26 15:47:36
|
Comments below... > > I've tested your patch (on windows box using IE and Netscape plus on > Linux box using Netscape and Konqueror) and it looks pretty good. > The only minor issue I found was with Konqueror. It was not capable of > displaying the $filename.csv name in the save as dialog box but rather > It showed the file name "manage.php". It's contents however were that of > the csv file. > I'm running Konq. 2.2.2 and other than "'s around the filename, it worked just fine. I'll fix the " problem. > I've also had a quick look at the code and it also seems very good. > > I do however have a few suggestions: > I don't believe that the download cvs facility should be > replacing the exporting of the cvs file to the /tmp dir (or any other > dir) but > complement it. By this I mean that the saving of the csv file to a dir > on the server should also occur when the csv file is being downloaded. > I can think of quite a few scenarios where a central repository of > result files might come in very handy. Ok will do this. > I also don't think that a survey with no results should be > downloadable. If a survey has no results it should return an error > statement > as the current phpesp version does. Whoops... yeah will fix this. > My final comment is a challenge. Assuming that others feel the > same way as I with regard to leaving a copy of the csv file on the > server > I'd like to see this process check to see if the csv file exists and if > it does, not to overwrite it - as is the current case- but rather check > the files size How about this... Always create a new file and append the current date or date/time to the filename then do the export. one of the friendly folks in the IT Lab. --------------------------------------\ The IT Lab (http://www.itlab.musc.edu) \____________________ Probably the world's premier software development center. Serving: Programming, Tools, Ice Cream, Seminars |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X