|
|
| (2 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| :''See also [[Set up BW Drupal]]''
| | #redirect [[BeWelcome]] |
| Trying to get an idea of what needs to be migrated and how...
| |
| | |
| <tt>mysql bwroxdb -e 'show tables\G'|grep Table|awk '{ print $2 }'</tt> 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 ====
| |
| * <strike>[http://drupal.org/node/1175562 SOLVED D6 user password import to D7]</strike> 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 [[User:Philipp|Philipp]] 00:21, 16 September 2011 (UTC)
| |
| | |
| ==== User Relationships ====
| |
| tables:
| |
| * comments (started)
| |
| * feedbacks
| |
| * feedbackcategories
| |
| * verifiedmembers
| |
| | |
| need [http://drupal.org/node/691034 to be exportable]
| |
| | |
| ====todo====
| |
| * <strike>members_roles</strike>?
| |
| | |
| * members_updating_status?
| |
| * donations?
| |
| | |
| == To import ==
| |
| | |
| === Geo ===
| |
| Maybe this can actually be done through a Drupal module + some service, instead of importing.
| |
| <pre>
| |
| geo_hierarchy
| |
| geo_location
| |
| geo_type
| |
| geo_usage
| |
| geonames_admincodes
| |
| geonames_alternate_names
| |
| geonames_cache
| |
| geonames_cache_backup
| |
| geonames_countries
| |
| geonames_timezones
| |
| </pre>
| |
| | |
| yes, do not import
| |
| | |
| === Groups ===
| |
| Nice but not essential:
| |
| * groups
| |
| * groups_locations
| |
| * groupshierarchy
| |
| * members_groups_subscribed
| |
| * membersgroups
| |
| * members_tags_subscribed
| |
| * members_threads_subscribed
| |
| | |
| | |
| === Possibly optional? ===
| |
| | |
| | |
| | |
| == Kinda done ==
| |
| * faq
| |
| * faqcategories
| |
| | |
| | |
| == Used for translations ==
| |
| * words
| |
| | |
| == Not needed ==
| |
| * <strike>user_friends</strike>
| |
| | |
| | |
| == Not clear yet ==
| |
| <pre>
| |
| 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 ~~~~
| |
| </pre>
| |
| | |
| ==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
| |
| | |
| | |
| [[Category:BW Drupal]]
| |
| {{bw}}
| |