I have manually added data rows to the ost_organization & ost_organization__cdata tables using a MySQL procedure. (In this post every time I write "manually" I mean by accessing the db directly using SQL).
When I call up the Organizations list my manually added ones are all there but when I open one of these with the Organization Information form no info from the ost_organization__cdata table is loaded, i.e. all the fields are blank.
On top of this, if I then select any field and close the form (note: with the Cancel button, I'm not even using the Update Organization button) it clears the manually entered data in the cdata table. If I then re-add the data manually this no longer happens, yet still the re-added data doesn't show up in the form.
When I compare data rows in the ost_organization__cdata table there is no discernable difference between data added one way or the other. Fields updated manually vs. using the form appear to contain identical types of data. It's almost as if osTicket doesn't know the cdata exists until it puts it there itself, but I can't figure out how it could be tracking this or how to circumvent it. Does anyone have a clue why this is happening?

Note: I am using v1.11.0-rc1 and I have customized the Organization Information form using "Custom Forms" from the "Manage" menu.

Sounds to me like you didn't make the form entry in the database correctly. You made the Orgs in the org tables, but you do not mention making it in the forms tables also.

@Robert_S

Yea, you can't really just add data to those two tables and expect it to work correctly; it's way more complex than that. The CDATA table pulls data from the OrganizationForm not the ost_organization table (that's why you're manually added data isn't being re-added once the table is dropped and re-created; yes, CDATA tables are always dropped and re-created). The OrganizationForm and it's data is housed in the ost_form, ost_from_entry, ost_form_entry_values, and ost_form_field tables. The OrganizationForm is also where the data on the page is loaded from, not the CDATA table (that's why all the fields were blank). The CDATA tables are mainly used for search indexing.

I hope that clears some things up for ya'! Cheers.

    KevinTheJedi
    Thanks. I totally did not realize I had to do that.
    I'd read somewhere before that the CDATA tables get recreated but I wasn't believing it, having not seen any evidence of it until now. Seems like a complicated way of doing it. It certainly makes what I'm trying to do more complicated. I could understand if it was used to avoid duplication of data in the form entry values table, but that's not happening.
    It will take a bit to re-write my SQL procedure. It's almost faster to enter everything manually. It would be nice if there was a way to bulk import organizations from csv.

      4 days later

      Very welcome. I'll close this thread, but feel free to start a new one if you have another question, comment, etc.

      Write a Reply...