L J Bayuk | 2 Jan 04:18 2001
Picon

Working with PostgreSQL, lots more

Hello, MRBS list, and happy New Year. I recently started looking at this
wonderful MRBS app, and am trying to sell it to The Boss. Of course,
there are several changes both he and I would like to make. At the top of
my list is to have it work with PostgreSQL. At the top of his list is to be
able to schedule repeating meetings on (for example) the 3rd Tuesday, or
the 2nd Friday, of the month. (This is a must-have feature for him.)

Well, I got a little carried away here, and I'm afraid to say I've done all
that and more, even though The Boss hasn't decided to use it, and hasn't
even shown me the rest of his list. Anyway, I started with the latest CVS
release, and also went through the Bug List and Mailing List Archives to
look for good patches. I standardized the SQL, and wrote database wrappers
for the basic functions and for those cases where both MySQL and PostgreSQL
differ in some non-standard SQL syntax. I also added my monthly repeat
feature for corresponding week number and day of week.

I'm testing it under PHP 4.0.4 and both MySQL 3.22.32 and PostgreSQL-7.0.3.
It's working well. Database selection is just one setting in config.inc.
No changes to the database schema, so it will work with existing databases
(except maybe for the magic quote thing below).  There's a new version of
tables.sql to create PostgreSQL tables, but if you want to migrate a
database between MySQL and PostgreSQL, well, you had better have your
wizard's degree in both, because it's not easy.

What else did I do? Let's see, it has the edit-area/room feature which was
on the mailing list.  I cleaned up the HTML output a bit, to fix some
errors like quoting and the tag order at the top. (weblint likes it now.)
I removed some unused functions from functions.inc. I beat up hard on magic
quoting problems, and I think I got it right so now you can put any
character into a name or description and it comes back the same way. (But
(Continue reading)

melissa allman | 3 Jan 19:52 2001

schedule print out

Has anyone created a printout of the schedule from their Mysql records?
Something with a form with a begin and end date issuing SQL Select statements?

-------------------------------------------
The Fastest Browser on Earth now for FREE!!
Download Opera 5 for Windows now! Get it at
http://www.opera.com/download/
-------------------------------------------

Pär Lindfors | 5 Jan 10:32 2001
Picon

Entry does not change properly..

Hi!

Just found a huge bug! :(

When i add a booking to mrbs, lets say duration of 1 hour, and then
modify the booking to
2 hours, and then DECREASE the duration again to 1 hour, the old entry
wont be deleted
and everything is a mess. 

If i want to the delete the entry above, i have to press 'delete' as
many times
as i have made changes to a particullar booking...

I have tried with my installation, and the demo installation at
mrbs.sourceforge.net, 
both have the same problem.

Anyone got a solution for this?

/Pär

--

-- 
Pär Lindfors, Coresys AB 
Ideon Research Park, SE-223 70 LUND, Sweden 
Tel : +46 (0)46 2863733, Fax : +46 (0)46 129879
par.lindfors <at> coresys.se, http://www.coresys.se

L J Bayuk | 7 Jan 02:20 2001
Picon

Re: schedule print out

melissa allman <melrse <at> operamail.com> wrote:
> Has anyone created a printout of the schedule from their Mysql records?
> Something with a form with a begin and end date issuing SQL Select statements?

A related comment I've heard was that the Search results do not contain
enough information (e.g. room name), nor can you search by room or area,
nor order the results differently. I like Search the way it is, as a
"quick search", but I started implementing a separate Report function.
Might this be what you are looking for too? It would be linked from the
common header (along with Help, Admin, Search). You get a form like this:
   Starting on or after:  [date selector, default to today]
   Starting no later than: [date selector, default to today+1 year]
   Only areas matching:  [text entry]
   Only rooms matching:  [text entry]
   Match entries titled:  [text entry]
   Match entry descriptions:  [text entry]

You could fill in whatever you want to limit the results, but by default
you get a year's worth of every meeting. (Maybe a year is too much?) The
"match" fields are simple contains-this-substring matches, like Search does,
not wildcards or regular expressions.  (This because I can't yet make either
SQL LIKE or regexp both be case insensitive in both MySQL and PostgreSQL.)
The output is ordered first by area/room, then by start date/time, so
bookings for each room are grouped together.

No multiple pagination of the results like Search does; you get the whole
thing in one HTML document, so if you want to print it out you can do so.
But I haven't quite figured out how the results should be formated.  I would
like to avoid one big table because browsers are so slow formatting large
tables. I've tried multi-line entries for each booking, but I'm not sure
(Continue reading)

L J Bayuk | 7 Jan 02:15 2001
Picon

Re: Entry does not change properly..

Pär Lindfors <par.lindfors <at> coresys.se> wrote:
> When i add a booking to mrbs, lets say duration of 1 hour, and then
> modify the booking to
> 2 hours, and then DECREASE the duration again to 1 hour, the old entry
> wont be deleted
> and everything is a mess.
> ...
> Anyone got a solution for this?

A fix for this was posted in a message to the mailing list from Bo Kleve, on
Nov 26 2000, "Patch for duplicates when changing a booking". You can find it
in the mailing list archives on sourceforge. The patch is to the
edit_entry_handler script. The bug is that the first time you edit the
entry, its entry_type incorrectly changes to 2 (which means "modified entry
in a series"). When you edit the entry a second time, it won't delete the
old entry because it thinks it was a modified part of a series. (The exact
change you made to the duration doesn't matter.)

I don't think the fix has made it into the CVS sources.  It is in my own
heavily modified version (the one which works with PostgreSQL and MySQL),
however I am still waiting to hear from the project maintainers on that.

Daniel | 7 Jan 22:45 2001
Picon
Picon

Re: Working with PostgreSQL, lots more

Hi!

I guess i'm the fabled admin that you've been after, sorry
its taken so long to get back to you on this - but what with
christmas and everything....

but enough excuses! all of this sounds really interesting! really
really interesting... i like the sound of all of this. how do you
fancy becoming an offical mrbs developer type person? if you have a
sourceforge id then i can add you as a developer so that you've got
write access to the cvs repository. then you can commit all of the
changes that you've made and everyone can look and see how whizzy it
is!

once the code is in there i can make a tarball out of the cvs code and
throw it out there to see what happens...

there's one little thing that i would ask, could you add something to
the INSTALL file about installing with postgres, because i've got no
experiance with it at all ;)

let me know if/when you have a sourceforge id and i'll add you in!

ta,
daniel

On Mon, Jan 01, 2001 at 10:18:24PM -0500, L J Bayuk wrote:
> Hello, MRBS list, and happy New Year. I recently started looking at this
> wonderful MRBS app, and am trying to sell it to The Boss. Of course,
> there are several changes both he and I would like to make. At the top of
(Continue reading)

Webdev | 8 Jan 01:16 2001
Picon
Picon

Running MRBS using basic AUTH_USER Authentication under IIS and N T 4

Hello,

My Name is Scott Leonard and I' am trying to implement  MRBS on an NT
environment using IIS, php4 and MySQL. I would like to use it on an
Intranet.

I download MRBS and have installed it and the standard configuration works
fine using IP Authentication. 

I have set-up the NTFS permissions on my MRBS directory and have enabled the
web settings so that only authorised users can have access and there is no
unauthorized access.

I copied the standard auth_ip.inc and used a modified version called it
auth_exp.inc. 

I changed it so that

function getUserName()
{
	global $REMOTE_ADDR;
	return $REMOTE_ADDR;
}

becomes

function getUserName()
{
	global $PHP_AUTH_USER;
	return $PHP_AUTH_USER;
(Continue reading)

Daniel | 9 Jan 22:41 2001
Picon
Picon

Re: Working with PostgreSQL, lots more

> Greetings, fabled admin. My sourceforge ID is "lbayuk" but I have to warn
> you that I am very very new at this (this, being: cvs + ssh + sourceforge)
> and I'm not sure it would be safe to let me commit changes to your CVS
> repository just yet. You can set me up, but I won't do anything until
> we discuss it. Keep in mind, there are a few new files, and I renamed
> all the *.php3 files to *.php (for PHP4) - so it isn't just a simple
> cvs commit.
> 
> I would certainly like to help as a developer of MRBS. But I haven't yet
> sold my work-place on this, and if they don't like it (or, even, if the
> right people don't bother to show up for the demo next week), I will
> unfortunately lose my main reason for working on it. So we'll have to see.
> I would surely like to help get my changes in and call it "1.0", but I
> can't promise much beyond that until I see how it goes at work.

okay. that's all cool.

i've added you as a developer anyway. since i came back to mrbs i've decided
to use a "more the merrier" approach - anyone who sounds like they have a
clue is probably going to get write access.

i like the look of the changes to the install file. it's all nice!

the thing about changing all of the file names to .php is probably something
that should happen. there's getting to be more php4 out there every day,
nad i guess it is kinda expected... so it wouldn't be a bad thing if the
names all changed.

i guess we'll see how your presentation goes next week. if it helps you
can let them know that the place i used to work for is still using
(Continue reading)

L J Bayuk | 10 Jan 02:43 2001
Picon

Thinking about External/Internal

I was thinking about the Booking Type field, which is now "Internal" or
"External". I find myself explaining this too often to people, and I think
it isn't really intuitive or generally applicable to have these 2 types of
bookings.  So, what would happen if we drop the wording, internal or
external, and just let the user select from a list of 10 colors? The
meaning then becomes whatever the site or user wants it to be, or you can
just make it nice and colorful by picking random types.  Inside MRBS, the
entry types would be extended from the current single letter I or E to a
letter A through J. (Of course, I and E would keep their current colors.)
If you want to assign meaning to specific colors, you could put that into
your site help/faq file (easy because it uses the same style sheet).

In the main calendar view, I would delete the "Color key" legend displayed
on the left, since the colors would have no meaning "inside" MRBS. Similarly
the view details screen wouldn't report the Type anymore. I don't think
there would be any other visible changes.

At this point I'm not convinced that this is a great idea, just an
interesting one. (No, I haven't coded it yet, just looked to see if it was
feasible.) Does anyone want to talk me into or out of this?

Ian Harrison | 10 Jan 12:52 2001

Re: Thinking about External/Internal

In our application "internal" or "external" are used to differentiate
between meetings with only attendees from inside the company (which can
probably be pushed around if there is a conflict) from meetings with
suppliers or customers from outside, which are harder to move.

As a colour-blind user, I find things which are completely
colour-dependent very difficult, and studiously avoid using colour alone
to convey information.  According to this article
http://msdn.microsoft.com/workshop/design/color/hess10092000.asp
eight percent of men, and 0.5 percent of women share this deficiency, a 
significant minority.

If we could have some customizable text, visible when we open the
booking at a minimum, as well as your colour suggestion then this would
help me.  We could differentiate regular weekly meetings from one-offs,
different groups could book using a different category, etc.  I can see
how this would be very useful.

Ian.

On Tue, 9 Jan 2001, L J Bayuk wrote:

> I was thinking about the Booking Type field, which is now "Internal" or
> "External". I find myself explaining this too often to people, and I think
> it isn't really intuitive or generally applicable to have these 2 types of
> bookings.  So, what would happen if we drop the wording, internal or
> external, and just let the user select from a list of 10 colors? The
> meaning then becomes whatever the site or user wants it to be, or you can
> just make it nice and colorful by picking random types.  Inside MRBS, the
> entry types would be extended from the current single letter I or E to a
(Continue reading)


Gmane