# Gibbon installation for one school with 7 locations **URL:** \ **Category:** Administration\ **Created:** [July 2, 2017, 6:05pm UTC](https://ask.gibbonedu.org/t/gibbon-installation-for-one-school-with-7-locations/1441 "2017-07-02T18:05:36Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![EduDot](https://ask.gibbonedu.org/letter_avatar_proxy/v4/letter/e/90db22/32.png) [@EduDot](https://ask.gibbonedu.org/u/EduDot)\ **Post date:** [July 2, 2017, 6:05pm UTC](https://ask.gibbonedu.org/t/gibbon-installation-for-one-school-with-7-locations/1441/1 "2017-07-02T18:05:36Z")
Hello. can gibbon be deployed for a school with 7 locations.A centralised DB is the aim,but being able to differentiate BTW these locations. A clear view is this: to have the centralized DB, but users in each location can only login to see details of their particular location. ---
**Author:** ![trains5390](https://ask.gibbonedu.org/letter_avatar_proxy/v4/letter/t/9de0a6/32.png) [@trains5390](https://ask.gibbonedu.org/u/trains5390)\ **Post date:** [July 2, 2017, 9:52pm UTC](https://ask.gibbonedu.org/t/gibbon-installation-for-one-school-with-7-locations/1441/2 "2017-07-02T21:52:56Z")
Hello, EduDot. Welcome to the community. Regarding your situation, it would be helpful to know why you want a centralised database and whether students remain at the same location all the time? Thanks ---
**Author:** ![EduDot](https://ask.gibbonedu.org/letter_avatar_proxy/v4/letter/e/90db22/32.png) [@EduDot](https://ask.gibbonedu.org/u/EduDot)\ **Post date:** [July 3, 2017, 4:52am UTC](https://ask.gibbonedu.org/t/gibbon-installation-for-one-school-with-7-locations/1441/3 "2017-07-03T04:52:09Z")
Thanks trains5390, Easy access and having Global view across all school locations remains key reasons. Others include having at a glance Global statistics, being able to use same resources across all school locations. And yes, students remains at their respective locations. There are no Interchange at anytime. Teachers too are permanent in these various locations, except maybe on transfer, which isn’t too much an issue and it doesn’t happen all the time. ---
**Author:** ![trains5390](https://ask.gibbonedu.org/letter_avatar_proxy/v4/letter/t/9de0a6/32.png) [@trains5390](https://ask.gibbonedu.org/u/trains5390)\ **Post date:** [July 3, 2017, 8:45am UTC](https://ask.gibbonedu.org/t/gibbon-installation-for-one-school-with-7-locations/1441/4 "2017-07-03T08:45:36Z")
Okay, I’m going to take a look at my install and see if I could do it. It may be possible but tricky by putting a designated letter before each class number to signify location. ---
**Author:** ![ross](https://ask.gibbonedu.org/user_avatar/ask.gibbonedu.org/ross/32/8_2.png) [@ross](https://ask.gibbonedu.org/u/ross)\ **Post date:** [July 3, 2017, 12:06pm UTC](https://ask.gibbonedu.org/t/gibbon-installation-for-one-school-with-7-locations/1441/5 "2017-07-03T12:06:23Z")
Hey EduDot. Sadly this is not currently possible. I wish we could add a multi-school feature to run multiple schools off one code base and database (like WordPress does for websites), but we don’t have the resources at the moment. I do believe, however, that @ross was talking about adding the ability to have database table prefixes into v15, which would allow you to run multiple installs from one database. I wonder if Sandra might let us know if this is still on the drawing board. Thanks, Ross ---
**Author:** ![sandra](https://ask.gibbonedu.org/user_avatar/ask.gibbonedu.org/sandra/32/5_2.png) [@sandra](https://ask.gibbonedu.org/u/sandra)\ **Post date:** [July 3, 2017, 6:03pm UTC](https://ask.gibbonedu.org/t/gibbon-installation-for-one-school-with-7-locations/1441/6 "2017-07-03T18:03:43Z")
Good question. I do remember thinking about table prefixes, must have mentioned it at some point but I cannot recall when 😃 It’s a change that would require editing every SQL query in Gibbon, so it’s likely possible after more of the architectural changes have been made to the core. Adding prefixes would help with multiple installs as well as potentially adds some security against sql injection/attacks, I think it’s something worth considering for the long-term roadmap (perhaps not as soon as v15 though). ---
**Author:** ![EduDot](https://ask.gibbonedu.org/letter_avatar_proxy/v4/letter/e/90db22/32.png) [@EduDot](https://ask.gibbonedu.org/u/EduDot)\ **Post date:** [July 3, 2017, 6:07pm UTC](https://ask.gibbonedu.org/t/gibbon-installation-for-one-school-with-7-locations/1441/7 "2017-07-03T18:07:31Z")
Thank you Admin i am hopeful that @trains5390 might come up with something, while we await @ross for her response. i am really keen on making a solution for this, It would really help. thank you everyone. GIBBON is a life saver ---
**Author:** ![trains5390](https://ask.gibbonedu.org/letter_avatar_proxy/v4/letter/t/9de0a6/32.png) [@trains5390](https://ask.gibbonedu.org/u/trains5390)\ **Post date:** [July 3, 2017, 6:33pm UTC](https://ask.gibbonedu.org/t/gibbon-installation-for-one-school-with-7-locations/1441/8 "2017-07-03T18:33:29Z")
I wouldn’t be too hopeful. Ross, is there any way he could add a prefix to each class and a custom field to each student, or do this by different houses/roll group? ---
**Author:** ![ross](https://ask.gibbonedu.org/user_avatar/ask.gibbonedu.org/ross/32/8_2.png) [@ross](https://ask.gibbonedu.org/u/ross)\ **Post date:** [July 4, 2017, 12:57am UTC](https://ask.gibbonedu.org/t/gibbon-installation-for-one-school-with-7-locations/1441/9 "2017-07-04T00:57:45Z")
@ross seems like I got a bit ahead of myself there! Looks like extending PDO might be the easiest way to do this, perhaps, as you say, as part of a larger DB abstraction layer: [https://gist.github.com/gfabrizi/7282782](https://gist.github.com/gfabrizi/7282782) Jack, I’d not recommend any undertake this unless they are familiar with the system, have coding experience, and are willing to contribute changes back to avoid getting cut off from the Gibbon core. Ross ---
**Author:** ![trains5390](https://ask.gibbonedu.org/letter_avatar_proxy/v4/letter/t/9de0a6/32.png) [@trains5390](https://ask.gibbonedu.org/u/trains5390)\ **Post date:** [July 4, 2017, 8:07am UTC](https://ask.gibbonedu.org/t/gibbon-installation-for-one-school-with-7-locations/1441/10 "2017-07-04T08:07:25Z")
Okay. Sorry @EduDot but Ross us correct. He knows the system way more than me. I was just thinking far out. Good luck in finding a solution! ---
**Author:** ![EduDot](https://ask.gibbonedu.org/letter_avatar_proxy/v4/letter/e/90db22/32.png) [@EduDot](https://ask.gibbonedu.org/u/EduDot)\ **Post date:** [July 4, 2017, 8:31am UTC](https://ask.gibbonedu.org/t/gibbon-installation-for-one-school-with-7-locations/1441/11 "2017-07-04T08:31:44Z")
:‘( :’( :‘( :’( 😢 Still need a solution. Any recommendation ? or does it mean that we would have to install 7 installations of Gibbon? But how can we merge the Database of all school locations? I guess with this we might be finding alternatives to this solution thanks Ross, Jack , Sandra… ---
**Author:** ![trains5390](https://ask.gibbonedu.org/letter_avatar_proxy/v4/letter/t/9de0a6/32.png) [@trains5390](https://ask.gibbonedu.org/u/trains5390)\ **Post date:** [July 4, 2017, 10:31am UTC](https://ask.gibbonedu.org/t/gibbon-installation-for-one-school-with-7-locations/1441/12 "2017-07-04T10:31:16Z")
If you install 7 installations across the web for each school, you can login to each. It would be a hassle but surely, when managing each, you would rather they were separate? @EduDot ---
**Author:** ![ross](https://ask.gibbonedu.org/user_avatar/ask.gibbonedu.org/ross/32/8_2.png) [@ross](https://ask.gibbonedu.org/u/ross)\ **Post date:** [July 4, 2017, 12:22pm UTC](https://ask.gibbonedu.org/t/gibbon-installation-for-one-school-with-7-locations/1441/13 "2017-07-04T12:22:45Z")
EduDot, at the moment you would need to install 7 separate Gibbons, but they could be on the same server. You could then use SQL on that single server to query all seven databases to find out the information you want: not ideal, but should be doable. If you do end up finding a better solution, I’d love to know what it is so that we can learn from it. Sorry we can’t do more to address this issue right now. Ross. ---
**Author:** ![EduDot](https://ask.gibbonedu.org/letter_avatar_proxy/v4/letter/e/90db22/32.png) [@EduDot](https://ask.gibbonedu.org/u/EduDot)\ **Post date:** [July 4, 2017, 5:15pm UTC](https://ask.gibbonedu.org/t/gibbon-installation-for-one-school-with-7-locations/1441/14 "2017-07-04T17:15:41Z")
thanks everyone, we would keep working on it. i believe we are getting there. this has expanded our scope and the need for future upgrade. well done everyone. ---
**Author:** ![EduDot](https://ask.gibbonedu.org/letter_avatar_proxy/v4/letter/e/90db22/32.png) [@EduDot](https://ask.gibbonedu.org/u/EduDot)\ **Post date:** [July 5, 2017, 5:46am UTC](https://ask.gibbonedu.org/t/gibbon-installation-for-one-school-with-7-locations/1441/15 "2017-07-05T05:46:52Z")
Hello Everyone, I’m here once again. Still on the path to finding solution. The thought came during the night. I had love to ask that, presently in Gibbon is there any level of abstraction that allows for a user with some roles to login to the portal only to see a selected view of say, department or year group or year houses. This is my point, if it’s possible to create or have such a login view, then the “Year Houses”, for example, might serve as the locations for this school. We want the staff in each location to have only a view that partains to that location and then the admin would have all views. I hope this explanation is possible and it’s clear enough. Thanks ---
**Author:** ![trains5390](https://ask.gibbonedu.org/letter_avatar_proxy/v4/letter/t/9de0a6/32.png) [@trains5390](https://ask.gibbonedu.org/u/trains5390)\ **Post date:** [July 5, 2017, 8:57am UTC](https://ask.gibbonedu.org/t/gibbon-installation-for-one-school-with-7-locations/1441/16 "2017-07-05T08:57:49Z")
@EduDot, with regards to possibility, only Sandra or Ross will know. However, in my suggestions comment, this was the exact idea when I said houses. Hopefully your explanation will help. ---
**Author:** ![ross](https://ask.gibbonedu.org/user_avatar/ask.gibbonedu.org/ross/32/8_2.png) [@ross](https://ask.gibbonedu.org/u/ross)\ **Post date:** [July 5, 2017, 1:13pm UTC](https://ask.gibbonedu.org/t/gibbon-installation-for-one-school-with-7-locations/1441/17 "2017-07-05T13:13:42Z")
EduDot, I don’t believe this will allow you to simulate different schools within one Gibbon install, as houses are a fairly minor feature in Gibbon. Ross. ---
**Author:** ![jmsperu](https://ask.gibbonedu.org/letter_avatar_proxy/v4/letter/j/db5fbb/32.png) [@jmsperu](https://ask.gibbonedu.org/u/jmsperu)\ **Post date:** [July 6, 2017, 4:39am UTC](https://ask.gibbonedu.org/t/gibbon-installation-for-one-school-with-7-locations/1441/18 "2017-07-06T04:39:03Z")
@trains5390 That’s a good possible feature you pointed out. I would however recommend that you don’t store all the data on the same database, and then, why do you want to keep the data of all the schools on the same centralized location? For easy access by management or students? or for easy integration? ---
**Author:** ![jmsperu](https://ask.gibbonedu.org/letter_avatar_proxy/v4/letter/j/db5fbb/32.png) [@jmsperu](https://ask.gibbonedu.org/u/jmsperu)\ **Post date:** [July 6, 2017, 8:46am UTC](https://ask.gibbonedu.org/t/gibbon-installation-for-one-school-with-7-locations/1441/19 "2017-07-06T08:46:18Z")
@trains5390 Would you agree with a custom solution for that specif Request. ---
**Author:** ![EduDot](https://ask.gibbonedu.org/letter_avatar_proxy/v4/letter/e/90db22/32.png) [@EduDot](https://ask.gibbonedu.org/u/EduDot)\ **Post date:** [July 6, 2017, 8:15am UTC](https://ask.gibbonedu.org/t/gibbon-installation-for-one-school-with-7-locations/1441/20 "2017-07-06T08:15:33Z")
Thanks @jmsperu Keeping the database centralized would ensure that all info can be reached at once and at a glance. It is for easy access by management. [Next page](https://ask.gibbonedu.org/t/gibbon-installation-for-one-school-with-7-locations/1441.md?page=2)