timestamp_link_maker

Create automatic descriptions with a several timestamp link, of a video composed by the joining of several small videos

Usefulness:

This application was developed specifically for video files that were generated from the grouping of several video files.
For example:
output video file 1: Created by joining 5 videos
output video file 2: Created by joining 12 videos
output video file 3: Created by joining 8 videos

This scenario would be expressed in a spreadsheet with 25 lines (one for each paternal video), where the column 'file_output' would contain only 3 distinct values.

This file structure is automatically generated by the app mass_videojoin

:Input:

The application's goal will be to create a description with timestamps link for each output video file, considering the length of his paternal videos.

Descriptions will be generated in two formats:

spreadsheet 'descriptions.xlsx':
Output video descriptions with timestamp link, folder structure and sequential hashtags

:Output 1:

text file 'summary.txt':
General summary of all output videos, folder structure and sequential hashtags

:Output 2:

Requirements:

-- Spreadsheet named 'video_details.xlsx' in same folder as this script

--- Required columns:
---- 'file_folder': actual file folder
---- 'file_name': actual file name with extension
---- 'file_folder_origin': original file folder
---- 'file_name_origin': original file name with extension
---- 'file_output': file name of joined video

--- Optional columns:
---- 'duration': video duration in the format 'hh:mm:ss'.
----- Example:
------ For a video line with 2 hours, 13 minutes and 8 seconds
------ duration value need to be: 02:13:08

note: The 'duration' column is optional because the app is able to capture the duration of each video. But videos have risks such as the incorrect duration metadata because the video could be partially corrupted. The explanation about this case is exemplified by a video whose duration metadata reports to be 3 hours, but has only 1 hour playable. As the current capture method does not correct metadata for partially corrupted videos, the user can enter his own duration column.

To facilitate the readability of the paternal videos in the timestamps, the name of their original folders are used to group the timestamps.

To ensure the correct capture of the name of the original paternal files and folders, the columns 'file_folder_origin' and 'file_name_origin' are required. If the names of the current files and folders are the same as the original ones, then the column 'file_folder_origin' can be created as a copy of 'file_folder', as well as the column 'file_name_origin' can be created as a copy of 'file_name'.

How to use

If it's your first time using the tool

Execute update_libs.bat

For the next times
2. Make sure the spreadsheet 'video_details.xlsx' is in the same folder as the script
3. Execute timestamp_link_maker.bat

Do you wish to buy a coffee to say thanks?
LBC (from LBRY) digital Wallet

bFmGgebff4kRfo5pXUTZrhAL3zW2GXwJSX

We recommend: