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@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Wipe_Out
Sent: Thursday, June 07, 2012
11:17 AM
To:
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..