Missing Catagories or Database.

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

Moderators: XnTriq, helmut, xnview

KojiKamori
Posts: 8
Joined: Sat Sep 28, 2019 3:29 am

Missing Catagories or Database.

Post by KojiKamori »

I think I may of wiped out the database.

So I have the database and all the files on an external Hard Drive and when I opened up XnView MP, none of the catagories populated in the pane as they should had. My drive was obviously plugged in as I was accessing through XnView the drive where I also have pictures stored. So I unplugged the drive, and plugged it back in and still, the catagories didn't populate. I forgot how to then check the file paths and tried to click on the catagories itself in the data pane and I think I wiped out all the catagories on mistake.

Is there a way to get them back or did I really lose all of my catagories and all associated tagged pictures, no not deleted the pictures, the category tags that were on the pictures.
User avatar
xnview
Author of XnView
Posts: 45193
Joined: Mon Oct 13, 2003 7:31 am
Location: France

Re: Missing Catagories or Database.

Post by xnview »

the drive/path has not changed? which filesize for your xnview.db?
Pierre.
KojiKamori
Posts: 8
Joined: Sat Sep 28, 2019 3:29 am

Re: Missing Catagories or Database.

Post by KojiKamori »

Same drive path with a DB file the size of 32,924 KB.
User avatar
xnview
Author of XnView
Posts: 45193
Joined: Mon Oct 13, 2003 7:31 am
Location: France

Re: Missing Catagories or Database.

Post by xnview »

is it possible to send me the .db to check the content?
Pierre.
KojiKamori
Posts: 8
Joined: Sat Sep 28, 2019 3:29 am

Re: Missing Catagories or Database.

Post by KojiKamori »

I had catagories that may dox me. So if anything is still recoverable then that might not be wise for myself.
KojiKamori
Posts: 8
Joined: Sat Sep 28, 2019 3:29 am

Re: Missing Catagories or Database.

Post by KojiKamori »

Is this an issue that may be resolved in someone walks one through the process to go figure what went wrong?
User avatar
xnview
Author of XnView
Posts: 45193
Joined: Mon Oct 13, 2003 7:31 am
Location: France

Re: Missing Catagories or Database.

Post by xnview »

i need to check the content of database file, please send me it
Pierre.
KojiKamori
Posts: 8
Joined: Sat Sep 28, 2019 3:29 am

Re: Missing Catagories or Database.

Post by KojiKamori »

xnview wrote: Tue Apr 19, 2022 6:35 pm i need to check the content of database file, please send me it
As I aforementioned there is sensitive information with in the DataBase however I were looking elsewhere to find solutions. SQLite allows me to view the DB file and all the tags are wiped clean, this is unfortunate. The DB file still contains the Table for the Folders, which as I thought WOULD dox me as well as the Table for images. I am scratching my chin to why the Catagories got wiped.

I was about to give up on this as I started re tagging everything again, using another file path to not affect the one that got wiped. Then I discovered on my other computer a copy of the DataBase as it were 2 years ago, still not up to date with everything added in 2 years, but it is a start. Question is, with what I were retaging, can I combined that with the old DB to save me all the efforts? I think this is as good as it is going to get and I just want to know, what wiped the DB to begin with and what safe gaurds are there to prevent this other then starting to make routine back ups of the DB periodically.
User avatar
xnview
Author of XnView
Posts: 45193
Joined: Mon Oct 13, 2003 7:31 am
Location: France

Re: Missing Catagories or Database.

Post by xnview »

Strange, you don't save categories in XMP metadata? You old DB use same folder structure?
Pierre.
KojiKamori
Posts: 8
Joined: Sat Sep 28, 2019 3:29 am

Re: Missing Catagories or Database.

Post by KojiKamori »

xnview wrote: Thu Apr 21, 2022 9:34 am Strange, you don't save categories in XMP metadata? You old DB use same folder structure?
My level of expertise on databases is small, so forgive me when I say, I have no idea what you are talking about. Though, I'm not a complete idiot, I can create websites pretty well and get paid for it so... Just another set of jargon. Any how, the structure of XNview that I have is everything being in that XnView.db file. There is no additional data the files themselves contain as most Jpegs allow for, as I save in PNG. Loseless data is best data.

I noticed that I can export categories into a text, xml, or Json But can they be merged? And yes, pretty much each DB references the same folders for the most part, other than in 2 years time, new folders were obviously created and so new files as well. I don't think that should be hard to do, should it? Scratching my chin at it as You have a file, it's location, and the tags associated though the location is what may be indexed differently between the two databases. Hmm perhaps it is a bit more complex than I thought....
User avatar
xnview
Author of XnView
Posts: 45193
Joined: Mon Oct 13, 2003 7:31 am
Location: France

Re: Missing Catagories or Database.

Post by xnview »

without the database it's difficult to help you...
Pierre.
charles.reily
Posts: 2
Joined: Mon Aug 14, 2023 6:47 am

Re: Missing Catagories or Database.

Post by charles.reily »

Unplugging and replugging an external hard drive while XnView MP is running can lead to the accidental deletion of the category database file (xnview.db). This file is crucial for maintaining the organization and categorization of your photos within XnView MP. If you suspect that this file has been deleted, you will need to rebuild the category database from scratch.

To prevent such data loss and ensure the integrity of your category database, consider integrating XnView MP with a robust B2B API integration solution. B2B API integration seamlessly connects XnView MP to a cloud-based data storage system, enabling real-time backup and synchronization of your category database. This eliminates the risk of data loss due to accidental deletion or hardware failures.

With B2B API integration, you can maintain a centralized repository of your category database, ensuring that your photo organization remains consistent across all devices and platforms. Additionally, B2B API integration facilitates seamless collaboration among team members, enabling them to access and update the category database simultaneously.

If you value the organization and categorization of your photos, investing in B2B API integration for XnView MP is a wise decision that safeguards your valuable data and enhances collaboration efficiency.