On Tue, 25 Aug 1998, Bill Carlson wrote:

> On Mon, 24 Aug 1998, Dave Belfer-Shevett wrote:
>
> > On Mon, 24 Aug 1998, Bill Carlson wrote:
> > > I tried reloading the tables, no dice.
> >
> > This error means there was a mismatch in the recalculation of your key.
> > Keystone authenticates based on server key, username, and password.
> > Generally what this error indicates is you've typed the wrong password.
> > Make sure the 'admin' password within your 'people' table has the MD5 hash
> > that's in the 'people.mysql' file.
>
> I understand, but this is a fresh install of 00.30.01, ie the admin
> password should be abc123 but that doesn't seem to work.
>
> Also, entering a different nonsense password returns the error:
>
> Login incorrect - Unpatched Password
>
> instead of the scalc.

Ok, I fixed this by modifying the passwd field directly.
I can login fine, but every screen update is giving me the error:

MySQL Error #1065 in function db_query
Query was empty

I tried adding a slip, thinking the complaint was no slip records, but no
slips are showing (the tables are populated with the slip records,
however).

What should I be looking at?
Again, this is pristine 00.30.01, straight from the tar ball.


Bill Carlson 	 | Opinions expressed are my own
KINZE Manufacturing, Inc. | not my employer's.

Thanks for the info, however when I move that line then my filters quit
working.  This may not matter since I believe that the plan is to replace
filters with the properties.

Do your filters still work?


Thanks again for the input

Chuck Duerson
chuck@...

On Wed, 26 Aug 1998, Spencer W Thomas wrote:

> Yeah, I just had this problem.  Here's the fix.  Line 93 of slips.php3
> gets moved to follow the next closing brace.
>
> =S
>
> ***************
> *** 89,98 ****
>                                                         }
>                                                 }
>                                         }
>                                 }
> -                               $qstring = "select * from slips $wclause
$otxt";
>                         }
>                 }
>         }
>
>         if ($prefs[opt_debug]) {
> --- 89,98 ----
>                                                         }
>                                                 }
>                                         }
>                                 }
>                         }
> +                       $qstring = "select * from slips $wclause $otxt";
>                 }
>         }
>
>         if ($prefs[opt_debug]) {
>

On Wed, 26 Aug 1998, Kay Behnke wrote:
> 1) The creation of a slip by Slip/Add opens a form in which I can
> specify particular attributes to a slip like "Assigned to...",
> "Priority", and so on.
>
> Question 1:
> What does the field "Assigned to..." actually means? i know that this
> contains all users that are in the group "tech" ...

Assigned To means the slip is on that particular persons 'todo' list.  The
idea is a helpdesk brokering tasks out to individual people.  That person
can come in and see all the slips that are 'assigned to' them.  Slips can
be reassigned from one person to another, etc etc.

> 2) Over and above that, I can modify the content and the attributes
> of a slip. However, in the "Modify" form, I am able to set more
> attributes than in the original "Add" form, namely the "Group"
> attribute.
>
> Question 2:
> What kind of function does the attribute "group" have for a slip?

The 'groups' functions in Keystone are in the embryonic stages.  Right now
they are only used for assignable techs, topslips, and administrative
priveleges.  More is on the way.

> 3) What I would like to do is to define a group by the
> administrator with particular users in it. If one of the users
> creates a slip, this slip will only be visible for members of the
> group.
>
> Question 3:
> How can I specify a slip to a group or to a particular user,
> respectively? And: What kind of function does a group actually has in
> Keystone (according to groups.txt a very special one ...)

Right now, you can't.  This is in the works, though.

> At the moment, every slip that is created by a logged user is shown
> to any other logged user. Moreover, every slip can be modified and
> deleted by a logged user...

Ayup.  Also, in the works. :)

-------------------.          http://www.homeport.org/~shevett/
Dave Belfer-Shevett >----------------------------------------------------.
shevett@...  /   I have the power to channel my imagination into    \
------------------<  ever-soaring levels of suspicion and paranoia. (from  |
                   |           'Ineffective Daily Affirmations')            |
                    \______________________________________________________/

I just installed the latest version of  keystone v0.30.01 and when I login
I recieve the following error

"MySQL error # 1065 in function db-query Query was empty.

It worked under v 0.30.00 and I have added the necessary tables for the
new version.

Does anybody have any ideas?  Thanks

On Wed, 26 Aug 1998, Bob Walters wrote:
> Apologizing to Dave Belfer-Shevett and others

Just 'Dave' is okay.  or Shayde (my nickname), or the like.  The long last
name sounds so.. so... formal.  :)

To Dave Fickes - please feel free to ask questions right on
Keystone-Users... That's what the list is for, for open discussion on
keystone issues.

> , I have not yet had time to install Keystone so I'm not entirely up to
> speed on all of its capabilities.  I have been using PTS to track
> "action items" which sounds like the same type of thing you're looking
> to do. It sounds like each book could fit in as a project (topic) and
> you could then track the activities associated with it as individual
> slips.

Indeed.  That's pretty close.  You're also talking about workflow
management, where there is a specific 'sequence' things have to go in to
be done.  The faxing end of things can be done pretty easily using the
Perl command line thing, doing direct queries.  If you wanted to hack up
something, I'd start with ksb.pl, and go from there.  Note that a company
in DC has agreed to finish the work on the command line interface, so you
might want to wait just a little bit. :)

> I like the idea of changing the color of overdue items to red. If this
> capability isn't already in place it may be a simple change to the
> schema to add a color attribute, and use this attribute at display time
> to set the color.

There's been a lot of call to put aging stuff into Keystone - where
there's a calculated column showing number of days since last activity,
days since opening, etc etc.  Things to sort on.

I'm working on cleaning up a lot of the display code for slips.  The mods
done for 0.30.01 were extensive, and left the system very difficult to
enhance.  As soon as I finish up some of these cleanups, and enable the
customized children view, I'll get back on these things.

David Fickes said:
> > Essentially, there is a bunch of upfront data for a given
> > project -- Title/Author/ISBN/EST Length which won't change
> > but should appear.

This can be done via Extended Table schema, by the way.

> > There are a number of "checkoff" issues such as "Do we have the
> > contracts signed?"

This cannot. :(

> > And then there are a number of To-Do's such as:
> >
> > Cover design: 1. Assign artwork for drafting (usually freelance)
> >               2. Create copy for front and back (usually in-house)
> >
> > CD-ROM 1. If this has a CD-ROM when is the master getting here?

This can be done with sequenced slips, I think.  Where there's a series of
slips, dependencies linked, under one parent project.  Much of the
dependency stuff is not yet enabled, but it might be okay for what you're
looking at.  It won't be automatic - someone would hace to jockey
assignments and schedules, but it would certainly handle the todos.


> > And of course, I wanted to have an interface that turned projects
> > with overdue items RED and the actual item RED so I could scan
> > through our current project list and see what needed assistance.

Yah, see above.  This is a pretty good idea.

Akshully, Keystone can now display slips sorted by last activity.  So if
you sort that way, with criteria set right (only open slips, etc etc), you
can come up with a listing of slips that haven't been touched for a while,
but are still active.

> > I'm almost thinking that Keystone might be able to handle these
> > issues with some modification... your opinion would be greatly
> > appreciated.

Some... careful with too many mods.  Keystone is changing very quickly :)

-------------------.          http://www.homeport.org/~shevett/
Dave Belfer-Shevett >----------------------------------------------------.
shevett@...  / 90's Vocab: Keyboard Plaque: The disgusting buildup  \
------------------<     of dirt and crud found on computer keyboards.      |
                    \______________________________________________________/

David,

Apologizing to Dave Belfer-Shevett and others, I have not yet had time to
install Keystone so I'm not entirely up to speed on all of its capabilities.  I
have been using PTS to track "action items" which sounds like the same type of
thing you're looking to do. It sounds like each book could fit in as a project
(topic) and you could then track the activities associated with it as individual
slips.

I don't know whether Keystone will be able to help with your Monday morning
faxes.  If not it's probably more efficient to write a query directly against
the database and process it separately rather than trying to code this type of
batch process into Keystone.

I like the idea of changing the color of overdue items to red. If this
capability isn't already in place it may be a simple change to the schema to add
a color attribute, and use this attribute at display time to set the color.

Bob Walters
rhw@...
=============================================================================

David Fickes wrote:

> I've just been browsing the Keystone and PTS pages on the web
> and noticed that you seem to have a number of trouble tickets
> that map into our requirements here... so I thought I'd bother
> you with a newbie discussion and ask you for a few minutes of
> your time considering our problem.
>
> We are a book publisher and the production process is getting
> out of hand -- too many cooks wandering off without any accountability.
>
> I had considered setting up a quick TCL/TK interface which would
> track on a project by project basis -- who is assigned what and
> when it is due but perhaps PTS or Keystone can be modified
> for these purposes.
>
> Essentially, there is a bunch of upfront data for a given
> project -- Title/Author/ISBN/EST Length which won't change
> but should appear.
>
> There are a number of "checkoff" issues such as "Do we have the
> contracts signed?"
>
> And then there are a number of To-Do's such as:
>
> Cover design: 1. Assign artwork for drafting (usually freelance)
>               2. Create copy for front and back (usually in-house)
>
> CD-ROM 1. If this has a CD-ROM when is the master getting here?
>
>
> Now I had thought of assigning just the current steps to a
> simple table:
>
> Responsible Party   Description     Due By
>
> and then I wanted a script to run through ALL of the projects
> and FAX of all of the TO-DOs for a given Party to them every
> Monday morning and every morning when they were overdue on a
> project item.
>
> And of course, I wanted to have an interface that turned projects
> with overdue items RED and the actual item RED so I could scan
> through our current project list and see what needed assistance.
>
> I'm almost thinking that Keystone might be able to handle these
> issues with some modification... your opinion would be greatly
> appreciated.
>
> regards, -d
>
> David Fickes                                       david@...
> ADVICE Press                                    phone: 650/321-2198
> 480 California Avenue - Suite 104                 fax: 650/321-2199
> Palo Alto, CA 94306

Dear all,

Again me ...

1) The creation of a slip by Slip/Add opens a form in which I can
specify particular attributes to a slip like "Assigned to...",
"Priority", and so on.

Question 1:
What does the field "Assigned to..." actually means? i know that this
contains all users that are in the group "tech" ...

2) Over and above that, I can modify the content and the attributes
of a slip. However, in the "Modify" form, I am able to set more
attributes than in the original "Add" form, namely the "Group"
attribute.

Question 2:
What kind of function does the attribute "group" have for a slip?

3) What I would like to do is to define a group by the
administrator with particular users in it. If one of the users
creates a slip, this slip will only be visible for members of the
group.

Question 3:
How can I specify a slip to a group or to a particular user,
respectively? And: What kind of function does a group actually has in
Keystone (according to groups.txt a very special one ...)

At the moment, every slip that is created by a logged user is shown
to any other logged user. Moreover, every slip can be modified and
deleted by a logged user...

Perhaps I should mention how I tested my problem. I created a group
"nova" with two users a and b and the assigned flag set. Another user
c is a member of a third group "ubc". A slip created by a is also
visible and can be modified/deleted by c and vice versa.

Do you have any suggestions?

Thanks, Kay

-------------------------------
nova ratio gmbh - Büro Nijmegen

Dr. K. Behnke
IT-Consultant

Postbus 31070
6503 CB Nijmegen

Tel.: ++31-24-3528852
Fax : ++31-24-3528856

email: Kay.Behnke@...
-------------------------------

>>>>> "Ronald" == Ronald Offerman <ron@...> writes:

     Ronald> It would be nice if the login page was reorganized in such
     Ronald> a way that after having typed my login name ONE tab will
     Ronald> take me to the password entry box.

If we're willing to use HTML 4, we can specify the tab order.  Oddly,
when I was running Netscape 4.05 on Windows 95, the tab order was
"right".  When I ran Netscape 4.05b on Linux, it isn't.  I didn't look
too closely....

roland
--
Roland B. Roberts, PhD                  Custom Software Solutions
roberts@...                           101 West 15th St #4NN
                                                New York, NY 10011

The moving depends on the browser you use. Netscape skips in a horizonal
manner as you described, the MS IE handles this better (user, password and
the the logon button).

...darko

> -----Original Message-----
> From: owner-pts-users@...
> [mailto:owner-pts-users@...]On Behalf Of Ronald
> Offerman
> Sent: Dienstag, 25. August 1998 14:07
> To: Keystone-Users
> Subject: [keystone-users] Login page mod.
>
>
> It would be nice if the login page was reorganized in such a way
> that after
> having typed my login name ONE tab will take me to the password entry box.
> Moving the 'lookup specific slip' and 'contact' entry boxes down would
> probably solve this easily.
>
> BTW, 0.30 really is much faster, I LOVE the
> properties/preferences, any ideas
> about the reporting functions yet?
>
> --
> <- Ronald Offerman | ron@...
> <- Root Powered Carrot Munchers Ltd. Inc. SA AG BV
>
> "Daddy, why do those people have to use Microsoft Windows?"
> "Don't stare, son; it's not polite."
> "M$ Windows NT, an accident waiting to happen"
>

On Mon, 24 Aug 1998, Dave Belfer-Shevett wrote:

> On Mon, 24 Aug 1998, Bill Carlson wrote:
> > I tried reloading the tables, no dice.
>
> This error means there was a mismatch in the recalculation of your key.
> Keystone authenticates based on server key, username, and password.
> Generally what this error indicates is you've typed the wrong password.
> Make sure the 'admin' password within your 'people' table has the MD5 hash
> that's in the 'people.mysql' file.

I understand, but this is a fresh install of 00.30.01, ie the admin
password should be abc123 but that doesn't seem to work.

Also, entering a different nonsense password returns the error:

Login incorrect - Unpatched Password

instead of the scalc.


Bill Carlson 	 | Opinions expressed are my own
KINZE Manufacturing, Inc. | not my employer's.

It would be nice if the login page was reorganized in such a way that after
having typed my login name ONE tab will take me to the password entry box.
Moving the 'lookup specific slip' and 'contact' entry boxes down would
probably solve this easily.

BTW, 0.30 really is much faster, I LOVE the properties/preferences, any ideas
about the reporting functions yet?

--
<- Ronald Offerman | ron@...
<- Root Powered Carrot Munchers Ltd. Inc. SA AG BV

"Daddy, why do those people have to use Microsoft Windows?"
"Don't stare, son; it's not polite."
"M$ Windows NT, an accident waiting to happen"

Dear all,

a few days ago I sent an email in which I described my problem with
changing a password. I have not solved the problem so far but found
another "funny" effect. I cannot change the passwords (of any user,
including admin) if I use a webbrowser on the host (Linux 2.0.34), on
which the Keystone system runs.

However, if I use a webbrowser on a remote host (Windows for
Workgroups 3.11 - yes, we are oldfashioned ...) on our local network,
changing the password is no problem. Moreover, if I am logged in as
admin, I now see the user "admin" in the entry "Username". This does
not happen if I use the webbrowser on the Linux machine on which
Keystone is installed ...

BTW, I use apache v.1.3.1, php3 v.3.0.2a, mysql v.3.21.33, and
finally keystone v.0.30.01.

If you have any further ideas I would like to hear from you.

Thanks, Kay
-------------------------------
nova ratio gmbh - Büro Nijmegen

Dr. K. Behnke
IT-Consultant

Postbus 31070
6503 CB Nijmegen

Tel.: ++31-24-3528852
Fax : ++31-24-3528856

email: Kay.Behnke@...
-------------------------------

On Mon, 24 Aug 1998, Bill Carlson wrote:
> I just setup 0.30.01 the other day.
> I'm getting an error (login incorrect(scalc failed) when I try to login
> under the admin account.
>
> I have a setup of 0.22.02 that works fine...
> Database is MySQL, Apache w/PHP3, etc...
> I tried reloading the tables, no dice.

This error means there was a mismatch in the recalculation of your key.
Keystone authenticates based on server key, username, and password.
Generally what this error indicates is you've typed the wrong password.
Make sure the 'admin' password within your 'people' table has the MD5 hash
that's in the 'people.mysql' file.

-------------------.          http://www.homeport.org/~shevett/
Dave Belfer-Shevett >----------------------------------------------------.
shevett@...  / You Know You're a coffee addict when (#6) : You have \
------------------<            to watch videos in fast-forward.            |
                    \______________________________________________________/

On Mon, Aug 24, 1998 at 10:30:45PM -0400, Dave Belfer-Shevett wrote:
> See, what I'm trying to avoid is keystone 'making' the decisions for the
> users.  What I use at my professional install of Keystone during my full
> time job, is I use the login name of hte user.  That's -always- going to

That makes sense to me - I think I'll edit the HTML to say "userid" instead
of "tag" - and I'll be happy :-)

--
Cheers

Jason Haar

Unix/Network Specialist, Trimble NZ
Phone: +64 3 3391 377 Fax: +64 3 3391 417

On Tue, 25 Aug 1998, Jason Haar wrote:
> > > Can keystone instead auto-generate unique id's instead of relying on
humans?
> > > To me this id concept looks like an internal thing that only keystone
should
> > > have to worry about...
> >
> > Mmm.  Probably, but is it really necessary?  Contact ID's are -supposed-
> > to be unique, so you can keep track of slips assigned to various contacts.
>
> True - but it adds an iteration cycle on the user. If I have 50 contacts and
> try to add another, I have to think "what numbers/ids have already been
> used?" before I fill in that tag (I know mysql will report an error if I use
> an existing tag, but that still seems like an unneccesary step). So I have
> to go 'Back' and check out the existing contacts before I go 'Add'.

See, what I'm trying to avoid is keystone 'making' the decisions for the
users.  What I use at my professional install of Keystone during my full
time job, is I use the login name of hte user.  That's -always- going to
be unique.  If I have Keystone generate the contact tag, I run into the
same problem that large companies have with their email systems.  What if
there are two John Smiths?  An auto-generated key would collide.  An admin
installing the system would -know- there's a conflict already.  See my
point?

This system is supposed to be as flexible as possible.  I need to be able
to have 'sane' way of referring to the contact name, especially for things
like going to Properties, and saying "Contact tag" "Equal to" "shevett".
If I had a hashed contact tag, I'd have to find out what that hash is and
copy it into that query.

-------------------.          http://www.homeport.org/~shevett/
Dave Belfer-Shevett >----------------------------------------------------.
shevett@...  /  If you can read this, I can hit my brakes and sue   \
------------------<            you. ("Extreme Bumper Stickers")            |
                    \______________________________________________________/

> > Can keystone instead auto-generate unique id's instead of relying on humans?
> > To me this id concept looks like an internal thing that only keystone should
> > have to worry about...
>
> Mmm.  Probably, but is it really necessary?  Contact ID's are -supposed-
> to be unique, so you can keep track of slips assigned to various contacts.

True - but it adds an iteration cycle on the user. If I have 50 contacts and
try to add another, I have to think "what numbers/ids have already been
used?" before I fill in that tag (I know mysql will report an error if I use
an existing tag, but that still seems like an unneccesary step). So I have
to go 'Back' and check out the existing contacts before I go 'Add'.

> If I auto-generate the unique tag - that sort of defeats the purpose,
> because then I could have two contacts in the Contact table for the same
> person.

How about auto-generating the tag from some hash of the contacts name? That
way simple double entering could be caught. As it is at the moment, I can
still double-enter contacts if I choose an unique id for the second entry. I
don't know if there's much you can really do about people double-entering
contacts - that's more of a people problem than a technical one ;-)


> Well, to delete the bad contact, you should just go to the Mysql command
> prompt and do a 'delete from contacts where ctag='xxx'' - that'll get rid
> of both 'bad' contacts, and just re-add what you want.
>

Yeah - I worked that one out myself :-)

--
Cheers

Jason Haar

Unix/Network Specialist, Trimble NZ
Phone: +64 3 3391 377 Fax: +64 3 3391 417

I just setup 0.30.01 the other day.
I'm getting an error (login incorrect(scalc failed) when I try to login
under the admin account.

I have a setup of 0.22.02 that works fine...
Database is MySQL, Apache w/PHP3, etc...
I tried reloading the tables, no dice.


Ideas?

Bill Carlson 	 | Opinions expressed are my own
KINZE Manufacturing, Inc. | not my employer's.

On Mon, 24 Aug 1998, Kay Behnke wrote:
> I already had the problem with v.2.21 and have it again with the new
> version v.3.00.
>
> I always get the error "Password change FAILED" when I try to change
> the password for a user (also for admin) in the menue Other/Password.

I have not heard of this problem before.  Are you using MySQL?

> I already had a look into the file changepw.php3 but cannot detect
> any bugs. The only conclusion can be that the function
> db_affected_rows () on line 65 does not return a value greater than
> 0, which means there were no changes in the database by the function
> db_query ().

Yup, that's how it works.  Again, this functions works all over the place.
What database server and what versin of PHP are you running?

-------------------.          http://www.homeport.org/~shevett/
Dave Belfer-Shevett >----------------------------------------------------.
shevett@...  /   From the "Top Ten Signs You Might Be A Sysadmin"   \
------------------<   (Jonathan Kalbfeld) : #1 You have ever uttered the   |
                   |   phrase "I will be working from home today so I can   |
                   |                 avoid wearing pants."                  |
                    \______________________________________________________/

On Mon, 24 Aug 1998, Darko Krizic wrote:
> One more little comment:
> I would like to be able to have an customized header and/or footer for
> each page in order to give Keystone a customized look.

The pages in Keystone are almost sculpted.  What are you looking to
change?  Custom headers are hard to work into the overall design without
breaking the table layout.

> Since Keystone costs money and is going to be used in commercial
> environments, the admins must be able to customize the look to any
> existing web server.

Again, I'm not sure what you're looking for here.  Color changes, yes.
Look and feel, that's far more difficult.

> MOT uses a general file that is included before each other. That file
> even can contain CSS-tags.

This application is not MOT.

(and I can't compare further, since it appears MOT's site is down)

-------------------.          http://www.homeport.org/~shevett/
Dave Belfer-Shevett >----------------------------------------------------.
shevett@...  /   90's Vocab: Generica - Features of the American    \
------------------<  landscape that are exactly the same no matter where   |
                   |    one is. "We were so lost in generica, I actually    |
                   |  forgot what city we were in." GOOD Job - A "Get-Out-  |
                   |  Of-Debt" job. A well-paying job people take in order  |
                   |   to pay off their debts, one that they will quit as   |
                   |            soon as they are solvent again.             |
                    \______________________________________________________/

On Mon, 24 Aug 1998, Darko Krizic wrote:
> I am still playing around with keystone and have a little list (for
> now!) with a few things about keystone. I am also comparing Keystone
> to MOT (Ministry of Truth).

Make sure you're running Keystone 0.30.01.  There are some fairly drastic
changes in the UI from 0.20 to 0.30.

(as a sidenote, MOT is based on PTS, which I also wrote. :)

> What about generally using CSS (cascading style sheets) instead of
> hardcoding colors. This would it make easier to customize Keystone in
> optics. Maybe a few CSS-sets could be included with Keystone where the
> user can choose in the Properties dialog.

CSS are only supported in 4.0-level browsers.  Enabling these functions
could alienate a tremendous number of users.  I don't think there's a
strong need for it, as the customizations could be handled other ways.

> Why can't one use have several properties where he can switch using
> one little popup.

That would be a good idea.  The 'properties' as they stand right now are
brand new to 0.30, and need to be stabilized before having multiple
settings.

> It is pretty complicated to get a list of slips that are assigned to
> me. I have to enter each hiearchy level in order to find such slips.
> By turning off the hiarchy display of slips I get back to the last
> point.

Are you running 0.30.01?  If so, go to Properties, and select "Current
tech" 'equal to' "your name".  If you're only seeing top level slips
there, make sure you have "$sys_justparents" set to '0' in the .conf file.

> I slip can only be assigned to one tech. MOT handles this different.
> It allows one slip to have one or more assigned techs.

Other people have pointed this out, and it's something I'm looking into.
The 'groups' and 'topslips' and various other lists mechanism has to be
replaced before I can do multiple assignments like that, but that's part
of it.

> Too many things in keystone are hardcoded. I would like to change the
> text "Problem" to "Subject" or "Issue". That should be database based.

0.30 was the first version to include a Data Dictionary.  I can cahnge
many of the prompts by modifying that dictionary.  Customizations,
however, run the risk of breaking the system from the distribution.  I'm
not sure how to handle local customizations of the data dictionary right
now.

> There is no relation between resources and slips. It would be nice to
> create a slip by combining one (or seveal) resources, contacts and
> techs.

Correct.  Most of the most recent development was centered on making the
Slips functions stable and useable.

-------------------.          http://www.homeport.org/~shevett/
Dave Belfer-Shevett >----------------------------------------------------.
shevett@...  /   W98 Err#01F - Error In Progress; Please Wait....   \
                    \______________________________________________________/

I am still playing around with keystone and have a little list (for
now!) with a few things about keystone. I am also comparing Keystone
to MOT (Ministry of Truth).

What about generally using CSS (cascading style sheets) instead of
hardcoding colors. This would it make easier to customize Keystone in
optics. Maybe a few CSS-sets could be included with Keystone where the
user can choose in the Properties dialog.

Why can't one use have several properties where he can switch using
one little popup.

It is pretty complicated to get a list of slips that are assigned to
me. I have to enter each hiearchy level in order to find such slips.
By turning off the hiarchy display of slips I get back to the last
point.

I slip can only be assigned to one tech. MOT handles this different.
It allows one slip to have one or more assigned techs.

Too many things in keystone are hardcoded. I would like to change the
text "Problem" to "Subject" or "Issue". That should be database based.

There is no relation between resources and slips. It would be nice to
create a slip by combining one (or seveal) resources, contacts and
techs.

...darko
==
--
Darko Krizic
mailto:dekay@...
http://www.bsb-software.com

_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com

One more little comment:

I would like to be able to have an customized header and/or footer for
each page in order to give Keystone a customized look.

Since Keystone costs money and is going to be used in commercial
environments, the admins must be able to customize the look to any
existing web server.

MOT uses a general file that is included before each other. That file
even can contain CSS-tags.

...darko

==
--
Darko Krizic
mailto:dekay@...
http://www.bsb-software.com

_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com

On Mon, 24 Aug 1998, Franck Poirot wrote:
> Thanks a lot for the answers of my Keystone questions. I have still 2 more
> quesitons before we jump into your product:

As a suggestion - you should subscribe to 'keystone-users'.  Folks there
can keep up faster than I can.  I'm CCing this to the list in hopes some
other folks can offer suggestions as well.

> - is there any way to attach files to a bug request (slip) ? Generally, each
> bug is associated with files (ascii files in your case such as Verilog or
> VHDL tar files).

Not currently.
However, if you have the files on a webserver somewher, you -can- embed a
URL to the file <a href="foo.bar">Here!</a> that sort of thing.

> - it seems that we can send a bug only to a given person and not to a product.
> In fact, I would prefer to report a bug to a category, let say XX Core Engine.
> Then, a predefined primary assignment list will re-route this bug to a given
> person ?
> Then, I can also display all bugs which are OPEN in category "XX Core Engine".
> At this time, I display all bugs with a give status (OPEN, CLOSE, ...).

The best way to do this is to create a Slip, and put it in the 'topslips'
group.  (via the 'groups' table in Maintenance.  This is documented in the
'groups.txt' file in the 'docs' subdir).  This can act as a 'category',
and you can categorize slips under this using Parents.

Example.  I have 2 'category' slips on my Keystone installation at
stonekeep.com.  One is 'Keystone Bugs', the other is 'Keystone Features'.
As slips are entered, their parents are set to oe of these two slips.
Then I just zoom on one of them, and see all the bug slips, or all the
feature slips.  Works great.  :)

If you put those 'category' slips in the Topslips group, then those
categories show up in the 'quickslips' pulldown menu in the upper right
corner, so you can quickly jump from one 'topic' to another.

(is anyone using this feature, by the way?  for my installation at
stonekeep, it's invaluable.  but I'm biased.  :)

> - when I try to send a slip to someboby (Email menu) it does not work and the
> bug is not sent, is there any bug here ?

Not htat I know of.  I'm -constantly- using this function.  Have you
looked in your mail log to see if it's even trying to send mail?  Also,
does the status line on Keystone say "Sent mail to xxx@xxx.xxx" after
doing a mail send?

> - when I enter a bug it seems to be slow sometimes.

Keystone 0.30.01 has -vast- speed improvements.  Make sure you're running
the latest version.

-------------------.          http://www.homeport.org/~shevett/
Dave Belfer-Shevett >----------------------------------------------------.
shevett@...  /   90's Vocab: SITCOMs: What yuppies turn into when   \
------------------<  they have children and one of them stops working to   |
                   |   stay home with the kids. Stands for Single Income,   |
                   |           Two Children, Oppressive Mortgage.           |
                    \______________________________________________________/

NOTE - please send keystone-related questions to 'keystone-users', not
'pts-users'.

On Mon, 24 Aug 1998, Jason Haar wrote:
> I've just installed keystone-0.30.01 (very nice...) and made the mistake of
> not allocating an unique id to a contact I made. Now I can see the contact
> but can't modify or delete it...

Whoops. :)

> Can keystone instead auto-generate unique id's instead of relying on humans?
> To me this id concept looks like an internal thing that only keystone should
> have to worry about...

Mmm.  Probably, but is it really necessary?  Contact ID's are -supposed-
to be unique, so you can keep track of slips assigned to various contacts.
If I auto-generate the unique tag - that sort of defeats the purpose,
because then I could have two contacts in the Contact table for the same
person.

> Comments?

Well, to delete the bad contact, you should just go to the Mysql command
prompt and do a 'delete from contacts where ctag='xxx'' - that'll get rid
of both 'bad' contacts, and just re-add what you want.

-------------------.          http://www.homeport.org/~shevett/
Dave Belfer-Shevett >----------------------------------------------------.
shevett@...  / "Just remember. Abraham Lincoln didn't die in vain.  \
------------------<    He died in Washington, D.C." (Firesign Theatre)     |
                    \______________________________________________________/

Dear all,

I already had the problem with v.2.21 and have it again with the new
version v.3.00.

I always get the error "Password change FAILED" when I try to change
the password for a user (also for admin) in the menue Other/Password.

I already had a look into the file changepw.php3 but cannot detect
any bugs. The only conclusion can be that the function
db_affected_rows () on line 65 does not return a value greater than
0, which means there were no changes in the database by the function
db_query ().

Any hints why this is the case?

Thanks, Kay
-------------------------------
nova ratio gmbh - Büro Nijmegen

Dr. K. Behnke
IT-Consultant

Postbus 31070
6503 CB Nijmegen

Tel.: ++31-24-3528852
Fax : ++31-24-3528856

email: Kay.Behnke@...
-------------------------------

On 21 Aug, Spencer W Thomas wrote:
> I downloaded and installed keystone 0.30.01.  I added the 3 new
> tables, dropped and added the states table (because it has 3 new
> columns).
>
> BUT, when I try to view slips, I get this error:
>
> Mysql error #1065 in function db_query Query was empty
>
> If I select a filter, the error goes away.
>
> Ideas?
>
> =Spencer W. Thomas |  JSTOR, 301 E. Liberty, Suite 310
>  School of Information  |  Univ of Michigan, Ann Arbor, MI 48104-2262
> spencer@... |  313-998-9104, FAX 313-998-9113

seems that line 93 (file slips.php3) spelling :

	 $qstring = "select * from slips $wclause $otxt";

needs to be one line down (just after the '}')

RN.

 Each time when I edit an filter the backslash symbol \ is escaped once more. This leads to a string like \\\\\\\'user'\\\\\\\ which really does not work. --Darko Krizichttp://www.bsb-software.commailto:dekay@... 

I had this problem, too. I tried taking out the 'addslashes' calls in filterpost.php3, and that worked, but I still had problems with backslashes in user followups.

It turns out that there is a global php3 setting called magic_quotes_gpc (get, post, cookies) in the php3.ini file that you need to set 'off'. This makes things almost entirely better, although with the 0.21.00 version of Keystone I've been using I still am having trouble with escaped characters when modifying the status messages for a slip - the modification history escapes things.

I left a followup comment on the public keystone interface to keystone, and requested that this be mentioned in the installation instructions for keystone.
--
Karl J. Smith -- karl@...
 

I downloaded and installed keystone 0.30.01.  I added the 3 new
tables, dropped and added the states table (because it has 3 new
columns).

BUT, when I try to view slips, I get this error:

Mysql error #1065 in function db_query Query was empty

If I select a filter, the error goes away.

Ideas?

=Spencer W. Thomas |  JSTOR, 301 E. Liberty, Suite 310
  School of Information  |  Univ of Michigan, Ann Arbor, MI 48104-2262
spencer@... |  313-998-9104, FAX 313-998-9113

On Fri, 21 Aug 1998, Darko Krizic wrote:
> Just downloaded this version and currently testing. Seems to work fine
> except one error I have: Each time I load a page I receive this error
> message:
>
>  MySQL Error # 1017 in function db_query Can't find file: 'preferences.frm'
> (errno: 2)

This means you're missing the table 'preferences' from your 'keystone'
database.

-rw-r--r--  1 shevett  services  387 Aug 18 22:35 preferences.mysql

That should be in your 'struct' directory.

just go 'mysql keystone < preferences.mysql'

-------------------.          http://www.homeport.org/~shevett/
Dave Belfer-Shevett >----------------------------------------------------.
shevett@...  /    W98 Err#01B - Error Removing Temporary File; a    \
------------------<           Permanent File Will Be Substituted           |
                    \______________________________________________________/