Here is MySQL code to export Variations Bookmarks to be imported into Avalon. The output of this code is a json file with the Variations bookmark information. This json file is structured to easily map to the playlist and marker structure in Avalon:
[ { "username": "username",
"playlist_ name": "default",
"playlist_item": [ { "name": "value", "container_string": "value", "comment": "value"
"bookmark": [ { "name": "value", "start_time": value } ] | /** | |
| * Copyright 2001-2011, Trustees of Indiana University | |
| * All rights reserved. | |
| * | |
| * Redistribution and use in source and binary forms, with or without | |
| * modification, are permitted provided that the following conditions are met: | |
| * | |
| * Redistributions of source code must retain the above copyright notice, | |
| * this list of conditions and the following disclaimer. | |
| * |
| { | |
| "@context": "http://iiif.io/api/presentation/3/context.json", | |
| "id": "https://preview.iiif.io/cookbook/0219-using-caption-file/recipe/0219-using-caption-file/manifest.json", | |
| "type": "Manifest", | |
| "label": { | |
| "en": [ | |
| "Lunchroom Manners" | |
| ] | |
| }, | |
| "items": [ |
| { | |
| "@context": [ | |
| "http://www.w3.org/ns/anno.jsonld", | |
| "http://iiif.io/api/presentation/3/context.json" | |
| ], | |
| "type": "Manifest", | |
| "id": "https://spruce.dlib.indiana.edu/media_objects/9593tv280/manifest", | |
| "label": { | |
| "@none": [ | |
| "Multi-section Item" |
| // manifest for https://bonduranthistory.aviaryplatform.com/collections/3/collection_resources/17/transcript?collection_resource_file_id=18 | |
| // annotations at the end eliminated to fit the number of lines available here. | |
| { | |
| "@context": "http://iiif.io/api/presentation/3/context.json", | |
| "id": "https://bonduranthistory.aviaryplatform.com/iiif/445h98zb86/manifest", | |
| "type": "Manifest", | |
| "label": { | |
| "en": [ | |
| "Kevin Campbell" | |
| ] |