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

[Earnie Boyd]

On Thu, Jun 7, 2012 at 12:46 PM, Wipe_Out wrote:
> Hi Dave and Ernie,
>
> Maybe a bit more explanation will help..
>
> We have a home baked MS access billing application that we use to generate
> and manage the bookings and bill based on those bookings.. The
> administration in managing all the bookings is getting to be too much so we
> want our customers to be able to manage and edit their bookings through our
> website..
>
> This needs to be a two way process so bookings can still be managed through
> the MS Access side but can also be managed through the web interface..
>
> It seemed easiest to create a new content type with all the required fields
> and references through Drupal and then get MS access to manage the same data
> tables in the mysql database.. The would mean creating, updating and
> deleting bookings nodes directly in the database from MS access..
>
> From your comments it sounds like you are saying that its not as straight
> forward as that to manage Drupal's data.. I thought that by simply updating
> the "node" table along with all the "field" and "revision" tables that we
> could add or edit booking nodes from the backend while durpal managed it
> from the front..
>
> Is this not the case??

You don't want to update the node tables directly.  You would miss out
on the hook implementations.  You need to create a node object and use
node_save() to do it.  You could manage this by creating a custom
module to push and pull the changes to an external DB for the ms
access entries via a hook_cron implementation.  There may be a module
already to do this but I don't know.

-- 
Earnie
-- https://sites.google.com/site/earnieboyd