Recherche avancée

Sur d’autres sites (11075)

• How to count variable in for loop in power shell

  17 avril 2020, par ilham zacky

  I am using powershell and i have got a for loop running each time 3 variables get printed, for now, loop runs 5 times. I need to get the count like $i++

  



  This is a part of my code

  



  $file = "D:\edl\input\CPExport.xlsx"
$sheetName = "Sheet1"
$objExcel = New-Object -ComObject Excel.Application
$workbook = $objExcel.Workbooks.Open($file)
$sheet = $workbook.Worksheets.Item($sheetName)
$objExcel.Visible = $false
$rowMax = ($sheet.UsedRange.Rows).count
$nu = 0
$rowcount = 000 

for ($i = 0; $i -le $rowMax - 1; $i++) {
    $id = $sheet.Cells.Item($rowName + $i, $colName).text
    $name = $sheet.Cells.Item($rowAge + $i, $colAge).text
    $subtitle = $sheet.Cells.Item($rowCity + $i, $colCity).text
    $jpgId = "$id.jpg"
    $videoId = "$id.mp4"
    $audioId = "$id.m4a"
    $duration1 = if ((ffmpeg -i $audioId 2>&1 | Out-String) -match 'Duration:\s+([\d:"."]+)') { $matches[1] };
    $duration2 = if ((ffmpeg -i $jpgId 2>&1 | Out-String) -match 'Duration:\s+([\d:"."]+)') { $matches[1] };
    $duration = if ((ffmpeg -i $videoId 2>&1 | Out-String) -match 'Duration:\s+([\d:"."]+)') { $matches[1] };

    $newduration = ("$duration").Replace(".", ":")
    $newduration1 = ("$duration1").Replace(".", ":")
    $newduration2 = ("$duration2").Replace(".", ":")

    $out1 = ""
    $out2 = ""
    $out = ""
    $nu++
    $rowcount++
    if ($newduration1) {

        if ($nu -eq 1) {
            $audioA = "00:00:00:00"
        }

        $audioB = Add-Frame -Base $newduration1 -Offset $audioA
        $out1 = "$rowcount" + "  " + "AX" + "   " + "AA" + "     " + "C" + "   " + "00:00:00:00" + " " + $newduration1 + "   " + $audioA 
    }

    if ($newduration2) {

        $imagecal = Add-Frame -Base $imageA -Offset "00:00:06:00"
        $imageB = $imagecal
        $out = "$rowcount" + "  " + "AX" + "   " + "V" + "      " + "C" + "   " + "02:00:05:15" + " " + $newduration2 + "   " + " " + $imageA 
    }


    if ($newduration) {

        $videoA = $imageB
        $videocal = Add-Frame -Base $newduration -Offset $videoA
        $videoB = $videocal
        $out2 = "$rowcount" + "  " + "AX" + "   " + "AA/V" + "   " + "C" + "   " + "00:00:00:00" + " " + $hh + "   " + " " + $videoA 
    }
    else {
        $videoB = ""
    }
    $gg = $out1 + "`n" + "`n" + $out + "`n" + "`n" + $out2 + "`n"
    echo $gg

    $gg | Out-File -FilePath d:\edl\input\output.txt -Append
}
#close excel file
$objExcel.quit()


  



  i have echo $gg
this is the output

  



  1 AX   AA     C   00:00:00:00 00:00:03:48   
1  AX   V      C   02:00:05:15 02:00:11:15
1  AX   AA/V   C   00:00:00:00 00:00:06:93 
2  AX   AA     C   00:00:00:00 00:00:03:46   
2  AX   V      C   02:00:05:15 02:00:11:15    
2  AX   AA     C   00:00:00:00 00:00:03:46  
3  AX   AA     C   00:00:00:00 00:00:03:52   
3  AX   V      C   02:00:05:15 02:00:11:15   
3  AX   AA/V   C   00:00:00:00 00:00:06:93    
4  AX   AA     C   00:00:00:00 00:00:03:21   
4  AX   V      C   02:00:05:15 02:00:11:15    
4  AX   AA     C   00:00:00:00 00:00:03:21   
5  AX   AA     C   00:00:00:00 00:00:03:05   
5  AX   V      C   02:00:05:15 02:00:11:15    
5  AX   AA/V   C   00:00:00:00 00:00:06:93    


  



  Output prints only 1-5 
I need it to be printed 1 - 15

  



  any suggestions ?

  



  thank you for reading

  


• avformat/matroskaenc : Improve mimetype search

  3 novembre 2019, par Andreas Rheinhardt

  avformat/matroskaenc : Improve mimetype search
  Use the mime_types of the corresponding AVCodecDescriptor instead of
  
  tables specific to Matroska. The former are generally more encompassing :
  
  They contain every item of the current lists except "text/plain" for
  
  AV_CODEC_ID_TEXT and "binary" for AV_CODEC_ID_BIN_DATA.
  The former has been preserved by special-casing it while the latter is
  
  a hack added in c9212abf so that the demuxer (which uses the same tables)
  
  sets the appropriate CodecID for broken files ("binary" is not a correct
  
  mime type at all) ; using it for the muxer was a mistake. The correct
  
  mime type for AV_CODEC_ID_BIN_DATA is "application/octet-stream" and
  
  this is what one gets from the AVCodecDescriptor.
  Signed-off-by : Andreas Rheinhardt <andreas.rheinhardt@gmail.com>
  

  • [DH] libavformat/matroskaenc.c

• FFMPEG Select Both Mp3 & M4a Files Through PowerShell

  30 avril 2020, par ilham zacky

  Question - Need to select both *.mp3, *.m4a files from a directory.
I have some audio, video files, I am using ffmpeg or ffprobe to get the file duration,

  



  It runs in a loop, audio names will be taken from an excel sheet. In my directory folder, I have both mp3, m4a files.

  



  This is my code :

  



      $file = (Get-Item -Path ".\CPExport.xlsx")
    #$sheetName = "Sheet1"
    #Create an instance of Excel.Application and Open Excel file
    $objExcel = New-Object -ComObject Excel.Application
    $workbook = $objExcel.Workbooks.Open($file)
    $sheet = $workbook.Worksheets.Item(1)
    $objExcel.Visible=$false
    #Count max row
    $rowMax = ($sheet.UsedRange.Rows).count
    #Declare the starting positions
    $rowName,$colName = 1,1

    $id = $sheet.Cells.Item($rowName+$i,$colName).text

    $audioId = "$id.m4a"
    $videoId = "$id.mp4"
    $duration6= ffprobe -v error -show_entries format=duration -of csv=p=0 $audioId


  



  So I am using this $audioId variable and passing it to my ffmpeg code. Here I can select only the m4a files,
I need to select both mp3 and m4a files.

  



  Any Suggestion ?

  



  I am using Powershell.

  



  Thank you.