phpesp-devel — Discussion of the development of phpESP

[phpesp-dev] [ phpesp-Bugs-591838 ] Question numbering and Section text

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

Bugs item #591838, was opened at 2002-08-06 21:00
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=591838&group_id=8956

Category: User
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Matthew Gregg (greggmc)
Assigned to: Matthew Gregg (greggmc)
Summary: Question numbering and Section text

Initial Comment:
I have a survey with 1 question per section (page). I
wanted to have text at the start of the survey and
nowhere else - so I added a section text to the start
of section 1. 

The first actual question is displayed correctly as
question 1 but subsequent sections don't take into
account the section text thus the second question is
labelled question 3


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

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

Re: [phpesp-dev] phpesp future expandability (xml)

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

After lots of chatting with James on IRC about XML.  I "think" I'm convienced it's 
the way to go. Using PEAR as a coding standard and library looks good.  Lots to 
get up to speed on with PEAR. Although OO-PHP, is none to nice, it's probably also
the way to go.

If James hasn't already sent it to you the XML/XSL "samples" are:
http://phpesp.sourceforge.net/xml/

Next step?  Maybe a create/edit/run for simple question types?

You ever join the IRC channel?  It's really good for ironing stuff out.

On Mon, Aug 05, 2002 at 09:09:15PM +1000, Kon Angelopoulos wrote:
> Guys,
> 
> 	It does seem logical that XML become the preferred media. I for one have no 
> problem with changing over to XML and OO coding. I've had a look at the docs 
> for Pear and being disciplined in coding standards is not a bad thing at all.  
> I would also prefer that XML Schemas replace DTDs.
> A few questions.
> Are we all confortable in coding using OO-principles and XML?
> How many developers would we 'lose' if this conversion takes place?
> Where do we go from here?
> What's our first step?
> 
> ps James could you please resend me the DTD and the sample XML/XSL.
> 
> 
> Regards
> 
> Kon
> 
> 
> On Mon, 5 Aug 2002 08:47, James E. Flemer wrote:
> > A few days ago I was chatting with the IT Lab guys
> > (greggmc, zorncj) about ways to make phpesp more flexible.
> > As you may have noticed, people frequently request the
> > ability to make forked (aka branching or conditional)
> > surveys, where the response to one question chooses what
> > additional questions are seen. In order to implement this
> > feature, the database schema would have to be changed to
> > hold more metadata. There have already been a few DB
> > changes, but I would like to find some solution to keep
> > this from continuing. Setting up the database seems to be
> > one of the biggest problems for users (besides windows
> > support). I propose that the survey storage model be
> > changed to XML. With XML, future metadata changes can be
> > easily accomplished by replacing the old DTD with a new
> > one, a simple 'cvs up' could do this (rather than fiddling
> > with mysql).
> >
> > My idea for this is to store surveys on the filesystem in
> > XML, and when they are activated (or tested) the XML will
> > be "compiled" (using xsl?) to php. This way the xml doesn't
> > have to be transformed on each hit. Also by using XML
> > internally, import/export of surveys will be trivial. I
> > wrote up a DTD and some sample XML/XSL files a while
> > ago[1]; they aren't complete but might give you an idea of
> > where I was headed.
> >
> > I also would like to pear-ize as much of phpesp as
> > possible. This means modularizing functionality, and
> > switching to OO-style code. However, we can make use of the
> > growing collection of existing Pear modules (like the Auth
> > module, and the XML modules). Even if this change doesn't
> > happen soon, I'd like developers to skim the Pear coding
> > standards[2] and start trying to follow them for all new
> > code.
> >
> > [1] http://phpesp.sf.net/xml/
> > [2] http://pear.php.net/manual/en/standards.php
> >
> > I'll be around on IRC if anyone would like to chat about
> > this, or post your thoughts on the list.
> >
> > Thanks,
> > -James
> >
> >
> >
> > -------------------------------------------------------
> > This sf.net email is sponsored by:ThinkGeek
> > Welcome to geek heaven.
> > http://thinkgeek.com/sf
> > _______________________________________________
> > phpESP-devel mailing list
> > php...@li...
> > https://lists.sourceforge.net/lists/listinfo/phpesp-devel
> 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> 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-dev] Re: [phpesp-general] Login Problem

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

It sounds like a problem with the browser caching your
username and password. You could look on
bugzilla.mozilla.org. :-) We may be switching to the PEAR
Auth package in the future for logins, which would not have
this problem (since it does not use HTTP-Auth).
-James

On Mon, 5 Aug 2002, Firecorge wrote:

> Hello,
>
> I have a problem with the correct login with some browsers for example with
> Mozilla. The first login works correctly, but when I log out and log in
> again
> the programm doesn't ask for username and password again. It simply logs
> in with the last user and password.
> Only if I restart the browser the login dialog appears correctly.
> This problem doesn't occur with IE 5.5 oder Opera 6.0.
>
> Has anybody a solution for this problem?
> If it is a bug, is it possible to correct this in the next release?
>
> Thank your for your help,
>
> greetings
> Matthias
>
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> phpESP-general mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-general
>

Re: [phpesp-dev] phpesp future expandability (xml)

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

Guys,

	It does seem logical that XML become the preferred media. I for one have no 
problem with changing over to XML and OO coding. I've had a look at the docs 
for Pear and being disciplined in coding standards is not a bad thing at all.  
I would also prefer that XML Schemas replace DTDs.
A few questions.
Are we all confortable in coding using OO-principles and XML?
How many developers would we 'lose' if this conversion takes place?
Where do we go from here?
What's our first step?

ps James could you please resend me the DTD and the sample XML/XSL.


Regards

Kon


On Mon, 5 Aug 2002 08:47, James E. Flemer wrote:
> A few days ago I was chatting with the IT Lab guys
> (greggmc, zorncj) about ways to make phpesp more flexible.
> As you may have noticed, people frequently request the
> ability to make forked (aka branching or conditional)
> surveys, where the response to one question chooses what
> additional questions are seen. In order to implement this
> feature, the database schema would have to be changed to
> hold more metadata. There have already been a few DB
> changes, but I would like to find some solution to keep
> this from continuing. Setting up the database seems to be
> one of the biggest problems for users (besides windows
> support). I propose that the survey storage model be
> changed to XML. With XML, future metadata changes can be
> easily accomplished by replacing the old DTD with a new
> one, a simple 'cvs up' could do this (rather than fiddling
> with mysql).
>
> My idea for this is to store surveys on the filesystem in
> XML, and when they are activated (or tested) the XML will
> be "compiled" (using xsl?) to php. This way the xml doesn't
> have to be transformed on each hit. Also by using XML
> internally, import/export of surveys will be trivial. I
> wrote up a DTD and some sample XML/XSL files a while
> ago[1]; they aren't complete but might give you an idea of
> where I was headed.
>
> I also would like to pear-ize as much of phpesp as
> possible. This means modularizing functionality, and
> switching to OO-style code. However, we can make use of the
> growing collection of existing Pear modules (like the Auth
> module, and the XML modules). Even if this change doesn't
> happen soon, I'd like developers to skim the Pear coding
> standards[2] and start trying to follow them for all new
> code.
>
> [1] http://phpesp.sf.net/xml/
> [2] http://pear.php.net/manual/en/standards.php
>
> I'll be around on IRC if anyone would like to chat about
> this, or post your thoughts on the list.
>
> Thanks,
> -James
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> phpESP-devel mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-devel

[phpesp-dev] phpesp future expandability (xml)

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

A few days ago I was chatting with the IT Lab guys
(greggmc, zorncj) about ways to make phpesp more flexible.
As you may have noticed, people frequently request the
ability to make forked (aka branching or conditional)
surveys, where the response to one question chooses what
additional questions are seen. In order to implement this
feature, the database schema would have to be changed to
hold more metadata. There have already been a few DB
changes, but I would like to find some solution to keep
this from continuing. Setting up the database seems to be
one of the biggest problems for users (besides windows
support). I propose that the survey storage model be
changed to XML. With XML, future metadata changes can be
easily accomplished by replacing the old DTD with a new
one, a simple 'cvs up' could do this (rather than fiddling
with mysql).

My idea for this is to store surveys on the filesystem in
XML, and when they are activated (or tested) the XML will
be "compiled" (using xsl?) to php. This way the xml doesn't
have to be transformed on each hit. Also by using XML
internally, import/export of surveys will be trivial. I
wrote up a DTD and some sample XML/XSL files a while
ago[1]; they aren't complete but might give you an idea of
where I was headed.

I also would like to pear-ize as much of phpesp as
possible. This means modularizing functionality, and
switching to OO-style code. However, we can make use of the
growing collection of existing Pear modules (like the Auth
module, and the XML modules). Even if this change doesn't
happen soon, I'd like developers to skim the Pear coding
standards[2] and start trying to follow them for all new
code.

[1] http://phpesp.sf.net/xml/
[2] http://pear.php.net/manual/en/standards.php

I'll be around on IRC if anyone would like to chat about
this, or post your thoughts on the list.

Thanks,
-James

Re: [phpesp-dev] how to add a language?

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

Could you email me the .po file (sorry for the delay
answering you).

Do you have the gettext module installed / enabled on PHP?
You can test it by getting this[1] php script and running
it on your server.

[1] http://phpesp.sf.net/files/status.php.txt

-James

On Fri, 2 Aug 2002, Raúl Pittí P. wrote:

> Hi everybody!
> I've translated the message.po file to spanish, and would like to add it to
> my site.
> I did the following, but with no positive results!
> 1. create the following dir structure:
> /usr/local/lib/php/contrib/phpESP/locale/es/LC_MESSAGES
> 2. set phpesp.ini to spanish ( es) as a language options
> 3. put my .po and .mo files in [1]
> restart my webserver, after accessing phpESP without luck! :-(
> And it's stil not working!
> Am I missing something??  can someone shed some light???
> Thanks in advanced!
> RP
>
> -------------------------------------------
> Raúl D. Pittí P.
> Tecnología de Información.
> Net-M@sters S.A.
> Plaza Credicorp Bank
> Calle 50, Oficina 703
> tel. (507)-210-1518
> fax. (507)-210-1506  [Hora Local: GMT-5]
> Apdo. Postal 0833-0045, Plaza Panama
> http://www.netmasters.com.pa
>
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> phpESP-devel mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-devel
>

[phpesp-dev] how to add a language?

[<rp...@ne...>]

Hi everybody!
I've translated the message.po file to spanish, and would like to add it =
to
my site.
I did the following, but with no positive results!
1. create the following dir structure:
/usr/local/lib/php/contrib/phpESP/locale/es/LC_MESSAGES
2. set phpesp.ini to spanish ( es) as a language options
3. put my .po and .mo files in [1]
restart my webserver, after accessing phpESP without luck! :-(
And it's stil not working!
Am I missing something??  can someone shed some light???
Thanks in advanced!
RP

-------------------------------------------
Ra=FAl D. Pitt=ED P.
Tecnolog=EDa de Informaci=F3n.
Net-M@sters S.A.
Plaza Credicorp Bank
Calle 50, Oficina 703
tel. (507)-210-1518
fax. (507)-210-1506  [Hora Local: GMT-5]
Apdo. Postal 0833-0045, Plaza Panama
http://www.netmasters.com.pa

Re: [phpesp-dev] #phpesp @ irc.openprojects.net

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

I'd prefer a searchable mailing list over a forum...

When and if Sourceforge gets the mailing list archives back up we'll
have that.  If they don't bring that functionality back, what then?
 
On Fri, Jul 26, 2002 at 09:31:11PM +0200, fl...@gm... wrote:
> yo! i would be happy to have a forum with seach functions for phpESP!
> already discussed questions can be easyly reviewd etc!
> 
> is there any reason not having it!?
> 
> flobee
>  
> From: "James E. Flemer" <jf...@ac...>
> To: <php...@li...>
> Cc: <php...@li...>
> Sent: Friday, July 26, 2002 7:13 PM
> Subject: [phpesp-dev] #phpesp @ irc.openprojects.net
> 
> 
> Hey Everyone.
>   I'm not sure if it has been mentioned before (I think it
> was). There is an IRC channel on irc.openprojects.net for
> discussing phpESP. Matthew Gregg (one of the developers) is
> freqently there, and now I will be there sometimes as well.
> Use this channel as both a means to support and development
> discussion.
> 
> I especially encourage all developers and those interested
> in the future of phpESP to take part in the channel.
> 
> For more information about Open Projects Network please
> visit their website[1].
> 
> [1] http://www.openprojects.net/
> 
> -James
> 
> 
> 
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> phpESP-devel mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-devel
> 
> 
> 
> 
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> 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

Re: [phpesp-dev] #phpesp @ irc.openprojects.net

[<fl...@gm...>]

yo! i would be happy to have a forum with seach functions for phpESP!
already discussed questions can be easyly reviewd etc!

is there any reason not having it!?

flobee
 
----- Original Message ----- 
From: "James E. Flemer" <jf...@ac...>
To: <php...@li...>
Cc: <php...@li...>
Sent: Friday, July 26, 2002 7:13 PM
Subject: [phpesp-dev] #phpesp @ irc.openprojects.net


Hey Everyone.
  I'm not sure if it has been mentioned before (I think it
was). There is an IRC channel on irc.openprojects.net for
discussing phpESP. Matthew Gregg (one of the developers) is
freqently there, and now I will be there sometimes as well.
Use this channel as both a means to support and development
discussion.

I especially encourage all developers and those interested
in the future of phpESP to take part in the channel.

For more information about Open Projects Network please
visit their website[1].

[1] http://www.openprojects.net/

-James



-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
phpESP-devel mailing list
php...@li...
https://lists.sourceforge.net/lists/listinfo/phpesp-devel

[phpesp-dev] #phpesp @ irc.openprojects.net

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

Hey Everyone.
  I'm not sure if it has been mentioned before (I think it
was). There is an IRC channel on irc.openprojects.net for
discussing phpESP. Matthew Gregg (one of the developers) is
freqently there, and now I will be there sometimes as well.
Use this channel as both a means to support and development
discussion.

I especially encourage all developers and those interested
in the future of phpESP to take part in the channel.

For more information about Open Projects Network please
visit their website[1].

[1] http://www.openprojects.net/

-James

[phpesp-dev] Bulk Upload and new question type

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

Bulk uploading of Respondent and Designer accounts is now is CVS.  Tab
delimited data files are all that it currently accepts, but stubs are
in place for CSV and XML.  Feel free to chime in and implement them :-)

I would also like to propose a new question type...  

With the surveys we are building here, we need a way to integrate data
from outside sources.  For example: several surveys need a dropdown
with a long list of Faculty.  This is cumbersome to try and maintain
by hand.

So, what I'd like to implement is a RPC question type.  It
could be XML-RPC, SOAP or just a simple URL that would return
name/value pairs that could be used to render a dropdown box.
In the survey edit screens, the info. required to access the RPC could
be filled in by the user using the current "Possible Answer(s)" fields.

What do you guys think? 


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

Re: [phpesp-dev] routings

[Steve M. <st...@is...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

| is a very interesting thing, but by using the next button, I don't
think it
| will be as complete as it could be.

it is important to note that skipping can only be done (unless
significant, complicated javascript is used) on a page-by-page basis.
the easiest way to skip from question-to-question is to put one question
~ on each page. (sounds lame, but how else are you gonna do it?)


| know that the respondent is a boy, we will refer to him as a he and not a
| she, we will not ask him questions about the girl department of a
store but
| rather about the boy department.

this is referred to as "piping".. in that the answer to a previous
question is used later in the survey, either in the text of the question
or in the text of an answer.
i plan on implementing that as well. it should really not be that hard,
as long as the "pipe-able" responses are well-defined (ie. it might be
hard to pipe something from an !other field, but im not sure).


| We also use multiple routings in the questionnaire, like a question with
| three answer options refering to three possible follow up questions.
If this
| would be possible to implement it would be great.

this can be done with skipping:
if questionA returns X, goto questionM
if questionA returns Y, goto questionN
if questionA returns Z, goto questionO

perhaps "else goto next question" will be implied, as well.
(note: this is all speculation so far. havent implemented this yet)


| As my programming abilities are very small, I understand that you have
your
| own priorities. But this is a feature that would make scientifical and
| comercial use of the software a lot easier. If there is a way that I can
| help you guys with anything please let me know.

what does scientifical mean? ;)  (jk)


just an update, i have devised a way to represent skips as modified page
breaks, without modifying the SQL schema. it seems to be working pretty
well so far. ill keep the list updated if there is significant interest.




- -stevem

-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8
Comment: Using PGP with Mozilla - http://enigmail.mozdev.org

iQA/AwUBPUAkh6Ur5syonrLMEQLXKwCfWGe2ZlLmr8Ne2lmmdVx8pKWer0cAn2NJ
J0m0YLWRhRPXz5B9oaYBcfyQ
=dh3Y
-----END PGP SIGNATURE-----

[phpesp-dev] routings

[Sipke O. <S.O...@ni...>]

Hello Steve and others,

While I'm working through my phpESP inbox I found the message from Steve on
skipping questions. I would like to comment on that. This skipping questions
is a very interesting thing, but by using the next button, I don't think it
will be as complete as it could be.

I work at a market research company and we use very complicated 'routings'
as we call them. We are for example able to get data from our database to
give respondents a customized questionnaire. So for example if we already
know that the respondent is a boy, we will refer to him as a he and not a
she, we will not ask him questions about the girl department of a store but
rather about the boy department. 

We also use multiple routings in the questionnaire, like a question with
three answer options refering to three possible follow up questions. If this
would be possible to implement it would be great. 

As my programming abilities are very small, I understand that you have your
own priorities. But this is a feature that would make scientifical and
comercial use of the software a lot easier. If there is a way that I can
help you guys with anything please let me know.

Sipke

_______________________________________
Sipke Overbeeke
Project Manager
NIPO the market research institute
Telephone	(+31) 20 - 5225 416
Fax		(+31) 20 - 5225 333
E-mail		S.O...@ni...
Internet		http://www.nipo.nl
_______________________________________

[phpesp-dev] CATI

[Sipke O. <S.O...@ni...>]

Hello All,

I think I understand what Vladi means by a CATI system. CATI stands for
Computer Assisted Telephone Interviewing. What those systems basicly are is
a digital questionnaire (like phpESP) and a database of telephone numbers.
When the interviewer wants to call a person het gets a phone number on his
screen which he can call either by hand or let the computer do this. 

This sounds pretty basic, but sophisticated systems (like ODIN which we use)
can also been given special targets for people with different backgrounds.
It also records the reason for not responding to the interview. So this way
you can automatically see your response rate and get a representive sample
based on for example age, sex or district.

Allthough these are nice systems for call centres and cost very much, I
think that most of the phpESP users will not use it. But if you want to make
a plug-in I would be very interested, an open source version of a CATI
system is a very valuable thing.

I hope I cleared some things up. As I work with these systems as a fulltime
job, I think that these are very valuable.

Sipke

_______________________________________
Sipke Overbeeke
Project Manager
NIPO the market research institute
Telephone	(+31) 20 - 5225 416
Fax		(+31) 20 - 5225 333
E-mail		S.O...@ni...
Internet		http://www.nipo.nl
_______________________________________

[phpesp-dev] skips

[Steve M. <st...@is...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

has anyone started implementing section skipping?

that is something along the lines of:

~   own a car?
~       |
~      / \
~ make?   why not?
~   |        |
model?     bike?
~     \    /
~      \  /
~       \/
~    thank you

i imagine it would be done with a modified page break. one that would
move onto a specific section (instead of just the "next" one), based on
the answer to a particular question in the current section.

if anyone has started this, or has a good idea of how the sections are
handled in phpESP, id appreciate any advice before tackling this.


- -stevem

-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8
Comment: Using PGP with Mozilla - http://enigmail.mozdev.org

iQA/AwUBPT7qT6Ur5syonrLMEQI47ACfU6sVgwzs+qepk7EszSTo5POxaowAmwVH
bxAKFPgikTrBqLfQePdKwEc/
=LS6/
-----END PGP SIGNATURE-----

[phpesp-dev] [ phpesp-Bugs-584018 ] SQL Connection failing without error

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

Bugs item #584018, was opened at 2002-07-19 15:50
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=584018&group_id=8956

Category: SQL
Group: v1.4
>Status: Closed
>Resolution: Invalid
Priority: 1
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: SQL Connection failing without error

Initial Comment:
Hi!

I'm getting the following rather cryptic sort of error
message when attempting to first run admin.php:

HTTP 503 Service Unavailable
[ Connection to database failed. Please check
configuration. ]
[ : ]

Upon further examination, I found that the [ : ] part
was supposed to contain the MySQL error message and it
doesn't. Here's everything I can tell you about my
installation:

1. I followed the instructions in the README exactly. I
have a database user named phpesp with password phpesp
and a database phpesp which has been created by the
phpESP.sql file. 

2. The above error is actually generated when I visit
an index.php, which is a symlink to admin.php (this was
going to change later). 

3. Mysql version: 3.23.36 Linux: 2.4.2-2smp Redhat 7.3. 

4. Here's the entry from the table mysql.user for the
user phpesp:
| %                             | phpesp@%   |
196ccabe5c8e0b3d | Y           | Y           | Y      
    | Y           | N           | N         | N       
   | N             | N            | N         | N     
    | N               | N          | N          |

So, that's Select, Update, Insert, Delete privs.

What could possibly be going wrong? 
[jo...@ma...]

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

>Comment By: James Flemer (jimmerman)
Date: 2002-07-22 15:15

Message:
Logged In: YES 
user_id=39444

Not a bug.

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

Comment By: Nobody/Anonymous (nobody)
Date: 2002-07-22 15:11

Message:
Logged In: NO 

Ah ha! Removing that @ sign certainly helped a lot. The
problem was that there was no /tmp/mysql.sock. Even if there
had been, I couldn't connect using the mysql command listed
below, so I've made changes to my mysql setup to allow for
the login. Now things appear to be working just fine. Might
I suggest a couple of things:

1. Remove that @ sign from the general distrobution. More
data is always better than less when trying to figure out
what's wrong.

2. Make these failures fail a little more gracefully, so you
never get an error in which the mysql error shows as [ : ],
which doesn't help at all.

3. Perhaps an installation script? It doesn't seem hard to
do using make/sed/awk or perl. I don't think it's
unreasonable to require any of those things on a server
where phpesp is going to be installed. That way, your
instructions wouldn't need to say "Go to file x and change
the location of y to whatever you set it to", and you could
check for things like a proper mysql installation.

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

Comment By: James Flemer (jimmerman)
Date: 2002-07-19 16:54

Message:
Logged In: YES 
user_id=39444

You can remove the "@" in front of the mysql_connect(), and
then you might get a php error with more details. Verify
that the mysql extension is loaded (from a phpinfo() page),
if you are using the stock redhat apache, then I am pretty
sure it is.

Also try to connect to the database from the web server
command line:
$ mysql -uphpesp -p phpesp

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

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

[phpesp-dev] [ phpesp-Bugs-584018 ] SQL Connection failing without error

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

Bugs item #584018, was opened at 2002-07-19 13:50
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=584018&group_id=8956

Category: SQL
Group: v1.4
Status: Open
Resolution: None
Priority: 1
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: SQL Connection failing without error

Initial Comment:
Hi!

I'm getting the following rather cryptic sort of error
message when attempting to first run admin.php:

HTTP 503 Service Unavailable
[ Connection to database failed. Please check
configuration. ]
[ : ]

Upon further examination, I found that the [ : ] part
was supposed to contain the MySQL error message and it
doesn't. Here's everything I can tell you about my
installation:

1. I followed the instructions in the README exactly. I
have a database user named phpesp with password phpesp
and a database phpesp which has been created by the
phpESP.sql file. 

2. The above error is actually generated when I visit
an index.php, which is a symlink to admin.php (this was
going to change later). 

3. Mysql version: 3.23.36 Linux: 2.4.2-2smp Redhat 7.3. 

4. Here's the entry from the table mysql.user for the
user phpesp:
| %                             | phpesp@%   |
196ccabe5c8e0b3d | Y           | Y           | Y      
    | Y           | N           | N         | N       
   | N             | N            | N         | N     
    | N               | N          | N          |

So, that's Select, Update, Insert, Delete privs.

What could possibly be going wrong? 
[jo...@ma...]

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

Comment By: Nobody/Anonymous (nobody)
Date: 2002-07-22 13:11

Message:
Logged In: NO 

Ah ha! Removing that @ sign certainly helped a lot. The
problem was that there was no /tmp/mysql.sock. Even if there
had been, I couldn't connect using the mysql command listed
below, so I've made changes to my mysql setup to allow for
the login. Now things appear to be working just fine. Might
I suggest a couple of things:

1. Remove that @ sign from the general distrobution. More
data is always better than less when trying to figure out
what's wrong.

2. Make these failures fail a little more gracefully, so you
never get an error in which the mysql error shows as [ : ],
which doesn't help at all.

3. Perhaps an installation script? It doesn't seem hard to
do using make/sed/awk or perl. I don't think it's
unreasonable to require any of those things on a server
where phpesp is going to be installed. That way, your
instructions wouldn't need to say "Go to file x and change
the location of y to whatever you set it to", and you could
check for things like a proper mysql installation.

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

Comment By: James Flemer (jimmerman)
Date: 2002-07-19 14:54

Message:
Logged In: YES 
user_id=39444

You can remove the "@" in front of the mysql_connect(), and
then you might get a php error with more details. Verify
that the mysql extension is loaded (from a phpinfo() page),
if you are using the stock redhat apache, then I am pretty
sure it is.

Also try to connect to the database from the web server
command line:
$ mysql -uphpesp -p phpesp

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

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

[phpesp-dev] Develop a CATI system

[Inform-azioni <in...@ca...>]

Hi.

I apologize my terrible english.

Premessa
A CATI system MUST do:
a- sample from a database;
b- assign a telephone number to a interviewer;
c- classify a contact;
d- analyse the job of interviewer and
e- record the response of respondent in a data base (check the response,
  branching, randomize,...);
f- export it in SPSS (for example).

A good example is www.dash.ca or www.surveysystem.com.


I work in a company that develop Yaacs, a software in GPL.

Yaacs is a tool for sample from a database of phone numbers,
schedule for interviewer and control the job of interviewer.

Yaacs do well a, b, c and d. Our new release (the next week) improve
for examples the integration with R -www.r-project.org- for analyse the
interviewer job.

Yaacs is in italian language, I'm sorry.

http://yaacs.sourceforge.net/


Well.

I find three GPL sw that do e and f.
phpesp http://phpesp.sourceforge.net/
mod_survey http://gathering.itm.mh.se/modsurvey/
exquisite http://exquisite.sourceforge.net/


There are others sw but the activity rate is very low.

I'm looking for someone interesting about integration that help us do it?

I hope my terrible english is no too much terrible.

If you have a question write me, I try to explain better.

tks.

Vladi






> -----Messaggio originale-----
> Da: Joel Palmius [mailto:joe...@mh...]
> Inviato: marted=EC 16 luglio 2002 11.37
> A: Inform-azioni
> Oggetto: Re: Your Cawi system
>
>
> What I think about yaacs? Hmm... Well, from what I understood, this is
> basically a wardialler which helps you call a list of phone numbers? Th=
is
> is, I'm sure, something which is useful. I would not profess to have an=
y
> expertise within the subject though.
>
> I am unsure how an integration with mod_survey would fit in.
> Would you fax
> printouts of the questionnaires using it? Or send URLs?
>
> It is possible that I do not entirely understand what you are
> asking me in
> your mail.
>
> Cheers..
>
>   // Joel
>
>
> On Mon, 15 Jul 2002, Inform-azioni wrote:
>
> > Hi, Joel Palmis.
> >
> > I'm sorry about my terrible english.
> >
> > We are developing a CATI system in GPL.
> > Visit the above web site.
> > http://sourceforge.net/projects/yaacs
> >
> >
> > We have finished to develop a scheduler: now yaacs is a good schedule=
r
> > for the telephone job.
> >
> >
> > Now we are planning to integrate our sofware with other sw for
> > build a complet CATI system.
> >
> >
> > I know something about mod_survey. In our page www.cawi.it we have
> > listed a lot of sw and your sw is the first in the list.
> >
> >
> > I see today that you have implemented random order in the matrix.
> >
> > What do you think about our project?
> >
> > Cordially.
> >
> >
> >
> > Demetra sas CATI & CAWI SOLUTIONS
> > dr Angelo Rodolfo Tomaselli
> > tel. 041-98.22.86
> > fax  041-98.30.64
> > mobile 348-26.16.881
> > in...@ca...
> > www.opinioni.net
> > www.opinione.net
> > http://sourceforge.net/projects/yaacs
> > Via Andrea Costa 34/c 30172 Venezia-Mestre ITALY
> > -------------------------------------------
> > Le informazioni contenute in questo messaggio e/o nei suoi allegati s=
ono
> > riservati alla persona in indirizzo e sono strettamente
> confidenziali. In
> > caso di trasmissione errata non =E8 consentito l'utilizzo delle
> informazioni
> > in essa contenute. Si richiede, quindi, di cancellare il messaggio e =
di
> > darne comunicazione a Demetra.
> >
> > The information in this message and/or attachements is intended
> solely for
> > the attention and use of the named addressee and may be
> confidential. If you
> > are not the intended recipient, you are hereby notified you
> have received
> > this transmittal in error and that any use of it is prohibited.
> In such a
> > case please delete this message and kindly notify Demetra accordingly=
=2E
> >
> >
>

Re: [phpesp-dev] Bulk upload patch

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

Hey Matthew,

A job well done.
I've tested it again and it worked fine for me.
I'd be pushing it up to cvs.

Kon

On Sat, 20 Jul 2002 04:31, Matthew Gregg wrote:
> I've update the patch(see attached) so that it now does validation on
> email addresses and expiration dates.  It should also correctly set
> the defaults for "pdesign, pstatus, pdata, pall, pgroup, puser,
> disabled", if they aren't correctly specified in the uploaded data.
>
> I'd like to push this up to CVS if you guys feel comfortable enough
> with it.  James?
>
> ON Fri, Jul 19, 2002 at 08:35:47PM +1000, Kon Angelopoulos wrote:
> > Hey Matthew,
> >
> > If the required fields are taken care of then the basic requirements have
> > been met. There is one thing that needs to be taken care of and that is
> > with the single Add forms a default value is always entered into the
> > database table whereas the bulk upload facility will only enter info
> > found in the file. There's no capacity to prevent fields not specified in
> > the uploadfile from showing up as empty fields in the database.
> >
> > eg. If I use the designer add form and only enter values for the required
> > fields: username, password and group then when I click the update button
> > it will enter the username, password and group into the designer table
> > and enter the default values for pdesign,
> > pstatus,pdata,pall,pgroup,puser,disabled etc...
> >
> > If I created a designer file with only a username, password and group
> > then when I upload it, all other fields will be blank in the designer
> > table.
> >
> > Does this affect the functionality of phpESP? Probably Not. empty fields
> > should be interpreted as 'N'. I guess I'm a little fussy when it comes to
> > data stored in databases. I prefer that fields contain some default value
> > rather that being empty. It provides clarity and prevents
> > misinterpretation.
> >
> > In conclusion, I guess what ever the majority decide I'd be happy with.
> > James' thoughts on the subject would also be greatly appreciated.
> >
> > Kon
> >
> > On Thu, 18 Jul 2002 23:25, Matthew Gregg wrote:
> > > The only fields I set as required are the fields that are currently
> > > required in the single Respondent/Designer Add forms.
> > > Which are:
> > > Username, Password and Group.
> > >
> > > Whoops...I neglected to do any validation on the Expiration field, but
> > > it should at least validate as much as the single Add forms.  I'll fix
> > > that.
> > >
> > > As for the other fields, do we want to be more strict with validation
> > > than the single Add forms?
> > >
> > > And thanks again for taking the time to look at this stuff.  The more
> > > eyes the better.
> > >
> > > On Thu, Jul 18, 2002 at 10:08:07AM +1000, Kon Angelopoulos wrote:
> > > > Matthew,
> > > >
> > > > I've finished testing your patch and I've found the following bugs:
> > > > 1. Bulk Importing Respondent Details:
> > > > 	I tested this functionality with a correct list of respondents and
> > > > it worked well. I then changed the realm to a non existent one and as
> > > > expected, it displayed the table with the failed uploaded rows. I
> > > > then removed the email address from some of the respondents and it
> > > > accepted them without a problem. (should this be the case?). I them
> > > > also removed the disabled field from some of the respondents and it
> > > > also accepted them without reporting any errors ( i don't think that
> > > > this should be the case).
> > > > I then changed the formatting of the exipration date from
> > > > year/month/day to year/day/month. It accepted all these without any
> > > > errors ( placing 000000000 into the database). I don't think this
> > > > should happen.
> > > >
> > > > 2. Bulk upload of Designers:
> > > > 	I tested this with a correct list of designers and it worked well.
> > > > I then tried uploading the respondents tab delimited file in place of
> > > > the designers tab delimited file and it accepted it without any
> > > > errors. This
> > >
> > > ...snip...
> >
> > This sf.net email is sponsored by:ThinkGeek
> > Welcome to geek heaven.
> > http://thinkgeek.com/sf
> > _______________________________________________
> > phpESP-devel mailing list
> > php...@li...
> > https://lists.sourceforge.net/lists/listinfo/phpesp-devel

Re: [phpesp-dev] Bulk upload patch

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

I agree with Matthew on this one.

Kon

On Sat, 20 Jul 2002 06:06, Matthew Gregg wrote:
> On Fri, Jul 19, 2002 at 09:02:12PM +0200, fl...@gm... wrote:
> > funny! i?m just writing a similar thing!
>
> Check the Feature request page on Sourceforge.
> http://sourceforge.net/tracker/?atid=358956&group_id=8956&func=browse
>
> > well maybe i lost,did not read some of these mails but the code looks
> > like the csv must be preformated!?
> > why not doing a preview where you can set each array and set a global Y,N
> > /activ,inactiv , expir etc ...
> >
> > example for a preview wher you can set: "WHAT IS WHAT"
>
> I don't quite understand what you mean here.
> Are you saying that ESP should read the upload file and show a "preview"
> to allow the user to associate fields in the text file with
> fields in the ESP database?
>
> If so, we would still need to know how to parse the uploaded
> format(xml, csv, tab, etc..).  I'm not sure it would be worth doing
> preview/associate in ESP, when you can easily format the text file
> outside of ESP using Excel, Gnumeric, etc. Much in the same way as the
> ESP export function.  The data is in one format and the user can
> format it themselves using whatever tool they have.
>
> Of course if you're uploading XML, it will need to be valid against
> our(or some standard) DTD/Schema, so the preview will be somewhat
> useless with XML data.
>
> > so then you can use any kind of  exported csv or text files-database!?
> > // code snippet
> > function makeopi($x) {
> >        echo "<TD><select name=\"data$x\" size=\"1\">\n<option>
> > </option>\n<option value=\"fname\">"._FNAME."</option>"
> >            ."<option value=\"lname\">"._LNAME."</option>\n"
> >           ."<option value=\"username\">"._USERNAME."</option>\n"
> >            ."<option
> > value=\"email\">"._EMAIL."</option></select></TD>\n"; // etc.. ++
> >        }
> > // ....prev. import data
> > // ... now use <option> to set which array num is which variable
> > // ... submit ->start funstions and place the data in DB
> >
> > flobee
> >
> > From: "Matthew Gregg" <gr...@mu...>
> > To: "Kon Angelopoulos" <ang...@ip...>
> > Cc: <php...@li...>
> > Sent: Friday, July 19, 2002 8:31 PM
> > Subject: Re: [phpesp-dev] Bulk upload patch
> >
> >
> > I've update the patch(see attached) so that it now does validation on
> > email addresses and expiration dates.  It should also correctly set
> > the defaults for "pdesign, pstatus, pdata, pall, pgroup, puser,
> > disabled", if they aren't correctly specified in the uploaded data.
> >
> > I'd like to push this up to CVS if you guys feel comfortable enough
> > with it.  James?
> >
> > ON Fri, Jul 19, 2002 at 08:35:47PM +1000, Kon Angelopoulos wrote:
> > > Hey Matthew,
> > >
> > > If the required fields are taken care of then the basic requirements
> > > have
> >
> > been
> >
> > > met. There is one thing that needs to be taken care of and that is with
> >
> > the
> >
> > > single Add forms a default value is always entered into the database
> > > table whereas the bulk upload facility will only enter info found in
> > > the file. There's no capacity to prevent fields not specified in the
> > > uploadfile from
> > >
> > > showing up as empty fields in the database.
> > >
> > > eg. If I use the designer add form and only enter values for the
> > > required fields: username, password and group then when I click the
> > > update button
> >
> > it
> >
> > > will enter the username, password and group into the designer table and
> >
> > enter
> >
> > > the default values for pdesign,
> > > pstatus,pdata,pall,pgroup,puser,disabled etc...
> > >
> > > If I created a designer file with only a username, password and group
> > > then when I upload it, all other fields will be blank in the designer
> > > table.
> > >
> > > Does this affect the functionality of phpESP? Probably Not. empty
> > > fields should be interpreted as 'N'. I guess I'm a little fussy when it
> > > comes to data stored in databases. I prefer that fields contain some
> > > default value rather that being empty. It provides clarity and prevents
> >
> > misinterpretation.
> >
> > > In conclusion, I guess what ever the majority decide I'd be happy with.
> > > James' thoughts on the subject would also be greatly appreciated.
> > >
> > > Kon
> > >
> > > On Thu, 18 Jul 2002 23:25, Matthew Gregg wrote:
> > > > The only fields I set as required are the fields that are currently
> > > > required in the single Respondent/Designer Add forms.
> > > > Which are:
> > > > Username, Password and Group.
> > > >
> > > > Whoops...I neglected to do any validation on the Expiration field,
> > > > but it should at least validate as much as the single Add forms. 
> > > > I'll fix that.
> > > >
> > > > As for the other fields, do we want to be more strict with validation
> > > > than the single Add forms?
> > > >
> > > > And thanks again for taking the time to look at this stuff.  The more
> > > > eyes the better.
> > > >
> > > > On Thu, Jul 18, 2002 at 10:08:07AM +1000, Kon Angelopoulos wrote:
> > > > > Matthew,
> > > > >
> > > > > I've finished testing your patch and I've found the following bugs:
> > > > > 1. Bulk Importing Respondent Details:
> > > > > I tested this functionality with a correct list of respondents and
> > > > > it worked well. I then changed the realm to a non existent one and
> > > > > as expected, it displayed the table with the failed uploaded rows.
> > > > > I then removed the email address from some of the respondents and
> > > > > it accepted them without a problem. (should this be the case?). I
> > > > > them also removed the disabled field from some of the respondents
> >
> > and
> >
> > > > > it also accepted them without reporting any errors ( i don't think
> >
> > that
> >
> > > > > this should be the case).
> > > > > I then changed the formatting of the exipration date from
> >
> > year/month/day
> >
> > > > > to year/day/month. It accepted all these without any errors (
> > > > > placing 000000000 into the database). I don't think this should
> > > > > happen.
> > > > >
> > > > > 2. Bulk upload of Designers:
> > > > > I tested this with a correct list of designers and it worked well.
> > > > > I then tried uploading the respondents tab delimited file in place
> > > > > of
> >
> > the
> >
> > > > > designers tab delimited file and it accepted it without any errors.
> >
> > This
> >
> > > > ...snip...
> > >
> > > This sf.net email is sponsored by:ThinkGeek
> > > Welcome to geek heaven.
> > > http://thinkgeek.com/sf
> > > _______________________________________________
> > > phpESP-devel mailing list
> > > php...@li...
> > > https://lists.sourceforge.net/lists/listinfo/phpesp-devel

[phpesp-dev] [ phpesp-Bugs-584018 ] SQL Connection failing without error

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

Bugs item #584018, was opened at 2002-07-19 15:50
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=584018&group_id=8956

>Category: SQL
Group: v1.4
Status: Open
Resolution: None
>Priority: 1
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: SQL Connection failing without error

Initial Comment:
Hi!

I'm getting the following rather cryptic sort of error
message when attempting to first run admin.php:

HTTP 503 Service Unavailable
[ Connection to database failed. Please check
configuration. ]
[ : ]

Upon further examination, I found that the [ : ] part
was supposed to contain the MySQL error message and it
doesn't. Here's everything I can tell you about my
installation:

1. I followed the instructions in the README exactly. I
have a database user named phpesp with password phpesp
and a database phpesp which has been created by the
phpESP.sql file. 

2. The above error is actually generated when I visit
an index.php, which is a symlink to admin.php (this was
going to change later). 

3. Mysql version: 3.23.36 Linux: 2.4.2-2smp Redhat 7.3. 

4. Here's the entry from the table mysql.user for the
user phpesp:
| %                             | phpesp@%   |
196ccabe5c8e0b3d | Y           | Y           | Y      
    | Y           | N           | N         | N       
   | N             | N            | N         | N     
    | N               | N          | N          |

So, that's Select, Update, Insert, Delete privs.

What could possibly be going wrong? 
[jo...@ma...]

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

>Comment By: James Flemer (jimmerman)
Date: 2002-07-19 16:54

Message:
Logged In: YES 
user_id=39444

You can remove the "@" in front of the mysql_connect(), and
then you might get a php error with more details. Verify
that the mysql extension is loaded (from a phpinfo() page),
if you are using the stock redhat apache, then I am pretty
sure it is.

Also try to connect to the database from the web server
command line:
$ mysql -uphpesp -p phpesp

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

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

[phpesp-dev] [ phpesp-Bugs-584018 ] SQL Connection failing without error

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

Bugs item #584018, was opened at 2002-07-19 13:50
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=584018&group_id=8956

Category: Admin
Group: v1.4
Status: Open
Resolution: None
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: SQL Connection failing without error

Initial Comment:
Hi!

I'm getting the following rather cryptic sort of error
message when attempting to first run admin.php:

HTTP 503 Service Unavailable
[ Connection to database failed. Please check
configuration. ]
[ : ]

Upon further examination, I found that the [ : ] part
was supposed to contain the MySQL error message and it
doesn't. Here's everything I can tell you about my
installation:

1. I followed the instructions in the README exactly. I
have a database user named phpesp with password phpesp
and a database phpesp which has been created by the
phpESP.sql file. 

2. The above error is actually generated when I visit
an index.php, which is a symlink to admin.php (this was
going to change later). 

3. Mysql version: 3.23.36 Linux: 2.4.2-2smp Redhat 7.3. 

4. Here's the entry from the table mysql.user for the
user phpesp:
| %                             | phpesp@%   |
196ccabe5c8e0b3d | Y           | Y           | Y      
    | Y           | N           | N         | N       
   | N             | N            | N         | N     
    | N               | N          | N          |

So, that's Select, Update, Insert, Delete privs.

What could possibly be going wrong? 
[jo...@ma...]

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

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

Re: [phpesp-dev] Bulk upload patch

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

On Fri, Jul 19, 2002 at 09:02:12PM +0200, fl...@gm... wrote:
> funny! i?m just writing a similar thing!
Check the Feature request page on Sourceforge.
http://sourceforge.net/tracker/?atid=358956&group_id=8956&func=browse

> well maybe i lost,did not read some of these mails but the code looks like
> the csv must be preformated!?
> why not doing a preview where you can set each array and set a global Y,N
> /activ,inactiv , expir etc ...
> 
> example for a preview wher you can set: "WHAT IS WHAT"

I don't quite understand what you mean here.  
Are you saying that ESP should read the upload file and show a "preview"
to allow the user to associate fields in the text file with
fields in the ESP database?

If so, we would still need to know how to parse the uploaded
format(xml, csv, tab, etc..).  I'm not sure it would be worth doing
preview/associate in ESP, when you can easily format the text file
outside of ESP using Excel, Gnumeric, etc. Much in the same way as the
ESP export function.  The data is in one format and the user can
format it themselves using whatever tool they have.

Of course if you're uploading XML, it will need to be valid against
our(or some standard) DTD/Schema, so the preview will be somewhat
useless with XML data.


> so then you can use any kind of  exported csv or text files-database!?
> // code snippet
> function makeopi($x) {
>        echo "<TD><select name=\"data$x\" size=\"1\">\n<option>
> </option>\n<option value=\"fname\">"._FNAME."</option>"
>            ."<option value=\"lname\">"._LNAME."</option>\n"
>           ."<option value=\"username\">"._USERNAME."</option>\n"
>            ."<option value=\"email\">"._EMAIL."</option></select></TD>\n";
>         // etc.. ++
>        }
> // ....prev. import data
> // ... now use <option> to set which array num is which variable
> // ... submit ->start funstions and place the data in DB
> 
> flobee
> 
> From: "Matthew Gregg" <gr...@mu...>
> To: "Kon Angelopoulos" <ang...@ip...>
> Cc: <php...@li...>
> Sent: Friday, July 19, 2002 8:31 PM
> Subject: Re: [phpesp-dev] Bulk upload patch
> 
> 
> I've update the patch(see attached) so that it now does validation on
> email addresses and expiration dates.  It should also correctly set
> the defaults for "pdesign, pstatus, pdata, pall, pgroup, puser,
> disabled", if they aren't correctly specified in the uploaded data.
> 
> I'd like to push this up to CVS if you guys feel comfortable enough
> with it.  James?
> 
> ON Fri, Jul 19, 2002 at 08:35:47PM +1000, Kon Angelopoulos wrote:
> > Hey Matthew,
> >
> > If the required fields are taken care of then the basic requirements have
> been
> > met. There is one thing that needs to be taken care of and that is with
> the
> > single Add forms a default value is always entered into the database table
> > whereas the bulk upload facility will only enter info found in the file.
> > There's no capacity to prevent fields not specified in the uploadfile from
> 
> > showing up as empty fields in the database.
> >
> > eg. If I use the designer add form and only enter values for the required
> > fields: username, password and group then when I click the update button
> it
> > will enter the username, password and group into the designer table and
> enter
> > the default values for pdesign, pstatus,pdata,pall,pgroup,puser,disabled
> > etc...
> >
> > If I created a designer file with only a username, password and group then
> > when I upload it, all other fields will be blank in the designer table.
> >
> > Does this affect the functionality of phpESP? Probably Not. empty fields
> > should be interpreted as 'N'. I guess I'm a little fussy when it comes to
> > data stored in databases. I prefer that fields contain some default value
> > rather that being empty. It provides clarity and prevents
> misinterpretation.
> >
> > In conclusion, I guess what ever the majority decide I'd be happy with.
> > James' thoughts on the subject would also be greatly appreciated.
> >
> > Kon
> >
> > On Thu, 18 Jul 2002 23:25, Matthew Gregg wrote:
> > > The only fields I set as required are the fields that are currently
> > > required in the single Respondent/Designer Add forms.
> > > Which are:
> > > Username, Password and Group.
> > >
> > > Whoops...I neglected to do any validation on the Expiration field, but
> > > it should at least validate as much as the single Add forms.  I'll fix
> > > that.
> > >
> > > As for the other fields, do we want to be more strict with validation
> > > than the single Add forms?
> > >
> > > And thanks again for taking the time to look at this stuff.  The more
> > > eyes the better.
> > >
> > > On Thu, Jul 18, 2002 at 10:08:07AM +1000, Kon Angelopoulos wrote:
> > > > Matthew,
> > > >
> > > > I've finished testing your patch and I've found the following bugs:
> > > > 1. Bulk Importing Respondent Details:
> > > > I tested this functionality with a correct list of respondents and it
> > > > worked well. I then changed the realm to a non existent one and as
> > > > expected, it displayed the table with the failed uploaded rows.
> > > > I then removed the email address from some of the respondents and it
> > > > accepted them without a problem. (should this be the case?).
> > > > I them also removed the disabled field from some of the respondents
> and
> > > > it also accepted them without reporting any errors ( i don't think
> that
> > > > this should be the case).
> > > > I then changed the formatting of the exipration date from
> year/month/day
> > > > to year/day/month. It accepted all these without any errors ( placing
> > > > 000000000 into the database). I don't think this should happen.
> > > >
> > > > 2. Bulk upload of Designers:
> > > > I tested this with a correct list of designers and it worked well.
> > > > I then tried uploading the respondents tab delimited file in place of
> the
> > > > designers tab delimited file and it accepted it without any errors.
> This
> > >
> > > ...snip...
> >
> >
> >
> > This sf.net email is sponsored by:ThinkGeek
> > Welcome to geek heaven.
> > http://thinkgeek.com/sf
> > _______________________________________________
> > 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

Re: [phpesp-dev] Bulk upload patch

[<fl...@gm...>]

funny! i´m just writing a similar thing!
well maybe i lost,did not read some of these mails but the code looks like
the csv must be preformated!?
why not doing a preview where you can set each array and set a global Y,N
/activ,inactiv , expir etc ...

example for a preview wher you can set: "WHAT IS WHAT"
so then you can use any kind of  exported csv or text files-database!?
// code snippet
function makeopi($x) {
       echo "<TD><select name=\"data$x\" size=\"1\">\n<option>
</option>\n<option value=\"fname\">"._FNAME."</option>"
           ."<option value=\"lname\">"._LNAME."</option>\n"
          ."<option value=\"username\">"._USERNAME."</option>\n"
           ."<option value=\"email\">"._EMAIL."</option></select></TD>\n";
        // etc.. ++
       }
// ....prev. import data
// ... now use <option> to set which array num is which variable
// ... submit ->start funstions and place the data in DB

flobee

----- Original Message -----
From: "Matthew Gregg" <gr...@mu...>
To: "Kon Angelopoulos" <ang...@ip...>
Cc: <php...@li...>
Sent: Friday, July 19, 2002 8:31 PM
Subject: Re: [phpesp-dev] Bulk upload patch


I've update the patch(see attached) so that it now does validation on
email addresses and expiration dates.  It should also correctly set
the defaults for "pdesign, pstatus, pdata, pall, pgroup, puser,
disabled", if they aren't correctly specified in the uploaded data.

I'd like to push this up to CVS if you guys feel comfortable enough
with it.  James?

ON Fri, Jul 19, 2002 at 08:35:47PM +1000, Kon Angelopoulos wrote:
> Hey Matthew,
>
> If the required fields are taken care of then the basic requirements have
been
> met. There is one thing that needs to be taken care of and that is with
the
> single Add forms a default value is always entered into the database table
> whereas the bulk upload facility will only enter info found in the file.
> There's no capacity to prevent fields not specified in the uploadfile from

> showing up as empty fields in the database.
>
> eg. If I use the designer add form and only enter values for the required
> fields: username, password and group then when I click the update button
it
> will enter the username, password and group into the designer table and
enter
> the default values for pdesign, pstatus,pdata,pall,pgroup,puser,disabled
> etc...
>
> If I created a designer file with only a username, password and group then
> when I upload it, all other fields will be blank in the designer table.
>
> Does this affect the functionality of phpESP? Probably Not. empty fields
> should be interpreted as 'N'. I guess I'm a little fussy when it comes to
> data stored in databases. I prefer that fields contain some default value
> rather that being empty. It provides clarity and prevents
misinterpretation.
>
> In conclusion, I guess what ever the majority decide I'd be happy with.
> James' thoughts on the subject would also be greatly appreciated.
>
> Kon
>
> On Thu, 18 Jul 2002 23:25, Matthew Gregg wrote:
> > The only fields I set as required are the fields that are currently
> > required in the single Respondent/Designer Add forms.
> > Which are:
> > Username, Password and Group.
> >
> > Whoops...I neglected to do any validation on the Expiration field, but
> > it should at least validate as much as the single Add forms.  I'll fix
> > that.
> >
> > As for the other fields, do we want to be more strict with validation
> > than the single Add forms?
> >
> > And thanks again for taking the time to look at this stuff.  The more
> > eyes the better.
> >
> > On Thu, Jul 18, 2002 at 10:08:07AM +1000, Kon Angelopoulos wrote:
> > > Matthew,
> > >
> > > I've finished testing your patch and I've found the following bugs:
> > > 1. Bulk Importing Respondent Details:
> > > I tested this functionality with a correct list of respondents and it
> > > worked well. I then changed the realm to a non existent one and as
> > > expected, it displayed the table with the failed uploaded rows.
> > > I then removed the email address from some of the respondents and it
> > > accepted them without a problem. (should this be the case?).
> > > I them also removed the disabled field from some of the respondents
and
> > > it also accepted them without reporting any errors ( i don't think
that
> > > this should be the case).
> > > I then changed the formatting of the exipration date from
year/month/day
> > > to year/day/month. It accepted all these without any errors ( placing
> > > 000000000 into the database). I don't think this should happen.
> > >
> > > 2. Bulk upload of Designers:
> > > I tested this with a correct list of designers and it worked well.
> > > I then tried uploading the respondents tab delimited file in place of
the
> > > designers tab delimited file and it accepted it without any errors.
This
> >
> > ...snip...
>
>
>
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> 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

Re: [phpesp-dev] Bulk upload patch

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

I've update the patch(see attached) so that it now does validation on
email addresses and expiration dates.  It should also correctly set
the defaults for "pdesign, pstatus, pdata, pall, pgroup, puser,
disabled", if they aren't correctly specified in the uploaded data.

I'd like to push this up to CVS if you guys feel comfortable enough
with it.  James?

ON Fri, Jul 19, 2002 at 08:35:47PM +1000, Kon Angelopoulos wrote:
> Hey Matthew,
> 
> If the required fields are taken care of then the basic requirements have been 
> met. There is one thing that needs to be taken care of and that is with the 
> single Add forms a default value is always entered into the database table 
> whereas the bulk upload facility will only enter info found in the file. 
> There's no capacity to prevent fields not specified in the uploadfile from 
> showing up as empty fields in the database.
> 
> eg. If I use the designer add form and only enter values for the required 
> fields: username, password and group then when I click the update button it 
> will enter the username, password and group into the designer table and enter 
> the default values for pdesign, pstatus,pdata,pall,pgroup,puser,disabled 
> etc...
> 
> If I created a designer file with only a username, password and group then 
> when I upload it, all other fields will be blank in the designer table.
> 
> Does this affect the functionality of phpESP? Probably Not. empty fields 
> should be interpreted as 'N'. I guess I'm a little fussy when it comes to 
> data stored in databases. I prefer that fields contain some default value 
> rather that being empty. It provides clarity and prevents misinterpretation.
> 
> In conclusion, I guess what ever the majority decide I'd be happy with.
> James' thoughts on the subject would also be greatly appreciated.
> 
> Kon
> 
> On Thu, 18 Jul 2002 23:25, Matthew Gregg wrote:
> > The only fields I set as required are the fields that are currently
> > required in the single Respondent/Designer Add forms.
> > Which are:
> > Username, Password and Group.
> >
> > Whoops...I neglected to do any validation on the Expiration field, but
> > it should at least validate as much as the single Add forms.  I'll fix
> > that.
> >
> > As for the other fields, do we want to be more strict with validation
> > than the single Add forms?
> >
> > And thanks again for taking the time to look at this stuff.  The more
> > eyes the better.
> >
> > On Thu, Jul 18, 2002 at 10:08:07AM +1000, Kon Angelopoulos wrote:
> > > Matthew,
> > >
> > > I've finished testing your patch and I've found the following bugs:
> > > 1. Bulk Importing Respondent Details:
> > > 	I tested this functionality with a correct list of respondents and it
> > > worked well. I then changed the realm to a non existent one and as
> > > expected, it displayed the table with the failed uploaded rows.
> > > I then removed the email address from some of the respondents and it
> > > accepted them without a problem. (should this be the case?).
> > > I them also removed the disabled field from some of the respondents and
> > > it also accepted them without reporting any errors ( i don't think that
> > > this should be the case).
> > > I then changed the formatting of the exipration date from year/month/day
> > > to year/day/month. It accepted all these without any errors ( placing
> > > 000000000 into the database). I don't think this should happen.
> > >
> > > 2. Bulk upload of Designers:
> > > 	I tested this with a correct list of designers and it worked well.
> > > I then tried uploading the respondents tab delimited file in place of the
> > > designers tab delimited file and it accepted it without any errors. This
> >
> > ...snip...
> 
> 
> 
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> 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