Hello
I havr updated some of the ticket custom fields from directly backend
it is reflected in osticket UI screen
but while exporting data it is not reflected updated data in excel
is any other table needs to update for excel?
binaldave028
Yes, you are never supposed to manually update things from the database. You now need to drop the _ticket__cdata table and run cron a bunch of times until the table is recreated and fully repopulated with data. We repopulate in batches so you will need to run cron multiple times until it’s fully complete.
Cheers.
which cron i need to run? can you please guide me?
The /path/to/osticket/api/cron.php file. You simply run that with your PHP command on the command line of the server. For example, if your PHP command is simply php and the path to osTicket is /var/www/html/ then the command to run would be php /var/www/html/api/cron.php.
/path/to/osticket/api/cron.php
php
/var/www/html/
php /var/www/html/api/cron.php
After dropping the cdata table in my local environment, I didn't run any cron jobs, yet the table was automatically recreated, and the export data worked properly. I just refresh the my ticket details page
