Now I would like to know, exactly how to convert the content to MC/MJ compatible style? I mean, what digits do I replace with what? (like you show in your post with screenshots).
I think it is quite obvious if you inspect and compare the values in your source file and the values in my excel and mpl files.
Because I am not exactly familiar with creating and converting xml structures with Excel or any other program I did most of the work "manually".
1. I opened your file with standard Windows Notepad and saved it in UTF-8 format (it was UTF-16).
2. I opened the saved file with Excel 2003, removed the unnecessary columns and after some experimenting I was able to convert the date & time values to the Unix format. The formula is in my Excel file. It was difficult to make Excel understand that the original source values were actually time stamps, but I found a workaround by creating a couple of new columns.
3. Then I copied only the resulting values (not formulas) to yet another column and finally replaced the original time stamps with these values. I removed my additional columns and saved the file as xml.
4. With Notepad++ I did several find & replace operations for fixing the headers. Notepad++ was able to do it quickly. MS Word was hopelessly slow with the huge file.
It's important to know the exact method in order for us all to adopt it.
Not many users are interested about the import dates and times. Though I think many users are interested about the playcount values.
The steps I did are not easy to explain in detail and probably would not work for everyone. To do something similar you would really need to understand how the field values work and if necessary be able to adjust the procedure according to the existing data.
Actually, you did not provide step by step instructions for creating an xml file like yours. It isn't something that you can do with WMP only.
JRiver programs have been around a long time. My library contains statistical information starting from the year 2002 and I have always been able to transfer that data to newer versions. I'd recommend importing the MPL file I created and never looking back.
I consider it very important, that the time zone fits to the danish GMT+1. How do I adjust all the timestamps in the file?
Have you checked if the WMP time stamps are GMT or your local time zone? If they are local you could do the correction in Excel. Excel allows to do various time stamp calculations. However, you would also need to fix the differences caused by the daylight saving time. I think it is possible to create a formula that calculates them automatically, but it wouldn't be simple because each year is a bit different. Perhaps you could handle the time periods separately. For instance: winter 2003-2004, summer 2004, winter 2004-2005, and so on. But does an hour or two really matter? The sort order of your old files would be correct anyway (when set to "Date Imported"). Naturally the files you add directly to MJ in the future will have exactly correct "Date Imported" values.
Btw.Are you sure the already imported files' dates and play counts will be replaced by the stored ones in the metadata?
Assuming the filenames are correct in the MPL file it should work fine if you do exactly as I instructed. As a precaution you can create a library backup file in MJ12. (File > Library > Back Up Library)