Messed up migration

Hi,
I followed you suggestion and sadly the duplicate /tv path did not resolve it. I have now ascertained that all the "missing" recordings are in the current /tv folder. However there are nearly 2500 of them. Mixed in with another similar number that the DB knows. Is there a way to copy/move all the recordings, known and unknown in the existing /tv folder and re importing the whole collection? If so I would appreciate a simple solution?

What is the absolute path to one of the "missing" recordings?
Case matters, so TV is not the same as tv
Examples;

/volume1/ChDVRtve/TV/Extraordinary Humans/Extraordinary Humans George Aldrich 2024-08-17-2230.mpg
/volume1/ChDVRhdhr/TV/Tracker/Tracker S01E01 2024-02-11 Klamath Falls 2024-07-28-2058.mpg

Question two
Did you perform a database backup on your QNAP and restore that backup on your Synology when you moved Channels DVR over?

The exact path is for the QNAP share:-
/share/CACHEDEV1_DATA/Home Media/TV/Vienna Blood (2019)/Season 01/Vienna Blood (2019) - S01E01 - The Last Seance.ts
But that does not exist anymore and it would appear that I copied the contents into the Channelsdvr/tv So the files exist, but in the current synology channelsdvr/tv folder.
I honestly cannot say if I performed a db backup and restore when I migrated from QNAP. The suggestion is that I did in some part, and this was either after I had moved the data in the channelsdvr/tv folder. But I cannot truthfully say what I did. Which is unhelpful I know, but saves going down a rabbit hole.
Michael

What is the absolute path to that "missing" recording on your Synology now?

Does that episode appear in your Library > TV Shows?

It is in TVshows


So the files exist, but in the current synology channelsdvr/tv folder. YES
path from file properties:-
/volume1/ChannelsDVR/TV/Vienna Blood (2019)/Season 01/Vienna Blood (2019) - S01E01 - The Last Seance.ts

OK
To find out where Channels DVR thinks the recorded file is, do this
Click the :gear:Options pulldown and select View Details
Then click the underlined File ID


Then look at the "Path"

What does it show? (you can click to the right of it to copy to clipboard)

That's strange. Channels DVR doesn't use the .ts file extension when it records, it uses .mpg

That's strange. Channels DVR doesn't use the .ts file extension when it records, it uses .mpg
That is because pre PLEX and the Channels I used 2 Humax recorders, and Hummy software.

So that wasn't recorded by Channels DVR?
Did you Import it into Channels DVR?
Still haven't answered the question Messed up migration - #13 by chDVRuser

Answering this one backwards.
Using the Vienna Blood example, I have 4 seasons. 2-4 exist and are on the Channels DVR DB. So when I go to season 2 I can achieve the screen you indicate.


However season one was on the QNAP share originally and does not offer the screen as it cannot find the file?

See the error note. Unless I am missing something?

But of course the file exists in the channelsDVR/TV folder as previously shown.

Yes, but the Channels DVR database thinks the file is in /share/CACHEDEV1_DATA/Home Media/TV

You can either create a new shared folder on your Synology
/share/CACHEDEV1_DATA/Home Media/TV and move only those "missing" TV Show recordings into it, then add it as an additional storage location

OR

Move only those "missing" recordings into /volume1/ChannelsDVR/Imports/TV and import them all into Channels DVR (not a fun and easy task)

OR

Move all your recordings into /volume1/ChannelsDVR/Imports/TV and import them all into Channels DVR (again, not a fun and easy task)

Of course, it's too late for the easiest way Channels Support - How do I move Channels DVR Server to a new computer?

OK, I can see what you are suggesting. The problem is its 2500 recordings which I do not know how to identify in bulk? As they and all the known recordings are in the channels dvr tv folder, could I copy the lot into a holding folder. Then delete all in the tv folder and in effect reimport the whole 5000 recordings back into Channelsdvr? Do you see a plan there somewhere?

You would be a sad puppy if you did that!

Channels DVR doesn't import as well as Plex and you will end up spending a lot of time fixing mismatched imports.

Probably best to come up with a way to identify which recordings/imports have the QNAP share path in the Channels DVR database and then do the first option

Thanks for all your time.

This will give you a list of all recordings in the Channels DVR database sorted by their path.

curl http://127.0.0.1:8089/dvr/files | jq --raw-output "sort_by(.ImportPath,.Path) | .[] | \"\(.ImportPath)\/\(.Path)\"" > /volume1/ChannelsDVR/Recordings_list.txt

Change the IP address and port (127.0.0.1:8089) to that of your Channels DVR Server.
Run this at an ssh command line on your Synology, or run it from Synology Task Scheduler.
If you need help doing either of these, just ask.
It will save the results into the text file /volume1/ChannelsDVR/Recordings_list.txt

Just updated it to show directories for any imports you may have done.
Recordings will appear like this

null/Movies/Titanic (1997) 2022-08-20-1258.mpg
null/TV/Yellowstone/Yellowstone S01E101 2018-06-20 Daybreak 2022-09-03-1158.mpg

Imports like this, showing the import directory

/shares/imports/Movie/The Discovery of Noah's Ark (1993)/The Discovery of Noah's Ark (1993).mp4
/shares/imports/TV/Farming the Wild (2018)/Farming the Wild (2018) - 2022-09-26 - Oregon USA Part 2.mp4

Also, if you installed Channels DVR using the Synology package, make sure to give the SYSTEM INTERNAL USER channels access to any additional storage locations or import directories you use.

Just had a "smack head" moment.

You can't use the first option since you can't create the /share directory on a Synology as a shared folder. On a Synology, shared folders have to be created in /volume1

You will have to move the "missing" recordings into an import directory and import them into Channels DVR. It won't be much fun, but move them into /volume1/ChannelsDVR/Imports/TV for TV Shows and /volume1/ChannelsDVR/Imports/Movies for Movies.

That's the best way, so if you migrate to something else, they will be in the correct directories to migrate that match the Channels database.

Thanks my biggest problem is bulk identifying the recordings that are in limbo.I cannot search on any criteria other than the path that the recording has related to it in Channels. Obviously the manage library function lists the "missing files" but I cannot get my head around how to make that list a search list. Maybe the channels database can be interrogated for a list of old qnap share path files? If you get another thought please share. Thanks

Did you try this?