Troubleshooting
SeedCodeCalendar12.Troubleshooting History
Hide minor edits - Show changes to output
June 15, 2021, at 03:46 PM
by - Added section on the endless loop issue with newer versions of FileMaker
Added lines 23-29:
[[#loop]]
!! My calendar is stuck in an endless loop and never loads
This issue seems to happen when upgrading the file in the process of moving to FileMaker 17+. The file update process doesn't handle the date formats correctly, causing this endless loop.
To fix this, you'll need to [[https://fmhelp.filemaker.com/help/18/fmp/en/index.html#page/FMP_Help/save-a-copy-as.html|save a clone copy of the file]], create at least one new record/event in the calendar, then import the data from the old file into this new file.
The calendar ''should'' work in the new file through FileMaker 19. However, this calendar was built for FileMaker 12-13 and has been replaced by the [[https://dayback.com/filemaker-calendar-add-on/|new DayBack calendar]]. We don't officially support this calendar in FileMaker 14+ and, at some point, it will not work in newer builds of FileMaker at all.
!! My calendar is stuck in an endless loop and never loads
This issue seems to happen when upgrading the file in the process of moving to FileMaker 17+. The file update process doesn't handle the date formats correctly, causing this endless loop.
To fix this, you'll need to [[https://fmhelp.filemaker.com/help/18/fmp/en/index.html#page/FMP_Help/save-a-copy-as.html|save a clone copy of the file]], create at least one new record/event in the calendar, then import the data from the old file into this new file.
The calendar ''should'' work in the new file through FileMaker 19. However, this calendar was built for FileMaker 12-13 and has been replaced by the [[https://dayback.com/filemaker-calendar-add-on/|new DayBack calendar]]. We don't officially support this calendar in FileMaker 14+ and, at some point, it will not work in newer builds of FileMaker at all.
Changed line 38 from:
There is also a known issue with events appearing on the wrong day when settings have been adjusted to show more than 72 portal rows, or more than 24 hours in a column. We've fixed this issue in [http://www.seedcode.com/pmwiki/index.php?n=DayBackForFileMaker.DayBackForFileMaker|DayBack], but the solution for Pro Calendar users is to avoid exceeding those settings.
to:
There is also a known issue with events appearing on the wrong day when settings have been adjusted to show more than 72 portal rows, or more than 24 hours in a column. We've fixed this issue in [[DayBackForFileMaker|DayBack]], but the solution for Pro Calendar users is to avoid exceeding those settings.
Changed line 38 from:
There is also a known issue with events appearing on the wrong day when settings have been adjusted to show more than 72 portal rows, or more than 24 hours in a column. We've fixed this issue in [DayBackForFileMaker.DayBackForFileMaker|DayBack], but the solution for Pro Calendar users is to avoid exceeding those settings.
to:
There is also a known issue with events appearing on the wrong day when settings have been adjusted to show more than 72 portal rows, or more than 24 hours in a column. We've fixed this issue in [http://www.seedcode.com/pmwiki/index.php?n=DayBackForFileMaker.DayBackForFileMaker|DayBack], but the solution for Pro Calendar users is to avoid exceeding those settings.
Changed line 38 from:
There is also a known issue with events appearing on the wrong day when settings have been adjusted to show more than 72 portal rows, or more than 24 hours in a column. We've fixed this issue in [DayBackForFileMaker|DayBack], but the solution for Pro Calendar users is to avoid exceeding those settings.
to:
There is also a known issue with events appearing on the wrong day when settings have been adjusted to show more than 72 portal rows, or more than 24 hours in a column. We've fixed this issue in [DayBackForFileMaker.DayBackForFileMaker|DayBack], but the solution for Pro Calendar users is to avoid exceeding those settings.
Changed line 38 from:
There is also a known issue with events appearing on the wrong day when settings have been adjusted to show more than 72 portal rows, or more than 24 hours in a column. We've fixed this issue in DayBack, but the solution for Pro Calendar users is to avoid exceeding those settings.
to:
There is also a known issue with events appearing on the wrong day when settings have been adjusted to show more than 72 portal rows, or more than 24 hours in a column. We've fixed this issue in [DayBackForFileMaker|DayBack], but the solution for Pro Calendar users is to avoid exceeding those settings.
Changed lines 36-38 from:
This is usually caused by carriage returns or other uncommon characters in your data. The most common cause is a trailing carriage return in one of the fields used in your zscEventSummaryCalc field (most likely the Summary or Description field), or ANY carriage return in your Status field (the calendar does not support multiple values in the Status field).
to:
This is usually caused by carriage returns or other uncommon characters in your data. The most common cause is a trailing carriage return in one of the fields used in your zscEventSummaryCalc field (most likely the Summary or Description field), or ANY carriage return in your Status field (the calendar does not support multiple values in the Status field).
There is also a known issue with events appearing on the wrong day when settings have been adjusted to show more than 72 portal rows, or more than 24 hours in a column. We've fixed this issue in DayBack, but the solution for Pro Calendar users is to avoid exceeding those settings.
There is also a known issue with events appearing on the wrong day when settings have been adjusted to show more than 72 portal rows, or more than 24 hours in a column. We've fixed this issue in DayBack, but the solution for Pro Calendar users is to avoid exceeding those settings.
Changed lines 32-36 from:
Just don't go to one of the actual calendar layouts just to get to a layout based on CalendarInterface, since those layout are script triggered and could delay / loop your startup.
to:
Just don't go to one of the actual calendar layouts just to get to a layout based on CalendarInterface, since those layout are script triggered and could delay / loop your startup.
!! Events are appearing in the wrong place
This is usually caused by carriage returns or other uncommon characters in your data. The most common cause is a trailing carriage return in one of the fields used in your zscEventSummaryCalc field (most likely the Summary or Description field), or ANY carriage return in your Status field (the calendar does not support multiple values in the Status field).
!! Events are appearing in the wrong place
This is usually caused by carriage returns or other uncommon characters in your data. The most common cause is a trailing carriage return in one of the fields used in your zscEventSummaryCalc field (most likely the Summary or Description field), or ANY carriage return in your Status field (the calendar does not support multiple values in the Status field).
Changed lines 9-22 from:
->''' 2.''' Click on the filters tab: if "Clear" is showing up in red, click "clear" to empty the filters. You may have been "searching" for events that don't have any matches. If you have multiple sources, visit the sources tab and select them one at a time to see if one source is the problem.
-> '''3.''' Check out the Source No 1 layout in browse mode, reviewing every tab: are there any errors shown? Do the timestamp fields show the same date / time as the date / time fields? (If not, skip to no 6 below.)
-> '''4.''' Take a lookat the calc fields in CalendarRows and make sure nothing has been commented out (commented calcs begin with /* and end with */). You may be able to just remove the comments from the calcs and they'll work. Check the auto enter calc definitions as well, such as those for DateRangeStartAutoGlob and DateRangeEndAutoGlob.
-> '''5.''' Check your system's date formats. If you're using a customized date format switch to one of the standard formats like United Kingdom and then close and re-open FileMaker. It is unusual, but stray characters in the date format can screw up the calendar. If switching formats repairs it, slowly add your customizations again checking that the calendar continues to recognize them.
->'''6.''' Take a look at the date and time fields you're using in the timestamp fields you pasted into your events table: are these defined as date and time respectively, or are they text. (Text will not work.) Also, make sure these timestamp calcs reference the same date and time fields you've mapped to on your Source No X layout. So if you're using a field called "Start Date" on Source No 1, make sure the time stamp calc uses "Start Date" and not something else like "Order Date". (Later, you can make a different source for Order Date.) This is especially something to look at if you have [[MultipleSources | more than one source]]; if the sources are using different date and time fields they'll need different timestamp calcs.
-> '''7.''' If you're having display issues, make sure the calendar layouts only have a body part; there should be no header or footer parts on the 4 main calendar layouts.
-> '''8.''' Make sure you don't have any folders with the same names as your layouts: notably that you don't have a folder named "calendar". Also make sure the name of your file doesn't contain a period in the last 4 characters.
->
-> '''4.''' Take a look
->
-> '''7.''' If you're having display issues, make sure the calendar layouts only have a body part; there should be no header or footer parts on the 4 main calendar layouts
-> '''8.''' Make sure you don't have any folders with the same names as your layouts: notably that you don't have a folder named "calendar". Also make sure the name of your file doesn
to:
-> '''2.''' Make sure you don't have any folders with the same names as your layouts: notably that you don't have a folder named "calendar". Also make sure the name of your file doesn't contain a period in the last 4 characters. More on these two issues here: [[YourFile | changes to your file]].
->''' 3.''' Click on the filters tab: if "Clear" is showing up in red, click "clear" to empty the filters. You may have been "searching" for events that don't have any matches. If you have multiple sources, visit the sources tab and select them one at a time to see if one source is the problem.
-> '''4.''' Check out the Source No 1 layout in browse mode, reviewing every tab: are there any errors shown? Do the timestamp fields show the same date / time as the date / time fields? (If not, skip to no 6 below.)
-> '''5.''' Take a look at the calc fields in CalendarRows and make sure nothing has been commented out (commented calcs begin with /* and end with */). You may be able to just remove the comments from the calcs and they'll work. Check the auto enter calc definitions as well, such as those for DateRangeStartAutoGlob and DateRangeEndAutoGlob.
-> '''6.''' Check your system's date formats. If you're using a customized date format switch to one of the standard formats like United Kingdom and then close and re-open FileMaker. It is unusual, but stray characters in the date format can screw up the calendar. If switching formats repairs it, slowly add your customizations again checking that the calendar continues to recognize them.
-> '''7.''' Take a look at the date and time fields you're using in the timestamp fields you pasted into your events table: are these defined as date and time respectively, or are they text. (Text will not work.) Also, make sure these timestamp calcs reference the same date and time fields you've mapped to on your Source No X layout. So if you're using a field called "Start Date" on Source No 1, make sure the time stamp calc uses "Start Date" and not something else like "Order Date". (Later, you can make a different source for Order Date.) This is especially something to look at if you have [[MultipleSources | more than one source]]; if the sources are using different date and time fields they'll need different timestamp calcs.
-> '''8.''' If you're having display issues, make sure the calendar layouts only have a body part; there should be no header or footer parts on the 4 main calendar layouts.
->''' 3.''' Click on the filters tab: if "Clear" is showing up in red, click "clear" to empty the filters. You may have been "searching" for events that don't have any matches. If you have multiple sources, visit the sources tab and select them one at a time to see if one source is the problem.
-> '''4.''' Check out the Source No 1 layout in browse mode, reviewing every tab: are there any errors shown? Do the timestamp fields show the same date / time as the date / time fields? (If not, skip to no 6 below.)
-> '''5.''' Take a look at the calc fields in CalendarRows and make sure nothing has been commented out (commented calcs begin with /* and end with */). You may be able to just remove the comments from the calcs and they'll work. Check the auto enter calc definitions as well, such as those for DateRangeStartAutoGlob and DateRangeEndAutoGlob.
-> '''6.''' Check your system's date formats. If you're using a customized date format switch to one of the standard formats like United Kingdom and then close and re-open FileMaker. It is unusual, but stray characters in the date format can screw up the calendar. If switching formats repairs it, slowly add your customizations again checking that the calendar continues to recognize them.
-> '''7.''' Take a look at the date and time fields you're using in the timestamp fields you pasted into your events table: are these defined as date and time respectively, or are they text. (Text will not work.) Also, make sure these timestamp calcs reference the same date and time fields you've mapped to on your Source No X layout. So if you're using a field called "Start Date" on Source No 1, make sure the time stamp calc uses "Start Date" and not something else like "Order Date". (Later, you can make a different source for Order Date.) This is especially something to look at if you have [[MultipleSources | more than one source]]; if the sources are using different date and time fields they'll need different timestamp calcs.
-> '''8.''' If you're having display issues, make sure the calendar layouts only have a body part; there should be no header or footer parts on the 4 main calendar layouts.
Changed lines 21-22 from:
-> '''8.''' Make sure you don't have any folders with the same names as your layouts: notably that you don't have a folder named "calendar".
to:
-> '''8.''' Make sure you don't have any folders with the same names as your layouts: notably that you don't have a folder named "calendar". Also make sure the name of your file doesn't contain a period in the last 4 characters.
Changed lines 29-30 from:
I imagine the reason it is deleting and creating them each time you launch is that the script is no loner running from a layout were it can evaluate "CalendarRows::RowNumber". If you change the beginning of the script to go to a layout based on CalendarInterface (where our home layout is / used to be) the script should only reset the CalendarRows table if there is a problem.
to:
I imagine the reason it is deleting and creating them each time you launch is that the script is no longer running from a layout were it can evaluate "CalendarRows::RowNumber". If you change the beginning of the script to go to a layout based on CalendarInterface (where our home layout is / used to be) the script should only reset the CalendarRows table if there is a problem.
Added lines 22-31:
!! My startup script keeps deleting and re-creating the calendar interface records, is this normal?
No. But it isn't lethal either. Here is how to fix it.
As you probably know, the calendar requires some dummy records in a table called CalendarRows. Our script " Load Calendar Settings - On Startup --- Edit Configuration Here ---" tries to make sure that users haven't deleted, duplicated, or created new records in this table.
I imagine the reason it is deleting and creating them each time you launch is that the script is no loner running from a layout were it can evaluate "CalendarRows::RowNumber". If you change the beginning of the script to go to a layout based on CalendarInterface (where our home layout is / used to be) the script should only reset the CalendarRows table if there is a problem.
Just don't go to one of the actual calendar layouts just to get to a layout based on CalendarInterface, since those layout are script triggered and could delay / loop your startup.
Changed lines 19-21 from:
-> '''7.''' If you're having display issues, make sure the calendar layouts only have a body part; there should be no header or footer parts on the 4 main calendar layouts.
to:
-> '''7.''' If you're having display issues, make sure the calendar layouts only have a body part; there should be no header or footer parts on the 4 main calendar layouts.
-> '''8.''' Make sure you don't have any folders with the same names as your layouts: notably that you don't have a folder named "calendar".
-> '''8.''' Make sure you don't have any folders with the same names as your layouts: notably that you don't have a folder named "calendar".
Changed lines 9-10 from:
->''' 2.''' Click on the filters tab: if "Clear" is showing up in red, click "clear" to empty the filters. You may have been "searching" for events that don't have any matches.
to:
->''' 2.''' Click on the filters tab: if "Clear" is showing up in red, click "clear" to empty the filters. You may have been "searching" for events that don't have any matches. If you have multiple sources, visit the sources tab and select them one at a time to see if one source is the problem.
Changed lines 11-12 from:
-> '''3.''' Check out the Source No 1 layout in browse mode, reviewing every tab: are there any errors shown?
to:
-> '''3.''' Check out the Source No 1 layout in browse mode, reviewing every tab: are there any errors shown? Do the timestamp fields show the same date / time as the date / time fields? (If not, skip to no 6 below.)
Changed lines 17-18 from:
-> '''6.''' Take a look at the date and time fields you're using in the timestamp fields you pasted into your events table: are these defined as date and time respectively, or are they text. (Text will not work.) Also, make sure these timestamp calcs reference the same date and time fields you've mapped to on your Source No X layout. So if you're using a field called "Start Date" on Source No 1, make sure the time stamp calc uses "Start Date" and not something else like "Order Date". (Later, you can make a different source for Order Date.)
to:
-> '''6.''' Take a look at the date and time fields you're using in the timestamp fields you pasted into your events table: are these defined as date and time respectively, or are they text. (Text will not work.) Also, make sure these timestamp calcs reference the same date and time fields you've mapped to on your Source No X layout. So if you're using a field called "Start Date" on Source No 1, make sure the time stamp calc uses "Start Date" and not something else like "Order Date". (Later, you can make a different source for Order Date.) This is especially something to look at if you have [[MultipleSources | more than one source]]; if the sources are using different date and time fields they'll need different timestamp calcs.
Changed lines 17-19 from:
-> '''6.''' Take a look at the date and time fields you're using in the timestamp fields you pasted into your events table: are these defined as date and time respectively, or are they text. (Text will not work.)
to:
-> '''6.''' Take a look at the date and time fields you're using in the timestamp fields you pasted into your events table: are these defined as date and time respectively, or are they text. (Text will not work.) Also, make sure these timestamp calcs reference the same date and time fields you've mapped to on your Source No X layout. So if you're using a field called "Start Date" on Source No 1, make sure the time stamp calc uses "Start Date" and not something else like "Order Date". (Later, you can make a different source for Order Date.)
-> '''7.''' If you're having display issues, make sure the calendar layouts only have a body part; there should be no header or footer parts on the 4 main calendar layouts.
-> '''7.''' If you're having display issues, make sure the calendar layouts only have a body part; there should be no header or footer parts on the 4 main calendar layouts.
Changed lines 15-17 from:
-> '''5.''' Check your system's date formats. If you're using a customized date format switch to one of the standard formats like United Kingdom and then close and re-open FileMaker. It is unusual, but stray characters in the date format can screw up the calendar. If switching formats repairs it, slowly add your customizations again checking that the calendar continues to recognize them.
to:
-> '''5.''' Check your system's date formats. If you're using a customized date format switch to one of the standard formats like United Kingdom and then close and re-open FileMaker. It is unusual, but stray characters in the date format can screw up the calendar. If switching formats repairs it, slowly add your customizations again checking that the calendar continues to recognize them.
-> '''6.''' Take a look at the date and time fields you're using in the timestamp fields you pasted into your events table: are these defined as date and time respectively, or are they text. (Text will not work.)
-> '''6.''' Take a look at the date and time fields you're using in the timestamp fields you pasted into your events table: are these defined as date and time respectively, or are they text. (Text will not work.)
Changed lines 13-14 from:
-> '''4.''' Take a look at the calc fields in CalendarRows and make sure nothing has been commented out (commented calcs begin with /* and end with */). You may be able to just remove the comments from the calcs and they'll work.
to:
-> '''4.''' Take a look at the calc fields in CalendarRows and make sure nothing has been commented out (commented calcs begin with /* and end with */). You may be able to just remove the comments from the calcs and they'll work. Check the auto enter calc definitions as well, such as those for DateRangeStartAutoGlob and DateRangeEndAutoGlob.
Changed lines 13-15 from:
-> '''4.''' Check your system's date formats. If you're using a customized date format switch to one of the standard formats like United Kingdom and then close and re-open FileMaker. It is unusual, but stray characters in the date format can screw up the calendar. If switching formats repairs it, slowly add your customizations again checking that the calendar continues to recognize them.
to:
-> '''4.''' Take a look at the calc fields in CalendarRows and make sure nothing has been commented out (commented calcs begin with /* and end with */). You may be able to just remove the comments from the calcs and they'll work.
-> '''5.''' Check your system's date formats. If you're using a customized date format switch to one of the standard formats like United Kingdom and then close and re-open FileMaker. It is unusual, but stray characters in the date format can screw up the calendar. If switching formats repairs it, slowly add your customizations again checking that the calendar continues to recognize them.
-> '''5.''' Check your system's date formats. If you're using a customized date format switch to one of the standard formats like United Kingdom and then close and re-open FileMaker. It is unusual, but stray characters in the date format can screw up the calendar. If switching formats repairs it, slowly add your customizations again checking that the calendar continues to recognize them.
Changed lines 7-13 from:
-> 1. Run the "Upon Opening" script again.
-> 2. Click on the filters tab: if "Clear" is showing up in red, click "clear" to empty the filters. You may have been "searching" for events that don't have any matches.
-> 3. Check out the Source No 1 layout in browse mode, reviewing every tab: are there any errors shown?
-> 4. Check your system's date formats. If you're using a customized date format switch to one of the standard formats like United Kingdom and then close and re-open FileMaker. It is unusual, but stray characters in the date format can screw up the calendar. If switching formats repairs it, slowly add your customizations again checking that the calendar continues to recognize them.
-> 2. Click on the filters tab: if "Clear" is showing up in red, click "clear" to empty the filters. You may have been "searching" for events that don't have any matches.
-> 3. Check out the Source No 1 layout in browse mode, reviewing every tab: are there any errors shown?
-> 4. Check your system's date formats. If you're using a customized date format switch to one of the standard formats like United Kingdom and then close and re-open FileMaker. It is unusual, but stray characters in the date format can screw up the calendar. If switching formats repairs it, slowly add your customizations again checking that the calendar continues to recognize them.
to:
-> '''1.''' Run the "Upon Opening" script again.
->''' 2.''' Click on the filters tab: if "Clear" is showing up in red, click "clear" to empty the filters. You may have been "searching" for events that don't have any matches.
-> '''3.''' Check out the Source No 1 layout in browse mode, reviewing every tab: are there any errors shown?
-> '''4.''' Check your system's date formats. If you're using a customized date format switch to one of the standard formats like United Kingdom and then close and re-open FileMaker. It is unusual, but stray characters in the date format can screw up the calendar. If switching formats repairs it, slowly add your customizations again checking that the calendar continues to recognize them.
->''' 2.''' Click on the filters tab: if "Clear" is showing up in red, click "clear" to empty the filters. You may have been "searching" for events that don't have any matches.
-> '''3.''' Check out the Source No 1 layout in browse mode, reviewing every tab: are there any errors shown?
-> '''4.''' Check your system's date formats. If you're using a customized date format switch to one of the standard formats like United Kingdom and then close and re-open FileMaker. It is unusual, but stray characters in the date format can screw up the calendar. If switching formats repairs it, slowly add your customizations again checking that the calendar continues to recognize them.
Added lines 1-13:
!! What's wrong?
If you can't see any events in the calendar after your integration, here are a couple things to check.
Note that Event Colors have their own trouble shooting section [[EventColors | here]].
-> 1. Run the "Upon Opening" script again.
-> 2. Click on the filters tab: if "Clear" is showing up in red, click "clear" to empty the filters. You may have been "searching" for events that don't have any matches.
-> 3. Check out the Source No 1 layout in browse mode, reviewing every tab: are there any errors shown?
-> 4. Check your system's date formats. If you're using a customized date format switch to one of the standard formats like United Kingdom and then close and re-open FileMaker. It is unusual, but stray characters in the date format can screw up the calendar. If switching formats repairs it, slowly add your customizations again checking that the calendar continues to recognize them.
If you can't see any events in the calendar after your integration, here are a couple things to check.
Note that Event Colors have their own trouble shooting section [[EventColors | here]].
-> 1. Run the "Upon Opening" script again.
-> 2. Click on the filters tab: if "Clear" is showing up in red, click "clear" to empty the filters. You may have been "searching" for events that don't have any matches.
-> 3. Check out the Source No 1 layout in browse mode, reviewing every tab: are there any errors shown?
-> 4. Check your system's date formats. If you're using a customized date format switch to one of the standard formats like United Kingdom and then close and re-open FileMaker. It is unusual, but stray characters in the date format can screw up the calendar. If switching formats repairs it, slowly add your customizations again checking that the calendar continues to recognize them.