<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; "><BR><DIV><DIV>On Jun 9, 2006, at 6:37 AM, Barry Jaspan wrote:</DIV><BR class="Apple-interchange-newline"><BLOCKQUOTE type="cite"><P style="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Helvetica" size="3" style="font: 12.0px Helvetica">My suggestion is to identify which database tables contain administrative or configuration data vs.</FONT></P> </BLOCKQUOTE><BR></DIV><DIV>CivicSpace has spent about 60 hours this week building the tools for extracting the configuration of a site into .profile and into a .install.</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Here's what we are extracting and then making available as a default configuration in a .profile:</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>1) Modules from the System Table are enabled in the .profile</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">function gojoingo_profile_modules() {</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "> return array('system', 'block', 'civicrm', 'filter', 'help', 'menu', 'node', 'page', 'taxonomy', 'user', 'watchdog', 'blog');</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">}</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><BR class="khtml-block-placeholder"></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">The rest are set using a .install</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>2) Menu's from the Menu Table: use the devel module to reset your menu's and diff them DB dumps</DIV><DIV>3) Menu's for primary navigation: We actually point these to views : My Groups, My Events... </DIV><DIV>3) Blocks from the Blocks Table</DIV><DIV>4) Access control from the access table</DIV><DIV>5) Module configuration settings: we have written a script called variable-export that export's your variables into a list of </DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>variable_set('variable', value); </DIV><DIV>variable_set('comment_content-event', '2');</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">variable_set('event_nodeapi_content-event', 'all');</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">variable_set('image_attach_content-event', '0');</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">variable_set('upload_content-event', '1');</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">variable_set('location_weight_content-event', '9');</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">variable_set('location_name_content-event', '1');</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>so that we can just add to the .install</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>6) Localization exporting to make Drupal terminology user friendly - we can do it manually but having some problems populating using the .install</DIV><DIV>7) Views are proving tricky to add in the .install with <FONT class="Apple-style-span" face="Lucida Grande" size="3"><SPAN class="Apple-style-span" style="font-size: 11px;">views_import_view_submit. Look for help here.</SPAN></FONT></DIV><DIV><FONT class="Apple-style-span" face="Lucida Grande" size="3"><SPAN class="Apple-style-span" style="font-size: 11px;"><BR class="khtml-block-placeholder"></SPAN></FONT></DIV><DIV><FONT class="Apple-style-span" face="Lucida Grande" size="3"><SPAN class="Apple-style-span" style="font-size: 11px;">We aren't that far away from having a module that just dump's your entire site configuration into a .profile and a .install. Then you can just add the files to the Drupal install profile system and presto you have a Drupal distribution or you have a back up of your site. If you want to collaborate and can contribute some hours that would be very helpful.</SPAN></FONT></DIV><DIV><FONT class="Apple-style-span" face="Lucida Grande" size="3"><SPAN class="Apple-style-span" style="font-size: 11px;"><BR class="khtml-block-placeholder"></SPAN></FONT></DIV><DIV><FONT class="Apple-style-span" face="Lucida Grande" size="3"><SPAN class="Apple-style-span" style="font-size: 11px;">Kieran</SPAN></FONT></DIV><DIV><FONT class="Apple-style-span" face="Lucida Grande" size="3"><SPAN class="Apple-style-span" style="font-size: 11px;">CivicSpace</SPAN></FONT></DIV><DIV><FONT class="Apple-style-span" face="Lucida Grande" size="3"><SPAN class="Apple-style-span" style="font-size: 11px;"><BR class="khtml-block-placeholder"></SPAN></FONT></DIV></BODY></HTML>