- Edited
First of all, let me start by saying, I know what I am doing is not standard.
OST 1.10.4 and 1.11.x
I have a host of organizations I need to import form an old system. OsTicket does not have an import feature for these, so I have resorted to inserting these via a SQL script directly. Does anyone know which tables I should be inserting into for Organization data? By experimentation, I have figured out the following ones:
ost_organization
ost_organization_cdata
ost_form_entry
ost_form_entry_values
ost__search
Are there others?
What's the deal with CDATA tables? I read on another post these are automatically dropped and recreated when need be. When/how does this happen? Should I leave the CDATA tables alone?
Should I be inserting anything into ost__search, or does this also auto-populate?
I appreciate any insight into this, thank you in advance.