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

[Earnie Boyd]

On Thu, Jun 7, 2012 at 1:00 PM, Earnie Boyd
<earnie at users.sourceforge.net> wrote:
> 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

or separate table, it doesn't have to be an external DB.

> 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