Estoy trabajando con tickets incrementales desde el 000001, pero me gustaria llevar mi registro por año, por lo que me gustaría reiniciar el contador al finalizar el año en 000001 nuevamente y respaldar los tickets anteriores y borrarlos de la tabla o si se puede reiniciar y generar consultas por fecha?

no encuentro solucion, podrian ayudarme?

  • KevinTheJedi replied to this.

  • jgarciaepncorinto

    First things first you would definitely need to create a new Ticket Number Sequence so it can be Incremental instead of Random. Then you would set this Sequence as your Default Ticket Number Sequence under Admin Panel > Settings > Tickets.

    Now, once the year is over and you want to export the Tickets you can do so via the Export feature at the bottom of any Ticket Queue and/or Advanced Search. Additionally, to get the full thread, metadata, attachments, etc. you can Print each ticket to PDF; this has to be done for each Ticket individually however. Otherwise you would need to do a database dump.

    Lastly, once the old Tickets are deleted and you want to reset the numbers you can go to Admin Panel > Settings > Tickets, update the current Sequence, set the Next field to 1, and Save Changes. Once you update the Next setting to 1 for the Sequence the Ticket Numbers will start at 1 again.

    Cheers.

      jgarciaepncorinto

      First things first you would definitely need to create a new Ticket Number Sequence so it can be Incremental instead of Random. Then you would set this Sequence as your Default Ticket Number Sequence under Admin Panel > Settings > Tickets.

      Now, once the year is over and you want to export the Tickets you can do so via the Export feature at the bottom of any Ticket Queue and/or Advanced Search. Additionally, to get the full thread, metadata, attachments, etc. you can Print each ticket to PDF; this has to be done for each Ticket individually however. Otherwise you would need to do a database dump.

      Lastly, once the old Tickets are deleted and you want to reset the numbers you can go to Admin Panel > Settings > Tickets, update the current Sequence, set the Next field to 1, and Save Changes. Once you update the Next setting to 1 for the Sequence the Ticket Numbers will start at 1 again.

      Cheers.

        mis tickets están en secuencia y empiezan en 000001,000002,000003,etc.. y van aumentando progresivamente, en lo que necesito ayuda es como puedo volver la cuenta a 000001 una vez que termine el año?

        no se si hay forma de borrar los tickets dado que hay varias tablas referenciadas y me preocupa la integridad de los datos y que si se va a borrar se borre todo lo relacionado a esos tickets y empezar de nuevo el contador.

        no quiero dejar residuales de lo datos, o hay forma de mantenerlos pero con una fecha diferente?

          jgarciaepncorinto

          I have explained above how to reset the Ticket Number counter. You need to create a sequence and then update the sequence to reset the Next counter when the new year starts.

          As far as deleting Tickets you can do so in batches via the UI. This is the best/safest way as it will delete all associated data for you.

          Cheers.

            muchas gracias me sirvió mucho tu comentario, aunque al eliminarlos todos me aparecerán en el dashboard como eliminados, como puedo reiniciar la gráfica del dashboard? o necesito abrir otro hilo con ese tema,

            porque efectivamente si lo elimino desde la interfaz gráfica se elimina todo lo asociado pero aún queda el histórico del dashboard y me aparecerán todos como eliminados

              Write a Reply...