Menu
▾
▴
phpesp-devel
|
From: SourceForge.net <no...@so...> - 2003-08-15 02:26:20
|
Bugs item #789042, was opened at 2003-08-15 12:13 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=108956&aid=789042&group_id=8956 Category: None Group: None Status: Open Resolution: None Priority: 5 Submitted By: Paul Jackson (beachbum_boy) Assigned to: Nobody/Anonymous (nobody) Summary: CSV Export field name clash 2 Initial Comment: The CSV doesn't deal with questions with the same name (as mentioned in another bug report). But further to this if there is many fields with the same name the time to do the CSV export grows exponentially because of the way it handles quotes is majorly broken. Basically each field gets a pair of quotes on either side for the csv export but because it actually keeps using the same field it gets more and more. And further to this the quotes are replaced via an ereg-replace with 2 quotes. So this is fine when you have only a couple of questions with the same name but someone on our system had 60. Now the time to run this becomes untenable. To see an example of this check out the results and survey on the demo site called csv_test. I personally think the csv export stuff needs to be written from scratch again. Even when it works its very slow and hits the datbase way more than is really required if more complex sql was used. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=108956&aid=789042&group_id=8956 |
|
From: SourceForge.net <no...@so...> - 2003-09-26 04:00:27
|
Bugs item #789042, was opened at 2003-08-15 12:13 Message generated for change (Comment added) made by angek You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=108956&aid=789042&group_id=8956 Category: None Group: None Status: Open Resolution: None Priority: 5 Submitted By: Paul Jackson (beachbum_boy) >Assigned to: Kon Angelopoulos (angek) Summary: CSV Export field name clash 2 Initial Comment: The CSV doesn't deal with questions with the same name (as mentioned in another bug report). But further to this if there is many fields with the same name the time to do the CSV export grows exponentially because of the way it handles quotes is majorly broken. Basically each field gets a pair of quotes on either side for the csv export but because it actually keeps using the same field it gets more and more. And further to this the quotes are replaced via an ereg-replace with 2 quotes. So this is fine when you have only a couple of questions with the same name but someone on our system had 60. Now the time to run this becomes untenable. To see an example of this check out the results and survey on the demo site called csv_test. I personally think the csv export stuff needs to be written from scratch again. Even when it works its very slow and hits the datbase way more than is really required if more complex sql was used. ---------------------------------------------------------------------- >Comment By: Kon Angelopoulos (angek) Date: 2003-09-26 14:00 Message: Logged In: YES user_id=198398 will add some logic to check previous question names. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=108956&aid=789042&group_id=8956 |
|
From: SourceForge.net <no...@so...> - 2003-09-28 01:18:01
|
Bugs item #789042, was opened at 2003-08-15 12:13 Message generated for change (Comment added) made by angek You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=108956&aid=789042&group_id=8956 Category: None Group: None >Status: Closed >Resolution: Fixed Priority: 5 Submitted By: Paul Jackson (beachbum_boy) Assigned to: Kon Angelopoulos (angek) Summary: CSV Export field name clash 2 Initial Comment: The CSV doesn't deal with questions with the same name (as mentioned in another bug report). But further to this if there is many fields with the same name the time to do the CSV export grows exponentially because of the way it handles quotes is majorly broken. Basically each field gets a pair of quotes on either side for the csv export but because it actually keeps using the same field it gets more and more. And further to this the quotes are replaced via an ereg-replace with 2 quotes. So this is fine when you have only a couple of questions with the same name but someone on our system had 60. Now the time to run this becomes untenable. To see an example of this check out the results and survey on the demo site called csv_test. I personally think the csv export stuff needs to be written from scratch again. Even when it works its very slow and hits the datbase way more than is really required if more complex sql was used. ---------------------------------------------------------------------- >Comment By: Kon Angelopoulos (angek) Date: 2003-09-28 11:17 Message: Logged In: YES user_id=198398 fixed in cvs. survey question names are now checked for duplication. ---------------------------------------------------------------------- Comment By: Kon Angelopoulos (angek) Date: 2003-09-26 14:00 Message: Logged In: YES user_id=198398 will add some logic to check previous question names. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=108956&aid=789042&group_id=8956 |
|
From: Luis F. <lfa...@fu...> - 2003-08-15 12:22:52
|
SourceForge.net wrote: > >I personally think the csv export stuff needs to be >written from scratch again. Even when it works its very >slow and hits the datbase way more than is really >required if more complex sql was used. > > > Is anyone working on CSV export? This part of phpESP have been causing me some headaches (problems with quotes, speed and bad checkbox handling) and I'd like to work on that. []s Luis |
|
From: Kon <ang...@ip...> - 2003-08-16 01:49:10
|
Hmmm, I've never had any probs with csv export and I have over 120 surveys with thousands of responses. I don't believe anyone is working on CSV export so please feel free to contribute. Kon On Fri, 2003-08-15 at 22:29, Luis Fagundes wrote: > SourceForge.net wrote: > > > > >I personally think the csv export stuff needs to be > >written from scratch again. Even when it works its very > >slow and hits the datbase way more than is really > >required if more complex sql was used. > > > > > > > Is anyone working on CSV export? This part of phpESP have been causing > me some headaches (problems with quotes, > speed and bad checkbox handling) and I'd like to work on that. > > []s > Luis > > > > ------------------------------------------------------- > This SF.Net email sponsored by: Free pre-built ASP.NET sites including > Data Reports, E-commerce, Portals, and Forums are available now. > Download today and enter to win an XBOX or Visual Studio .NET. > http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01 > _______________________________________________ > phpESP-devel mailing list > php...@li... > https://lists.sourceforge.net/lists/listinfo/phpesp-devel |
×
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