Problems with copy a table of the program zentrack to sugarcrm

[MIConsultancy]

hello,

i want to copy all my bugs which i made in the program Zentrack to sugarcrm is this possible?
Zentrack is a program with a mysql database but i don't know how to copy the table.
Can anyone help me?

Thanks in advance

[pblag]

Hi!

You need custom code for doing this. We can develop it for you if you want.
If you are interested please email to me.

[roblaus]

Hi,

Simply copying a table won't do it I am afraid. I assume that you want to copy your bugs once and not having them synchronized periodically. In the case of the latter it requires a bit more.

For a one time copy:

Backup both systems
Get the structure (fields) of Sugar's bug table
Get the structure of Zentrack's bug table
Match the fields, check where conversions of field types may be necessary
Export your Zentrack table to a csv file (or any other that you are familiar with although Excel might not be a good choice)
Modify your data where required
Sort the columns properly
Import through phpmyadmin (NOT into your production system!!)

There are plenty of tools out there but I deliberately suggested the ones you may have available.

I'd be doing the same with Access and the MYSQL Migration Toolkit but it's a matter of taste.

rgds
rl

[Angel]

Just a minor addition..

Each row will need a unique ID value before you can import it into the Bugs table in Sugar. You can assign values 1 -> infinity if you want, doesn't matter -- as long as they are unique, then import. For that matter, you can use the ID value used within Zentrack, as long as it is unique for each row.

That will allow the import to complete and then you can go back an easily update those values with a simple PHP script that generates IDs that conform to the Sugar standard.

Also, if you are on Windows, you might find SQLYog useful for your task, as it has the ability to easily copy tables from different MySQL databases. Further info here: www.webyog.com