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

[Wipe_Out]

On 7 June 2012 18:43, Metzler, David <metzlerd at evergreen.edu> wrote:

>
> I agree with Earnie, the best advice is to hire a developer/consultant to
> work through this with/for you.   Or to convince your Access users to
> modify the data in drupal instead of the access.
>
>
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/409bb2f4/attachment.html