Databases
StackOverflow2013
Postsdbo
POHow would the conversion of a custom CMS using a text-file-based database to Drupal be tackled?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow would the conversion of a custom CMS using a text-file-based database to Drupal be tackled?
    text
    copied!<p>Just today I've started using Drupal for a site I'm designing/developing. For my own site <a href="http://jwm-art.net" rel="nofollow noreferrer">http://jwm-art.net</a> I wrote a user-unfriendly CMS in PHP. My brief experience with Drupal is making me want to convert from the CMS I wrote. A CMS whose sole method (other than comments) of automatically publishing content is by logging in via SSH and using NANO to create a plain text file in a format like so*:</p> <pre><code> head&lt;&lt;END_HEAD title = Audio keywords= open,source,audio,sequencing,sampling,synthesis descr = Music, noise, and audio, created by James W. Morris. parent = home END_HEAD main&lt;&lt;END_MAIN text&lt;&lt;END_TEXT Digital music, noise, and audio made exclusively with @=xlink=http://www.linux-sound.org@:Linux Audio Software@_=@. END_TEXT image=gfb@--@;Accompanying image for penonpaper-c@right ilink=audio_2008 br= ilink=audio_2007 br= ilink=audio_2006 END_MAIN info=text&lt;&lt;END_TEXT I've been making PC based music since the early nineties - fortunately most of it only exists as tape recordings. END_TEXT </code></pre> <p>( <a href="http://jwm-art.net/dark.php?p=audio" rel="nofollow noreferrer">http://jwm-art.net/dark.php?p=audio</a> - There's just over 400 pages on there. )</p> <p>*The jounal-entry form which takes some of the work out of it, has mysteriously broken. And it still required SSH access to copy the file to the main dat dir and to check I had actually remembered the format correctly and the code hadn't mis-formatted anything (which it <strong>always</strong> does).</p> <p>I don't want to drop all the old content (just some), but how much work would be involved in converting it, factoring into account I've been using Drupal for a day, have not written any PHP for a couple of years, and have zero knowledge of SQL?</p> <p>How would I map the abstraction in the text file above so that a user can select these elements in the page-publishing mechanism to create a page?</p> <p>How might a team of developers tackle this? How do-able is it for one guy in his spare time?</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload