Import tickets from Kayako

[soos]

Hi,

I'm looking for a way to import tickets, we're moving from Kayako to OTRS and we need to have some searchable history, the quality of the history isn't that important i.e. it's OK if attachments are missing or if notes are missing, but customer correspondence should be searchable.

Hope someone here has tried something similar?

[jojo]

send the ticket as email to otrs or build a tool in kayako to create tickets via webservice in OTRS

[soos]

OK, is there a way I can change the date on the articles created?

[jojo]

no

[soos]

Not even in the database?

[RStraub]

Well the MySQL table saves these attributes:
id tn title queue_id ticket_lock_id type_id service_id sla_id user_id responsible_user_id ticket_priority_id ticket_state_id customer_id customer_user_id timeout until_time escalation_time escalation_update_time escalation_response_time escalation_solution_time valid_id archive_flag create_time_unix create_time create_by change_time change_by


I'm pretty sure you can update the create_time_unix and create_time...

[jojo]

data is stored in several tables, so you really should not change anything manually!