You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@openmeetings.apache.org by Hamdi THABET <ha...@gmail.com> on 2012/04/13 13:16:54 UTC
Default Timezone ?
Hello everybody,
Can I set default timezone for all OM users ?
It's set as the first in the list = GMT+12 (Magadan, Fiji, New Zealand)
Can I set it here in "src/install_step1_EN.vm" ?
<select name="timeZone" id="timeZone" hidden="true"
size="0">
#foreach( $key in $allTimeZones.keySet() )
<option value="$key">$allTimeZones.get($key)</option>
#end
</select>
Hamdi THABET
Élève ingénieur en Téléinformatique (3e année)
Maîtrisard en informatique
Technicien en Réseau informatique et Télécoms
[+216] 52 72 27 25
hamdi.thabet86@gmail.com
Re: Réf. : Re: Suggestions !
Posted by "seba.wagner@gmail.com" <se...@gmail.com>.
Thanks Hamdi!
2012/4/13 Hamdi THABET <ha...@gmail.com>
> It's done
>
> 1) https://issues.apache.org/jira/browse/OPENMEETINGS-167
>
> 2) https://issues.apache.org/jira/browse/OPENMEETINGS-168
>
>
--
Sebastian Wagner
https://twitter.com/#!/dead_lock
http://www.openmeetings.de
http://www.webbase-design.de
http://www.wagner-sebastian.com
seba.wagner@gmail.com
Réf. : Re: Suggestions !
Posted by Hamdi THABET <ha...@gmail.com>.
It's done
1) https://issues.apache.org/jira/browse/OPENMEETINGS-167
2) https://issues.apache.org/jira/browse/OPENMEETINGS-168
Re: Suggestions !
Posted by "seba.wagner@gmail.com" <se...@gmail.com>.
That is true :)
You might copy your screenshots and open a new issue at:
https://issues.apache.org/jira/browse/OPENMEETINGS
2012/4/13 Hamdi THABET <ha...@gmail.com>
> 1) It will be more practical if the 2nd click on an item from the
> main menu could close it.
>
>
>
> 2) It will be better if we display system date instead of the word "Today"
>
>
>
> *Hamdi THABET
> *Élève ingénieur en Téléinformatique (3e année)
> Maîtrisard en informatique
> Technicien en Réseau informatique et Télécoms
> [+216] 52 72 27 25
> hamdi.thabet86@gmail.com
>
>
--
Sebastian Wagner
https://twitter.com/#!/dead_lock
http://www.openmeetings.de
http://www.webbase-design.de
http://www.wagner-sebastian.com
seba.wagner@gmail.com
Suggestions !
Posted by Hamdi THABET <ha...@gmail.com>.
1) It will be more practical if the 2nd click on an item from the main menu
could close it.
2) It will be better if we display system date instead of the word "Today"
Hamdi THABET
Élève ingénieur en Téléinformatique (3e année)
Maîtrisard en informatique
Technicien en Réseau informatique et Télécoms
[+216] 52 72 27 25
hamdi.thabet86@gmail.com
Re: Réf. : Re: Réf. : Re: Question about "users" table in DB
Posted by Maxim Solodovnik <so...@gmail.com>.
openmeetings.users table already have column deleted
The record is treated as deleted if value in this column is varchar 'true'
On Sat, Apr 14, 2012 at 21:44, Hamdi THABET <ha...@gmail.com>wrote:
> "To flag records as deleted" is a very good idea ! I'm working on it.
>
>
>
--
WBR
Maxim aka solomax
Réf. : Re: Réf. : Re: Question about "users" table in DB
Posted by Hamdi THABET <ha...@gmail.com>.
"To flag records as deleted" is a very good idea ! I'm working on it.
Re: Réf. : Re: Question about "users" table in DB
Posted by "seba.wagner@gmail.com" <se...@gmail.com>.
The userId is also a foreign key in records in other tables that are
created by other users.
To flag records as deleted instead of actual deleting records is a common
way of solving this problem.
There might be situations where it would work to delete the actual record,
but instead of having a solution to say "sometimes we delete it sometimes
we just flag it" my personal opinion is to do it consistent in all tables
the same way.
Otherwise: If there is a majority of developers that would like to change
it and will do the neccessary work => go for it :)
Sebastian
2012/4/14 Hamdi THABET <ha...@gmail.com>
> I'm using Postgresql DB.
> I read the *Wikipedia* article about referential integrity but I still
> can't understand why we are obliged to keep deleted users in the "users"
> table.
> Even in the case of referential integrity we can delete all entries
> related to the deleted "userId" in all tables. Not ?
>
> There's a lot of disadvantages when keeping absolute entries in a such
> important table in DB.
> This is a preliminary administration task and I think that all meetings
> and activities created by a deleted user must be deleted too.
>
--
Sebastian Wagner
https://twitter.com/#!/dead_lock
http://www.openmeetings.de
http://www.webbase-design.de
http://www.wagner-sebastian.com
seba.wagner@gmail.com
Réf. : Re: Question about "users" table in DB
Posted by Hamdi THABET <ha...@gmail.com>.
I'm using Postgresql DB.
I read the Wikipedia article about referential integrity but I still can't
understand why we are obliged to keep deleted users in the "users" table.
Even in the case of referential integrity we can delete all entries related
to the deleted "userId" in all tables. Not ?
There's a lot of disadvantages when keeping absolute entries in a such
important table in DB.
This is a preliminary administration task and I think that all meetings and activities created by a deleted user must be deleted too.
Re: Question about "users" table in DB
Posted by "seba.wagner@gmail.com" <se...@gmail.com>.
The userId is a foreign key in lots of table you cannot just delete that
record.
Except you are using database engine like MySQL MyISAM that has no
referential integrity in fact by deleting you invalidate your complete
database. Databases that allow that are actually considered to be less
secure.
See: http://en.wikipedia.org/wiki/Referential_integrity.
Sebastian
2012/4/14 Hamdi THABET <ha...@gmail.com>
> Why when I delete a user from administration users panel it's only
> deleted from interface but it still exist in DB (users table) ?
>
>
>
>
> *Hamdi THABET
> *Élève ingénieur en Téléinformatique (3e année)
> Maîtrisard en informatique
> Technicien en Réseau informatique et Télécoms
> [+216] 52 72 27 25
> hamdi.thabet86@gmail.com
>
>
--
Sebastian Wagner
https://twitter.com/#!/dead_lock
http://www.openmeetings.de
http://www.webbase-design.de
http://www.wagner-sebastian.com
seba.wagner@gmail.com
Question about "users" table in DB
Posted by Hamdi THABET <ha...@gmail.com>.
Why when I delete a user from administration users panel it's only deleted
from interface but it still exist in DB (users table) ?
Hamdi THABET
Élève ingénieur en Téléinformatique (3e année)
Maîtrisard en informatique
Technicien en Réseau informatique et Télécoms
[+216] 52 72 27 25
hamdi.thabet86@gmail.com
Re: Réf. : Re: Default Timezone ?
Posted by "seba.wagner@gmail.com" <se...@gmail.com>.
I would recommend rather then trying to remove functionality to set some
default pre-selected values. So that the user just has no need to modify
settings. Removing them completely will be difficult.
Sebastian
2012/4/13 Hamdi THABET <ha...@gmail.com>
> There will not be any misconfiguration because some elements will be
> only hidden not deleted from interfaces.
> I want that the inscription procedure become easier and more convenient
> for a company network.
>
> Country setting, language and others are also not necessary in a such
> context.
> So I will try to set them as static values.
>
--
Sebastian Wagner
https://twitter.com/#!/dead_lock
http://www.openmeetings.de
http://www.webbase-design.de
http://www.wagner-sebastian.com
seba.wagner@gmail.com
Re: Réf. : Re: Default Timezone ?
Posted by Hamdi THABET <ha...@gmail.com>.
There will not be any misconfiguration because some elements will be only
hidden not deleted from interfaces.
I want that the inscription procedure become easier and more convenient for
a company network.
Country setting, language and others are also not necessary in a such
context.
So I will try to set them as static values.
Re: Réf. : Re: Default Timezone ?
Posted by "seba.wagner@gmail.com" <se...@gmail.com>.
Well that is actually a misconfiguration that you produce that way.
The correct way is to have a timezone in the user profile.
Why would you want to have the timezone feature deleted?
Sebastian
2012/4/13 Hamdi THABET <ha...@gmail.com>
> Ok Sebastian but you don't understand me well.
> I deleted the timezone preference from all interfaces and I will delete
> all entries from database except the one that I need. Because I need only
> to use OM in intranet context (always the same timezone).
>
--
Sebastian Wagner
https://twitter.com/#!/dead_lock
http://www.openmeetings.de
http://www.webbase-design.de
http://www.wagner-sebastian.com
seba.wagner@gmail.com
Réf. : Re: Default Timezone ?
Posted by Hamdi THABET <ha...@gmail.com>.
Ok Sebastian but you don't understand me well.
I deleted the timezone preference from all interfaces and I will delete all entries from database except the one that I need. Because I need only to use OM in intranet context (always the same timezone).
Re: Default Timezone ?
Posted by "seba.wagner@gmail.com" <se...@gmail.com>.
No Hamdi,
there is no default timezone for all users. Every user has its own timezone.
The timezone in the installation only sets the timezone for the admin user
and the openmeetings default timezone. The openmeetings default timezone is
only used as backup, for example if there are accidently (for whatever
reason) invitation send to participants that have no timezone at all then
there is always at least a default one and the system can process the
invitations.
Sebastian
2012/4/13 Hamdi THABET <ha...@gmail.com>
> Hello everybody,
> Can I set default timezone for all OM users ?
> It's set as the first in the list = GMT+12 (Magadan, Fiji, New Zealand)
>
> Can I set it here in "src/install_step1_EN.vm" ?
> <select name="timeZone" id="timeZone" hidden="true"
> size="0">
> #foreach( $key in $allTimeZones.keySet() )
> <option value="$key">$allTimeZones.get($key)</option>
> #end
> </select>
>
>
>
>
> *Hamdi THABET
> *Élève ingénieur en Téléinformatique (3e année)
> Maîtrisard en informatique
> Technicien en Réseau informatique et Télécoms
> [+216] 52 72 27 25
> hamdi.thabet86@gmail.com
>
>
>
--
Sebastian Wagner
https://twitter.com/#!/dead_lock
http://www.openmeetings.de
http://www.webbase-design.de
http://www.wagner-sebastian.com
seba.wagner@gmail.com