[phpesp-dev] [ phpesp-Bugs-789042 ] CSV Export field name clash 2

[SourceForge.net <no...@so...>]

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