Note: don't forget to work on a test system and to backup the database before any uploads!
regards,
Tomolimo
If you could send me that excel sheet, I'd appreciate it. Do you have a Dropbox, or other public file sharing site?
]]>regards,
Tomolimo
GLPI 0.80.5 / windows 2003
]]>1) Prepare in GLPI the needed master data:
entities
users
groups
and more if you need more (like categories)
2) Prepare in Excel the master data mapping you need:
Ticket priority mapping
Ticket status mapping
Ticket category mapping (if used)
Ticket type mapping
Ticket satisfaction survey mapping
3) Extract master data from glpi tables to Excel (I did that with mySQL ODBC driver, creating a data source to mySQL server)
entities from glpi_entities
users from glpi_users
groups from glpi_groups
4) You need the detailed description of the glpi tables you need to fill in (for this I have an excel file, but I don't know how to send it to the forum):
glpi_tickets
glpi_tickets_users
glpi_ticketfollowups
glpi_ticketsatisfactions
glpi_groups_tickets
and more if needed (like custom fields)
5) Write mapping formulas or macros in Excel in order to map the old values to the one used in GLPI:
tickets
ticket_users
followups
and so on for each tables you need
6) Migration steps:
Export data from you old system
fill in the sheets in Excel with your exported data (and don't forget to use the mapping and the master data values
then when Excel sheets seem ok, save them to unicode text files
use a tool to import the text files into mySQL (I used HeidiSQL: a free tool, very useful: http://www.heidisql.com/)
At each import, check in GLPI that everything is OK
7) Special case: attached documents (if you have some)
I have developed a small script in order to upload documents into tickets.
at your disposal for more info,
regards,
Tomolimo
slinx, are you still interested by this topic?
I have done a complete migration from our old prtracker ticketing system to GLPI, using the same IDs for the tickets (in order to keep the link with the running tickets at migration time).
and I have generalized this procedure in order to migrate tickets from another tool used in another subsidiary of our company.
regards,
Tomolimo
Yes, I would like to know how you did it.
]]>