What Google Calendar's help page says
If you get this error message when you use the "Public address in iCal format" link, use the "Secret address in iCal format" instead.
If you don't find the secret address, you can’t export the calendar.
Quoted word for word from Google Calendar's help page, listed under Sources.
Why it happens
- An app was given the public iCal address of the calendar. Google's page names that link as the source of the message.
- The secret address is missing from the calendar's settings. Google's page says the calendar then cannot be exported, and that a work or school admin may restrict export settings.
How to fix it
- Open Google Calendar on a computer. The Google Calendar app cannot export.
- Under My calendars, point to the calendar, click More, then Settings and sharing.
- To keep another app in sync, copy the "Secret address in iCal format" and give that app the secret address in place of the public one. Anyone who has the secret address can read every event on the calendar, so give it only to an app you trust.
- To get a file, click Export calendar under Calendar settings. An .ics file downloads.
- Drop that .ics on the ClientHours Google Calendar page. If the secret address and Export calendar are both missing, ask the admin of your Google account.
Google Calendar to timesheet by client
What ClientHours does with the file
- ClientHours reads only files you choose. The file box takes .ics, .ical, .zip and .csv files, and there is no field for a calendar address and no Google sign-in.
- The .ics from Export calendar holds that one calendar. The .zip from Settings, Import & export, Export holds all of yours, and ClientHours reads it without unzipping.
- A file does not change when the calendar does. For a new billing period, export again.
Limits
- Google's page says you need the "Make changes and manage sharing" permission on a calendar to export it.
- ClientHours does not test or repair iCal addresses and cannot tell why another app refused one.
- ClientHours has not yet been run on a real Google Calendar export. Its test calendars are built by hand from the iCalendar standard and Google's help pages, so check the first timesheet against your calendar.
Questions
- Can I paste the iCal address into ClientHours?
- No. ClientHours reads a file you choose on your device. Use Export calendar to download the .ics file, then drop it on the page.
- Why is there no secret address in my settings?
- Google's page says that without the secret address you cannot export the calendar. On a work or school account the admin may restrict export settings, so ask them.
- How do I export every calendar at once?
- In Settings, open Import & export and click Export. A .zip downloads with an .ics file for each calendar. Drop it on ClientHours as it is.
Sources
Other import problems
- Clockify: "Date, time, and duration formats don't match Clockify settings"
- Clockify: "The file is not comma-delimited"
- Clockify: "Missing or incomplete field values"
- Toggl Track: "Adding new users increases your workspace fee"
- Toggl Track: "Not allowed as header: Project;task;client"
- Harvest: semicolons "will result in import errors"
- Google Calendar: "Processed zero events"
- Google Calendar: "Processed x of y events"
- "Google Calendar is temporarily unavailable" when importing
- Calendar and time tracker import problems
ClientHours is free, with no account and no payment. The calendar file never leaves your browser.