On Mon, 26 Aug 2013 16:25:42 -0300 Bruno Galindro da Costa bruno.galindro@gmail.com wrote:
I need to add a roomid that has more than 30 chars.
I've altered the size of rommid column in table room (at database level), but the HTML fields has a 30 chars limitation.
Nav web has built on Django framework which is very nice ;), but I don't know where I can make this modification.
The Django model Room is defined in the Python module nav.models.manage. The max_length attribute is set to 30 there. Modifying data model would require a SQL changescript under the `sql/changes/` directory, and a change to the Room model class.
The Location/Room data models are modeled after the scheme used at NTNU (from which NAV originated). NTNU has multiple campuses and locations, but all wiring closets are identified by a unique 3 digit number (which makes the limit of 30 characters seem immense).
That being said, the 30 character limit is entirely artificial. The database field is of the type VARCHAR, and could be changed to have no limit at all. However, since this string is a primary key, having it be a huge string isn't a good way to normalize the schema.
My sugestion is:
1 - add a field called Location in Edit IP Device screen which filters the Room field. 2 - add Location and Parent Organization information at IP Device Info.
We can help you and your development team to make these modifications (and maybe others). This could be a nice starting.
IIUC, your use case is that you have so many rooms in your database, that the Room dropdown box for editing IP Devices is overpopulated?
John-Magne has suggested something like this component: http://ivaynberg.github.io/select2/ - I.e. a hierarchical (Location/Room), searchable dropdown.
I'm Cc:ing nav-dev, since your getting into development territory with this question.
IIUC, your use case is that you have so many rooms in your database, that the Room dropdown box for editing IP Devices is overpopulated?
Not only that, but if the location could be searcheable too, we can define more flexible room IDs, avoiding increase rommid size at database.
John-Magne has suggested something like this component:
http://ivaynberg.github.io/select2/ - I.e. a hierarchical (Location/Room), searchable dropdown.
Good. If we use this component to filter the room id search by location, my problem will certainly be resolved.
Anyone are working with it now?
2013/9/2 Morten Brekkevold morten.brekkevold@uninett.no
On Mon, 26 Aug 2013 16:25:42 -0300 Bruno Galindro da Costa < bruno.galindro@gmail.com> wrote:
I need to add a roomid that has more than 30 chars.
I've altered the size of rommid column in table room (at database level), but the HTML fields has a 30 chars limitation.
Nav web has built on Django framework which is very nice ;), but I don't know where I can make this modification.
The Django model Room is defined in the Python module nav.models.manage. The max_length attribute is set to 30 there. Modifying data model would require a SQL changescript under the `sql/changes/` directory, and a change to the Room model class.
The Location/Room data models are modeled after the scheme used at NTNU (from which NAV originated). NTNU has multiple campuses and locations, but all wiring closets are identified by a unique 3 digit number (which makes the limit of 30 characters seem immense).
That being said, the 30 character limit is entirely artificial. The database field is of the type VARCHAR, and could be changed to have no limit at all. However, since this string is a primary key, having it be a huge string isn't a good way to normalize the schema.
My sugestion is:
1 - add a field called Location in Edit IP Device screen which filters
the
Room field. 2 - add Location and Parent Organization information at IP Device Info.
We can help you and your development team to make these modifications
(and
maybe others). This could be a nice starting.
IIUC, your use case is that you have so many rooms in your database, that the Room dropdown box for editing IP Devices is overpopulated?
John-Magne has suggested something like this component: http://ivaynberg.github.io/select2/ - I.e. a hierarchical (Location/Room), searchable dropdown.
I'm Cc:ing nav-dev, since your getting into development territory with this question.
-- Morten Brekkevold UNINETT
On Mon, 16 Sep 2013 08:28:30 -0300 Bruno Galindro da Costa bruno.galindro@gmail.com wrote:
John-Magne has suggested something like this component:
http://ivaynberg.github.io/select2/ - I.e. a hierarchical (Location/Room), searchable dropdown.
Good. If we use this component to filter the room id search by location, my problem will certainly be resolved.
Anyone are working with it now?
Not at this very moment, no.
We are working towards a NAV 4.0 release in December, where we hope to include a series of design changes to increase uniformity of the web interface. This feature would fit well in the scope of these changes.
You should file a bug report for this wishlist item, then I will assign it to one of the guys working on the interface redesign.
Done: https://bugs.launchpad.net/nav/+bug/1234410
Tks!
2013/9/17 Morten Brekkevold morten.brekkevold@uninett.no
On Mon, 16 Sep 2013 08:28:30 -0300 Bruno Galindro da Costa < bruno.galindro@gmail.com> wrote:
John-Magne has suggested something like this component:
http://ivaynberg.github.io/select2/ - I.e. a hierarchical (Location/Room), searchable dropdown.
Good. If we use this component to filter the room id search by location,
my
problem will certainly be resolved.
Anyone are working with it now?
Not at this very moment, no.
We are working towards a NAV 4.0 release in December, where we hope to include a series of design changes to increase uniformity of the web interface. This feature would fit well in the scope of these changes.
You should file a bug report for this wishlist item, then I will assign it to one of the guys working on the interface redesign.
-- Morten Brekkevold UNINETT
-
Bruno Galindro da Costa -
Morten Brekkevold