Topic: Twiggi to Twig

[dilligaf]

I have a test environment where I have an existing populated Twiggi database (that has contacts, and notes, schedule itmems I want to export).
I also have the latest Twig on another machine.
I have experimented using DBTools to export import the tables and data with no errors, yet the data does not show in twig.
Has anyone else exported from Twiggi to Twig with success and do you have a step by step?
Thanks,

[blockbuster]

I have installed both Twig and Twiggi on one machine, I am not really using it but I like to play with it. For me Horde is just fine at the moment.

I was looking to the both database structures and saw that twiggi has 43 tables and twig only 32? Doesn't this give you any more problems?

See below table structure:

twiggi ; twig
twig_access ; twig_accounts
twig_accounts ; twig_announce
twig_announce ; twig_acl_groups
twig_bookmarks ; twig_acls
twig_bookmarks_prefs ; twig_bookmarks
twig_contacts ; twig_bookmarks_prefs
twig_contacts_lists_entries ; twig_contacts
twig_contacts_prefs ; twig_contacts_lists_entries
twig_context ; twig_contacts_prefs
twig_file_pathes ; twig_context
twig_files ; twig_folders
twig_files_prefs ; twig_global_prefs
twig_folders ; twig_groups
twig_global_prefs ; twig_lhsqltable
twig_groups ; twig_mail_prefs
twig_groups_prefs ; twig_main_prefs
twig_holiday_dates ; twig_meetings
twig_holiday_names ; twig_meetings_invitations
twig_holiday_selection ; twig_meetings_prefs
twig_lhsqltable ; twig_meetings_registration
twig_mail_prefs ; twig_members
twig_mail_tree ; twig_news_prefs
twig_maildrafts ; twig_notes
twig_main_prefs ; twig_notes_prefs
twig_members ; twig_schedule
twig_notes ; twig_schedule_prefs
twig_notes_prefs ; twig_schedule_recurring
twig_resource_booking ; twig_sclhsqltable
twig_resource_mgr ; twig_session
twig_resource_prefs ; twig_todo
twig_resource_users ; twig_todo_lists_entries
twig_resources ; twig_todo_prefs
twig_schedule ;
twig_schedule_prefs ;
twig_schedule_recurring ;
twig_sclhsqltable ;
twig_session ;
twig_threadcache ;
twig_todo ;
twig_todo_lists_entries ;
twig_todo_prefs ;
twig_ums ;
twiggi ;

[dilligaf]

blockbuster,
I agree and understand, but if all you want is "contacts" as example, or "notes" etc, those tables are the same, so you should be able to export the data from the one table, and import to the other?
dilligaf

[blockbuster]

dilligaf,

I had a quick look at the tables via phpmyadmin
twiggi twig_contacts and twig twig_contacts

and saw the tabel structure is different from eachother so a standard export / import wouldn't do the job.

not only different names are used within the table also the type structure is different.

I think you have to take a look at mysql front
http://www.mysqlfront.de/

This programme gives you a windows client in wich you can copy paste and edit your databases. This works a lot better if you are not that good like me in SQL but sometimes want to have a difficult job done the easy windows way. Only disadvantage of the software is: not opensource.

But the good thing is:
This software can be tested 30 days for free without any limitations.

So this should enable you to get the job done.

[dilligaf]

Blockbuster,
Yes, but the notes and groups are identical in both.
I exported and imported those, and can not see the entries.
With DBTools, or (MySQL Front, or even PHPMyadmin) see the table is populated, it just does not show in twig.