How can I export my ratings and colours?

Ask for help and post your question on how to use XnView MP.

Moderators: XnTriq, xnview

Post Reply
Stuart444
Posts: 9
Joined: Mon Oct 03, 2016 6:54 pm

How can I export my ratings and colours?

Post by Stuart444 »

I've found that if I browse through my images and assign ratings and colours to them, then if I back up my files to an external drive and then examine the files on that external drive (actually my backups drive) then those ratings and colours are not there. It seems as though the files themselves are not altered by assigning a rating or a colour to them. So I presume XnViewMP is storing this information somewhere else.

Please can you advise me where it is kept? If I copy it to my external drive and then look at the images on that drive with another computer running XnViewMP, will this then display the colours and ratings that were assigned to the files using the first computer?

Thanks
User avatar
XnTriq
Moderator & Librarian
Posts: 5618
Joined: Sun Sep 25, 2005 3:00 am
Location: Ref Desk

How can I export my ratings and colours?

Post by XnTriq »

This information is stored in XnView.db. The location of this file depends on the configuration in Tools » Settings... » Integration » Paths » Other settings » Folder for Catalog (.db).

You can also write the ratings and colors to JPEG images as embedded metadata…
  • Selected files: View » Update files from catalog
    All files: Tools » Settings... » Metadata » IPTC & XMP » Keywords » Export DB Category to XMP Subject and IPTC Keyword
… and have them imported to another installation:
  • Selected files: View » Update catalog from files
    All files: Tools » Settings... » Metadata » IPTC & XMP » Keywords » Import XMP subject and IPTC keyword to DB Categories
Let's hope I got everything correct :mrgreen:

Stuart444
Posts: 9
Joined: Mon Oct 03, 2016 6:54 pm

Re: How can I export my ratings and colours?

Post by Stuart444 »

Thanks XnTriq,

I'm actually trying to migrate from my PC to my Macmini. The "correct" ratings and colours were set in the PC. I back this PC up to an external USB drive just by copying the PC images to it, and I read the copied files on the backup drive with my mac whose HDD isn't big enough for all the images. Rather than have to go through all my (backup) images using my mac and resetting the ratings and colours there, I'm trying to transfer the data over. I suppose putting the data into the metadata of each image file is better in terms of locking them together, but does that make XnView's browser work more slowly than keeping the information in its database? Anyway I've tried 2 things and not quite succeeded.

A. Try to copy the PC database to the mac
1. I found my XnView.db file on my PC
2. I copied that to my external drive
3. I transferred the drive to my mac and found the db file there and copied it
4. I went Settings\Integration\Paths\Other settings\Open the catalog location
5. I right clicked and Paste Item
6. It asked me if I wanted to replace the existing file with the new one, which I affirmed
7. It copied the db file.
I'd thought that XnView on the mac would then read the ratings and colours that I'd set on the PC, but the previous mac ratings and colours are still there. Is there a further command to get XnView on the mac to update the browser from the new database or have I gone wrong?

B. Try to put the PC database settings into the PC files
1. All files: Tools » Settings... » Metadata » IPTC & XMP » Keywords » Export DB Category to XMP Subject and IPTC Keyword (both create boxes ticked)
2. Click OK
3. What now? Nothing is happening, I'd expected lots of activity whilst XnView writes the data from the db into the files

I don't know if it's relevant but I notice my PC is using version XnViewMP Version 0.83 x64 (Oct 3 2016), whereas the mac is using Version 0.78 x64 (Jan 14 2016).
Stuart444
Posts: 9
Joined: Mon Oct 03, 2016 6:54 pm

Re: How can I export my ratings and colours?

Post by Stuart444 »

A further issue. I closed XnViewMP on my mac and re-opened it, as I remembered I had to do that when changing the names of the colour labels to make the changes visible. What I was hoping to see was the same ratings and colours as on the PC. On the PC, nothing has a star rating, and many images have a colour rating. On the mac previously, lots had a star rating and none had a colour rating. (I swapped from one to the other as I can customise the names of my colour labels but can't customise the names of the star labels). Now I see on the mac that all the starred files still have their star rating, but no thumbnails appear, just the file names. (Actually going back to it 10 minutes after I initially typed this, some icons have appeared, and they show the correct thumbnail, and they can be previewed, but the ones without thumbnails can't) In the mac's colour label filters, there are now the same number of files shown as are shown in the same colour on the PC and the file names are all correct, but only some have a thumbnail, and they are all wrong, ie the thumbnail pictures being shown are not the correct ones for their file name. Somehow the thumbnails and the labels have been scrambled I think. Looking via the browser, all the thumbnails appear to be correct, but I can't find any showing a colour mark as shown when doing the same thing in the PC, although they do show the stars there.
It wouldn't be much trouble to uninstall XnViewMP from my mac and re-install it. If I put the XnView.db onto the external HDD and pointed both computers to it, would that work?
Stuart444
Posts: 9
Joined: Mon Oct 03, 2016 6:54 pm

Re: How can I export my ratings and colours?

Post by Stuart444 »

Another thought - when I searched for XnView.db on my PC, I found 2 - one in C:\Users\myname\AppData\Roaming\XnViewMP\XnView.db, and C:\Documents and settings\myname\AppData\Roaming\XnViewMP\XnView.db. Both were the same age and size. The path set in XnView is to the first one whereas I think I copied the second one for the external drive as I thought both were the same.
Erixx haxx
Posts: 330
Joined: Tue Jul 28, 2015 10:37 am

Re: How can I export my ratings and colours?

Post by Erixx haxx »

Hello:

The main issue I see here is your not aware of what ties the .db file to the images.

The .db file is tied to ( The file path + Filename ) Namely, drive letter. So when you are backing them up you are in fact changing this.

Backups should be just that. Backups. Not hot in-use files.

You have a few options here.

-Share the .db file and the same PC images with same path.
-Embed the files on your PC with rating data, Then share, Then reread shared embeded images with mac mini.
-Embed the files on your PC with rating data, Then backup, Then reread Backup from mac mini. (I Wouldn't suggest this )

Note: On some OS's, how they use Slash. \ or / in path names. Might be an issue..
Stuart444
Posts: 9
Joined: Mon Oct 03, 2016 6:54 pm

Re: How can I export my ratings and colours?

Post by Stuart444 »

Hi Erixx haxx,

Yes, I think you've hit the nail on the head there. I was trying to get the best of all worlds. I've been a PC user for 35 years and a mac user for 1 year, the latter mainly to use Affinity Photo. As Serif now say they are going to launch Affinity for Windows later this year I was trying to get XnViewMP to work with both for a while as I think I might then go back to Windows entirely. XnViewMP seems to answer my catalogue needs on either platform. I'll have another go at your second option and if it doesn't work for me then I'll await Serif and my decision on whether to use PC or Mac for Affinity and only use XnViewMP there.

Thanks for your help.

Stuart
Erixx haxx
Posts: 330
Joined: Tue Jul 28, 2015 10:37 am

Re: How can I export my ratings and colours?

Post by Erixx haxx »

Hello Stuart

I think you was just missing a small piece of the puzzle here. I also think you should be able to get this working how you wanted without to much trouble now.

Just remember the settings for (Read and writing) to the .db file until you get info embeded and then synced.

Let us know how it turns out or if you need anymore info.
Post Reply