phpesp-devel — Discussion of the development of phpESP

[phpesp-dev] I've created and ran a few surveys, and have noticed the access and response_date table have no dat

[Charlie S. <Sm...@ld...>]

I've created and ran  a few surveys, and have noticed the access and =
response_date table have no data in them.
Are these tables being used?



---------------------------------------------------------------------------=
---
This message may contain confidential information, and is intended only for=
 =
the use of the individual(s) to whom it is addressed.


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

[phpesp-dev] Conversion from mysql to OCI8 for use with mod_php and OCI8 module.

[Charlie S. <Sm...@ld...>]

In my attempts to convert the mysql tables to oracle tables, I noticed a =
couple anomolies.
There is a column named 'public' and a table named 'access'.  Both of these=
 =
appear
to be reserved words in oracle.   Would it be possible to have these field =
and table names changed?


---------------------------------------------------------------------------=
---
This message may contain confidential information, and is intended only for=
 =
the use of the individual(s) to whom it is addressed.


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

Re: [phpesp-dev] Pear support

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

See below...
On Fri, Sep 26, 2003 at 07:53:18AM +0000, Stefan Champailler wrote:
> So...
> 
> It seems like Pear is having some rave reviews down here. Here's what I'll do 
> : as soon as I got a dev environment with Oracle/ODBC running, I'll test the 
> Pear connectivity. If it works, I'll move my phpEsp to PEAR. But, 
> unfortunatley, I have also several additional features that I have to add to 
> the code that are not necessarily good for everyone. I'll try to maintain my 
> code as re-importable in the main branch as possible, but there will be some 
> work.
> 
> Features I plan to add :
> 
> - More graphic generation
What do you mean by graphic generation?

> - A survey translation mechanism (I'll try to HACK it in the current
> code, so don't expect something too clean)

Can you do this drawing from what is currently implemented in the
management interfaces multilingual code?

> - I simplified the "question" tab : removed Fieldname, length, precision in 
> favor of defaults (so yes, I killed some flexibility, but my users are 
> ranging from "I don't understand computers" to "I do understand
> them")

Can this be optional?  A phpESP.ini config variable?  Lots of people
need the flexibility.

> - Rewritten the core logi in question.inc, it was way too complicated,
> uncommented and buggy, I expect my version to be done today. However, it'll 
> need a lot of QA attention.
> - I'm also redefining the notion of group (which is pretty fuzzy
> anyway)

How so?

> - I'm writing a user manual, all in Docbook.?

A manual would be awesome.  Docbook or XHTML would be my vote.

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

-- 
mcg
-------------------------------------
The IT Lab (http://www.itlab.musc.edu)

[phpesp-dev] Pear support

[Stefan C. <sch...@ea...>]

So...

It seems like Pear is having some rave reviews down here. Here's what I'll =
do=20
: as soon as I got a dev environment with Oracle/ODBC running, I'll test th=
e=20
Pear connectivity. If it works, I'll move my phpEsp to PEAR. But,=20
unfortunatley, I have also several additional features that I have to add t=
o=20
the code that are not necessarily good for everyone. I'll try to maintain m=
y=20
code as re-importable in the main branch as possible, but there will be som=
e=20
work.

=46eatures I plan to add :

=2D More graphic generation
=2D A survey translation mechanism (I'll try to HACK it in the current code=
, so=20
don't expect something too clean)
=2D I simplified the "question" tab : removed Fieldname, length, precision =
in=20
favor of defaults (so yes, I killed some flexibility, but my users are=20
ranging from "I don't understand computers" to "I do understand them")
=2D Rewritten the core logi in question.inc, it was way too complicated,
uncommented and buggy, I expect my version to be done today. However, it'll=
=20
need a lot of QA attention.
=2D I'm also redefining the notion of group (which is pretty fuzzy anyway)
=2D I'm writing a user manual, all in Docbook.=B5


stF

[phpesp-dev] include/tab/questions.inc

[Stefan C. <sch...@ea...>]

I don't know if anyone has ever tried to debug that piece of code, but well it 
wasn't very well written, to say the least.

(PS: that was an ANGRY programmer comment, it's not intended to flame the 
author :) :))

stF

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

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

Bugs item #789042, was opened at 2003-08-15 12:13
Message generated for change (Comment added) made by angek
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=789042&group_id=8956

Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Paul Jackson (beachbum_boy)
>Assigned to: Kon Angelopoulos (angek)
Summary: CSV Export field name clash 2

Initial Comment:
The CSV doesn't deal with questions with the same 

name (as mentioned in another bug report). 



But further to this if there is many fields with the same 

name the time to do the CSV export grows exponentially 

because of the way it handles quotes is majorly broken.



Basically each field gets a pair of quotes on either side 

for the csv export but because it actually keeps using 

the same field it gets more and more. And further to this 

the quotes are replaced via an ereg-replace with 2 

quotes. So this is fine when you have only a couple of 

questions with the same name but someone on our 

system had 60. Now the time to run this becomes 

untenable.



To see an example of this check out the results and 

survey on the demo site called csv_test.



I personally think the csv export stuff needs to be 

written from scratch again. Even when it works its very 

slow and hits the datbase way more than is really 

required if more complex sql was used.

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

>Comment By: Kon Angelopoulos (angek)
Date: 2003-09-26 14:00

Message:
Logged In: YES 
user_id=198398

will add some logic to check previous question names.

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

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

[phpesp-dev] [ phpesp-Feature Requests-795836 ] Bugs in CSS

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

Feature Requests item #795836, was opened at 2003-08-27 16:55
Message generated for change (Comment added) made by angek
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=358956&aid=795836&group_id=8956

>Category: None
>Group: None
Status: Open
Priority: 5
Submitted By: Stefan Waldherr (swa)
Assigned to: Nobody/Anonymous (nobody)
Summary: Bugs in CSS

Initial Comment:
Yes/No +  Radio-answer-type questions and possible some others have incorrect CSS tagging. They just get appear as <table >...</table > but not as < table class="qnInnerTable" > or somesuch.



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

>Comment By: Kon Angelopoulos (angek)
Date: 2003-09-26 13:43

Message:
Logged In: YES 
user_id=198398

This is not a bug but an ommission of a style which does not 

affect the functionality of phpESP. I have changed it to a 

feature request and will look into it.

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

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

Re: [phpesp-dev] Porting to PEAR and/or PostgreSQL

[Jeremy B. <je...@we...>]

Unfortunetly, I just joined the list today and when I try to access the 
archives, I get an error message from Sourceforge :(    But I'm 
guessing very little has been done...


On Thursday, September 25, 2003, at 10:41 AM, Matthew Gregg wrote:

> What you've seen mentioned on this mailing list in the last few days,
> is all there is of the port.
>
> On Thu, Sep 25, 2003 at 10:29:21AM -0700, Jeremy Buchmann wrote:
>> Hi all,
>>
>> I'm evaluating the use of phpESP for my company and have a few quick
>> questions.
>>
>> First, we use PostgreSQL for all our database needs.  Since phpESP 
>> uses
>> mySQL, we would either have to port it to PostgreSQL or assist in the
>> port to PEAR.  I'm experienced in PHP/PostgreSQL, and I think based on
>> the number of lines in the code base that have 'mysql' in them, that I
>> could do a port to PostgreSQL in 1-2 weeks.  I'd rather not fork from
>> the main distribution, so ideally I'd like to help in the port to 
>> PEAR,
>> but I've never used PEAR.  With a quick glance at the API, it looks
>> easy enough...fairly similar to Perl's DBI.  So my questions are, how
>> is the PEAR port coming along?  Would my help be welcome and useful?
>> Would phpESP only use the database parts of PEAR?
>>
>> Thanks,
>> Jeremy

Re: [phpesp-dev] Porting to PEAR and/or PostgreSQL

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

What you've seen mentioned on this mailing list in the last few days,
is all there is of the port.

On Thu, Sep 25, 2003 at 10:29:21AM -0700, Jeremy Buchmann wrote:
> Hi all,
> 
> I'm evaluating the use of phpESP for my company and have a few quick 
> questions.
> 
> First, we use PostgreSQL for all our database needs.  Since phpESP uses 
> mySQL, we would either have to port it to PostgreSQL or assist in the 
> port to PEAR.  I'm experienced in PHP/PostgreSQL, and I think based on 
> the number of lines in the code base that have 'mysql' in them, that I 
> could do a port to PostgreSQL in 1-2 weeks.  I'd rather not fork from 
> the main distribution, so ideally I'd like to help in the port to PEAR, 
> but I've never used PEAR.  With a quick glance at the API, it looks 
> easy enough...fairly similar to Perl's DBI.  So my questions are, how 
> is the PEAR port coming along?  Would my help be welcome and useful?  
> Would phpESP only use the database parts of PEAR?
> 
> Thanks,
> Jeremy
> 
> 
> 
> 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
> 

-- 
mcg
-------------------------------------
The IT Lab (http://www.itlab.musc.edu)

[phpesp-dev] Porting to PEAR and/or PostgreSQL

[Jeremy B. <je...@we...>]

Hi all,

I'm evaluating the use of phpESP for my company and have a few quick 
questions.

First, we use PostgreSQL for all our database needs.  Since phpESP uses 
mySQL, we would either have to port it to PostgreSQL or assist in the 
port to PEAR.  I'm experienced in PHP/PostgreSQL, and I think based on 
the number of lines in the code base that have 'mysql' in them, that I 
could do a port to PostgreSQL in 1-2 weeks.  I'd rather not fork from 
the main distribution, so ideally I'd like to help in the port to PEAR, 
but I've never used PEAR.  With a quick glance at the API, it looks 
easy enough...fairly similar to Perl's DBI.  So my questions are, how 
is the PEAR port coming along?  Would my help be welcome and useful?  
Would phpESP only use the database parts of PEAR?

Thanks,
Jeremy

Re: [phpesp-dev] ODBC support rewrite

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

Why I favor Pear...
PearDB currently supports:
MySQL
PostgreSQL
InterBase
Mini SQL
Microsoft SQL Server
Oracle 7/8/8i
ODBC (Open Database Connectivity)
SyBase
Informix
FrontBase

A port to PearDB will give us connectivity to all of these DB's almost
for free.  And I'm sure more thought and development time has gone
into these libraries that we would ever do in a generic solution.

How does a "generic" solution give us more choice?


On Thu, Sep 25, 2003 at 06:46:34PM +1000, Kon wrote:
> Guys,
> 
> I think that the generic functions would be OK as it provides greater
> choice.
> 
> Regards
> 
> Kon
> 
> 
> On Thu, 2003-09-25 at 04:04, Matthew Gregg wrote:
> > I would prefer a PEAR solution, but something like this would be ok.
> > 
> > On Wed, Sep 24, 2003 at 11:59:32AM -0600, Charlie Smith wrote:
> > > So instead of mysql_connect or @OCIPLogon($oracleUser, $oraclePassword, $oracleSid);
> > > you could have:
> > > 
> > > function genDBConnect($genDBSid, $genDBUser, $genDBPassword) {
> > >   if (DB == 'Oracle) {
> > >       $connected = @OCIPLogon($genDBUser, $genDBPassword, $genDBSid);
> > > 
> > >       if($error = OCIError()) {
> > >         die("<font color=red>ERROR!! Couldn't connect to server!</font>");
> > >       }
> > >       return $connected;
> > >   }
> > >   else if (DB == 'MySQL' {
> > >       mysql_connect($genDBSid, $genDBUser, $genDBPassword)
> > >   }
> > > }
> > > 
> > > Something like this?  along with other generic functions to handle each of the mysql/oracle functional pieces?
> > > 
> > > 
> > > >>> "Matthew Gregg" <gr...@mu...> 09/24/03 10:56AM >>>
> > > This does sound good.  But instead of porting to Oracle, a port to
> > > PEAR or some other "generic" database abstraction layer would be even
> > > better.
> > > 
> > > On Wed, Sep 24, 2003 at 09:38:28AM -0600, Charlie Smith wrote:
> > > > I'm starting a project to give us an oracle interface ie. replacing mySQL calls with Oracle.  Sounds like this could be beneficial to others, especially you.   Hope to be done by end of  day today.  Will let you know if sounds good to you.
> > > > 
> > > > >>> "Stefan Champailler" <sch...@ea...> 09/22/03 08:09AM >>>
> > > > Dear all,
> > > > 
> > > > 
> > > > I'm going to use phpESP for a project inside a big tyre company. However, I'll 
> > > > need to interface it with Oracle through ODBC. So, what do you think is 
> > > > better :
> > > > 
> > > > - use normal ODBC (iODBC, unixODBC)
> > > > - use PEAR libs
> > > > 
> > > > Personally, I prefer ODBC because I read very poor benchmarks for PEAR 
> > > > database access.
> > > > 
> > > > Any suggestions ?
> > > > 
> > > > Stefan
> > > > 
> > > > 
> > > > 
> > > > 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 message may contain confidential information, and is intended only for the use of the individual(s) to whom it is addressed.
> > > > 
> > > > 
> > > > ==============================================================================
> > > > 
> > > > 
> > > > 
> > > > 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
> > > > 
> > > 
> 

-- 
mcg
-------------------------------------
The IT Lab (http://www.itlab.musc.edu)

[phpesp-dev] [ phpesp-Bugs-743518 ] Several bugs in 1.6.1

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

Bugs item #743518, was opened at 2003-05-26 18:02
Message generated for change (Comment added) made by angek
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=743518&group_id=8956

Category: None
Group: None
>Status: Closed
Resolution: None
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Kon Angelopoulos (angek)
Summary: Several bugs in 1.6.1

Initial Comment:
Great package... but:

Cross tabulate includes complete="N" records;

Cros tab grand total incorrect;

survey_results does not display records where a column

'key' is 0;

Error messages are not prominent in espresponse.inc;

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

>Comment By: Kon Angelopoulos (angek)
Date: 2003-09-25 18:52

Message:
Logged In: YES 
user_id=198398

Correction made and commited to cvs.



- thanks Charlie

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

Comment By: Nobody/Anonymous (nobody)
Date: 2003-09-25 01:15

Message:
Logged In: NO 

The grand_total var is being initialized inside the outer loop.  

The initialization for this should be moved outside the outer 

loop.  I'd wanted to submit this as a patch but have not been 

successful in using cvs to get the most current developer 

version.   The fix is as follows:

crosstab.inc:

                // cws: 9/17/03 moved initialization for grand 

total from inside

                //      fisrt for loop below to above first for loop 

so that it didn't

                //      get reset on adding up each column's total.

                $grand_total = 0;

                for ($f = 0; $f < $cids_col_count; $f++){

                        // $grand_total = 0;

                        for ($g = 0; $g < $cids_row_count; $g++){









Charlie Smith

sm...@ld...

9/24/03

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

Comment By: Kon Angelopoulos (angek)
Date: 2003-09-13 22:36

Message:
Logged In: YES 
user_id=198398

cross tabulate does not include complete="N" records.

As for the totals I cannot replicate the mathematical error

you claim to exist with the totals.

The prominence of error message should be a feature request

and not part of a bug submission.



If you feel that any of what I've said is incorrect please

provide examples for me to see as I cannot duplicate these bugs.



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

Comment By: Kon Angelopoulos (angek)
Date: 2003-07-21 09:13

Message:
Logged In: YES 
user_id=198398

I'll start looking into this and see what can be done.

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

Comment By: Kon Angelopoulos (angek)
Date: 2003-07-21 09:12

Message:
Logged In: YES 
user_id=198398

I'll start looking into this and see what can be done.

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

Comment By: Owen Duffy (owenduffy)
Date: 2003-05-27 07:36

Message:
Logged In: YES 
user_id=787353

Bug report from sourceforge user owenduffy.

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

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

Re: [phpesp-dev] ODBC support rewrite

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

Guys,

I think that the generic functions would be OK as it provides greater
choice.

Regards

Kon


On Thu, 2003-09-25 at 04:04, Matthew Gregg wrote:
> I would prefer a PEAR solution, but something like this would be ok.
> 
> On Wed, Sep 24, 2003 at 11:59:32AM -0600, Charlie Smith wrote:
> > So instead of mysql_connect or @OCIPLogon($oracleUser, $oraclePassword, $oracleSid);
> > you could have:
> > 
> > function genDBConnect($genDBSid, $genDBUser, $genDBPassword) {
> >   if (DB == 'Oracle) {
> >       $connected = @OCIPLogon($genDBUser, $genDBPassword, $genDBSid);
> > 
> >       if($error = OCIError()) {
> >         die("<font color=red>ERROR!! Couldn't connect to server!</font>");
> >       }
> >       return $connected;
> >   }
> >   else if (DB == 'MySQL' {
> >       mysql_connect($genDBSid, $genDBUser, $genDBPassword)
> >   }
> > }
> > 
> > Something like this?  along with other generic functions to handle each of the mysql/oracle functional pieces?
> > 
> > 
> > >>> "Matthew Gregg" <gr...@mu...> 09/24/03 10:56AM >>>
> > This does sound good.  But instead of porting to Oracle, a port to
> > PEAR or some other "generic" database abstraction layer would be even
> > better.
> > 
> > On Wed, Sep 24, 2003 at 09:38:28AM -0600, Charlie Smith wrote:
> > > I'm starting a project to give us an oracle interface ie. replacing mySQL calls with Oracle.  Sounds like this could be beneficial to others, especially you.   Hope to be done by end of  day today.  Will let you know if sounds good to you.
> > > 
> > > >>> "Stefan Champailler" <sch...@ea...> 09/22/03 08:09AM >>>
> > > Dear all,
> > > 
> > > 
> > > I'm going to use phpESP for a project inside a big tyre company. However, I'll 
> > > need to interface it with Oracle through ODBC. So, what do you think is 
> > > better :
> > > 
> > > - use normal ODBC (iODBC, unixODBC)
> > > - use PEAR libs
> > > 
> > > Personally, I prefer ODBC because I read very poor benchmarks for PEAR 
> > > database access.
> > > 
> > > Any suggestions ?
> > > 
> > > Stefan
> > > 
> > > 
> > > 
> > > 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 message may contain confidential information, and is intended only for the use of the individual(s) to whom it is addressed.
> > > 
> > > 
> > > ==============================================================================
> > > 
> > > 
> > > 
> > > 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] ODBC support rewrite

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

I would prefer a PEAR solution, but something like this would be ok.

On Wed, Sep 24, 2003 at 11:59:32AM -0600, Charlie Smith wrote:
> So instead of mysql_connect or @OCIPLogon($oracleUser, $oraclePassword, $oracleSid);
> you could have:
> 
> function genDBConnect($genDBSid, $genDBUser, $genDBPassword) {
>   if (DB == 'Oracle) {
>       $connected = @OCIPLogon($genDBUser, $genDBPassword, $genDBSid);
> 
>       if($error = OCIError()) {
>         die("<font color=red>ERROR!! Couldn't connect to server!</font>");
>       }
>       return $connected;
>   }
>   else if (DB == 'MySQL' {
>       mysql_connect($genDBSid, $genDBUser, $genDBPassword)
>   }
> }
> 
> Something like this?  along with other generic functions to handle each of the mysql/oracle functional pieces?
> 
> 
> >>> "Matthew Gregg" <gr...@mu...> 09/24/03 10:56AM >>>
> This does sound good.  But instead of porting to Oracle, a port to
> PEAR or some other "generic" database abstraction layer would be even
> better.
> 
> On Wed, Sep 24, 2003 at 09:38:28AM -0600, Charlie Smith wrote:
> > I'm starting a project to give us an oracle interface ie. replacing mySQL calls with Oracle.  Sounds like this could be beneficial to others, especially you.   Hope to be done by end of  day today.  Will let you know if sounds good to you.
> > 
> > >>> "Stefan Champailler" <sch...@ea...> 09/22/03 08:09AM >>>
> > Dear all,
> > 
> > 
> > I'm going to use phpESP for a project inside a big tyre company. However, I'll 
> > need to interface it with Oracle through ODBC. So, what do you think is 
> > better :
> > 
> > - use normal ODBC (iODBC, unixODBC)
> > - use PEAR libs
> > 
> > Personally, I prefer ODBC because I read very poor benchmarks for PEAR 
> > database access.
> > 
> > Any suggestions ?
> > 
> > Stefan
> > 
> > 
> > 
> > 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 message may contain confidential information, and is intended only for the use of the individual(s) to whom it is addressed.
> > 
> > 
> > ==============================================================================
> > 
> > 
> > 
> > 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 
> > 
> 

-- 
mcg
-------------------------------------
The IT Lab (http://www.itlab.musc.edu)

Re: [phpesp-dev] ODBC support rewrite

[Charlie S. <Sm...@ld...>]

So instead of mysql_connect or @OCIPLogon($oracleUser, $oraclePassword, =
$oracleSid);
you could have:

=66unction genDBConnect($genDBSid, $genDBUser, $genDBPassword) {
  if (DB =3D=3D 'Oracle) {
      $connected =3D @OCIPLogon($genDBUser, $genDBPassword, $genDBSid);

      if($error =3D OCIError()) {
        die("<font color=3Dred>ERROR!! Couldn't connect to server!</font>");
      }
      return $connected;
  }
  else if (DB =3D=3D 'MySQL' {
      return mysql_connect($genDBSid, $genDBUser, $genDBPassword)
  }
}

Something like this?  along with other generic functions to handle each of =
the mysql/oracle functional pieces?


>>> "Matthew Gregg" <gr...@mu...> 09/24/03 10:56AM >>>
This does sound good.  But instead of porting to Oracle, a port to
PEAR or some other "generic" database abstraction layer would be even
better.

On Wed, Sep 24, 2003 at 09:38:28AM -0600, Charlie Smith wrote:
> I'm starting a project to give us an oracle interface ie. replacing mySQL=
 =
calls with Oracle.  Sounds like this could be beneficial to others, =
especially you.   Hope to be done by end of  day today.  Will let you know =
if sounds good to you.
>=20
> >>> "Stefan Champailler" <sch...@ea...> 09/22/03 08:09AM >>>
> Dear all,
>=20
>=20
> I'm going to use phpESP for a project inside a big tyre company. However,=
 =
I'll=20
> need to interface it with Oracle through ODBC. So, what do you think is=20
> better :
>=20
> - use normal ODBC (iODBC, unixODBC)
> - use PEAR libs
>=20
> Personally, I prefer ODBC because I read very poor benchmarks for PEAR=20
> database access.
>=20
> Any suggestions ?
>=20
> Stefan
>=20
>=20
>=20
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf=20
> _______________________________________________
> phpESP-devel mailing list
> php...@li...=20
> https://lists.sourceforge.net/lists/listinfo/phpesp-devel=20
>=20
>=20
>=20
> This message may contain confidential information, and is intended only =
=66or the use of the individual(s) to whom it is addressed.
>=20
>=20
> =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
>=20
>=20
>=20
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf=20
> _______________________________________________
> phpESP-devel mailing list
> php...@li...=20
> https://lists.sourceforge.net/lists/listinfo/phpesp-devel=20
>=20

--=20
mcg
-------------------------------------
The IT Lab (http://www.itlab.musc.edu)



---------------------------------------------------------------------------=
---
This message may contain confidential information, and is intended only for=
 =
the use of the individual(s) to whom it is addressed.


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

Re: [phpesp-dev] ODBC support rewrite

[Charlie S. <Sm...@ld...>]

So instead of mysql_connect or @OCIPLogon($oracleUser, $oraclePassword, =
$oracleSid);
you could have:

=66unction genDBConnect($genDBSid, $genDBUser, $genDBPassword) {
  if (DB =3D=3D 'Oracle) {
      $connected =3D @OCIPLogon($genDBUser, $genDBPassword, $genDBSid);

      if($error =3D OCIError()) {
        die("<font color=3Dred>ERROR!! Couldn't connect to server!</font>");
      }
      return $connected;
  }
  else if (DB =3D=3D 'MySQL' {
      mysql_connect($genDBSid, $genDBUser, $genDBPassword)
  }
}

Something like this?  along with other generic functions to handle each of =
the mysql/oracle functional pieces?


>>> "Matthew Gregg" <gr...@mu...> 09/24/03 10:56AM >>>
This does sound good.  But instead of porting to Oracle, a port to
PEAR or some other "generic" database abstraction layer would be even
better.

On Wed, Sep 24, 2003 at 09:38:28AM -0600, Charlie Smith wrote:
> I'm starting a project to give us an oracle interface ie. replacing mySQL=
 =
calls with Oracle.  Sounds like this could be beneficial to others, =
especially you.   Hope to be done by end of  day today.  Will let you know =
if sounds good to you.
>=20
> >>> "Stefan Champailler" <sch...@ea...> 09/22/03 08:09AM >>>
> Dear all,
>=20
>=20
> I'm going to use phpESP for a project inside a big tyre company. However,=
 =
I'll=20
> need to interface it with Oracle through ODBC. So, what do you think is=20
> better :
>=20
> - use normal ODBC (iODBC, unixODBC)
> - use PEAR libs
>=20
> Personally, I prefer ODBC because I read very poor benchmarks for PEAR=20
> database access.
>=20
> Any suggestions ?
>=20
> Stefan
>=20
>=20
>=20
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf=20
> _______________________________________________
> phpESP-devel mailing list
> php...@li...=20
> https://lists.sourceforge.net/lists/listinfo/phpesp-devel=20
>=20
>=20
>=20
> This message may contain confidential information, and is intended only =
=66or the use of the individual(s) to whom it is addressed.
>=20
>=20
> =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
>=20
>=20
>=20
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf=20
> _______________________________________________
> phpESP-devel mailing list
> php...@li...=20
> https://lists.sourceforge.net/lists/listinfo/phpesp-devel=20
>=20

--=20
mcg
-------------------------------------
The IT Lab (http://www.itlab.musc.edu)



---------------------------------------------------------------------------=
---
This message may contain confidential information, and is intended only for=
 =
the use of the individual(s) to whom it is addressed.


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

Re: [phpesp-dev] ODBC support rewrite

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

This does sound good.  But instead of porting to Oracle, a port to
PEAR or some other "generic" database abstraction layer would be even
better.

On Wed, Sep 24, 2003 at 09:38:28AM -0600, Charlie Smith wrote:
> I'm starting a project to give us an oracle interface ie. replacing mySQL calls with Oracle.  Sounds like this could be beneficial to others, especially you.   Hope to be done by end of  day today.  Will let you know if sounds good to you.
> 
> >>> "Stefan Champailler" <sch...@ea...> 09/22/03 08:09AM >>>
> Dear all,
> 
> 
> I'm going to use phpESP for a project inside a big tyre company. However, I'll 
> need to interface it with Oracle through ODBC. So, what do you think is 
> better :
> 
> - use normal ODBC (iODBC, unixODBC)
> - use PEAR libs
> 
> Personally, I prefer ODBC because I read very poor benchmarks for PEAR 
> database access.
> 
> Any suggestions ?
> 
> Stefan
> 
> 
> 
> 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 message may contain confidential information, and is intended only for the use of the individual(s) to whom it is addressed.
> 
> 
> ==============================================================================
> 
> 
> 
> 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
> 

-- 
mcg
-------------------------------------
The IT Lab (http://www.itlab.musc.edu)

Re: [phpesp-dev] ODBC support rewrite

[Charlie S. <Sm...@ld...>]

I'm starting a project to give us an oracle interface ie. replacing mySQL =
calls with Oracle.  Sounds like this could be beneficial to others, =
especially you.   Hope to be done by end of  day today.  Will let you know =
if sounds good to you.

>>> "Stefan Champailler" <sch...@ea...> 09/22/03 08:09AM >>>
Dear all,


I'm going to use phpESP for a project inside a big tyre company. However, =
I'll=20
need to interface it with Oracle through ODBC. So, what do you think is=20
better :

- use normal ODBC (iODBC, unixODBC)
- use PEAR libs

Personally, I prefer ODBC because I read very poor benchmarks for PEAR=20
database access.

Any suggestions ?

Stefan



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



---------------------------------------------------------------------------=
---
This message may contain confidential information, and is intended only for=
 =
the use of the individual(s) to whom it is addressed.


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

[phpesp-dev] [ phpesp-Bugs-743518 ] Several bugs in 1.6.1

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

Bugs item #743518, was opened at 2003-05-26 01:02
Message generated for change (Comment added) made by nobody
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=743518&group_id=8956

Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Kon Angelopoulos (angek)
Summary: Several bugs in 1.6.1

Initial Comment:
Great package... but:

Cross tabulate includes complete="N" records;

Cros tab grand total incorrect;

survey_results does not display records where a column

'key' is 0;

Error messages are not prominent in espresponse.inc;

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

Comment By: Nobody/Anonymous (nobody)
Date: 2003-09-24 08:15

Message:
Logged In: NO 

The grand_total var is being initialized inside the outer loop.  

The initialization for this should be moved outside the outer 

loop.  I'd wanted to submit this as a patch but have not been 

successful in using cvs to get the most current developer 

version.   The fix is as follows:

crosstab.inc:

                // cws: 9/17/03 moved initialization for grand 

total from inside

                //      fisrt for loop below to above first for loop 

so that it didn't

                //      get reset on adding up each column's total.

                $grand_total = 0;

                for ($f = 0; $f < $cids_col_count; $f++){

                        // $grand_total = 0;

                        for ($g = 0; $g < $cids_row_count; $g++){









Charlie Smith

sm...@ld...

9/24/03

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

Comment By: Kon Angelopoulos (angek)
Date: 2003-09-13 05:36

Message:
Logged In: YES 
user_id=198398

cross tabulate does not include complete="N" records.

As for the totals I cannot replicate the mathematical error

you claim to exist with the totals.

The prominence of error message should be a feature request

and not part of a bug submission.



If you feel that any of what I've said is incorrect please

provide examples for me to see as I cannot duplicate these bugs.



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

Comment By: Kon Angelopoulos (angek)
Date: 2003-07-20 16:13

Message:
Logged In: YES 
user_id=198398

I'll start looking into this and see what can be done.

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

Comment By: Kon Angelopoulos (angek)
Date: 2003-07-20 16:12

Message:
Logged In: YES 
user_id=198398

I'll start looking into this and see what can be done.

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

Comment By: Owen Duffy (owenduffy)
Date: 2003-05-26 14:36

Message:
Logged In: YES 
user_id=787353

Bug report from sourceforge user owenduffy.

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

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

[phpesp-dev] [ phpesp-Bugs-804184 ] Problem with quotes

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

Bugs item #804184, was opened at 2003-09-10 22:21
Message generated for change (Comment added) made by nobody
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=804184&group_id=8956

Category: User
Group: v1.6.1
Status: Open
Resolution: None
Priority: 5
Submitted By: Elie De Brauwer (amo-ej1)
Assigned to: Nobody/Anonymous (nobody)
Summary: Problem with quotes

Initial Comment:
http://phpesp.sourceforge.net/demo/public/survey.php?

name=TESTING1234577



In the essay box type something which contains a bunch 

of quotes and double quotes (or pick a french line, or 

just copy the example above).



Do NOT check on or the combo boxes (so you forgot to 

fill out a required question), press submit. The program 

still knows the data you entered but it has escaped it, 

now if that was a big text you could amuse yourself 

deleting all the backslashes. On the otherhand a user 

could also not see it, press ok and enter the quoted text 

into the database which isn't a good solution either.



problem exists on 1.6.1 running at home and at the 

online demo.

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

Comment By: Nobody/Anonymous (nobody)
Date: 2003-09-24 08:04

Message:
Logged In: NO 

using html_entities or urldecode might solve this problem.

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

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

[phpesp-dev] Question names

[Stefan C. <sch...@ea...>]

Hi,


I'd like to know why question names are to be given by the user since we can 
always use their title instead (for the enduser) and use some automatically 
generated ones (for the programmer side).

stF

[phpesp-dev] ODBC support rewrite

[Stefan C. <sch...@ea...>]

Dear all,


I'm going to use phpESP for a project inside a big tyre company. However, I'll 
need to interface it with Oracle through ODBC. So, what do you think is 
better :

- use normal ODBC (iODBC, unixODBC)
- use PEAR libs

Personally, I prefer ODBC because I read very poor benchmarks for PEAR 
database access.

Any suggestions ?

Stefan

Re: [phpesp-dev] I'll program some features.. what to you think of them?

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

Hi Dan,

an "!other" response for pulldown boxes is something I personally have
never considered nor have ever required however I think that it could
benefit others so I would say that I would have this feature added.

Passing an ID for tracking purposes is a great idea because it opens up
many other opportunities and would make phpESP even more versatile.

Editing results after they've been submitted isn't something that
appeals to me but I'm willing to hold off on commenting any further on
this topic until I've had a closer look at the this feature. Furthermore
what ends up being added to phpESP doesn't rest with me. I don't readily
commit even my own major new features to phpESP :).

Having said this I would suggest that you also submit this feature back
to us for evaluation.

In closing, I'd like to thank you in advance for your efforts and may I
say that I am already eagerly awaiting your code.


Regards


Kon 



On Sun, 2003-09-21 at 15:31, Dan J Lyons wrote:
> Hello,
> 
> I'm doing some volunteer database work for American Whitewater (http://www.americanwhitewater.org) - a nonprofit organization with the purpose "to conserve and restore America's whitewater resources and to enhance opportunities to enjoy them safely."
> 
> We have a database of whitewater accidents dating back to 1975.  I'm trying modernize it using php ESP.
> 
> I need to do some changes to phpESP to make it work with our systems..
> 
> I'm hoping these changes can become part of the core phpESP package so that we can update phpESP and still have it functioning with our web site.
> 
> I've added one function already - added having a "!other" response to pulldown boxes (only one though - other question types allow multiple !other's).
> 
> 
> There are two other features I'd like (and will program):
> 
> I want to have the ability to pass a survey an external ID it can store with a response (which I noticed was suggested by someone else to the phpesp dev list).  Basically, I'll just pass the ID to the handler - and it'll create an assocation between the Response ID and the ID I pass in a new title (how about... Response ID | External Resource ID) - keeps it simple!
> 
> The reason is - I want to be able to have people first select their state from a nice graphical map we have, and then select the river their accident occured on from a list of rivers from that state, and then complete the other questions in a normal phpESP survey - and I need to track the responder's state/river choice with their survey responses.  Otherwise a respondent could be faced with a "drop down" box of 1500 rivers - which I'm afraid could give a guy a headache after just coming back from a river accident (quite possibly a fatality).  This will also enable us to connect responses with our current website members.
> 
> Last, I need the ability to "Edit" results after they've been submitted - phpESP doesn't allow this unless the survey was left uncompleted, correct?  Our database will actually be two surveys - one that gets filled out by people - and another which our Safety Director will fill out by going through each report and putting it in the real version.  He needs the ability to go back and edit previous ones, though.
> 
> Any thoughts on this?  Does it sound good to you guys for inclusion into the core package?
> 
> I'll do all the coding, so you guys can sit back, relax, and watch the features pour in.
> 
> I prefer responses from the core developers.
> 
> Advancing our safety database will lead to more careful accident analyses to be performed, and will quite possibly result in saved lives.
> 
> Thanks,
> Dan Lyons
> 
> 
> ____________________________________________________________
> Get 25MB of email storage with Lycos Mail Plus!
> Sign up today -- http://www.mail.lycos.com/brandPage.shtml?pageId=plus
> 
> 
> -------------------------------------------------------
> 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] I'll program some features.. what to you think of them?

[Dan J L. <dan...@an...>]

Hello,

I'm doing some volunteer database work for American Whitewater (http://www.americanwhitewater.org) - a nonprofit organization with the purpose "to conserve and restore America's whitewater resources and to enhance opportunities to enjoy them safely."

We have a database of whitewater accidents dating back to 1975.  I'm trying modernize it using php ESP.

I need to do some changes to phpESP to make it work with our systems..

I'm hoping these changes can become part of the core phpESP package so that we can update phpESP and still have it functioning with our web site.

I've added one function already - added having a "!other" response to pulldown boxes (only one though - other question types allow multiple !other's).


There are two other features I'd like (and will program):

I want to have the ability to pass a survey an external ID it can store with a response (which I noticed was suggested by someone else to the phpesp dev list).  Basically, I'll just pass the ID to the handler - and it'll create an assocation between the Response ID and the ID I pass in a new title (how about... Response ID | External Resource ID) - keeps it simple!

The reason is - I want to be able to have people first select their state from a nice graphical map we have, and then select the river their accident occured on from a list of rivers from that state, and then complete the other questions in a normal phpESP survey - and I need to track the responder's state/river choice with their survey responses.  Otherwise a respondent could be faced with a "drop down" box of 1500 rivers - which I'm afraid could give a guy a headache after just coming back from a river accident (quite possibly a fatality).  This will also enable us to connect responses with our current website members.

Last, I need the ability to "Edit" results after they've been submitted - phpESP doesn't allow this unless the survey was left uncompleted, correct?  Our database will actually be two surveys - one that gets filled out by people - and another which our Safety Director will fill out by going through each report and putting it in the real version.  He needs the ability to go back and edit previous ones, though.

Any thoughts on this?  Does it sound good to you guys for inclusion into the core package?

I'll do all the coding, so you guys can sit back, relax, and watch the features pour in.

I prefer responses from the core developers.

Advancing our safety database will lead to more careful accident analyses to be performed, and will quite possibly result in saved lives.

Thanks,
Dan Lyons


____________________________________________________________
Get 25MB of email storage with Lycos Mail Plus!
Sign up today -- http://www.mail.lycos.com/brandPage.shtml?pageId=plus 

[phpesp-dev] [ phpesp-Feature Requests-718273 ] question choice ordering

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

Feature Requests item #718273, was opened at 2003-04-10 00:30
Message generated for change (Comment added) made by angek
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=358956&aid=718273&group_id=8956

Category: gui
Group: None
Status: Open
Priority: 5
Submitted By: Chad Bearden (ebeard)
>Assigned to: Kon Angelopoulos (angek)
Summary: question choice ordering

Initial Comment:
I've had requests from the users to allow ordering of

question choices.  Ideally this could be done automatic

or manually.  If automatic, the questions tab would

need to add a new checkbox so that the questions

choices would automatically be arranged in abc order. 

If left unchecke that would remain in the order as

submitted. In manual mode  the interface would be

similar to the order tab when ordering questions.  The

user could then move the question choices up or down at

their discretion.

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

>Comment By: Kon Angelopoulos (angek)
Date: 2003-09-19 08:15

Message:
Logged In: YES 
user_id=198398

Thanks Chad, I understand where you're comming from.

I'll give it some thought and get back to you.

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

Comment By: Chad Bearden (ebeard)
Date: 2003-09-19 00:41

Message:
Logged In: YES 
user_id=171801

when creating a question the first time this is not a problem you 

can add choices in the order you need them.  However when 

editing a question on a copied survey you might want to re-

arrange the choices and when you have many choices  this can be 

a pain.

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

Comment By: Kon Angelopoulos (angek)
Date: 2003-09-16 10:19

Message:
Logged In: YES 
user_id=198398

Chad I understand what you are requesting but I'm finding it 

hard to understand why you want to be reordering question 

choices why not set them in the order you want when 

designing the question?

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

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