<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en">
	<id>https://wiki.trustroots.org/api.php?action=feedcontributions&amp;feedformat=atom&amp;user=Philipp</id>
	<title>Trustroots Wiki - User contributions [en]</title>
	<link rel="self" type="application/atom+xml" href="https://wiki.trustroots.org/api.php?action=feedcontributions&amp;feedformat=atom&amp;user=Philipp"/>
	<link rel="alternate" type="text/html" href="https://wiki.trustroots.org/wiki/Special:Contributions/Philipp"/>
	<updated>2026-05-08T10:45:44Z</updated>
	<subtitle>User contributions</subtitle>
	<generator>MediaWiki 1.45.1</generator>
	<entry>
		<id>https://wiki.trustroots.org/index.php?title=BW_Rox_to_Drupal_database_migration&amp;diff=3610</id>
		<title>BW Rox to Drupal database migration</title>
		<link rel="alternate" type="text/html" href="https://wiki.trustroots.org/index.php?title=BW_Rox_to_Drupal_database_migration&amp;diff=3610"/>
		<updated>2011-09-16T00:27:12Z</updated>

		<summary type="html">&lt;p&gt;Philipp: /* Not clear yet */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;:&#039;&#039;See also [[Set up BW Drupal]]&#039;&#039;&lt;br /&gt;
Trying to get an idea of what needs to be migrated and how...&lt;br /&gt;
&lt;br /&gt;
&amp;lt;tt&amp;gt;mysql bwroxdb -e &#039;show tables\G&#039;|grep Table|awk &#039;{ print $2 }&#039;&amp;lt;/tt&amp;gt; was used as a starting point.&lt;br /&gt;
&lt;br /&gt;
For now this is only about the data migration, not about the presentation of the data.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
==Work in progress==&lt;br /&gt;
* ewiki =&amp;gt; bw_wikipage&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
===Users===&lt;br /&gt;
* user =&amp;gt; Drupal users&lt;br /&gt;
* members =&amp;gt; Drupal profile&lt;br /&gt;
** addresses&lt;br /&gt;
** cryptedfields&lt;br /&gt;
==== Passwords ====&lt;br /&gt;
* &amp;lt;strike&amp;gt;[http://drupal.org/node/1175562 SOLVED D6 user password import to D7]&amp;lt;/strike&amp;gt; doesn&#039;t work&lt;br /&gt;
* we need a Rox authentication module that will upgrade passwords to D7 user_hash_password when a user logs in&lt;br /&gt;
* 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)&lt;br /&gt;
&lt;br /&gt;
==== User Relationships ====&lt;br /&gt;
tables:&lt;br /&gt;
* comments (started)&lt;br /&gt;
* feedbacks&lt;br /&gt;
* feedbackcategories&lt;br /&gt;
* verifiedmembers&lt;br /&gt;
&lt;br /&gt;
need [http://drupal.org/node/691034 to be exportable]&lt;br /&gt;
&lt;br /&gt;
====todo====&lt;br /&gt;
* &amp;lt;strike&amp;gt;members_roles&amp;lt;/strike&amp;gt;?&lt;br /&gt;
&lt;br /&gt;
* members_updating_status?&lt;br /&gt;
* donations?&lt;br /&gt;
&lt;br /&gt;
== To import ==&lt;br /&gt;
&lt;br /&gt;
=== Geo ===&lt;br /&gt;
Maybe this can actually be done through a Drupal module + some service, instead of importing.&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
geo_hierarchy&lt;br /&gt;
geo_location&lt;br /&gt;
geo_type&lt;br /&gt;
geo_usage&lt;br /&gt;
geonames_admincodes&lt;br /&gt;
geonames_alternate_names&lt;br /&gt;
geonames_cache&lt;br /&gt;
geonames_cache_backup&lt;br /&gt;
geonames_countries&lt;br /&gt;
geonames_timezones&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
yes, do not import&lt;br /&gt;
&lt;br /&gt;
=== Groups ===&lt;br /&gt;
Nice but not essential:&lt;br /&gt;
* groups&lt;br /&gt;
* groups_locations&lt;br /&gt;
* groupshierarchy&lt;br /&gt;
* members_groups_subscribed&lt;br /&gt;
* membersgroups&lt;br /&gt;
* members_tags_subscribed&lt;br /&gt;
* members_threads_subscribed&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
=== Possibly optional? ===&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Kinda done ==&lt;br /&gt;
* faq &lt;br /&gt;
* faqcategories&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Used for translations ==&lt;br /&gt;
* words&lt;br /&gt;
&lt;br /&gt;
== Not needed ==&lt;br /&gt;
* &amp;lt;strike&amp;gt;user_friends&amp;lt;/strike&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Not clear yet ==&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
NbMembersByCities  - not needed ~~~~&lt;br /&gt;
addresses&lt;br /&gt;
blog&lt;br /&gt;
blog_categories&lt;br /&gt;
blog_categories_seq&lt;br /&gt;
blog_comments&lt;br /&gt;
blog_comments_seq&lt;br /&gt;
blog_data&lt;br /&gt;
blog_seq&lt;br /&gt;
blog_tags&lt;br /&gt;
blog_tags_seq&lt;br /&gt;
blog_to_category&lt;br /&gt;
blog_to_tag&lt;br /&gt;
broadcast&lt;br /&gt;
broadcastmessages&lt;br /&gt;
cal_event_to_tag - not needed ~~~~&lt;br /&gt;
cal_eventdata - not needed ~~~~&lt;br /&gt;
cal_events - not needed ~~~~&lt;br /&gt;
cal_tags - not needed ~~~~&lt;br /&gt;
chat_messages - not needed ~~~~&lt;br /&gt;
chat_room_moderators - not needed ~~~~&lt;br /&gt;
chat_rooms - not needed ~~~~&lt;br /&gt;
chat_rooms_members - not needed ~~~~&lt;br /&gt;
cities - not needed ~~~~&lt;br /&gt;
comments&lt;br /&gt;
comments_ofthemomment_votes&lt;br /&gt;
core_session_expiry&lt;br /&gt;
core_sessions&lt;br /&gt;
counters_cities_nbmembers - not needed ~~~~&lt;br /&gt;
counters_regions_nbcities - not needed ~~~~&lt;br /&gt;
counters_regions_nbmembers - not needed ~~~~&lt;br /&gt;
countries&lt;br /&gt;
&lt;br /&gt;
dbversion&lt;br /&gt;
donations&lt;br /&gt;
&lt;br /&gt;
feedbackcategories&lt;br /&gt;
feedbacks&lt;br /&gt;
flags&lt;br /&gt;
flagsmembers&lt;br /&gt;
forum_trads&lt;br /&gt;
forums_posts&lt;br /&gt;
forums_posts_votes&lt;br /&gt;
forums_tags&lt;br /&gt;
forums_threads&lt;br /&gt;
forums_threads_votes&lt;br /&gt;
func&lt;br /&gt;
gallery&lt;br /&gt;
gallery_comments&lt;br /&gt;
gallery_comments_seq&lt;br /&gt;
gallery_items&lt;br /&gt;
gallery_items_seq&lt;br /&gt;
gallery_items_to_gallery&lt;br /&gt;
gallery_seq&lt;br /&gt;
&lt;br /&gt;
groups&lt;br /&gt;
groups_locations&lt;br /&gt;
groupshierarchy&lt;br /&gt;
groupsmessages&lt;br /&gt;
guestsonline&lt;br /&gt;
hcvol_config&lt;br /&gt;
intermembertranslations&lt;br /&gt;
languages&lt;br /&gt;
linklist&lt;br /&gt;
localvolmessages&lt;br /&gt;
localvolmessages_location&lt;br /&gt;
logs&lt;br /&gt;
meetings&lt;br /&gt;
&lt;br /&gt;
members_groups_subscribed&lt;br /&gt;
members_roles&lt;br /&gt;
members_tags_subscribed&lt;br /&gt;
members_threads_subscribed&lt;br /&gt;
members_updating_status&lt;br /&gt;
membersgroups&lt;br /&gt;
memberslanguageslevel&lt;br /&gt;
membersmeetings&lt;br /&gt;
membersphotos&lt;br /&gt;
memberspreferences&lt;br /&gt;
memberspublicprofiles&lt;br /&gt;
memberstrads&lt;br /&gt;
message&lt;br /&gt;
messages&lt;br /&gt;
mod_user_apps&lt;br /&gt;
mod_user_apps_seq&lt;br /&gt;
mod_user_auth&lt;br /&gt;
mod_user_auth_seq&lt;br /&gt;
mod_user_authgroups&lt;br /&gt;
mod_user_authrights&lt;br /&gt;
mod_user_groupauth&lt;br /&gt;
mod_user_grouprights&lt;br /&gt;
mod_user_implications&lt;br /&gt;
mod_user_rights&lt;br /&gt;
mod_user_rights_seq&lt;br /&gt;
mycontacts&lt;br /&gt;
notes&lt;br /&gt;
old_t_cities_old_BW - not needed ~~~~&lt;br /&gt;
old_t_regions - not needed ~~~&lt;br /&gt;
oldvisits - not needed ~~~&lt;br /&gt;
online - not needed ~~~&lt;br /&gt;
params&lt;br /&gt;
pendingmandatory&lt;br /&gt;
plannedtrips&lt;br /&gt;
polls&lt;br /&gt;
polls_choices&lt;br /&gt;
polls_choices_hierachy&lt;br /&gt;
polls_contributions&lt;br /&gt;
polls_list_allowed_countries&lt;br /&gt;
polls_list_allowed_groups&lt;br /&gt;
polls_list_allowed_locations&lt;br /&gt;
polls_record_of_choices&lt;br /&gt;
posts_notificationqueue&lt;br /&gt;
preferences&lt;br /&gt;
previousversion&lt;br /&gt;
privileges&lt;br /&gt;
privilegescopes&lt;br /&gt;
proc&lt;br /&gt;
profilesvisits&lt;br /&gt;
recentvisits&lt;br /&gt;
recorded_usernames_of_left_members&lt;br /&gt;
regions&lt;br /&gt;
reports_to_moderators&lt;br /&gt;
rights&lt;br /&gt;
rightsvolunteers&lt;br /&gt;
roles&lt;br /&gt;
roles_privileges&lt;br /&gt;
shouts&lt;br /&gt;
shouts_seq&lt;br /&gt;
specialrelations&lt;br /&gt;
sqlforgroupsmembers - not needed ~~~~&lt;br /&gt;
sqlforvolunteers - not needed ~~~~&lt;br /&gt;
stats&lt;br /&gt;
tags_threads&lt;br /&gt;
translations&lt;br /&gt;
trip&lt;br /&gt;
trip_data&lt;br /&gt;
trip_seq&lt;br /&gt;
trip_to_gallery&lt;br /&gt;
urlheader_languages&lt;br /&gt;
&lt;br /&gt;
user_inbox&lt;br /&gt;
user_outbox&lt;br /&gt;
user_seq&lt;br /&gt;
user_settings&lt;br /&gt;
v_cities&lt;br /&gt;
volunteer_boards&lt;br /&gt;
volunteers_reports_schedule&lt;br /&gt;
wEnglish&lt;br /&gt;
&lt;br /&gt;
words_use - not needed ~~~~&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
== Useful info ==&lt;br /&gt;
* http://www.midwesternmac.com/blogs/jeff-geerling/using-migrate-import-content&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
{{bw}}&lt;/div&gt;</summary>
		<author><name>Philipp</name></author>
	</entry>
	<entry>
		<id>https://wiki.trustroots.org/index.php?title=BW_Rox_to_Drupal_database_migration&amp;diff=3609</id>
		<title>BW Rox to Drupal database migration</title>
		<link rel="alternate" type="text/html" href="https://wiki.trustroots.org/index.php?title=BW_Rox_to_Drupal_database_migration&amp;diff=3609"/>
		<updated>2011-09-16T00:26:29Z</updated>

		<summary type="html">&lt;p&gt;Philipp: /* Not clear yet */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;:&#039;&#039;See also [[Set up BW Drupal]]&#039;&#039;&lt;br /&gt;
Trying to get an idea of what needs to be migrated and how...&lt;br /&gt;
&lt;br /&gt;
&amp;lt;tt&amp;gt;mysql bwroxdb -e &#039;show tables\G&#039;|grep Table|awk &#039;{ print $2 }&#039;&amp;lt;/tt&amp;gt; was used as a starting point.&lt;br /&gt;
&lt;br /&gt;
For now this is only about the data migration, not about the presentation of the data.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
==Work in progress==&lt;br /&gt;
* ewiki =&amp;gt; bw_wikipage&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
===Users===&lt;br /&gt;
* user =&amp;gt; Drupal users&lt;br /&gt;
* members =&amp;gt; Drupal profile&lt;br /&gt;
** addresses&lt;br /&gt;
** cryptedfields&lt;br /&gt;
==== Passwords ====&lt;br /&gt;
* &amp;lt;strike&amp;gt;[http://drupal.org/node/1175562 SOLVED D6 user password import to D7]&amp;lt;/strike&amp;gt; doesn&#039;t work&lt;br /&gt;
* we need a Rox authentication module that will upgrade passwords to D7 user_hash_password when a user logs in&lt;br /&gt;
* 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)&lt;br /&gt;
&lt;br /&gt;
==== User Relationships ====&lt;br /&gt;
tables:&lt;br /&gt;
* comments (started)&lt;br /&gt;
* feedbacks&lt;br /&gt;
* feedbackcategories&lt;br /&gt;
* verifiedmembers&lt;br /&gt;
&lt;br /&gt;
need [http://drupal.org/node/691034 to be exportable]&lt;br /&gt;
&lt;br /&gt;
====todo====&lt;br /&gt;
* &amp;lt;strike&amp;gt;members_roles&amp;lt;/strike&amp;gt;?&lt;br /&gt;
&lt;br /&gt;
* members_updating_status?&lt;br /&gt;
* donations?&lt;br /&gt;
&lt;br /&gt;
== To import ==&lt;br /&gt;
&lt;br /&gt;
=== Geo ===&lt;br /&gt;
Maybe this can actually be done through a Drupal module + some service, instead of importing.&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
geo_hierarchy&lt;br /&gt;
geo_location&lt;br /&gt;
geo_type&lt;br /&gt;
geo_usage&lt;br /&gt;
geonames_admincodes&lt;br /&gt;
geonames_alternate_names&lt;br /&gt;
geonames_cache&lt;br /&gt;
geonames_cache_backup&lt;br /&gt;
geonames_countries&lt;br /&gt;
geonames_timezones&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
yes, do not import&lt;br /&gt;
&lt;br /&gt;
=== Groups ===&lt;br /&gt;
Nice but not essential:&lt;br /&gt;
* groups&lt;br /&gt;
* groups_locations&lt;br /&gt;
* groupshierarchy&lt;br /&gt;
* members_groups_subscribed&lt;br /&gt;
* membersgroups&lt;br /&gt;
* members_tags_subscribed&lt;br /&gt;
* members_threads_subscribed&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
=== Possibly optional? ===&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Kinda done ==&lt;br /&gt;
* faq &lt;br /&gt;
* faqcategories&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Used for translations ==&lt;br /&gt;
* words&lt;br /&gt;
&lt;br /&gt;
== Not needed ==&lt;br /&gt;
* &amp;lt;strike&amp;gt;user_friends&amp;lt;/strike&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Not clear yet ==&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
NbMembersByCities  - not needed ~~~&lt;br /&gt;
addresses&lt;br /&gt;
blog&lt;br /&gt;
blog_categories&lt;br /&gt;
blog_categories_seq&lt;br /&gt;
blog_comments&lt;br /&gt;
blog_comments_seq&lt;br /&gt;
blog_data&lt;br /&gt;
blog_seq&lt;br /&gt;
blog_tags&lt;br /&gt;
blog_tags_seq&lt;br /&gt;
blog_to_category&lt;br /&gt;
blog_to_tag&lt;br /&gt;
broadcast&lt;br /&gt;
broadcastmessages&lt;br /&gt;
cal_event_to_tag - not needed ~~~&lt;br /&gt;
cal_eventdata - not needed ~~~&lt;br /&gt;
cal_events - not needed ~~~&lt;br /&gt;
cal_tags - not needed ~~~&lt;br /&gt;
chat_messages - not needed ~~~&lt;br /&gt;
chat_room_moderators - not needed ~~~&lt;br /&gt;
chat_rooms - not needed ~~~&lt;br /&gt;
chat_rooms_members - not needed ~~~&lt;br /&gt;
cities - not needed ~~~&lt;br /&gt;
comments&lt;br /&gt;
comments_ofthemomment_votes&lt;br /&gt;
core_session_expiry&lt;br /&gt;
core_sessions&lt;br /&gt;
counters_cities_nbmembers - not needed ~~~&lt;br /&gt;
counters_regions_nbcities - not needed ~~~&lt;br /&gt;
counters_regions_nbmembers - not needed ~~~&lt;br /&gt;
countries&lt;br /&gt;
&lt;br /&gt;
dbversion&lt;br /&gt;
donations&lt;br /&gt;
&lt;br /&gt;
feedbackcategories&lt;br /&gt;
feedbacks&lt;br /&gt;
flags&lt;br /&gt;
flagsmembers&lt;br /&gt;
forum_trads&lt;br /&gt;
forums_posts&lt;br /&gt;
forums_posts_votes&lt;br /&gt;
forums_tags&lt;br /&gt;
forums_threads&lt;br /&gt;
forums_threads_votes&lt;br /&gt;
func&lt;br /&gt;
gallery&lt;br /&gt;
gallery_comments&lt;br /&gt;
gallery_comments_seq&lt;br /&gt;
gallery_items&lt;br /&gt;
gallery_items_seq&lt;br /&gt;
gallery_items_to_gallery&lt;br /&gt;
gallery_seq&lt;br /&gt;
&lt;br /&gt;
groups&lt;br /&gt;
groups_locations&lt;br /&gt;
groupshierarchy&lt;br /&gt;
groupsmessages&lt;br /&gt;
guestsonline&lt;br /&gt;
hcvol_config&lt;br /&gt;
intermembertranslations&lt;br /&gt;
languages&lt;br /&gt;
linklist&lt;br /&gt;
localvolmessages&lt;br /&gt;
localvolmessages_location&lt;br /&gt;
logs&lt;br /&gt;
meetings&lt;br /&gt;
&lt;br /&gt;
members_groups_subscribed&lt;br /&gt;
members_roles&lt;br /&gt;
members_tags_subscribed&lt;br /&gt;
members_threads_subscribed&lt;br /&gt;
members_updating_status&lt;br /&gt;
membersgroups&lt;br /&gt;
memberslanguageslevel&lt;br /&gt;
membersmeetings&lt;br /&gt;
membersphotos&lt;br /&gt;
memberspreferences&lt;br /&gt;
memberspublicprofiles&lt;br /&gt;
memberstrads&lt;br /&gt;
message&lt;br /&gt;
messages&lt;br /&gt;
mod_user_apps&lt;br /&gt;
mod_user_apps_seq&lt;br /&gt;
mod_user_auth&lt;br /&gt;
mod_user_auth_seq&lt;br /&gt;
mod_user_authgroups&lt;br /&gt;
mod_user_authrights&lt;br /&gt;
mod_user_groupauth&lt;br /&gt;
mod_user_grouprights&lt;br /&gt;
mod_user_implications&lt;br /&gt;
mod_user_rights&lt;br /&gt;
mod_user_rights_seq&lt;br /&gt;
mycontacts&lt;br /&gt;
notes&lt;br /&gt;
old_t_cities_old_BW - not needed ~~~&lt;br /&gt;
old_t_regions - not needed ~~~&lt;br /&gt;
oldvisits - not needed ~~~&lt;br /&gt;
online - not needed ~~~&lt;br /&gt;
params&lt;br /&gt;
pendingmandatory&lt;br /&gt;
plannedtrips&lt;br /&gt;
polls&lt;br /&gt;
polls_choices&lt;br /&gt;
polls_choices_hierachy&lt;br /&gt;
polls_contributions&lt;br /&gt;
polls_list_allowed_countries&lt;br /&gt;
polls_list_allowed_groups&lt;br /&gt;
polls_list_allowed_locations&lt;br /&gt;
polls_record_of_choices&lt;br /&gt;
posts_notificationqueue&lt;br /&gt;
preferences&lt;br /&gt;
previousversion&lt;br /&gt;
privileges&lt;br /&gt;
privilegescopes&lt;br /&gt;
proc&lt;br /&gt;
profilesvisits&lt;br /&gt;
recentvisits&lt;br /&gt;
recorded_usernames_of_left_members&lt;br /&gt;
regions&lt;br /&gt;
reports_to_moderators&lt;br /&gt;
rights&lt;br /&gt;
rightsvolunteers&lt;br /&gt;
roles&lt;br /&gt;
roles_privileges&lt;br /&gt;
shouts&lt;br /&gt;
shouts_seq&lt;br /&gt;
specialrelations&lt;br /&gt;
sqlforgroupsmembers - not needed ~~~&lt;br /&gt;
sqlforvolunteers - not needed ~~~&lt;br /&gt;
stats&lt;br /&gt;
tags_threads&lt;br /&gt;
translations&lt;br /&gt;
trip&lt;br /&gt;
trip_data&lt;br /&gt;
trip_seq&lt;br /&gt;
trip_to_gallery&lt;br /&gt;
urlheader_languages&lt;br /&gt;
&lt;br /&gt;
user_inbox&lt;br /&gt;
user_outbox&lt;br /&gt;
user_seq&lt;br /&gt;
user_settings&lt;br /&gt;
v_cities&lt;br /&gt;
volunteer_boards&lt;br /&gt;
volunteers_reports_schedule&lt;br /&gt;
wEnglish&lt;br /&gt;
&lt;br /&gt;
words_use - not needed ~~~&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
== Useful info ==&lt;br /&gt;
* http://www.midwesternmac.com/blogs/jeff-geerling/using-migrate-import-content&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
{{bw}}&lt;/div&gt;</summary>
		<author><name>Philipp</name></author>
	</entry>
	<entry>
		<id>https://wiki.trustroots.org/index.php?title=BW_Rox_to_Drupal_database_migration&amp;diff=3608</id>
		<title>BW Rox to Drupal database migration</title>
		<link rel="alternate" type="text/html" href="https://wiki.trustroots.org/index.php?title=BW_Rox_to_Drupal_database_migration&amp;diff=3608"/>
		<updated>2011-09-16T00:22:37Z</updated>

		<summary type="html">&lt;p&gt;Philipp: /* Geo */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;:&#039;&#039;See also [[Set up BW Drupal]]&#039;&#039;&lt;br /&gt;
Trying to get an idea of what needs to be migrated and how...&lt;br /&gt;
&lt;br /&gt;
&amp;lt;tt&amp;gt;mysql bwroxdb -e &#039;show tables\G&#039;|grep Table|awk &#039;{ print $2 }&#039;&amp;lt;/tt&amp;gt; was used as a starting point.&lt;br /&gt;
&lt;br /&gt;
For now this is only about the data migration, not about the presentation of the data.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
==Work in progress==&lt;br /&gt;
* ewiki =&amp;gt; bw_wikipage&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
===Users===&lt;br /&gt;
* user =&amp;gt; Drupal users&lt;br /&gt;
* members =&amp;gt; Drupal profile&lt;br /&gt;
** addresses&lt;br /&gt;
** cryptedfields&lt;br /&gt;
==== Passwords ====&lt;br /&gt;
* &amp;lt;strike&amp;gt;[http://drupal.org/node/1175562 SOLVED D6 user password import to D7]&amp;lt;/strike&amp;gt; doesn&#039;t work&lt;br /&gt;
* we need a Rox authentication module that will upgrade passwords to D7 user_hash_password when a user logs in&lt;br /&gt;
* 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)&lt;br /&gt;
&lt;br /&gt;
==== User Relationships ====&lt;br /&gt;
tables:&lt;br /&gt;
* comments (started)&lt;br /&gt;
* feedbacks&lt;br /&gt;
* feedbackcategories&lt;br /&gt;
* verifiedmembers&lt;br /&gt;
&lt;br /&gt;
need [http://drupal.org/node/691034 to be exportable]&lt;br /&gt;
&lt;br /&gt;
====todo====&lt;br /&gt;
* &amp;lt;strike&amp;gt;members_roles&amp;lt;/strike&amp;gt;?&lt;br /&gt;
&lt;br /&gt;
* members_updating_status?&lt;br /&gt;
* donations?&lt;br /&gt;
&lt;br /&gt;
== To import ==&lt;br /&gt;
&lt;br /&gt;
=== Geo ===&lt;br /&gt;
Maybe this can actually be done through a Drupal module + some service, instead of importing.&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
geo_hierarchy&lt;br /&gt;
geo_location&lt;br /&gt;
geo_type&lt;br /&gt;
geo_usage&lt;br /&gt;
geonames_admincodes&lt;br /&gt;
geonames_alternate_names&lt;br /&gt;
geonames_cache&lt;br /&gt;
geonames_cache_backup&lt;br /&gt;
geonames_countries&lt;br /&gt;
geonames_timezones&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
yes, do not import&lt;br /&gt;
&lt;br /&gt;
=== Groups ===&lt;br /&gt;
Nice but not essential:&lt;br /&gt;
* groups&lt;br /&gt;
* groups_locations&lt;br /&gt;
* groupshierarchy&lt;br /&gt;
* members_groups_subscribed&lt;br /&gt;
* membersgroups&lt;br /&gt;
* members_tags_subscribed&lt;br /&gt;
* members_threads_subscribed&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
=== Possibly optional? ===&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Kinda done ==&lt;br /&gt;
* faq &lt;br /&gt;
* faqcategories&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Used for translations ==&lt;br /&gt;
* words&lt;br /&gt;
&lt;br /&gt;
== Not needed ==&lt;br /&gt;
* &amp;lt;strike&amp;gt;user_friends&amp;lt;/strike&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Not clear yet ==&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
NbMembersByCities&lt;br /&gt;
addresses&lt;br /&gt;
blog&lt;br /&gt;
blog_categories&lt;br /&gt;
blog_categories_seq&lt;br /&gt;
blog_comments&lt;br /&gt;
blog_comments_seq&lt;br /&gt;
blog_data&lt;br /&gt;
blog_seq&lt;br /&gt;
blog_tags&lt;br /&gt;
blog_tags_seq&lt;br /&gt;
blog_to_category&lt;br /&gt;
blog_to_tag&lt;br /&gt;
broadcast&lt;br /&gt;
broadcastmessages&lt;br /&gt;
cal_event_to_tag&lt;br /&gt;
cal_eventdata&lt;br /&gt;
cal_events&lt;br /&gt;
cal_tags&lt;br /&gt;
chat_messages&lt;br /&gt;
chat_room_moderators&lt;br /&gt;
chat_rooms&lt;br /&gt;
chat_rooms_members&lt;br /&gt;
cities&lt;br /&gt;
comments&lt;br /&gt;
comments_ofthemomment_votes&lt;br /&gt;
core_session_expiry&lt;br /&gt;
core_sessions&lt;br /&gt;
counters_cities_nbmembers&lt;br /&gt;
counters_regions_nbcities&lt;br /&gt;
counters_regions_nbmembers&lt;br /&gt;
countries&lt;br /&gt;
&lt;br /&gt;
dbversion&lt;br /&gt;
donations&lt;br /&gt;
&lt;br /&gt;
feedbackcategories&lt;br /&gt;
feedbacks&lt;br /&gt;
flags&lt;br /&gt;
flagsmembers&lt;br /&gt;
forum_trads&lt;br /&gt;
forums_posts&lt;br /&gt;
forums_posts_votes&lt;br /&gt;
forums_tags&lt;br /&gt;
forums_threads&lt;br /&gt;
forums_threads_votes&lt;br /&gt;
func&lt;br /&gt;
gallery&lt;br /&gt;
gallery_comments&lt;br /&gt;
gallery_comments_seq&lt;br /&gt;
gallery_items&lt;br /&gt;
gallery_items_seq&lt;br /&gt;
gallery_items_to_gallery&lt;br /&gt;
gallery_seq&lt;br /&gt;
&lt;br /&gt;
groups&lt;br /&gt;
groups_locations&lt;br /&gt;
groupshierarchy&lt;br /&gt;
groupsmessages&lt;br /&gt;
guestsonline&lt;br /&gt;
hcvol_config&lt;br /&gt;
intermembertranslations&lt;br /&gt;
languages&lt;br /&gt;
linklist&lt;br /&gt;
localvolmessages&lt;br /&gt;
localvolmessages_location&lt;br /&gt;
logs&lt;br /&gt;
meetings&lt;br /&gt;
&lt;br /&gt;
members_groups_subscribed&lt;br /&gt;
members_roles&lt;br /&gt;
members_tags_subscribed&lt;br /&gt;
members_threads_subscribed&lt;br /&gt;
members_updating_status&lt;br /&gt;
membersgroups&lt;br /&gt;
memberslanguageslevel&lt;br /&gt;
membersmeetings&lt;br /&gt;
membersphotos&lt;br /&gt;
memberspreferences&lt;br /&gt;
memberspublicprofiles&lt;br /&gt;
memberstrads&lt;br /&gt;
message&lt;br /&gt;
messages&lt;br /&gt;
mod_user_apps&lt;br /&gt;
mod_user_apps_seq&lt;br /&gt;
mod_user_auth&lt;br /&gt;
mod_user_auth_seq&lt;br /&gt;
mod_user_authgroups&lt;br /&gt;
mod_user_authrights&lt;br /&gt;
mod_user_groupauth&lt;br /&gt;
mod_user_grouprights&lt;br /&gt;
mod_user_implications&lt;br /&gt;
mod_user_rights&lt;br /&gt;
mod_user_rights_seq&lt;br /&gt;
mycontacts&lt;br /&gt;
notes&lt;br /&gt;
old_t_cities_old_BW&lt;br /&gt;
old_t_regions&lt;br /&gt;
oldvisits&lt;br /&gt;
online&lt;br /&gt;
params&lt;br /&gt;
pendingmandatory&lt;br /&gt;
plannedtrips&lt;br /&gt;
polls&lt;br /&gt;
polls_choices&lt;br /&gt;
polls_choices_hierachy&lt;br /&gt;
polls_contributions&lt;br /&gt;
polls_list_allowed_countries&lt;br /&gt;
polls_list_allowed_groups&lt;br /&gt;
polls_list_allowed_locations&lt;br /&gt;
polls_record_of_choices&lt;br /&gt;
posts_notificationqueue&lt;br /&gt;
preferences&lt;br /&gt;
previousversion&lt;br /&gt;
privileges&lt;br /&gt;
privilegescopes&lt;br /&gt;
proc&lt;br /&gt;
profilesvisits&lt;br /&gt;
recentvisits&lt;br /&gt;
recorded_usernames_of_left_members&lt;br /&gt;
regions&lt;br /&gt;
reports_to_moderators&lt;br /&gt;
rights&lt;br /&gt;
rightsvolunteers&lt;br /&gt;
roles&lt;br /&gt;
roles_privileges&lt;br /&gt;
shouts&lt;br /&gt;
shouts_seq&lt;br /&gt;
specialrelations&lt;br /&gt;
sqlforgroupsmembers&lt;br /&gt;
sqlforvolunteers&lt;br /&gt;
stats&lt;br /&gt;
tags_threads&lt;br /&gt;
translations&lt;br /&gt;
trip&lt;br /&gt;
trip_data&lt;br /&gt;
trip_seq&lt;br /&gt;
trip_to_gallery&lt;br /&gt;
urlheader_languages&lt;br /&gt;
&lt;br /&gt;
user_inbox&lt;br /&gt;
user_outbox&lt;br /&gt;
user_seq&lt;br /&gt;
user_settings&lt;br /&gt;
v_cities&lt;br /&gt;
volunteer_boards&lt;br /&gt;
volunteers_reports_schedule&lt;br /&gt;
wEnglish&lt;br /&gt;
&lt;br /&gt;
words_use&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Useful info ==&lt;br /&gt;
* http://www.midwesternmac.com/blogs/jeff-geerling/using-migrate-import-content&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
{{bw}}&lt;/div&gt;</summary>
		<author><name>Philipp</name></author>
	</entry>
	<entry>
		<id>https://wiki.trustroots.org/index.php?title=BW_Rox_to_Drupal_database_migration&amp;diff=3607</id>
		<title>BW Rox to Drupal database migration</title>
		<link rel="alternate" type="text/html" href="https://wiki.trustroots.org/index.php?title=BW_Rox_to_Drupal_database_migration&amp;diff=3607"/>
		<updated>2011-09-16T00:21:10Z</updated>

		<summary type="html">&lt;p&gt;Philipp: /* Passwords */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;:&#039;&#039;See also [[Set up BW Drupal]]&#039;&#039;&lt;br /&gt;
Trying to get an idea of what needs to be migrated and how...&lt;br /&gt;
&lt;br /&gt;
&amp;lt;tt&amp;gt;mysql bwroxdb -e &#039;show tables\G&#039;|grep Table|awk &#039;{ print $2 }&#039;&amp;lt;/tt&amp;gt; was used as a starting point.&lt;br /&gt;
&lt;br /&gt;
For now this is only about the data migration, not about the presentation of the data.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
==Work in progress==&lt;br /&gt;
* ewiki =&amp;gt; bw_wikipage&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
===Users===&lt;br /&gt;
* user =&amp;gt; Drupal users&lt;br /&gt;
* members =&amp;gt; Drupal profile&lt;br /&gt;
** addresses&lt;br /&gt;
** cryptedfields&lt;br /&gt;
==== Passwords ====&lt;br /&gt;
* &amp;lt;strike&amp;gt;[http://drupal.org/node/1175562 SOLVED D6 user password import to D7]&amp;lt;/strike&amp;gt; doesn&#039;t work&lt;br /&gt;
* we need a Rox authentication module that will upgrade passwords to D7 user_hash_password when a user logs in&lt;br /&gt;
* 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)&lt;br /&gt;
&lt;br /&gt;
==== User Relationships ====&lt;br /&gt;
tables:&lt;br /&gt;
* comments (started)&lt;br /&gt;
* feedbacks&lt;br /&gt;
* feedbackcategories&lt;br /&gt;
* verifiedmembers&lt;br /&gt;
&lt;br /&gt;
need [http://drupal.org/node/691034 to be exportable]&lt;br /&gt;
&lt;br /&gt;
====todo====&lt;br /&gt;
* &amp;lt;strike&amp;gt;members_roles&amp;lt;/strike&amp;gt;?&lt;br /&gt;
&lt;br /&gt;
* members_updating_status?&lt;br /&gt;
* donations?&lt;br /&gt;
&lt;br /&gt;
== To import ==&lt;br /&gt;
&lt;br /&gt;
=== Geo ===&lt;br /&gt;
Maybe this can actually be done through a Drupal module + some service, instead of importing.&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
geo_hierarchy&lt;br /&gt;
geo_location&lt;br /&gt;
geo_type&lt;br /&gt;
geo_usage&lt;br /&gt;
geonames_admincodes&lt;br /&gt;
geonames_alternate_names&lt;br /&gt;
geonames_cache&lt;br /&gt;
geonames_cache_backup&lt;br /&gt;
geonames_countries&lt;br /&gt;
geonames_timezones&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
=== Groups ===&lt;br /&gt;
Nice but not essential:&lt;br /&gt;
* groups&lt;br /&gt;
* groups_locations&lt;br /&gt;
* groupshierarchy&lt;br /&gt;
* members_groups_subscribed&lt;br /&gt;
* membersgroups&lt;br /&gt;
* members_tags_subscribed&lt;br /&gt;
* members_threads_subscribed&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
=== Possibly optional? ===&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Kinda done ==&lt;br /&gt;
* faq &lt;br /&gt;
* faqcategories&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Used for translations ==&lt;br /&gt;
* words&lt;br /&gt;
&lt;br /&gt;
== Not needed ==&lt;br /&gt;
* &amp;lt;strike&amp;gt;user_friends&amp;lt;/strike&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Not clear yet ==&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
NbMembersByCities&lt;br /&gt;
addresses&lt;br /&gt;
blog&lt;br /&gt;
blog_categories&lt;br /&gt;
blog_categories_seq&lt;br /&gt;
blog_comments&lt;br /&gt;
blog_comments_seq&lt;br /&gt;
blog_data&lt;br /&gt;
blog_seq&lt;br /&gt;
blog_tags&lt;br /&gt;
blog_tags_seq&lt;br /&gt;
blog_to_category&lt;br /&gt;
blog_to_tag&lt;br /&gt;
broadcast&lt;br /&gt;
broadcastmessages&lt;br /&gt;
cal_event_to_tag&lt;br /&gt;
cal_eventdata&lt;br /&gt;
cal_events&lt;br /&gt;
cal_tags&lt;br /&gt;
chat_messages&lt;br /&gt;
chat_room_moderators&lt;br /&gt;
chat_rooms&lt;br /&gt;
chat_rooms_members&lt;br /&gt;
cities&lt;br /&gt;
comments&lt;br /&gt;
comments_ofthemomment_votes&lt;br /&gt;
core_session_expiry&lt;br /&gt;
core_sessions&lt;br /&gt;
counters_cities_nbmembers&lt;br /&gt;
counters_regions_nbcities&lt;br /&gt;
counters_regions_nbmembers&lt;br /&gt;
countries&lt;br /&gt;
&lt;br /&gt;
dbversion&lt;br /&gt;
donations&lt;br /&gt;
&lt;br /&gt;
feedbackcategories&lt;br /&gt;
feedbacks&lt;br /&gt;
flags&lt;br /&gt;
flagsmembers&lt;br /&gt;
forum_trads&lt;br /&gt;
forums_posts&lt;br /&gt;
forums_posts_votes&lt;br /&gt;
forums_tags&lt;br /&gt;
forums_threads&lt;br /&gt;
forums_threads_votes&lt;br /&gt;
func&lt;br /&gt;
gallery&lt;br /&gt;
gallery_comments&lt;br /&gt;
gallery_comments_seq&lt;br /&gt;
gallery_items&lt;br /&gt;
gallery_items_seq&lt;br /&gt;
gallery_items_to_gallery&lt;br /&gt;
gallery_seq&lt;br /&gt;
&lt;br /&gt;
groups&lt;br /&gt;
groups_locations&lt;br /&gt;
groupshierarchy&lt;br /&gt;
groupsmessages&lt;br /&gt;
guestsonline&lt;br /&gt;
hcvol_config&lt;br /&gt;
intermembertranslations&lt;br /&gt;
languages&lt;br /&gt;
linklist&lt;br /&gt;
localvolmessages&lt;br /&gt;
localvolmessages_location&lt;br /&gt;
logs&lt;br /&gt;
meetings&lt;br /&gt;
&lt;br /&gt;
members_groups_subscribed&lt;br /&gt;
members_roles&lt;br /&gt;
members_tags_subscribed&lt;br /&gt;
members_threads_subscribed&lt;br /&gt;
members_updating_status&lt;br /&gt;
membersgroups&lt;br /&gt;
memberslanguageslevel&lt;br /&gt;
membersmeetings&lt;br /&gt;
membersphotos&lt;br /&gt;
memberspreferences&lt;br /&gt;
memberspublicprofiles&lt;br /&gt;
memberstrads&lt;br /&gt;
message&lt;br /&gt;
messages&lt;br /&gt;
mod_user_apps&lt;br /&gt;
mod_user_apps_seq&lt;br /&gt;
mod_user_auth&lt;br /&gt;
mod_user_auth_seq&lt;br /&gt;
mod_user_authgroups&lt;br /&gt;
mod_user_authrights&lt;br /&gt;
mod_user_groupauth&lt;br /&gt;
mod_user_grouprights&lt;br /&gt;
mod_user_implications&lt;br /&gt;
mod_user_rights&lt;br /&gt;
mod_user_rights_seq&lt;br /&gt;
mycontacts&lt;br /&gt;
notes&lt;br /&gt;
old_t_cities_old_BW&lt;br /&gt;
old_t_regions&lt;br /&gt;
oldvisits&lt;br /&gt;
online&lt;br /&gt;
params&lt;br /&gt;
pendingmandatory&lt;br /&gt;
plannedtrips&lt;br /&gt;
polls&lt;br /&gt;
polls_choices&lt;br /&gt;
polls_choices_hierachy&lt;br /&gt;
polls_contributions&lt;br /&gt;
polls_list_allowed_countries&lt;br /&gt;
polls_list_allowed_groups&lt;br /&gt;
polls_list_allowed_locations&lt;br /&gt;
polls_record_of_choices&lt;br /&gt;
posts_notificationqueue&lt;br /&gt;
preferences&lt;br /&gt;
previousversion&lt;br /&gt;
privileges&lt;br /&gt;
privilegescopes&lt;br /&gt;
proc&lt;br /&gt;
profilesvisits&lt;br /&gt;
recentvisits&lt;br /&gt;
recorded_usernames_of_left_members&lt;br /&gt;
regions&lt;br /&gt;
reports_to_moderators&lt;br /&gt;
rights&lt;br /&gt;
rightsvolunteers&lt;br /&gt;
roles&lt;br /&gt;
roles_privileges&lt;br /&gt;
shouts&lt;br /&gt;
shouts_seq&lt;br /&gt;
specialrelations&lt;br /&gt;
sqlforgroupsmembers&lt;br /&gt;
sqlforvolunteers&lt;br /&gt;
stats&lt;br /&gt;
tags_threads&lt;br /&gt;
translations&lt;br /&gt;
trip&lt;br /&gt;
trip_data&lt;br /&gt;
trip_seq&lt;br /&gt;
trip_to_gallery&lt;br /&gt;
urlheader_languages&lt;br /&gt;
&lt;br /&gt;
user_inbox&lt;br /&gt;
user_outbox&lt;br /&gt;
user_seq&lt;br /&gt;
user_settings&lt;br /&gt;
v_cities&lt;br /&gt;
volunteer_boards&lt;br /&gt;
volunteers_reports_schedule&lt;br /&gt;
wEnglish&lt;br /&gt;
&lt;br /&gt;
words_use&lt;br /&gt;
&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Useful info ==&lt;br /&gt;
* http://www.midwesternmac.com/blogs/jeff-geerling/using-migrate-import-content&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
{{bw}}&lt;/div&gt;</summary>
		<author><name>Philipp</name></author>
	</entry>
</feed>