<div class="gmail_quote">On 7 June 2012 18:43, Metzler, David <span dir="ltr"><<a href="mailto:metzlerd@evergreen.edu" target="_blank">metzlerd@evergreen.edu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
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.<br>
<br></blockquote><div><br></div><div>Ok, working on that theory would this be a more feasible/logical approach based on our level of code programming ability..</div><div><br></div><div>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??</div>
<div><br></div><div>2. Users then make changes to the bookings through Drupal rather than access which solves that aspect..</div><div><br></div><div>3. For billing purposes I assume its not a problem to query the data from the Drupal tables from access..</div>
<div><br></div><div>This leaves one potential issue..</div><div><br></div><div>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)..</div>
<div><br></div><div>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??</div>
<div><br></div><div>Thanks..</div></div>