1 Reply Latest reply on Apr 9, 2013 9:55 AM by kjette

    Ticket import

    ttorrisi1982

      Hey all

       

      We are migrating from ServiceDesk to WebHelpDesk and I had a few quick questions about importing tickets.

       

      1.  I was hoping to be able to distinguish imported tickets from tickets created in WHD.  Using the import template, if I give my legacy tickets a negative identity column, will that cause any problems going forward?

      2.  We have multiple fields that we are hoping to be able to shoehorn into the Notes field.  While the ticket import template only appears to allow one row of data per ticket, the actual database table (whd..tech_note) appears to allow multiple rows per ticket.  Would it cause a problem to manually insert our data in there?  It looks like the PK on this table (tech_note_id) just increments up with each note added.  Am I likely to run into key collisions if I insert the rows outside of the program?

       

      Thanks!

       

      Tim

        • Re: Ticket import
          kjette

          I set the first ticket number in WHD a few hundred past my highest number in the old system.  Imported tickets numbers will reflect the lower ticket number and allows me to distinguish the new from the old.