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

[Metzler, David]

That sounds more feasible.  Note that drupal date and time fields are
likely unix timestamps, so you my run into troubles converting from
access times to date times, but provided you can get that date math to
work out, it seems plausible. 

 

 

 

________________________________

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

 

Ok, working on that theory would this be a more feasible/logical
approach based on our level of code programming ability..

 

1. In order to create the bookings we generate a CSV from MS Access and
use something like the "Feeds" module to import it.. This should handle
the node creation for bulk generated bookings right??

 

2. Users then make changes to the bookings through Drupal rather than
access which solves that aspect..

 

3. For billing purposes I assume its not a problem to query the data
from the Drupal tables from access..

 

This leaves one potential issue..

 

In the booking there is a "Date" field for booked time and a second
"Date" field for actual time (both fields part of the same node so would
be created when its generated)..

 

We have an external interface used for clocking actual start and end
times which would need to update the values of the actual time field..
Would it be a problem to only UPDATE these DateTime values from an
interface outside of Drupal??

 

Thanks..

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