In order to set up cells to not automatically turn the timestamps into times of day, you must first highlight the entire space that you are going to use for your timestamps. Then, go to the tab labeled “Format” towards the top of the screen. Click it and at the top of the list should be something labeled “Numbers.” Hover over that label and change the format from “Automatic” to “Plain text.” If you plan to add more annotations and timestamps to your sheet, you will have to make sure that you changed the format all the way down the timestamps column.
AVAnnotate requires users to have a properly formatted spreadsheet when uploading annotations to a project. This means that:
– Each horizontal row that includes data must be filled to the index portion. If any cell in a row includes a time stamp, annotation, layer, or index, the remainder of the row must be filled.
– No additional columns are required to build a project. If you have multiple layers, annotations, or index terms, they should be listed vertically in a column.
– Any inclusion of images or links in the annotation column must be done in Markdown.
If data is being copied and pasted into a spreadsheet, it is recommended to “clear formatting” prior to uploading a spreadsheet. This can be done by clicking “Formatting” and “Clear Formatting” in Google Sheets.
In the top right corner of AVAnnotate projects, a status will display either “Ready,” “Building,” or “Error.” This status is associated with the build status in GitHub. If a project status reads “Errored,” this is most likely due to multiple changes being committed. This is normal and doesn’t necessarily mean your change has been lost.
One common reason that you may be having trouble is that your spreadsheet has not been fully filled or there is a small error present. Double check that every cell in the “Layer” column has been filled and that all timestamps are correctly formatted. See Above FAQ: “How do I correctly format annotations?”
At this time, it is not possible to use AVAnnotate with streaming files like Youtube videos. You must have a IIIF manifest or direct link to the .mp3 or .mp4 file to generate one.
The Internet Archive has published a step-by-step guide to creating a collection. It can be found here.
Ben is one of AudiAnnotate’s software developers. GitHub uses his name when some changes are made to AudiAnnotate projects. There’s nothing to worry about.