search

cpvalente / ontime

Free, open-source time keeping for live events
https://www.getontime.no
Other
507 stars 51 forks source link

Blocks from .xlsx imported as Events #1310

Open forchinmaser opened 3 weeks ago

forchinmaser commented 3 weeks ago

Created blocks in the app and exported as .csv. Uploaded to google sheets for further editing. Downloaded as .xlsx from sheets, when I import this spreadsheet, the blocks appear as events with start, end, and duration times all 00:00:00.

Screenshot 2024-10-29 at 11 27 13 PM Screenshot 2024-10-29 at 11 26 33 PM
cpvalente commented 3 weeks ago

Hi @forchinmaser , thank you for taking the time to open a ticket It makes sense to me that either a) the CSV export would indicate this is a block or b) the UI allows special rules for importing when there are no time data in the row (ie: make block or skip import)

For now, you can work around this by creating a timer type column and setting it to "block" You can see examples of this, both in the documentation and in the excel template here https://docs.getontime.no/features/import-spreadsheet