I'm building a custom importer to bring in 10,000 old tickets into OSTicket from an old system.
Reaching the ost_thread_entry table, I need more info on the purpose of the "pid" and 'flags' column what are these used for?

I would recommend that you create a single ticket in the osTicket system. Then add a reply. You should then be able to look at the all the tab les and see how and what changes where.

    ntozier i have been trying this, but there are still a few bits i'm searching for answers with

      if anyone has a full rundown of the table, i'd be most greatful

      Sorry I am on the highway heading to vacation and do not have remote access yo my database right now. If I remember once I am back from vacation *the 5th is when i get home) I can post more about it.

      23 days later

      I have figured these out,

      for reference
      pid = parent id, it appears to be used when merging topics i think, but in most cases is safely set as 0
      flags, this defines different aspects, but largely i used

      M - Message - User = 64
      R - Reply - agent = 576

      first post in a topic +1 to these values

      this seems to have worked

      Write a Reply...