Hi All,I wrote a php page that parses the text of a ticket logged by the users (using a template via email), and extracts some information, for example a custom field that represents their reference number (the ticket number on their ticketing system).I am able to update the code in the ticket__cdata table successfully; in fact, I could search for it in the web interface and find the ticket using their reference number. I am able to do the same with their phone number (which is added to the user__cdata table).However, the custom field is not shown in the web interface, as well as the phone number. The latter field is filled in the DB, but empty in the web interface; while the first one is only displayed if the user logs the ticket using the web interface instead of an email.Does anyone know how to force a "sync/refresh" of the data? I could do it every night in case it is possible...Let me know if you need more info.Thank you in advance

So the ticket__cdata table is a temporary table and is dropped routine and regenerated.  Making changes to that table is a little like editing a copy.

Thank you as usual for your replies ntozier. Do you know where the phone number is permanently stored for an user account?And a custom field for a ticket?I went through the tables but I could not find them.

My guess would be the ost_form_entry_values table.

Thank you ntozier, I noticed that also the other ost_form tables could be related to it, and I working on a solution. I have also followed some guidelines from http://tmib.net/how-manually-update-clientuser-phone-number-osticket-181x

Oh hey... I wrote that.  

Write a Reply...