Converting base64 encoded database

0

1

I have a dadabase whose structure is really simple.

<ws>
    <e>
        <k>base64_encoded_string</k>
        <v>base64_encoded_string</v>
    </e>
    <e>
        <k>...</k>
        <v>...</v>
    </e>
    ...
</ws>

I need to convert it to simple json in a format like this:

{"k":"v",
 "k":"v",
 ...
}

My first thought was importing it through MS Excel's xml parser, but there is a problem with maximum length size Excel cell can be, which is 32kB, but some the values in my database can go up to 600kB.

My next thought was to use Notepad++ with macros to decode base64 and then to use search and replace to reformat the structure of the file, but it seems that N++'s macro recorder doesn't support plug-in commands which is necessary to decode the b64.

What can I do to convert my database?

(In case it might help, basically all I need is to convert Opera 12.16 extension storage to Firefox add-on storage).

Thanks for any help.

JonnyRobbie

Posted 2014-01-11T15:12:39.503

Reputation: 111

Have you ever programmed? This could be done pretty easily with Python. – nerdwaller – 2014-01-11T16:33:09.147

not seriously and not in Python – JonnyRobbie – 2014-01-11T16:49:17.260

No answers