0

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.

2
  • Have you ever programmed? This could be done pretty easily with Python.
    – nerdwaller
    Jan 11, 2014 at 16:33
  • not seriously and not in Python Jan 11, 2014 at 16:49

0

You must log in to answer this question.

Browse other questions tagged .