VIDIMPORT crashing

[Reddwarf]

I'v been botherd for a while with this problem and found that filenames with "_" (underscore) not followed by a number seems to crash vidimport/gbpvr, the filename:

"D:\GBPC\The Cosmos_ A Beginners Guide\The Cosmos_ A Beginners Guide_20090719_17301800.avi"

makes it crash and no file is imported. Can someone come up with a fix for it quickly please?

[carpeVideo]

When does it crash - during import to GBPVR or during processing?

[dennit]

I'v been botherd for a while with this problem and found that filenames with "_" (underscore) not followed by a number seems to crash vidimport/gbpvr, the filename:

"D:\GBPC\The Cosmos_ A Beginners Guide\The Cosmos_ A Beginners Guide_20090719_17301800.avi"

makes it crash and no file is imported. Can someone come up with a fix for it quickly please?

That's odd, I've used vidimport for a while and I've never noticed this. Further, I just checked my RECORDING_SCHEDULE table in gbpvr.db3 and it has lots of these files:
\\ABCD\e\_UK\The Voyage of Charles Darwin\The_Voyage_Of_Charles_Darwin_Ep1.avi
that were entered with vidimport.

As an aside, it's not that hard to enter manually or even write a batch file to import into gbpvr.db3. You just need an entry in the PROGRAMME table to give you an oid which becomes the programme_oid in a corresponding entry in the RECORDING_SCHEDULE table. The hard part of vidimport is looking up info about the file on the net.

[Reddwarf]

When does it crash - during import to GBPVR or during processing?

It crashes during import when it comes to that folder, "ordinary" names is imported fine, but this and all following folders is not imported.

That's odd, I've used vidimport for a while and I've never noticed this. Further, I just checked my RECORDING_SCHEDULE table in gbpvr.db3 and it has lots of these files:
\\ABCD\e\_UK\The Voyage of Charles Darwin\The_Voyage_Of_Charles_Darwin_Ep1.avi
that were entered with vidimport.

As an aside, it's not that hard to enter manually or even write a batch file to import into gbpvr.db3. You just need an entry in the PROGRAMME table to give you an oid which becomes the programme_oid in a corresponding entry in the RECORDING_SCHEDULE table. The hard part of vidimport is looking up info about the file on the net.
Reply With Quote

In fact, I would prefer a batch file to enter these recordings into GBPVR, they originates from MediaPortal and Vidimport is invoked from it in a batchfile which also queues the recording for post processing. Since vidimport craches the recording is never put into the postprocessing queue eighter.

Unfortunately all databasehandling is like swahili to me, so if someone could give me an example of a batchfile to put a recording into gbpvr's database and possibly explain what it does I'd be very happy

[dennit]

all databasehandling is like swahili to me, so if someone could give me an example of a batchfile to put a recording into gbpvr's database and possibly explain what it does I'd be very happy

Well, I don't mind messing up my own database, or even encouraging others to mess up theirs, but writing a batch file that screws up yours would worry me. I'd feel responsible.

How about this instead:
Use a batch file to strip your problematical underscores:

Code:

for /f "tokens=1,2 delims=_" %%i in ('dir /b /a:-d') do IF EXIST "%%i_%%j" ECHO "%%i_%%j" To "%%i-%%j"

Replace "ECHO" with "ren" to rename the files. As it is it will just list files.

The 'dir /b /a:-d' will find all files (no directories) in the current directory. The "tokens=1,2 delims=_" will handle files with a single underscore and replace with a hyphen.

If you want to handle files with two underscores, just add:

Code:

for /f "tokens=1,2,3 delims=_" %%i in ('dir /b /a:-d') do IF EXIST "%%i_%%j_%%k" ECHO "%%i_%%j_%%k" To "%%i-%%j-%%k"

[ACTCMS]

"D:\GBPC\The Cosmos_ A Beginners Guide\The Cosmos_ A Beginners Guide_20090719_17301800.avi"

\\ABCD\e\_UK\The Voyage of Charles Darwin\The_Voyage_Of_Charles_Darwin_Ep1.avi

This is probably a red herring... but, from dennit's post, underscores don't look like the problem. Could it be something to do with the fact that you have a blank between 'Cosmos_' and 'A Beginners' - might be worth trying to manually edit out the blanks in one of your files then trying Vidimport again...

[Reddwarf]

Tha blank in front of the underscore does not matter, by running vidimport manually I was able to see that it is actually PVRX2.EXE that crashes in a routine called StringToNumber. Obviously PVRX2 expects a number immidiatly following the first underscore, so renaming the file and replacing "_" with "-" makes sence, but ONLY if it not followed by a number. But telling if it is would probably be a very complicated batch ?

[dennit]

Tha blank in front of the underscore does not matter, by running vidimport manually I was able to see that it is actually PVRX2.EXE that crashes in a routine called StringToNumber.

FYI: As a test, I updated my vidimport and tried to import some files with underscores - including some with numbers, and some with letters following the underscore. They all imported fine into my database.

[ACTCMS]

FYI: As a test, I updated my vidimport and tried to import some files with underscores - including some with numbers, and some with letters following the underscore. They all imported fine into my database.

Did you try underscore followed by a blank by any chance?

[dennit]

Did you try underscore followed by a blank by any chance?

No. When I posted the FYI, I realized I should have tested blanks, but it didn't occur to me when I did the tests.

In addition, I'm not sure why PVRX2.EXE is crashing (in a routine called StringToNumber), since I'm not even sure why PVRX2 would be involved. I would expect vidimport to just collect the data it needs from online, then do an SQL INSERT INTO the two tables needed in the db3. The only other thing that vidimport does that I know of is to add a channel named IMPORT that corresponds to the channel the imported video was recorded on.