phpesp-devel — Discussion of the development of phpESP

Re: [phpesp-dev] Respondent database

[Creative M. <Cre...@Pu...>]

[Sorry about the e-mail wrapping =)]

A couple of issues on your comments...

2002-06-23 16:37:11, "James E. Flemer" <jf...@ac...> wrote:

>A few points here. Having the data fields associated with
>each respondent be arbitrarily chosen by the designer is
>difficult. Databases are designed to, and work best when,
>the fields are pre-determined. Adding a new table per
>survey to store this information is a bad idea for several
>reasons. The other option is to somehow store the data in
>one (or two) predefined tables -- this is sort of how the
>survey questions work, its dirty and slow.

I must say I'm a bit confused here. You refer to two tables
as a dirty and slow solution or the "none" predefined?

I would imagine a new table for each survey (to store data, 
not descriptions) would be very fast. What I figure here is
that a table exists which describes all surveys in the system.
This table has a unique identifier for each project, a project
number so to say. This number could be used in an SQL statement
as the table name in the creation process (possibly in a respondent
Dbase???). After that, the fields in this table can be unique as
it is defined by a new create statement. When the project is put to
Inactive or actually to a later status --> Archived, the table could
be restructured into an archiving table containing one row for 
each field/row in the respondent base.

Then we could keep the system clean of two many tables and still gain the 
flexibility of having special respondent information. If this idea is
completely out the window, I would recommend a table with load of fields
so it can be adapted to different sets of information.

>Having a way to add respondents in bulk is certainly a good
>idea. I agree that an option to import them from either
>text (csv or xml) would be helpful.

=)

>I am constantly amazed by people wanting to take the data
>out of a database and put it in excel. To me it seems that
>in doing so, you give up so many tools available in SQL. Oh
>well, I suppose it's because excel is pointy-clicky, and to
>take full advantage of a database requires substantial
>knowledge of SQL.

Oh but you don't see my friend, Excel is not where the information
is placed in the next phase, but into a powerful analyses program
such as SPSS or Answertree or SAS or for a tabulation package which
offers true power such as Diana or Quantum.

>(More at a later date on quota management.)

Look forward to it.

If you're interested to see some of the leading MR applications
I can send you thorough documentation of how it works and some
demo versions. If you have Remote Administrator from Famatech
I can show you some ASP solutions similar to this one.

Interested?

// Creative Minds


>
>-James
>
>On Sat, 22 Jun 2002, Creative Minds wrote:
>
>> Hi There,
>>
>> I see a lack of functionality in the respondent
>> database. First of all, normally when you conduct a
>> study you would not add respondents one by one but
>> rather want to upload an entire set of respondents. May
>> I recommend using a non-predefined format for this.
>> Respondent information can be very different from
>> survey to survey.
>>
>> I think you should focus on a Comma Separated file for
>> upload with first line containing variable name. After
>> that a guide (as in Excel for instance) where you
>> define what kind of variable is in the field.
>>
>> This would be a good next phase in development before
>> we head on to quota management etc. Because if have a
>> survey where you need 500 males and 500 females, you
>> should be able to create a field inside the survey
>> which then stores values to the respondent database and
>> not just to a datafile. And inside the questionnaire
>> you should be able to check whether you have or do not
>> have enough respondents of a certain quota group and
>> make a condition to end the survey for that respondent
>> with the motivation that the quota group is full.
>>
>> Any opinions?
>
>

Re: [phpesp-dev] Respondent database

[James E. F. <jf...@ac...>]

[ Please try to make your email wrap at something slightly
less than 80 characters, thanks. ]

A few points here. Having the data fields associated with
each respondent be arbitrarily chosen by the designer is
difficult. Databases are designed to, and work best when,
the fields are pre-determined. Adding a new table per
survey to store this information is a bad idea for several
reasons. The other option is to somehow store the data in
one (or two) predefined tables -- this is sort of how the
survey questions work, its dirty and slow.

Having a way to add respondents in bulk is certainly a good
idea. I agree that an option to import them from either
text (csv or xml) would be helpful.

When you are analyzing the data, it should be very easy to
include the rest of your respondent information. One of the
great thing about relational databases is that you can join
tables. Simple use one of the phpESP fields (username,
email, etc) as a key into your separate database with all
your custom data.

I am constantly amazed by people wanting to take the data
out of a database and put it in excel. To me it seems that
in doing so, you give up so many tools available in SQL. Oh
well, I suppose it's because excel is pointy-clicky, and to
take full advantage of a database requires substantial
knowledge of SQL. It is certainly well worth learning if
you need to do any substantial data analysis. There are
also several tools to help you with this, I know that SAS
can use an ODBC database directly as a data source.

(More at a later date on quota management.)

-James

On Sat, 22 Jun 2002, Creative Minds wrote:

> Hi There,
>
> I see a lack of functionality in the respondent
> database. First of all, normally when you conduct a
> study you would not add respondents one by one but
> rather want to upload an entire set of respondents. May
> I recommend using a non-predefined format for this.
> Respondent information can be very different from
> survey to survey.
>
> I think you should focus on a Comma Separated file for
> upload with first line containing variable name. After
> that a guide (as in Excel for instance) where you
> define what kind of variable is in the field.
>
> This would be a good next phase in development before
> we head on to quota management etc. Because if have a
> survey where you need 500 males and 500 females, you
> should be able to create a field inside the survey
> which then stores values to the respondent database and
> not just to a datafile. And inside the questionnaire
> you should be able to check whether you have or do not
> have enough respondents of a certain quota group and
> make a condition to end the survey for that respondent
> with the motivation that the quota group is full.
>
> Any opinions?

[phpesp-dev] [ phpesp-Bugs-572588 ] Radio Button Results display

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

Bugs item #572588, was opened at 2002-06-23 06:48
You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=108956&aid=572588&group_id=8956

Category: None
Group: None
>Status: Closed
Resolution: Fixed
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: Radio Button Results display

Initial Comment:
Radio button results only display choices that have been 
clicked by at least one respndent. Person viewing results 
needs to be able to see all of the other possible choices 
even if no one picked them as their choice.


----------------------------------------------------------------------

>Comment By: Kon Angelopoulos (angek)
Date: 2002-06-23 16:48

Message:
Logged In: YES 
user_id=198398

fix applied to survey_results.inc which can be checked out from 
cvs.

----------------------------------------------------------------------

You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=108956&aid=572588&group_id=8956

[phpesp-dev] Bugs item #572588:Radio Button Results Display

[Kon A. <ang...@ip...>]

Hi All,

This has been fixed in cvs. File affected: survey_results.inc.

Now when viewing results from a survey all choices appear for radio button and 
checkbox questions even if their count is zero (not clicked by any 
respondent).


Kon


On Sun, 23 Jun 2002 06:48, no...@so... wrote:
> Bugs item #572588, was opened at 2002-06-22 13:48
> You can respond by visiting:
> http://sourceforge.net/tracker/?func=detail&atid=108956&aid=572588&group_id
>=8956
>
> Category: None
> Group: None
> Status: Open
> Resolution: None
> Priority: 5
> Submitted By: Nobody/Anonymous (nobody)
> Assigned to: Nobody/Anonymous (nobody)
> Summary: Radio Button Results display
>
> Initial Comment:
> Radio button results only display choices that have been
> clicked by at least one respndent. Person viewing results
> needs to be able to see all of the other possible choices
> even if no one picked them as their choice.
>
>
> ----------------------------------------------------------------------
>
> You can respond by visiting:
> http://sourceforge.net/tracker/?func=detail&atid=108956&aid=572588&group_id
>=8956
>
>
> -------------------------------------------------------
> Sponsored by:
> ThinkGeek at http://www.ThinkGeek.com/
> _______________________________________________
> phpESP-devel mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-devel

[phpesp-dev] [ phpesp-Bugs-572588 ] Radio Button Results display

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

Bugs item #572588, was opened at 2002-06-23 06:48
You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=108956&aid=572588&group_id=8956

Category: None
Group: None
Status: Open
>Resolution: Fixed
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: Radio Button Results display

Initial Comment:
Radio button results only display choices that have been 
clicked by at least one respndent. Person viewing results 
needs to be able to see all of the other possible choices 
even if no one picked them as their choice.


----------------------------------------------------------------------

You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=108956&aid=572588&group_id=8956

[phpesp-dev] Respondent database

[Creative M. <Cre...@Pu...>]

Hi There,

I see a lack of functionality in the respondent database. First of all, normally when 
you conduct a study you would not add respondents one by one but rather want to upload 
an entire set of respondents. May I recommend using a non-predefined format for this. 
Respondent information can be very different from survey to survey.

I think you should focus on a Comma Separated file for upload with first line 
containing variable name. After that a guide (as in Excel for instance) where you 
define what kind of variable is in the field.

This would be a good next phase in development before we head on to quota management 
etc. Because if have a survey where you need 500 males and 500 females, you should be 
able to create a field inside the survey which then stores values to the respondent 
database and not just to a datafile. And inside the questionnaire you should be able to 
check whether you have or do not have enough respondents of a certain quota group and 
make a condition to end the survey for that respondent with the motivation that the 
quota group is full.

Any opinions?

// Creative Minds

[phpesp-dev] [ phpesp-Bugs-572588 ] Radio Button Results display

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

Bugs item #572588, was opened at 2002-06-22 13:48
You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=108956&aid=572588&group_id=8956

Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: Radio Button Results display

Initial Comment:
Radio button results only display choices that have been 
clicked by at least one respndent. Person viewing results 
needs to be able to see all of the other possible choices 
even if no one picked them as their choice.


----------------------------------------------------------------------

You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=108956&aid=572588&group_id=8956

[phpesp-dev] new phpesp demo

[James E. F. <jf...@ac...>]

Hey everyone, with all the recent changes to phpESP, I
decided that we should have another demo site to
showoff/test everything. The SF.net servers seem a little
fubar at the moment, but I think that the demo should work
as soon as they start behaiving again.

  http://phpesp.sf.net/demo-current/  v1.5-current
  http://phpesp.sf.net/demo/          v1.4

If you have problems with 1.5, try 1.4 to make sure SF.net
is ok before trying to figure out what is wrong. =)

Thanks again to all the developers.
-James

[phpesp-dev] feature request 485427-Option for Human Readable Email

[Kon A. <ang...@ip...>]

Hi All,
	Firstly thank you hackedalot for allowing me to finish this one off.
	I've commited the changes to cvs. The files affected are phpESP.ini which now 
has an additional global ESPCONFIG variable = human_read_mail which can be 
set to TRUE or FALSE and espresponse.inc which now has an additional function 
= response_select_hrm() which configures everything in human readable form.
example below:

1/ Machine readable form :
survey.id = 5
survey.name = email responses
response.id = 43
response.username = 192.168.1.30
41 = my name is Kon
42 = Y
43 = I can't be bothered writing an essay....
45 = 67
46 = 69,71,72
47 = 76
48_77 = 2
48_78 = 3
48_79 = 2
48_80 = 3
49 = 2002-04-21
50 = 222

2/ Human readable form:
survey.id = 5
survey.name = email responses
response.id = 42
response.username = 192.168.1.30
41 = here's a text box question : my name is Kon
42 = Here's a yes/no question : Y
43 = Here's an essay box question : I can't be bothered writing an essay....
45 = Here's the radio buttons question : option three
46_69 = Here's the check boxes question : option one
46_71 = Here's the check boxes question : option three
46_72 = Here's the check boxes question : option four
47 = Here's the dropdown question : option four
48_77 = Here's a rate question : question 1 : 2
48_78 = Here's a rate question : question 2 : 3
48_79 = Here's a rate question : question 3 : 2
48_80 = Here's a rate question : question 4 : 3
49 = Here's the date question : 2002-04-21
50 = Here's a numeric qustion : 222

Re: [phpesp-dev] suggestions

[Kon A. <ang...@ip...>]

Thanks for the contirbution David,
	I'll certainly take a look at your code over the next few days and get back 
to you.

Kon

On Fri, 21 Jun 2002 22:58, David Buchmann wrote:
> hi
>
> first, thanks for your great work!
> i installed phpESP for a survey here at the university of fribourg and it
> runs with no problems. we run a survey with some 800 selected
> partipiciants.
>
> i hacked two things into phpESP. i am not a experienced php developper, so
> its not very nice code... i send you what i've done as a suggestion and a
> draft of how you could implement it if you want.
>
> what i did:
> - as we had hundreds of users to enter, we needed a form to enter user data
> not 1 by 1 but as a cvs.
> - we did not want the username:password scheme but just a personal id. i
> made a new authentication scheme i call ID_FORM. username and password are
> the same. for auth we do not use the http method but show a form with a
> field and a submit button. as an extra, this allows to send a "personal
> link" for a survey: just add a ?userid=xy to the url and you are logged
> in...
>
> - we had some questions about countries and languages. as there are many,
> many countries around the world, it would be rather hard to create a normal
> dropdown question and enter all countries for each question. i added the
> new question types country and language.
>
> i attached two files describing where i did what, plus a tar of my modified
> phpESP as it is turning at university now (version 1.3 plus the download
> cvs from 1.4)
>
> i hope this can help you improve phpESP.
>
> david

[phpesp-dev] suggestions

[David B. <dav...@un...>]

hi

first, thanks for your great work! 
i installed phpESP for a survey here at the university of fribourg and it runs
with no problems. we run a survey with some 800 selected partipiciants.

i hacked two things into phpESP. i am not a experienced php developper, so its
not very nice code... i send you what i've done as a suggestion and a draft of
how you could implement it if you want.

what i did: 
- as we had hundreds of users to enter, we needed a form to enter user data not
1 by 1 but as a cvs.
- we did not want the username:password scheme but just a personal id. i made a
new authentication scheme i call ID_FORM. username and password are the same.
for auth we do not use the http method but show a form with a field and a submit
button. as an extra, this allows to send a "personal link" for a survey: just
add a ?userid=xy to the url and you are logged in...

- we had some questions about countries and languages. as there are many, many
countries around the world, it would be rather hard to create a normal dropdown
question and enter all countries for each question. i added the new question
types country and language.

i attached two files describing where i did what, plus a tar of my modified
phpESP as it is turning at university now (version 1.3 plus the download cvs
from 1.4)

i hope this can help you improve phpESP.

david
-- 
David Buchmann, Student DIUF Uni Fribourg, http://diuf.unifr.ch

[phpesp-dev] Survey Themes

[Kon A. <an...@cp...>]

Hi All,

	CVS-devel has now been updated to include the Survey Themes patches.
	Please feel free to update your local copy of cvs and test the creation of
themes for surveys.
	Just a quick note: When you create a new survey you will notice a drop down
list that enables you
	to select a css (theme) file to include in the survey. If you do not wish
to apply a theme to the survey
	you should select "default". Help is available by reading both the
README_SURVEYTHEMES file and
	by clicking the help link available to you when you are creating a survey.
	As always your thoughts, ideas, likes, dislikes, improvements would be
greatly appreciated.

Kon

[phpesp-dev] [ phpesp-Bugs-563046 ] !other bugs

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

Bugs item #563046, was opened at 2002-05-31 14:14
You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=108956&aid=563046&group_id=8956

Category: None
Group: v1.4
Status: Open
Resolution: None
Priority: 1
Submitted By: Robin Carriere (rscarriere)
Assigned to: Nobody/Anonymous (nobody)
Summary: !other bugs

Initial Comment:
Two more minor bugs?  They aren't major - just thought I would 
point them out....

I accidently placed !other in a "scale" question, and while it didn't 
show up in the survey, it did appear in the results reporting.

Second,

(again - it's silly, and now that I think about it may not be a bug....)

When a user fills out the other section in a checkbox type - but 
then doesn't click on the checkbox (or chooses to de-select it) 
the information is still recorded when they sumbit (unless of 
course they delete it completely).


Again, thanks for the great work.  This tool was so useful in the 
eyes of my boss that she allowed me to setup our first linux 
server in a strictly M$ shop.  


----------------------------------------------------------------------

>Comment By: Matthew Gregg (greggmc)
Date: 2002-06-20 10:46

Message:
Logged In: YES 
user_id=14116

The "error: [] operator not supported for strings in 
/usr/local/lib/php/contrib/phpESP/admin/include/lib/espresponse.inc
on line 156"
bug is already fixed in CVS.


----------------------------------------------------------------------

Comment By: Mickey Coggins (coggins)
Date: 2002-06-20 09:15

Message:
Logged In: YES 
user_id=566181

I'm seeing another bug with !other in a checkbox question.  When I fill 
out the question, and enter something in the other option, I get "Fatal 
error: [] operator not supported for strings in 
/usr/local/lib/php/contrib/phpESP/admin/include/lib/espresponse.inc 
on line 156"

----------------------------------------------------------------------

Comment By: Robin Carriere (rscarriere)
Date: 2002-05-31 14:16

Message:
Logged In: YES 
user_id=401713

I'm not very good with making sure I add the configuration piece.....   
Redhat 7.2 running php 4.0.6

----------------------------------------------------------------------

You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=108956&aid=563046&group_id=8956

[phpesp-dev] [ phpesp-Bugs-563046 ] !other bugs

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

Bugs item #563046, was opened at 2002-05-31 19:14
You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=108956&aid=563046&group_id=8956

Category: None
Group: v1.4
Status: Open
Resolution: None
Priority: 1
Submitted By: Robin Carriere (rscarriere)
Assigned to: Nobody/Anonymous (nobody)
Summary: !other bugs

Initial Comment:
Two more minor bugs?  They aren't major - just thought I would 
point them out....

I accidently placed !other in a "scale" question, and while it didn't 
show up in the survey, it did appear in the results reporting.

Second,

(again - it's silly, and now that I think about it may not be a bug....)

When a user fills out the other section in a checkbox type - but 
then doesn't click on the checkbox (or chooses to de-select it) 
the information is still recorded when they sumbit (unless of 
course they delete it completely).


Again, thanks for the great work.  This tool was so useful in the 
eyes of my boss that she allowed me to setup our first linux 
server in a strictly M$ shop.  


----------------------------------------------------------------------

Comment By: Mickey Coggins (coggins)
Date: 2002-06-20 14:15

Message:
Logged In: YES 
user_id=566181

I'm seeing another bug with !other in a checkbox question.  When I fill 
out the question, and enter something in the other option, I get "Fatal 
error: [] operator not supported for strings in 
/usr/local/lib/php/contrib/phpESP/admin/include/lib/espresponse.inc 
on line 156"

----------------------------------------------------------------------

Comment By: Robin Carriere (rscarriere)
Date: 2002-05-31 19:16

Message:
Logged In: YES 
user_id=401713

I'm not very good with making sure I add the configuration piece.....   
Redhat 7.2 running php 4.0.6

----------------------------------------------------------------------

You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=108956&aid=563046&group_id=8956

[phpesp-dev] [ phpesp-Bugs-556963 ] Can't test multi page surveys

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

Bugs item #556963, was opened at 2002-05-16 16:06
You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=108956&aid=556963&group_id=8956

Category: Admin
Group: v1.4
Status: Open
Resolution: None
Priority: 5
Submitted By: Douglas Hobaugh (doug868)
Assigned to: Nobody/Anonymous (nobody)
Summary: Can't test multi page surveys

Initial Comment:
on the demo site the action part of the form tag is 
action="/demo/index.php?where=test&sid=3429"

mine is action="/phpesp/index.php"

missing the query string?

Might I have something setup wrong?

the file /phpesp/index.php is a symbolic link to 
manage.php 

OS: SuSe linux
Web server: Zeus 4.01r1

Doug




----------------------------------------------------------------------

>Comment By: Matthew Gregg (greggmc)
Date: 2002-06-19 15:36

Message:
Logged In: YES 
user_id=14116

Do you have "register_globals" on or off in your php.ini?

If it's off, try turning it on, restart your web server and
see if the problem continues.

----------------------------------------------------------------------

Comment By: Douglas Hobaugh (doug868)
Date: 2002-05-17 12:27

Message:
Logged In: YES 
user_id=545343

phpESP: 1.4 released on the 15th or 16th
PHP: 4.1.2



----------------------------------------------------------------------

Comment By: Matthew Gregg (greggmc)
Date: 2002-05-17 12:22

Message:
Logged In: YES 
user_id=14116

What version of phpESP is this?

----------------------------------------------------------------------

You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=108956&aid=556963&group_id=8956

Re: [phpesp-dev] .ini?

[James E. F. <jf...@ac...>]

On Mon, 17 Jun 2002, randall ehren wrote:

> also, for /public/*.php files -
>
> randall@web[/www/phpesp/public]% diff survey.php.dist survey.php
> 3c3
> <       require('/usr/local/lib/php/contrib/phpESP/admin/phpESP.ini');
> ---
> >     require("../admin/phpESP.ini");
>
> doesn't that seem better?

No it does not. I have tried to make phpESP as secure as
possible. I don't want phpESP to open up holes to your
system, and you probably don't either. On of the best ways
to protect php scripts is to place them in a location that
is not accessible from the web. What I mean is, the main
body of any complicated php script should be *outside* of
your "htdocs" (or whatever) directory. That way you can
ensure that entry into the script is through a limited
number of points, and you only have to do security/sanity
checks there. For this reason, I suggest installing phpESP
in /usr/local/lib/php/contrib/phpESP, which is most
certainly outside of htdocs. Then you only copy the few
known entry points (public/handler*, admin/manage.php) to
some location in your htdocs. Because of this, it is
impossible to use relative pathnames in the public/* and
manage.php files. Does everyone understand this?

The naive user does this:

  cd /usr/local/www/htdocs
  tar -zxf ~/phpESP-1.4.tar.gz
  vi phpESP-1.4/admin/phpESP.ini
  mozilla http://mysite.com/phpESP-1.4/admin/manage.php

Wow, that was easy huh? But what about when someone notices
they are using phpESP, looks at the source and says humm:

  mozilla http://mysite.com/phpESP-1.4/admin/phpESP.ini
  mysql -h mysite.com -u phpESP -p phpESP
  > DELETE FROM survey;
  > ...

Several people have unzipped their fly with phpESP.ini
already. I've checked personally, every time someone asks a
question and posts some URL to the list or to me with
"phpESP/admin" in the URL I warn them they are exposing
themselves. (Are you Randal? It sure looks like it to me:
randall@web[/www/phpesp/public])

One step that has been mentioned is changing phpESP.ini to
something .php so that if it is accessible via a URL it
will get executed by PHP and be a harmless blank page. This
is treating the *symptoms* not the *problem*. I don't want
to promote bad security practices. I will not apply your
patch, unless it addresses these issues. Sorry to rant, but
there seem to be very few PHP coders who jack about
security.

-James

Re: [phpesp-dev] .ini?

[randall e. <ra...@uc...>]

> > > $locale_path  = PHPESP_BASE . "/locale/";
> > > $include_path = PHPESP_BASE . "/include/";
> > > ...
> > Also talked about before.  If it can be implemented without limiting
> > installation flexibility, which I think it can be, it should probably
> > also be done.
>
> i'll test this out tomorrow and if it works, i'll submit a patch.

worked just fine.

patch is attached.

cp phpESP.ini.patch /path/to/phpESP/
cd /path/to/phpESP/
patch < phpESP.ini.patch

also, for /public/*.php files -

randall@web[/www/phpesp/public]% diff survey.php.dist survey.php
3c3
<       require('/usr/local/lib/php/contrib/phpESP/admin/phpESP.ini');
---
>     require("../admin/phpESP.ini");

doesn't that seem better?

 -randall

        - randall s. ehren       :// 805.893.5632
           systems administrator :// isber|survey|avss.ucsb.edu
            institute for social, behavioral, and economic research

Re: [phpesp-dev] .ini?

[randall e. <ra...@uc...>]

> This has been mentioned before and it's something I would like to see happen.

probably should be edited directly in the CVSROOT so that the file maintains
its history.

> > $locale_path  = PHPESP_BASE . "/locale/";
> > $include_path = PHPESP_BASE . "/include/";
> > ...
> Also talked about before.  If it can be implemented without limiting
> installation flexibility, which I think it can be, it should probably
> also be done.

i'll test this out tomorrow and if it works, i'll submit a patch.

> Another good one.  I would lean towards PEAR(http://pear.php.net)
> instead of ADODB myself.  Anyone have any thoughts pro/con on PEAR,
> ADODB, etc...?

here's a benchmark showing direct mysql, adodb, phplib & PEAR:

http://phplens.com/lens/adodb/

another point of interest is the 'gallery' developers notes on PEAR vs. adodb:

 http://marc.theaimsgroup.com/?l=gallery-devel&m=101946544502824&w=2

 and:

 http://phpwiki.sourceforge.net/phpwiki/PhpDatabaseAccessLibraries

        - randall s. ehren       :// 805.893.5632
           systems administrator :// isber|survey|avss.ucsb.edu
            institute for social, behavioral, and economic research

Re: [phpesp-dev] .ini?

[Matthew G. <gr...@mu...>]

On Mon, Jun 17, 2002 at 11:42:24AM -0700, randall ehren wrote:
> hi,
>  i have a few questions about the filestructure & setup of phpESP...
> 
>  1) is there any reasoning to have the config file be a .ini instead of say a
> .php so that there is no concern about it getting parsed as cleartext?
This has been mentioned before and it's something I would like to see happen.


> 
>  2) has anyone thought about using a global to define the filesystem
> locations? seems like it would require much less editing to use something like
> the horde.org's setup:
> 
> define('PHPESP_BASE', dirname(__FILE__));
> $locale_path  = PHPESP_BASE . "/locale/";
> $include_path = PHPESP_BASE . "/include/";
> ...
Also talked about before.  If it can be implemented without limiting
installation flexibility, which I think it can be, it should probably
also be done.



> 
>  3) any thoughts on importing adodb (http://php.weblogs.com/ADODB) so multiple
> databases could be used as the backend storage?
Another good one.  I would lean towards PEAR(http://pear.php.net)
instead of ADODB myself.  Anyone have any thoughts pro/con on PEAR,
ADODB, etc...?


> 
>  thanks,
> 
>         - randall s. ehren       :// 805.893.5632
>            systems administrator :// isber|survey|avss.ucsb.edu
>             institute for social, behavioral, and economic research
> 
> 
> _______________________________________________________________
> 
> Sponsored by:
> ThinkGeek at http://www.ThinkGeek.com/
> _______________________________________________
> phpESP-devel mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-devel
> 

-- 
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

[phpesp-dev] .ini?

[randall e. <ra...@uc...>]

hi,
 i have a few questions about the filestructure & setup of phpESP...

 1) is there any reasoning to have the config file be a .ini instead of say a
.php so that there is no concern about it getting parsed as cleartext?

 2) has anyone thought about using a global to define the filesystem
locations? seems like it would require much less editing to use something like
the horde.org's setup:

define('PHPESP_BASE', dirname(__FILE__));
$locale_path  = PHPESP_BASE . "/locale/";
$include_path = PHPESP_BASE . "/include/";
...

 3) any thoughts on importing adodb (http://php.weblogs.com/ADODB) so multiple
databases could be used as the backend storage?

 thanks,

        - randall s. ehren       :// 805.893.5632
           systems administrator :// isber|survey|avss.ucsb.edu
            institute for social, behavioral, and economic research

Re: [phpesp-dev] Filters

[randall e. <ra...@uc...>]

> eg.
> VARNAME = Q1
> 1. Do you own a Ford?
> 1. Yes
> 2. No
>
> <PAGEBREAK>
> *PAGE DISPLAY IF (Q1 = 1)
> VARNAME = Q2
> 2. Do you like your Ford?
>
> 1. Yes
> 2. No

with the [lame] windows survey creation software we currently use, these
features are called question piping and question skipping. the above example
would be a "skip", and a question pipe would be like this:

VARNAME = Q1
1. What type of car do you own?
1. Ford
2. Chevy
3. BMW
4. Don't Own A Car

<PAGEBREAK>
 *PAGE DISPLAY IF (Q1 != 4)
 VARNAME = Q2
 2. Do you like your ${car_name}?

 1. Yes
 2. No

these are two of the featres our survey center plans on implementing this
summer, but if others get started that'd be great.

 -randall
        - randall s. ehren       :// 805.893.5632
           systems administrator :// isber|survey|avss.ucsb.edu
            institute for social, behavioral, and economic research

[phpesp-dev] Filters

[Creative M. <Cre...@Pu...>]

Hi,

How about adding a filter function to pagebreaks. I haven't involved myself to deeply yet to 
whether you can or cannot adress variable names to questions rather than just numbers, but I'll 
look into that later on. That would be first step I believe, when that's done you should be able 
to address a variable and a value to whether the page will be displayed or not.

eg. 
VARNAME = Q1
1. Do you own a Ford?
1. Yes
2. No

<PAGEBREAK>
*PAGE DISPLAY IF (Q1 = 1)
VARNAME = Q2
2. Do you like your Ford?

1. Yes
2. No

Is that the next step? I could think of a queryset for filters as the one above using the normal 
operators and then a querybuilder as an option to make it easy for certain users.

// Creative Minds

[phpesp-dev] [ phpesp-Bugs-569039 ] Section breaks throw off question number

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

Bugs item #569039, was opened at 2002-06-14 07:45
You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=108956&aid=569039&group_id=8956

Category: None
Group: v1.4
Status: Closed
Resolution: Works For Me
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: Section breaks throw off question number

Initial Comment:
I made a survey and then added section breaks to it.  
What happens is, the section break seems to increment 
the question numbers.  So questions 1 thru 5 would be 
on page one, but page two would start with question 7.
Any ideas?  Thanks.

----------------------------------------------------------------------

Comment By: Nobody/Anonymous (nobody)
Date: 2002-06-14 09:23

Message:
Logged In: NO 

Our host server is running the CGI version of PHP (version 
4.2.1)
I host with PowWeb.  They use the FreeBSD OS. (not sure 
which version)

Thanks again for the help.  We will give the CVS version a 
chance if I have time this weekend.

----------------------------------------------------------------------

Comment By: James Flemer (jimmerman)
Date: 2002-06-14 08:51

Message:
Logged In: YES 
user_id=39444

The demo site is running the devel version, but I don't
think anything has changed since 1.4 that would effect your
problem, tho you could try using the CVS version. Can you
give more details about your install: operating system,
webserver name and version, php version and type (cgi or
module)?

Giving me a URL to your site won't help me any, so don't
bother. Also I cannot see your email address since you
weren't logged into sourceforge when you submitted the bug.

----------------------------------------------------------------------

Comment By: Nobody/Anonymous (nobody)
Date: 2002-06-14 08:20

Message:
Logged In: NO 

Ok, it seems to work on the Demo site just fine.  We are 
running v1.4.  However, we have duplicated the problem on an 
entirely different survey on our server.  The problem appears 
both in the Preview mode and the Test mode.

If you would like to see what is happening with my survey, 
please email me directly, and I will send you the link to our 
server where the survey resides. Thanks in advance for your 
help.

----------------------------------------------------------------------

Comment By: James Flemer (jimmerman)
Date: 2002-06-14 08:00

Message:
Logged In: YES 
user_id=39444

The "Order" tab does not show "real" numbers, just numbers
that let you rearrange items. The "Preview" tab should have
questions numbered correctly. If you are seeing incorrect
numbers on the preview, please duplicate your problem on the
demo site.

----------------------------------------------------------------------

You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=108956&aid=569039&group_id=8956

[phpesp-dev] [ phpesp-Bugs-569039 ] Section breaks throw off question number

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

Bugs item #569039, was opened at 2002-06-14 09:45
You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=108956&aid=569039&group_id=8956

Category: None
Group: v1.4
Status: Closed
Resolution: Works For Me
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: Section breaks throw off question number

Initial Comment:
I made a survey and then added section breaks to it.  
What happens is, the section break seems to increment 
the question numbers.  So questions 1 thru 5 would be 
on page one, but page two would start with question 7.
Any ideas?  Thanks.

----------------------------------------------------------------------

>Comment By: James Flemer (jimmerman)
Date: 2002-06-14 10:51

Message:
Logged In: YES 
user_id=39444

The demo site is running the devel version, but I don't
think anything has changed since 1.4 that would effect your
problem, tho you could try using the CVS version. Can you
give more details about your install: operating system,
webserver name and version, php version and type (cgi or
module)?

Giving me a URL to your site won't help me any, so don't
bother. Also I cannot see your email address since you
weren't logged into sourceforge when you submitted the bug.

----------------------------------------------------------------------

Comment By: Nobody/Anonymous (nobody)
Date: 2002-06-14 10:20

Message:
Logged In: NO 

Ok, it seems to work on the Demo site just fine.  We are 
running v1.4.  However, we have duplicated the problem on an 
entirely different survey on our server.  The problem appears 
both in the Preview mode and the Test mode.

If you would like to see what is happening with my survey, 
please email me directly, and I will send you the link to our 
server where the survey resides. Thanks in advance for your 
help.

----------------------------------------------------------------------

Comment By: James Flemer (jimmerman)
Date: 2002-06-14 10:00

Message:
Logged In: YES 
user_id=39444

The "Order" tab does not show "real" numbers, just numbers
that let you rearrange items. The "Preview" tab should have
questions numbered correctly. If you are seeing incorrect
numbers on the preview, please duplicate your problem on the
demo site.

----------------------------------------------------------------------

You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=108956&aid=569039&group_id=8956

[phpesp-dev] [ phpesp-Bugs-569039 ] Section breaks throw off question number

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

Bugs item #569039, was opened at 2002-06-14 07:45
You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=108956&aid=569039&group_id=8956

Category: None
Group: v1.4
Status: Closed
Resolution: Works For Me
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: Section breaks throw off question number

Initial Comment:
I made a survey and then added section breaks to it.  
What happens is, the section break seems to increment 
the question numbers.  So questions 1 thru 5 would be 
on page one, but page two would start with question 7.
Any ideas?  Thanks.

----------------------------------------------------------------------

Comment By: Nobody/Anonymous (nobody)
Date: 2002-06-14 08:20

Message:
Logged In: NO 

Ok, it seems to work on the Demo site just fine.  We are 
running v1.4.  However, we have duplicated the problem on an 
entirely different survey on our server.  The problem appears 
both in the Preview mode and the Test mode.

If you would like to see what is happening with my survey, 
please email me directly, and I will send you the link to our 
server where the survey resides. Thanks in advance for your 
help.

----------------------------------------------------------------------

Comment By: James Flemer (jimmerman)
Date: 2002-06-14 08:00

Message:
Logged In: YES 
user_id=39444

The "Order" tab does not show "real" numbers, just numbers
that let you rearrange items. The "Preview" tab should have
questions numbered correctly. If you are seeing incorrect
numbers on the preview, please duplicate your problem on the
demo site.

----------------------------------------------------------------------

You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=108956&aid=569039&group_id=8956