Scenarist 3.1.5 Import chapter

[PhillipWyllie]

Now that 3.1.5 has the import chapter feature turned on I thought I'd let people know the format for the csv file, if you don't already know. It's:

PAL
hh:mm:ss;nn,chapter name,

Note the semi-colon( ; ) between the minute and frame-number, the comma( , ) between the frame-number and chapter name, with each line ending on a comma( , ).

NTSC
hh:mm:ss:nn,chapter name,

Note the colon( : ) between the minute and frame-number, the comma( , ) between the frame-number and chapter name, with each line ending on a comma( , ). For drop-rame encoded video the chapter file must be saved in a non drop-frame format as scenarist seems to assume that all chapter files are in the non drop-frame format and does the conversion.

White-space seems to be ignored. You don't have to add chapter names. Also SceneImport doesn't work now.

[crya]

Hi, it is interesting,pls post a few lines for example,also,if you can tell here what prg extracts chapters into this format?
thanks

[PhillipWyllie]

CCE chapter file:
%Frame Rate 3,0
00:03:15:20 chapter1
00:06:09:15 chapter2
00:11:02:00 chapter3
00:14:04:02 chapter4
00:16:14:07 chapter5
00:19:45:23 chapter6
00:22:56:02 chapter7
00:25:37:11 chapter8
00:28:28:19 chapter9

Scenarist csv file:
00:03:15;20,chapter1,
00:06:09;15,chapter2,
00:11:02;00,chapter3,
00:14:04;02,chapter4,
00:16:14;07,chapter5,
00:19:45;23,chapter6,
00:22:56;02,chapter7,
00:25:37;11,chapter8,
00:28:28;19,chapter9,

[alfixdvd]

Hi, it is interesting,pls post a few lines for example,also,if you can tell here what prg extracts chapters into this format?
thanks

ChapterExtractor let's you define your format for chapter.

[crya]

Hi,me again,it seems that i'm so stupid i cannot make a preset for the .csv in chapter extractor.Please make one for me and PM me so i can give you my email.Please
Or,if in the mean time u manged to find another program that extracts chapters in csv format,pls share.Thank you.

[bigotti5]

Use this...
%hh:%mm:%ss:%ff,chapter%c,\n

[PhillipWyllie]

Here's a batch file I made, I'd appreciate comments and improvements.
Usage:
Either drag and drop (multiple if you want) CCE chapter file over the batch file, or specify at the command prompt. Here's the code:

:BEGIN
@echo off
TITLE CCE to Scenarist chapter converter
if "%~1"=="" goto NEEDFILE
echo This will turn CCE chapter output files to Scenarist's chapter format
echo.
pause
echo.

:START
if /i "%~1"=="" goto END
echo -----------------------------------------------------------------------------
echo Using: %~nx1
echo.

for /F "usebackq tokens=2* delims= " %%i in ("%~1") do (
@echo Testing TV mode...
@echo.
for /F "usebackq tokens=1,2* delims=," %%j in ('%%i') do (
if %%j==3 goto PAL
if %%j==4 goto NTSC
@echo Can't determine the TV system of %~nx1
@echo.
shift
goto START
)
)


:PAL
echo This is a PAL chapter file
echo.
echo #Scenarist chapter file generated from CCE chapter file >"%~d1%~p1%~n1.csv"
for /F "usebackq skip=1 tokens=1,2,3,4,5* delims=: " %%i in ("%~1") do (
if not "%%m"=="" (
@echo %%i:%%j:%%k;%%l,%%m, >>"%~d1%~p1%~n1.csv"
) ELSE (
@echo %%i:%%j:%%k;%%l, >>"%~d1%~p1%~n1.csv"
)
)
shift
goto START

:NTSC
echo This is a NTSC chapter file
echo.
echo #Scenarist chapter file generated from CCE chapter file >"%~d1%~p1%~n1.csv"
for /F "usebackq skip=1 tokens=1,2,3,4,5* delims=: " %%i in ("%~1") do (
if not "%%m"=="" (
@echo %%i:%%j:%%k:%%l,%%m, >>"%~d1%~p1%~n1.csv"
) ELSE (
@echo %%i:%%j:%%k:%%l, >>"%~d1%~p1%~n1.csv"
)
)
shift
goto START

:NEEDFILE
echo You must specify a CCE chapter file(s)
echo.
pause
exit

:END
echo -----------------------------------------------------------------------------
Echo All done...
echo.
pause
exit