Any chance we can convert an old PList file to sqlite?

[CDenby]

I've got an old iPad V1 that I've used for a very very long time.
I saw that it had the "Export to Band Helper" on it, so I was pleased that it looked like when I was ready to use a newer ipad, I'd be able to move my SLM databases over to the new app and proceed.

However - when I run that Export to Band Helper routine, it provides a PList file. This is an XML file. I can't seem to import it into a newer version of Set List Maker, nor can I bring it into Band Helper.

What am I missing on this? The Set List Maker version is 4.2.

How can I get everything over to either Set List Maker version 2024-10-23 (134) or Band Helper?

[arlo]

Sorry, support for the iPad 1 ended nine years ago and any way to get data off of it stopped seven years ago. Your best option now is to use the import options to populate a new device:

http://www.setlistmaker.com/tutorials/importing_data.html

https://www.bandhelper.com/tutorials/importing_data.html

As long as you're starting over, we do recommend BandHelper now:

https://www.bandhelper.com/tutorials/SLM_migration_1.html

[arlo]

Actually while there's no way to import that data into the current Set List Maker, it looks like the BandHelper website still includes the code to import plist files. You will need to make the following edits to the plist file before importing it on the Admin > Import page of the BandHelper website:

1. Replace these lines:

Code Select Expand

    <key>version</key>
    <string>4.2</string>

with these lines:

Code Select Expand

    <key>meta</key>
    <dict>
        <key>meta</key>
        <dict>
            <key>version</key>
            <string>2022-05-12</string>
        </dict>
    </dict>

2. Rename all the tables (the top-level keys) from plural to singular: apps to app, customFields to customField, songs to song, etc. Note that you should rename the document and recording tables, but not the documents and recordings fields within the song table.

I assume some data will still be missing after doing this, but this should handle most of it.