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

[Metzler, David]

You might consider using a project I created called Forena.  It's report
writing software and can report directly against tables in drupal or
other databases.  In this fashion you could display the booking data
directly without having to try and create nodes from an MS access
database.  

 

It would probably be easier to write a custom drupal module to update
the booking table structures than to get MS access to create nodes in
drupal.  The primary problem is that you'd have to be rewriting much of
the cck logic in Access which seems like a lot of work, not no mention
some data structures in drupal are serialized php objects, so there
would be a lot of parsing code that would need to be written for this.
There are no non-php apis.  

 

Creating php code to update a booking structure in drupal on the other
hand seems really straightforward to me.  I do this kind of development
work in drupal all the time. 

 

________________________________

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

 

Hi,

 

I am creating a booking management application and the bookings are
largely generated and managed from a MS Access front end working
directly on a MySQL database.. Now we need to integrate these bookings
into the Drupal website so that users can add or update bookings for
themselves..

 

I have created a content type with the required fields and now need to
work out how to create content directly with SQL from MS Access..

 

Has anyone ever created content this way or have any idea which tables
need records created/updated??

 

Unfortunately the system needs to be able to be updated from the Drupal
site and from the MS Access application so imports and feeds won't
work..

 

Thanks for any ideas or help..

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