Annotation imports and exports

[camdendotlol]

Summary

• adds a new page at /[lang]/projects/[projectSlug]/events/[eventUuid]/import that is accessed by clicking the Import button in the annotation table on Event Detail (this button previously didn't do anything)
• adds a form to that page that allows the user to import annotations
• updates the annotations POST endpoint to accept an array of annotations as well as a single one
  • this keeps the API consistent no matter how we're creating annotations - no need for a separate import endpoint that behaves differently
• adds a fromTimestamp helper function to convert regular timestamps (e.g. 12:00:20) to seconds, the way we store them in our JSON files
• passes a raw: false option to xlsx's sheet_to_json function to ingest the timestamps correctly
  • Although their docs suggest otherwise, raw: true is the default, and it was causing our colon-based timestamps like the example above to appear as long decimal numbers. raw apparently tells the function to convert anything that looks like a number to a number using some sort of xlsx-specific logic, while disabling raw keeps everything as a string (doesn't that seem backward?)
• updates the deserialize helper to be able to run in both the backend and the browser
  • Previously, the entire file would fail to import on the browser because something in jsdom is checking process which is undefined in the browser. Since JSDOM's purpose is to mock browser functionality anyway, I added a check for whether the function is running in the browser so we can use browser-native Node functionality there
  • this allows us to call deserialize from the client, as I do when parsing annotations
• removes a bad position: sticky CSS rule in the annotation edit/create modal that was causing the bottom bar to float over the form
• updates the API routes to guarantee that an AV file can never end up without an associated annotation set

[netlify[bot]]

✅ Deploy Preview for avannotate-staging ready!

Name	Link
🔨 Latest commit	72562073d65a621f647fc436e0712eeb58bf4952
🔍 Latest deploy log	https://app.netlify.com/sites/avannotate-staging/deploys/66ce2cac99948500080c277f
😎 Deploy Preview	https://deploy-preview-37--avannotate-staging.netlify.app
📱 Preview on mobile	Toggle QR Code... Use your smartphone camera to open QR code link.

---

To edit notification comments on pull requests, go to your Netlify site configuration.