[support] Create and manage content directly from the database.

[Metzler, David]

If you are not the world's greatest programmers, I'd strongly recommend
you abandon this approach.  It will not be straightforward.   Go ahead
and look at the revisions tables and see that there are large text
fields that contain data serialized by php's serialize function, and
that's just this tip of the iceberg in terms of complexity you will
encounter.  You are basically facing rewriting drupal and some of PHP
in  Access!   This is not simple stuff. Also Earnie is right that you be
failing to fire the required hooks if you operate on the database tables
directly, so the features that you talk about in drupal will not really
be available to you. 

 

I would strongly recommend give the other approach more serious
consideration.  If you run into trouble there you are much more likely
to get meaningful and helpful support from the drupal community on this
endeavor. 

 

Dave

 

. 

 

 

 

 

 

 

________________________________

From: support-bounces at drupal.org [mailto:support-bounces at drupal.org] On
Behalf Of Wipe_Out
Sent: Thursday, June 07, 2012 9:57 AM
To: support at drupal.org
Subject: Re: [support] Create and manage content directly from the
database.

 

 

On 7 June 2012 17:24, Earnie Boyd <earnie at users.sourceforge.net> wrote:

On Thu, Jun 7, 2012 at 11:22 AM, Metzler, David <metzlerd at evergreen.edu>
wrote:
> Unless I misunderstand this question he's asking about how to create
> nodes in a mysql database using MS access as the development tool.
The
> nodes he's asking to create are CCK crafted nodes in drupal.
>

He is asking how to update the tables created by the MSACCESS tool in
an external MySql DB.  You can connect to the external DB with Drupal
and use Drupal to display and update the data.  You don't need to
create Drupal nodes to do that.

 

 

@Ernie - That was where we started but since we are not the worlds
greatest programmers we are looking to switch it the other way around
and get MS Access to work on the Drupal tables.. This way we can use
"Views", "Rules", "References" and all the other available Drupal
functionality as well..

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20120607/e6b10555/attachment.html