Best Content of All Time

  • Gibbon installation for one school with 7 locations

    Thank you Admin i am hopeful that @trains5390 might come up with something, while we await @sandra 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
  • Export Custom Field Data

    Hello & welcome to the community :smiley:

    This one can be a bit tricky because the data is serialized, but if you only need to pull out a few fields at a time there is a way:

    SELECT (CASE WHEN (@find := LOCATE('s:3:"001";s', gibbonPerson.fields)) > 0 THEN REPLACE(LEFT( @var := SUBSTRING(gibbonPerson.fields, @find + 15), LOCATE('";', @var)-1), '"', '') ELSE '' END) AS `Your Custom Field` FROM gibbonPerson

    What this will do is extract a single value by locating the start and end of the string (with a couple variables to help). You can add this statement as part of any query on the gibbonPerson table to get custom field values.

    The important part of the above statements is s:3:"001", where the 001 is the ID of the custom field. When you're editing the custom field in Gibbon you can see the ID number in the url bar as gibbonPersonFieldID=001. If you need a different custom field you can replace the 001 with the ID of the field you need. You can repeat this statement if you need to pull out a few different custom fields, just change the ID value for each one (and the `Your Custom Field` part).

    Hope this helps! I think it would certainly be great if Query Builder had a way to pull out this data built-in, it's possibly something we can look into.
  • New email template system?

    Hi Roman, we are pleased you like it! Hopefully there will be many more improvements in v19: under @sandra's wonderful stewardship, Gibbon is going from strength to strength.

    The email templates are stored under /resources/templates/mail

    Let us know how you get on!
  • How to Import Students?

    If you refer to student user data then go to...

    Admin> System Admin> Import From File

    Scroll down to section 'USER ADMIN'. Entry 'User - Data - Basic' should be fine for you.

  • Using the Database on Multiple Computers

    @gpsal Well, our hosting package is as cheap as 20 USD Per Year, setting up Gibbon for you, can do that for free.
  • Logo

    Yes, there is a setting in Admin > System Admin where you can add a path to a new logo: before that, just upload your logo, correctly formatted to your server (400 x 100px is the expected size.)