On 7 June 2012 18:43, Metzler, David metzlerd@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..