| LinHES Forums http://forums.linhes.org/ |
|
| Importing NUV file http://forums.linhes.org/viewtopic.php?f=17&t=6399 |
Page 1 of 1 |
| Author: | macman [ Tue Oct 11, 2005 11:36 pm ] |
| Post subject: | Importing NUV file |
G'day, I have deleted an original when I transcoded. The good thing is I still have the original NUV file backed up. How do I "restore" it so that I can use it in myth as a recorded file with the correct length etc, and then edit it and transcode ? Any ideas ? Matt |
|
| Author: | macman [ Tue Oct 11, 2005 11:49 pm ] |
| Post subject: | |
G'day, Sorry, just did a bit more digging and it appears that this just isn't possible. I might have to move the file to a windows box and deal with it there. Matt |
|
| Author: | cecil [ Wed Oct 12, 2005 12:11 am ] |
| Post subject: | |
Why wouldn't it be possible? Use nuvexport to export a show w/ the SQL statement. Edit the SQL for your show, then import it back. Now that I've done this, but I see no reason why it wouldn't work. Unless that feature has been removed from nuvexport... |
|
| Author: | macman [ Wed Oct 12, 2005 1:51 am ] |
| Post subject: | |
G'day, Thanks for the reply. OK , I worked out what you meant by NUVexport. I ran it and it made a .sql file. I presume i need to edit that file and then do mysql < filename.sql. My problem now, is that I'm not sure what to edit out of the table so that I can rejig the cutpoints etc. I have a bit that goes something like USE mythconverg; INSERT INTO recorded (findid, programid, recgroup, hostname, previouslyshown, lastmodified, cutlist, commflagged, starttime, autoexpire, editing, preserve, endtime, category, deletepending, originalairdate, stars, chanid, description, filesize, subtitle, bookmark, recordid, title, seriesid) VALUES ('0', '', 'Default', 'mythtv', '0', '20051012160934', NULL, '1', '2005-10-02 19:08:00', '1', '0', '0', '2005-10-02 19:09:00', '', '0', '2005-10-02', '0', '1034', '', '4666364213', 'Sun Oct 2 19:05:00 2005', NULL, '13', 'NRL Grand Final (Manual Record)', ''); ; INSERT INTO recordedmarkup (mark, starttime, type, chanid, offset) VALUES ('0', '2005-10-02 19:08:00', '-3', '1034', NULL), ('0', '2005-10-02 19:08:00', '9', '1034', '0'), ('13', '2005-10-02 19:08:00', '9', '1034', '442156'), ('25', '2005-10-02 19:08:00', '9', '1034', '890936'), ('37', '2005-10-02 19:08:00', '9', '1034', '1340111'), ('49', '2005-10-02 19:08:00', '9', '1034', '1789820'); I was thinking maybe I just delete everything after 0') ??? Matt |
|
| Author: | cesman [ Wed Oct 12, 2005 2:05 am ] |
| Post subject: | |
Why not import it as is and manually edit the cutlist once you have it in Myth? |
|
| Author: | Greg Frost [ Wed Oct 12, 2005 2:52 am ] |
| Post subject: | |
All those numbers in the recordedmarkup table map frame numbers to byte offsets in the nuv file. These will be different for different recordings and seeking and commercial cutting will not work properly unless that data is correct. nigelpearson has made some posts about using mythcommflag --rebuild to rebuild the recordedmarkup data. Previously, it didn't work for mpeg2 files however he reports that it does work now. I have not tried it. You should edit the data in the "insert into recorded" query and then run the query. This is done something like Code: cat file_with_query.sql | mysql
Then run the mythcommflag --rebuild on that file. |
|
| Author: | bshroyer [ Wed Oct 12, 2005 5:28 am ] |
| Post subject: | |
If all you're looking to do is have the recording available for future viewing, and don't care that it doesn't show up in the "recordings" list, you could take this simpler approach: Convert to avi via nuv2avi Copy the avi to /myth/video The program in question now will show up as an entry in MythVideo. |
|
| Author: | macman [ Wed Oct 12, 2005 4:59 pm ] |
| Post subject: | |
G'day, Thanks for the replies, I think I have enough info to go a little further, I will report back how I go. BSHroyer, I want it in the recordings list because I need to edit it and blow it to DVD. Thanks |
|
| Author: | tjc [ Wed Oct 12, 2005 6:21 pm ] |
| Post subject: | |
You are in luck. Since you have the critical DB record you can restore the file and actually have it work again. DO NOT jigger the SQL! There is critical infomation in there which you simply can't get back by any means I was able to discover. Do as Cecil suggests and restore it as is, then fuss with the markup from inside MythTV. |
|
| Author: | macman [ Wed Oct 12, 2005 8:02 pm ] |
| Post subject: | |
G'day, What do I need to do within myth then ? Is there somewhere to "reinitialise" the clip and dump all of the cutpoints etc ? Matt |
|
| Author: | tjc [ Wed Oct 12, 2005 11:00 pm ] |
| Post subject: | |
There are more detailed instreuctions in an old posting around here somewhere but you just put the .nuv file in the right place (/myth/tv) and feed the .sql file to mysql to be run... As root: Code: mv CHANID_DATESTAMPSTART_DATESTAMPEND.nuv /myth/tv
mysql mythconverg <FILE_WITH_INSERTS.sql |
|
| Author: | macman [ Fri Oct 14, 2005 12:12 am ] |
| Post subject: | |
G'day Well, I successfully dragged the file back into Myth but somehow when I go to edit it, myth thinks it is 1 second long ! Obviously something isn't right. So now I think I will export it and burn it / edit it on windoze. So I ran nuvexport with the DVD option and I get a problem where it can't get fifos and then exits. When I just take the nuv directly to windoze, I can play it in WMP etc, but virtual dub etc won't recognise it. Any suggestions. Sorry to be a pain, but I am really keen to blow this to a dvd before I kill it. Matt |
|
| Page 1 of 1 | All times are UTC - 6 hours |
| Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |
|