Troubleshooting
If something doesn't look right, please get in touch. If you like getting your hands dirty and would like to dig into this yourself, we hope the following walkthroughs will help.
Note, there isn't much to set up for Google or Basecamp sources, so not much can go wrong. Salesforce and FileMaker data sources have a lot of options, though, so you'll see common issues for those sources below.
Troubleshooting in Salesforce
I'm unable to authorize DayBack
If you're logged in a less than a system administrator, it may be that your user privileges don't include authorizing new apps: you'll want to ask a system administrator for help.
If you are a system admin the Salesforce might just be getting confused between your single-sign-on and sandbox logins. To fix this you can change the Connected App settings to pre-authorize by profile, and that will bypass the authorization step. Information on how to do this can be found here under "Authorizing Users."
All I see is a frowny face on the DayBack tab in my org
This is likely because your network is blocking the dayback.com domain. To doublecheck, try and open http://app.dayback.com in your browser. If you don't see a login page, then your network is blocking the domain: ask your IT department to "whitelist" dayback.com and you'll be all set.
The progress indicator keeps going and my items don't show up in the calendar
The most likely reason for this is that something in your Field Mapping isn't pointing at a field in your Salesforce table. A common example is that you've mapped to a custom field but haven't used the Salesforce name for the field in field mapping: custom fields will have a suffix "__c" so your field "SomeText" will be named "SomeText__c" in Salesforce and that's the name you should use in field mapping.
I can't create or edit campaigns in DayBack
Modifying campaigns requires that the user is assigned the "Marketing User" permission. Visit your permissions in Setup and see if "Marketing Users" is checked. If not ask your Salesforce admin to turn his privilege on for you.
Assigned To ID: Owner cannot be left blank
If you see this warning when dragging an item to the none column in resource scheduling it's because the field you've mapped to Resource will not accept blank values. That's the case for the "Owner" field DayBack uses by default as the resource for Events, Tasks, and Campaigns. You can map this to another field of your own which will accept blank values.
Only System Administrators can see some events
If you're in Salesforce Classic. there are some interesting restrictions that Salesforce imposes on the visibility of shared calendars. These are described here, but the relevant fact is that "The 'Related To' and/or 'Name' field must be completed, or the Activity will be deemed Private regardless of other sharing settings (such as Calendar Sharing). For example, even if a user shares their calendar with 'Full Access' all events that are not associated with another record will be Private.”
Troubleshooting FileMaker Server
Background
The troubleshooting here is for administrators configuring DayBack. Most of this will be looking at the results of tests you can run to examine your config. You'll find this test towards the bottom of the Source Settings screen once you've selected your source:
General Improvements
FileMaker Web Publishing will pull data from every field on your layout, even though DayBack only needs some of the fields in your table. So to speed up your queries, and to reduce the possibility that bad data is getting sent to DayBack, be sure that the layout specified in DayBack admin's Source Settings only contains the fields DayBack requires.
What's Wrong?
My server settings test aren't doing anything
If you click "Test Source Settings" and don't get any results, it is likely because DayBack can't see your FileMaker Server at all. Check that the server address is correct and that
XML Web Publishing is enabled for your server.
My server settings test are failing
If you get an orange failed sign for the PHP Relay file it likely means your
PHP relay file isn't there or is in the wrong place. It could also be that PHP isn't running on your FileMaker Server.
If you get an orange failed sign that says the DayBack account doesn't exist in your PHP Relay file it likely means that you have set the variable "$loginByName" to true in PHP Relay file and there is not a match for the DayBack account in the if statement to determine the correct FileMaker account.
If you get an orange failed sign on the FileMaker file there are a few things to check.
Begin by testing to make sure XML web publishing is running. You can do this by manually typing the following into your browser, replacing "serverAddress" with the server address you entered in DayBack's configuration:
If you get results in the test above and see your file listed there but got "0" or "1" byte downloaded in your test details, then your PHPrelay file is in the wrong place. Double-check that the location is one of the ones listed
here in "Where does the file go?" You can test that you have the relay in the correct location by entering this URL:
That should return the phpinfo on your server if the relay is in the right spot and PHP is running. Remember, if you connect to dayback.com over https and your PHP relay / fmserver is only on http then you will get that error that it couldn't connect to the PHP relay file. So if your relay file is http you need to log into
https://app.dayback.com instead of
https://app...
Tip: If you're not getting the correct expected output, such as file not found or a 500 error, try replacing your PHPRelay file with the downloaded, untouched version. If that works, then your PHP service is functioning correctly. Make sure you've used a plain text editor, as mentioned in our docs
here. Also, verify that there aren't any commas or quotes that have been accidentally deleted where the file was edited.
Once you're getting something more than 1 byte returned in test details or results at the URL above you'll have the PHP relay file in the right place and can make sure the rest of your configuration is correct. If the URL tests above are passing but you still can't get the PHP file to work AND you're using "localhost" in your PHP file, it could be that your server/hosting provider has settings preventing that: try replacing "localhost" with your server IP address.
Check the test details to see, for example, that the filename you entered is one of the file names on your server. Only files with XML web publishing enabled show up, so make sure it's enabled for your file.
Same thing with layouts: check the test details to see which layouts DayBack can see in your FileMaker file. It's likely that your spelling is wrong (remember that these entries are case sensitive).
My server settings test passed but I can't see any events
If you have green lights on your tests but no events I'd check the fields mapped to the "TimestampNum calc start" and "...end" fields. Are these calcs defined to return numbers? Note that if you paste in our example field definition you need to point parts of the "Let" statements at your own date and time fields: double-check that you picked the right fields from your table.
The TimeStampNum Calc End field is required to be mapped, even if you've disabled it in the settings. If you don't enter a valid field, you will receive the following error when loading the calendar: "There was an error retrieving FileMaker events: 4 - Command is unknown"
If you're continually seeing the 3 loading dots in the calendar header, make sure that the FileMaker user assigned in the PHP Relay file has access to view
all
of the fields on the source's layout. This includes fields on the layout that are not used for DayBack Online and any hidden fields that may be off to the side of the layout. If those fields are necessary for a user interface, then it's probably best to create a new layout, specifically for DayBack Online.
I can see some events but they're all on the wrong date or for multiple days
This likely means that your "TimestampNum calc start" and "...end" fields described above are returning numbers but the calcs themselves aren't correct or only one of them is (only the start or end calc).
I can see bars for my events but no text
Double-check the field mapped to "Event display calc" and make sure it's returning a value on your FileMaker layout.
None of my events have any colors
You'll see event colors when the values in the field you've mapped to "Status" match the values in the calendar's Status Filters (these are on the Filters tab of the calendar sidebar).
If you're not seeing colors it's because the field you've mapped doesn't contain one of the status values in the sidebar.
Some tips for errors you might see when dragging events around or editing them...
Errors when editing events
Error 102
102 means a "field is missing" so it sounds like DayBack Online is trying to write your event back to FileMaker but can't find one of the fields it needs. This is probably because one of the fields you've mapped got removed from the layout you specified or the field got deleted from your table.
I'd return to Source Settings and re-run the tests towards the bottom of the page to see which field(s) this might be. You can also revisit the layout you specified (probably "Source No 1" if you're using DayBack for FileMaker also) and make sure the fields are mapped to fields in your table.
Error 201
"Field Can't Be Modified." Make sure that the fields you mapped are writable; that is, not calculation fields. Of the fields DayBack Online asks for, only the three that have "calc" in the name may be calculated fields.
If you are using a calc field for any of the other fields, try changing it to a Text field, then set it up to auto-enter a calculated value instead. You might also check that the account you've set up in the
PHP relay uses a privilege set with write privileges to all the fields you mapped.
Error 500
"There was an error saving the event and your changes will be reverted: 500 - Date value does not meet validation entry options." When you see this it likely means that the Date Format in your Source Settings doesn't match that in your file. To begin with, the format needs to be all capital letters like MM/DD/YYYY. To be sure the setting here matches your file, click on "Test Source Settings" then "Show Test Details" and scan down through the results until you find "Fields Available on Layout..." below that you'll see the date format of your file. it likely looks like this:
"DATEFORMAT": "MM/dd/yyyy"
Then make sure that the settings you've entered into DayBack are the uppercase version of the format you find here.
Error 959
Error 959 lets you know that a dependant technology has been disabled on the FileMaker Server. DayBack Online depends on the XML and PHP web publishing technologies. Starting in FileMaker 17, XML and PHP web publishing
must be enabled using the command-line interface. Details on how to enable XML and PHP web publishing on FileMaker 17+ can be found in FileMaker's docs here:
https://fmhelp.filemaker.com/help/18/fms/en/index.html#page/FMS_Help/config-webpub-php.html
Error 8003
Error 8003 is returned when the event record you are trying to modify is locked for editing in FileMaker. If you receive this error, someone else is actively modifying that event record. It's probably best to revert the changes and refresh the calendar to make sure you're seeing the most recent data before editing that event.
