osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now
importing table data from existing organizations table to ost_organization
I can insert organizations into the database and they appear on osticket so I'm happy I don't have to manually add organizations. My question is:
In the db, the organization table has 8 fields (id, name, manager, status, domain, extra, created(date), updated(date)). BUT when going to edit an organization there are many more fields like: address, phone, city, website, administrative contact person, account manager, etc. I have all this info but I'm curious if it's possible to add them by inserting into DB as well. In other words, where is all this extra form info about the organization stored.
I found the field names and their descriptions, hints, etc in the table ost_form_field but not the actual data. Is there a reason for some of the organization data being stored in ost_organization and the rest of it being stored in other tables.
I'm just exploring here :)