Integrating the latest DayBack into an FM14 file.

Got the majority of things done as per the integration instructions. I can add events (using the SampleEvents table), Resources working. The Event shows up on the calendar, but whenever the Calendar gets refreshed either by the Refresh button or changing views the event vanishes. The record is still in the table but doesn't display.

Any suggestions? I know I've likely missed something or done it incorrectly.

Dave Zakary

I'm having the same problem. It appears that I am using version 9.61. The event does appear on the Month calendar and in the Week and Day List calendars but not the 'Schedule' versions of those two calendars.

One potential difference from the original poster is that my events disappear almost immediately after I click on the Safe button. As I said they are there in the respective list views. And I can click on the 'Refresh' button on those layouts and nothing disappears.

Zakary and Oakbridge,

Thanks so much for reaching out here. I do think these issues are similar, but not quite the same.

Zakary, since it appears you can create events on the calendar, but they disappear when the calendar refreshes, check that the date and time fields that you've mapped in you DBk_WebViewerSource field match the fields that are mapped on your Source No X layout. My hunch is that the date fields are not mapped correctly in the WebViewerSource calc field, causing them to not display on the calendar.

Oakbridge, I think there are two possible causes. We corrected a small bug in v9.61 where some events seem to disappear on different views. Run the "check for updates" on the Account Settings dialog, and get updated to v9.63 (no FileMake changes required, since you have already upgraded to v9.61. Then check if your events display as expected.
Another possibility: since your event appears on all views except Schedule views, the event end dates may be before (less than) the start dates. This would cause events to not display on the Schedule views. To correct this, you can force the DateEnd to always be greater than or equal to the DateStart, by adding this auto-enter calc and un-checking "Do not replace..."

Case (
not IsEmpty ( Self ) and Self < DateStart ;
DateStart ;
Self
)

I hope this helps! Please let me know if you have any other questions.

All the best,
Dan Wheelon
[email protected]

Thanks for the suggestion. Something still isn't correct. When I run the Upon Opening script I get an error that I need to update scripts - doesn't tell me which script it is though.

I'm using the SampleEvents table from the DayBack file. I'm not using Projects, Phases or Status for this integration and have commented out a couple of lines for the mapping of those.

The Source No 1 layout seems to be fully mapped with the exception of the Gantt tab.
Source No 2 is mapped again with the exception of the Gantt tab.

Related No 1 is mapped to my Contacts table and the two fields there are mapped correctly
Related No 2 is mapped to the Sample Projects, but I'm not using it.

Dave Zakary

Zakary,

Thanks for the additional info here. I'd love to take a closer look at your files to try to get to the bottom of this here, so feel free to send us a copy.

If the file(s) zip under 15MB, then you can e-mail them to us at [email protected]. If they're bigger than that, you can use a service like http://www.sendbigfiles.com/ to get them to us. Please include the full access account info.

Thank you!

Dan
[email protected]