Recherche avancée

Sur d’autres sites (7436)

• Trying to populate video file data to mysql database

  7 octobre 2015, par Tom

  I’m trying on a mac to loop through all videos in a directory and add the details (Duration, size and time) of the file to a mysql db. But for some reason every time it fails on the mysql part.

  If I take the mysql query generated by the script and run it on the mysql db it works fine. Can anyone help at all ?

  #!/bin/bash
  
  
  
  OrDir="/Volumes/Misc/video"
  
  find "$OrDir" -type f -exec /bin/bash -c \
  
      'name=$(basename "$1")
  
       name=${name%.*}
  
       duration=$( ffprobe -v error -show_entries format=duration -of default=noprint_wrappers=1:nokey=1 -sexagesimal "$1")
  
       hash=$( md5 "$1" | cut -f 4 -d " ")
  
       size=$( stat -f%z "$1")
  
  
  
       QUERY="UPDATE Video SET Duration=\"$duration\", Hash=\"$hash\", Bytes=$size WHERE Name=\"$name\" "
  
       echo "$QUERY \n"
  
       mysql --host=**.**.**.** --user=**** --password=****** **** << EOF
  
       $QUERY;
  
       EOF
  
  
  
       ' _ {} \;

  The * are omitting sensitive data and are correct (they’re used in another shell script with the same method that runs fine on the same server)

  This is just part of a larger script which will then be combined once this works properly

• Paid Advertising Performance – target the right customers and invest confidently

  21 avril 2020, par Joselyn Khor — Development, Marketing, Plugins
  You can now analyse the success of your Google Ads campaigns and accounts directly in your Matomo with ease. See what keywords and search queries are leading to clicks for your paid ads and bringing your business the highest ROI, right down to devices and networks – for more effective targeting.

  For many Matomo users, Google Ads is the lifeline for their business. If people are looking for products you sell, you’ll want them to find you first.

  Invest confidently in the right keywords and target the right customers for higher ROI

  You can accurately measure the success of your impressions, clicks, costs, CPC and CPAs and see how they directly relate to the goals you’ve created in your Matomo.

  -> Read the rest of the story on the Form Analytics Marketplace page.

  What does the new Paid Advertising Performance feature look like ?

  The PPC Advertising Performance plugin integrates seamlessly with Matomo’s Row Evolution feature to show you how the performance of your campaigns change over time. This way you can see if the changes you’ve made have a positive or negative effect on sales over time.

  

  The Visitor Profiles feature is also integrated within the plugin so you can get a detailed overview of everyone who clicks on your ads. This will tell you if they have visited your website in the past and to what extent, so you can identify and target more like-minded customers for more sales when setting up your next campaign.

  

  Where do I get the Paid Advertising Performance feature ?

  Paid Advertising Performance is available on the Matomo Marketplace :

  Get the Paid Advertising Performance feature here

  Learn more from the PaidAdvertisingPerformance user guide and FAQs.

• Anomalie #2727 : base et tables MySQL de type InnoDB

  5 juin 2012, par b b

  Pas mal d’infos intéressantes sur le passage de MyISAM vers InnoDB ici : http://mysql.rjweb.org/doc.php/myisam2innodb