Hello, I already checked that there is no basic import or migrate-from-other-system feature in OSTicket. I run OSTicket 1.14 and want to import tickets from another system (custom made) . There are just email based tickets with answers and attachment stored in database. I found this 7 year old solution for importing data from eTicket to OSTicket from forum members mfeldmann and cenceros: https://forum.osticket.com/assets/files/migrated/FileUpload/c5/38267b27760e21034058f3549482c7.txt
It might be a good start point and I wouldn't be too afraid of necessary mods, but just wanted to hear if somebody did something similar for a later version.....
the process of the original script is:
- translation of correct values for ost_staff (agents) and ost_help_topic
- check / insert / update sender emails / ost_user and ost_user_email
- translate ticket status
- check if ticket number doesn't exist yet (if so will need some changes))
- insert in ost_ticket
- insert in ost_ticket__cdata
- insert in ost_form_entry
- insert in ost_form_entry_values
- close ticket / set last answer
However instead of setting fixed value of 5 for ost_form_entry_values.field_id it looks like there should be one for each of field_id=20 (issue Summary) and field_id=22 (priority Level)
Does anybody can tell me if those two entries would be neccessary?
... extremely thankful for any help