Script error & Incorrect error

[sprocketandfriendsuk]

Hi,

I'm having two issues:

1) ScriptError: Exceed maximum execution time

I have 1382 rows in my spreadsheet which have been built up over a number of months. When I run the 'Import Calendar to Sheet' option, I am now receiving the following error "ScriptError: Exceed maximum execution time".

2) You cannot import updates for a range of dates

If I deselect 'All events', and try to select dates, irrespective of whether I leave one of the date fields empty, complete both, set both date fields as the today, or have the start date before the end date, I still get the same error "You cannot import updates for a range of dates".

Any ideas? Thanks Rebecca

[GCalToolkit]

Hi Rebecca, you should be able to update that many rows without exceeding the maximum script time that Google allows (I think it's 30 seconds), but this depends on the amount of data you are updating... If this issue persists for more than 24 hours then you probably have a large amount of data to process and the script is hitting Google's restrictions.

I'm currently working on a way to update in several sessions to work around this limit, but it's not ready yet. The second issue is normal because Google only provides a syncing mechanism when fetching the full calendar, not for a range of dates.

While I figure out a solution to this it might be easier to simply do a new import. If you have other data in the Sheet you could also do a fresh import to a separate Sheet and copy/paste only the columns used by Sheets2GCal.

[sprocketandfriendsuk]

Hi,

Just a little more info, if I create a new sheet and use the ‘clear sheet & import calendar’ the calendar events are posted in the spreadsheet without issue. A total of 1652 events.

Many thanks, Rebecca

On Tue, 26 Jul 2022 at 19:46, Rebecca Marsh @.***> wrote:

Hi,

We’re having the same issue as last month. We are getting an error message but do not have many calendar events to process.

Is there an error/issue that you are aware of?

Many thanks, Lorraine

On Thu, 30 Jun 2022 at 23:32, GCalToolkit @.***> wrote:

Hi Rebecca, you should be able to update that many rows without exceeding the maximum script time that Google allows (I think it's 30 seconds), but this depends on the amount of data you are updating... If this issue persists for more than 24 hours then you probably have a large amount of data to process and the script is hitting Google's restrictions.

I'm currently working on a way to update in several sessions to work around this limit, but it's not ready yet. The second issue is normal because Google only provides a syncing mechanism when fetching the full calendar, not for a range of dates.

While I figure out a solution to this it might be easier to simply do a new import. If you have other data in the Sheet you could also do a fresh import to a separate Sheet and copy/paste only the columns used by Sheets2GCal.

— Reply to this email directly, view it on GitHub https://github.com/GCalToolkit/Sheets2GCal/issues/16#issuecomment-1171739683, or unsubscribe https://github.com/notifications/unsubscribe-auth/AZ3W22LUENLVXVHZ3DCKCG3VRYOBFANCNFSM52KMHT5Q . You are receiving this because you authored the thread.Message ID: @.***>

[sprocketandfriendsuk]

Hi,

We’re having the same issue as last month. We are getting an error message but do not have many calendar events to process.

Is there an error/issue that you are aware of?

Many thanks, Lorraine

On Thu, 30 Jun 2022 at 23:32, GCalToolkit @.***> wrote:

Hi Rebecca, you should be able to update that many rows without exceeding the maximum script time that Google allows (I think it's 30 seconds), but this depends on the amount of data you are updating... If this issue persists for more than 24 hours then you probably have a large amount of data to process and the script is hitting Google's restrictions.

I'm currently working on a way to update in several sessions to work around this limit, but it's not ready yet. The second issue is normal because Google only provides a syncing mechanism when fetching the full calendar, not for a range of dates.

While I figure out a solution to this it might be easier to simply do a new import. If you have other data in the Sheet you could also do a fresh import to a separate Sheet and copy/paste only the columns used by Sheets2GCal.

— Reply to this email directly, view it on GitHub https://github.com/GCalToolkit/Sheets2GCal/issues/16#issuecomment-1171739683, or unsubscribe https://github.com/notifications/unsubscribe-auth/AZ3W22LUENLVXVHZ3DCKCG3VRYOBFANCNFSM52KMHT5Q . You are receiving this because you authored the thread.Message ID: @.***>

[mygraddca]

Having the same issue. Please advise. Need a workaround or a refund! Thank you!

[GCalToolkit]

Please contact me via the email/contact form on www.gcaltoolkit.com so I can try to work out what the problem is and hopefully find a solution, or refund.

I'll need as much information as possible about how you use Sheet2GCal, and some screenshots of the error and how it is triggered would help too.