BW Rox to Drupal database migration

to be moved to http://redmine.bewelcome.org/projects/bw-drupal

See also Set up BW Drupal

Trying to get an idea of what needs to be migrated and how...

mysql bwroxdb -e 'show tables\G'|grep Table|awk '{ print $2 }' was used as a starting point.

For now this is only about the data migration, not about the presentation of the data.

Work in progress

• ewiki => bw_wikipage

Users

• user => Drupal users
• members => Drupal profile
  • addresses
  • cryptedfields

Passwords

• SOLVED D6 user password import to D7 doesn't work
• we need a Rox authentication module that will upgrade passwords to D7 user_hash_password when a user logs in
• imho passwords are secondary. It will be super easy for the users to request a new password once we do the final change - not worth the time Philipp 00:21, 16 September 2011 (UTC)

User Relationships

tables:

• comments (started)
• feedbacks
• feedbackcategories
• verifiedmembers

need to be exportable

todo

• members_roles?

• members_updating_status?
• donations?

To import

Geo

Maybe this can actually be done through a Drupal module + some service, instead of importing.

geo_hierarchy
geo_location
geo_type
geo_usage
geonames_admincodes
geonames_alternate_names
geonames_cache
geonames_cache_backup
geonames_countries
geonames_timezones

yes, do not import

Groups

Nice but not essential:

• groups
• groups_locations
• groupshierarchy
• members_groups_subscribed
• membersgroups
• members_tags_subscribed
• members_threads_subscribed

Kinda done

• faq
• faqcategories

Used for translations

• words

Not needed

• user_friends

Not clear yet

NbMembersByCities  - not needed ~~~~
addresses
blog
blog_categories
blog_categories_seq
blog_comments
blog_comments_seq
blog_data
blog_seq
blog_tags
blog_tags_seq
blog_to_category
blog_to_tag
broadcast
broadcastmessages
cal_event_to_tag - not needed ~~~~
cal_eventdata - not needed ~~~~
cal_events - not needed ~~~~
cal_tags - not needed ~~~~
chat_messages - not needed ~~~~
chat_room_moderators - not needed ~~~~
chat_rooms - not needed ~~~~
chat_rooms_members - not needed ~~~~
cities - not needed ~~~~
comments
comments_ofthemomment_votes
core_session_expiry
core_sessions
counters_cities_nbmembers - not needed ~~~~
counters_regions_nbcities - not needed ~~~~
counters_regions_nbmembers - not needed ~~~~
countries

dbversion
donations

feedbackcategories
feedbacks
flags
flagsmembers
forum_trads
forums_posts
forums_posts_votes
forums_tags
forums_threads
forums_threads_votes
func
gallery
gallery_comments
gallery_comments_seq
gallery_items
gallery_items_seq
gallery_items_to_gallery
gallery_seq

groups
groups_locations
groupshierarchy
groupsmessages
guestsonline
hcvol_config
intermembertranslations
languages
linklist
localvolmessages
localvolmessages_location
logs
meetings

members_groups_subscribed
members_roles
members_tags_subscribed
members_threads_subscribed
members_updating_status
membersgroups
memberslanguageslevel
membersmeetings
membersphotos
memberspreferences
memberspublicprofiles
memberstrads
message
messages
mod_user_apps
mod_user_apps_seq
mod_user_auth
mod_user_auth_seq
mod_user_authgroups
mod_user_authrights
mod_user_groupauth
mod_user_grouprights
mod_user_implications
mod_user_rights
mod_user_rights_seq
mycontacts
notes
old_t_cities_old_BW - not needed ~~~~
old_t_regions - not needed ~~~
oldvisits - not needed ~~~
online - not needed ~~~
params
pendingmandatory
plannedtrips
polls
polls_choices
polls_choices_hierachy
polls_contributions
polls_list_allowed_countries
polls_list_allowed_groups
polls_list_allowed_locations
polls_record_of_choices
posts_notificationqueue
preferences
previousversion
privileges
privilegescopes
proc
profilesvisits
recentvisits
recorded_usernames_of_left_members
regions
reports_to_moderators
rights
rightsvolunteers
roles
roles_privileges
shouts
shouts_seq
specialrelations
sqlforgroupsmembers - not needed ~~~~
sqlforvolunteers - not needed ~~~~
stats
tags_threads
translations
trip
trip_data
trip_seq
trip_to_gallery
urlheader_languages

user_inbox
user_outbox
user_seq
user_settings
v_cities
volunteer_boards
volunteers_reports_schedule
wEnglish

words_use - not needed ~~~~

More generic data structure

• A member is an entity that belongs to the organization: one person, couple, family, peace org, etc),
• A person is a human being who has a login and can have various roles, including belonging to one of the members,
• A site is a physical place where hosting is offered).

Useful info

• http://www.midwesternmac.com/blogs/jeff-geerling/using-migrate-import-content

This page is written in the context of BeWelcome.