Blank rows in Spreadsheet

[crhtex]

Thanks - this is working great. Is there a way to skip over the blank rows in the spreadsheet without having an error message? In other words, I have a spreadsheet that I filled with consecutive dates, but I want to skip the Saturday and Sunday entries by having no Title.

[davepar]

I think that's a fairly easy change in the code. Are you syncing from the spreadsheet to the calendar, calendar to spreadsheet, or both?

[crhtex]

Just syncing Spreadsheet to Calendar.

Carl R. Hochmuth Educational Technology Coordinator Luther Preparatory School

The Fear of the Lord is the beginning of wisdom - Psalm 111:10

On Tue, Jul 19, 2016 at 9:30 AM, Dave Parsons notifications@github.com wrote:

I think that's a fairly easy change in the code. Are you syncing from the spreadsheet to the calendar, calendar to spreadsheet, or both?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/Davepar/gcalendarsync/issues/9#issuecomment-233650771, or mute the thread https://github.com/notifications/unsubscribe-auth/ATkm_7ieI52j-oBFZbwEfJGESnF4fMDXks5qXN9rgaJpZM4JO_dE .

---

This electronic communication, including any attached documents, may contain confidential and/or legally privileged information that is intended only for use by the recipient(s) named above. If you have received this communication in error, please notify the sender immediately and delete the communication and any attachments.

[crhtex]

Where in the code would I look to make the changes?

[kassieberger]

Has a solution to this been found? I tried changing a few things in the code, but wasn't able to figure it out. I am only updating to Calendar.

Awesome script by the way!

[davepar]

I want to make sure I'm fixing this in a way that makes sense. So if a row in the spreadsheet is blank (or all blank except for start/end time), you're expecting it to just be skipped with no error/warning, right?

[kassieberger]

I was hoping that if there were no start/end time the row would be skipped without error because there are rows that just contain additional details about the event. I merged an old version of the script with the updated version and was able to get rid of the error.

I've attached the spreadsheet so you can see why and the current script I'm using.

Thank you for your assistance. ​ Copy of Central FL - Gleaning Calendar https://docs.google.com/spreadsheets/d/11sY8B9Flw33e6B_5GoezBZBdWdTe8kCtOCqfV12Qtfg/edit?usp=drive_web ​

On Thu, Jul 6, 2017 at 6:44 PM, Dave Parsons notifications@github.com wrote:

I want to make sure I'm fixing this in a way that makes sense. So if a row in the spreadsheet is blank (or all blank except for start/end time), you're expecting it to just be skipped with no error/warning, right?

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/Davepar/gcalendarsync/issues/9#issuecomment-313539445, or mute the thread https://github.com/notifications/unsubscribe-auth/ASXH08Fe2GKTestcJ3BkTaNt99tIkIp8ks5sLWNJgaJpZM4JO_dE .

[davepar]

Thanks for the example spreadsheet. That helps me understand what's going on. I added a setting called SKIP_BLANK_ROWS. Setting that to true should do what you want. A couple of your events had end times before the start time, but the script otherwise added all the events without complaint.

I'm closing this issue, but feel free to re-open if it's not working as expected.

Looks like a great organization you're working with.

[kassieberger]

Thank you!

Sent from my iPhone

On Jul 7, 2017, at 12:37 PM, Dave Parsons notifications@github.com wrote:

Closed #9.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub, or mute the thread.