[drupal-docs] Help exporting CivicSpace and Drupal documentation so we can comply with CC share alike attribution

[Kieran Lal]

Hi, we have posted the CivicSpace documentation at 
http://civicspacelabs.org/files/documentation.sql.  Also, here is the 
Drupal Documentation, thanks to Steven Wittens: 
http://civicspacelabs.org/files/csdump.mysql.gz.  Now all we need is 
the Bryght Documentation and the Development Seed FAQ ;-)

Here's is what I am planning on doing with the CivicSpace 
documentation, but I am looking for a better way that is repeatable for 
the larger community.
1) Load document.sql into a clean database. mysql -u USER -pPASSWORD 
documentation.mysql > NewDatabase.
2) From my drupal site create content to get the last node number of 
the site. e.g.If you create a blog post and the url for that blog post 
is http://yousite.com/node/10000 then your high node number is 10000.
3) Update the Book table with nid += high node number; Parent += high 
node number.
5) We need to change the format in the node table.  In order to do this 
you will need to be an admin for your site. You need to go to 
users->configure->permission->filter and check all the permissions(esp 
filter).
6) From admin on your site go to input formats in your navigation menu. 
  Configure Filter HTML format if it exists. If textile is selected you 
need to go back and rename HTML filter to textile.  Then add a new 
filter called HTML filter.  Add the administrator permission check box 
for the new HTML filter.  Then configure the new HTML filter.  Select 
HTML filter, line break, and URL filter.  Then click on configure 
filter tab.  There should be a list of acceptable HTML tags but Charlie 
Lowe would have the complete list of used HTML tags.
7) We can now go back to the main filters admin and look at the filter 
number in the url:http://www.yoursite.com/admin/filters/SOMENUMBER.   
The node table has a format column and we need to set the whole column 
=SOMENUMBER.  Select Distinct Format FROM node to see how many filters 
your site has.   If you have only one filter then in the node table set 
the nid += high node number, uid = 1, format =SOMENUMBER.
8) Add CC Share Alike Attribution to each page, probably need a MySQL 
update command to do this.

It's even more fun for the Drupal Documentation.  We get to add a few 
steps:
9) Figure out what the top node is in the Drupal Docs.  Figure out what 
portion of the tree I need.  I might have to write a tree walking 
algorithm.  I need four tables in my database: A drupaldoc_book table 
and drupaldoc_node table and insert what I like from the drupaldoc 
tables into a parallel set of subset_book tables and subset_node 
tables.
10) Drupal org has php  pages that includes stuff from CVS.  So they 
will have multiple filters.  You have to make a note of the different 
filters and you have to figure out something to do with these filters.  
This will probably need a lot of hand tuning.

So this seems really hard.  Ideally I'd like to make it easy for people 
to install documentation on their own sites.   Help would be greatly 
appreciated.  You can edit these instructions here: 
http://dev.bryght.com/t/wiki/DrupalDocInterchange

Cheers,
Kieran