Importing into Tropy: ESW database files via JSON

Question
1

This question is about a problem that is a tough nut to crack. I, therefore, do not expect that there is an easy solution. Still, I am hoping for a nudge in the right direction.
I want to convert thousands of database files that are called ESW into JSON so as to be able to import them into Tropy. To give you an idea of how an ESW file looks like, I am attaching one example taken from my database.
How to best go about the conversion, the import and the whole migration?
Should I use “ConvertCSV” or would a specifically written script be the better option?

[GENERAL]
Version=4
SHORTDESC=Archives US
ABLDATE=12.04.2013
ABLDATE2= 
OBJTYPE=259
KEY=0
ACL=
GUID=(1C0EAFCD-771A-4B14-B311-D1247AE5E53D)
KIND=0
PATH=1
FLAGS=1073741953
MASKFLAGS=0
DOCDATE= 
DOCDATE2= 
DOCTYPE=Correspondance
MASKFLOWID=-1
USER=0
DELDATE=0
DELDATE2=0
SREG=
REPLSET=0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
MASKIDX=
DOCEXT=.TIF
DTPATH=0
IDXTEXT=Folder¶Archives¶US¶Foundations
SIGID=0
[KEY2]
KEYNAME=Themen
KEYTEXT=¶¶Foundations¶Europa 1950s¶Carreer¶Trips¶Thompson¶University
KEYKEY=Themes
[KEY52]
KEYNAME=ELO_FNAME
KEYTEXT=Archives US.tif
KEYKEY=ELO_FNAME
[NOTE1]
TEXT=This list is missing in the folder.
TYPE=1
USER=0
XPOS=0
YPOS=0
PAGENO=0
CREATE=28.11.2015 00:47
WIDTH=0
HEIGHT=0
BACKGROUNDCOLOR=0
2

Converting to JSON using a script would be the most flexible approach. However, depending on the way your items are structured it may be straight forward to use the CSV import plugin instead.

The main question is how your metadata relate to images. The CSV plugin assumes that there is one row per image; this row can have a flexible number of metadata columns and one or more photos (which can have their own metadata and notes). So the question is, what do you want each ESW file to represent in Tropy and how does it correspond to photo files on?

3

This settles things. I will be using a script to do it.
Thanks a lot!