Converting DVD with VLC

A friend recently asked me how to convert a DVD into MP4 or any other format (AVI, MOV, etc.) quick, free and easy.

This is the process of converting DVD chapters or films into MP4 with VideoLan (a.k.a. VLC), a free and open source video player you can download from

Step 1: Open VLC and select “Convert / Save” from then menu:

Step 2: Click the “Add” Button

Step 3: Open the DVD (or folder where you copied the DVD files) and select one of the chapters or the main movie (usually the VOB file with the largest size). Click on “Open”

Step 4: Click on the Convert / Save dropdown and pick “Convert”

Step 5: In profile, select H.264 + MP3 (MP4) – This is my preferred format but you can pick any other format from the dropdown list.

If you want to preview the file while it’s being converted, check the “Display the output” checkbox

Step 6: In destination file, click Browse and pick the folder where you want to save the output / resulting MP4 file

Step 7: Let VLC do its job. If you’re not previewing the result (displaying the output), you can check the progress in the time bar

That’s it!

Facebooktwitter Facebooktwitter

27 Video Formats and Styles to Inspire You

A collection of video styles to inspire your next post or campaign on social media or traditional media.

1. Narrator Video

An invisible narrator is telling the story creating distance between you and the subject which can – depending on the story – give a feel of fantasy, romance, wonder, or expertise (if the voice is the one of an expert in the field in case of a scientific video). This can be your best option if you have a lot of B-rolls and no time to shoot.

2. First-Person Video

The story is – also  about you (or the person/ spokesperson/ brand you’re trying to promote). You’re the main character in the video, asking, investigating, suggestion, explaining. The camera is following you and you’re sending the message. Use this video if you or the main player are a charismatic people, professionals and experts in the subject at hand. Remember “the messenger is the message”: the message will only reach your audience if you’re capable of carrying it.

3. Infographics video

Tell it with graphics. Has been used extensively in the past few years and is somehow becoming a has-been style. Nevertheless, can still attract people in an academic, training or NGO context.

4. Green Screen Infographics

To make infographics more lively and “human”, add a narrator that will turn the infographic into a story, lead the spectator through the process, explain, and throw jokes to wake the viewer…

5. Props Videos

Show it with objects. Despite a much lower cost than production, videos using can be more impactful just by using small elements to show by example.

6. PIP Videos

Picture in Picture (PIP) videos are Ideal for academic videos and online training. While the video is playing or the steps are performed on the screen, your face shows in a corner giving the impression that you’re actually there now (even if the video is not live).

7. DIY Small Budget Video

You have a limited budget. Use Internet libraries for photos, music, transitions. Make it short and meaningful. Three elements are necessary to succeed: a good camera and lens (amateur, semi-professional or professional equipment), good lighting (extremely important in low light situation or outdoors – choose the right time), and semi-professional microphone (missing from this video).

8. Photo Montage Slideshow Video

You have a stack of photos, nothing else. Use Microsoft PowerPoint to create a slideshow, add some music and effects, and you’re done! Or, better, use Adobe After Effects to make it professional.

9. Traditional Ad

Still trending despite the fact that it has not shown results in terms of ROI. You can use those to display “power” but not to sell.

We prefer the “story” approach with tackles with the science of influence using either reasoning, show by example, or emotions.

10. Ads with a Twist, Branding Commercials

If your commercial video is about your brand and your persona, it will succeed. Use psychology, sociology and storytelling to talk to your audience. A brand is about a feeling, not a product.

11. Emotional Ads / Stories

The brand becomes a “trojan horse” inside the Ad. The Ad is about you or people like you, the brand is only a tool that gets you from your current situation to a better one.

12. Social Experiment

Use real case experiments to show your point. Be aware that this raises ethical and legal issues and must be carefully conducted.

13. Whiteboard Animations

Can be done using specialized software (low cost) or a manual process. This is very simple to create. Success depends largely on the quality of the 2D drawings you make and the sequencing and narration.

14. Animation and Motion Graphics

2D, 3D, CGI (computer generated graphics), the possibilities are endless…

15. Claymation or Muppet Movies

Using clay, toys, puppets, dolls or else, can, in some situations and for some audiences, make an impact.

16. Interactive Videos

Turn your video into a game where the user chooses his own ending. Netflix has experienced this with Black Mirror’s Bandersnatch.

17. Documentary

Use a traditional approach to presenting your subject. Remember that this requires a lot of preparation in terms of research, script, analysis and interviews… A documentary is almost never shorter than 20 minutes.

الفيلم الوثائقي الخاص بحملة #أفعال

الفيلم الوثائقي الخاص بحملة #أفعال لمكافحة #الفقر_المدقع .وقّعوا ضدّ الفقر المدقع:أفعال#الفقر_في_لبنان#صوتك_ضد_الفقر

Posted by ‎National Bloc – الكتلة الوطنيّة‎ on Wednesday, October 16, 2019

18. News-like

Similar to documentaries, they rely heavily on still photos, animation, text overlay, b-rolls, infographics, supers and voice-overs

19. Cognitive Dissonance and Trigger Ads

Defy logic or bring elements that have nothing to do with the problem at hand. Make it fun or weird. It will stick in people’s mind as it challenges their expectations and is out of the ordinary.

Associate your product with ideas and activities in people’s lives: words, top of mind, habits (coffee in the morning), locations…

20. Live / Streaming Videos

Facebook, YouTube and other platforms and tools (like OBS studio) allow you to live stream. The main take out here is live interaction with your audience. Can be used as a support or education tool or to show an event as it occurs.

المؤتمر الصحافي لإطلاق حملة قانون أفعال لمحاربة الفقر المدقع

Posted by ‎National Bloc – الكتلة الوطنيّة‎ on Wednesday, October 16, 2019

21. Full Movies

If you have money, time and imagination, and a team of experts – or youth (allowing you to spare time) and a solid stomach (allowing you to live on sandwiches), go for the full package (animated, or with real actors) to transmit your message.

22. Video Clips

Say it with Music…

23. “Programmed” incidents and fake scandals

Use clips filmed “by surprise” with a smartphone or low budget cameras (however make sure the quality is good enough) to spread rumor, curiosity and create interest and follow-up on other platforms and channels.

24. User Generated Content or Citizen Journalism

Let customers do the content for you. Encourage and empower users, launch competitions, hashtags, events, communities, make the brand about THEM, not YOU.

25. Leaks

Leak a video to a small seeding population and let it go viral. Depending on your strategy and objectives, you may leak other videos or names to create a buzz.

26. Interviews

Two cameras or more, one location or vox pop (a.k.a. “man on the street“, interviews with members of the public), can be an easy way to send a message or promote a product or event…

27. Deep Fakes

To make this article as extensive as possible, deep fakes are a new technology allowing you to put words in other people’s or animated character’s mouth.

Remember, the rule is not to copy but to innovate. This list is here to help you in your first step: knowing what’s out there. The rest is up to you and your imagination.

Facebooktwitter Facebooktwitter

Combining Multiple Twitter Searches in NodeXL

There are two reasons you may need to combine different Twitter imports in NodeXL:

  • You want to import tweets for the same search for a longer period than a week (Twitter’s limit) by re-importing the results for the same search every few days for the period you want to cover
  • You want to add several searches without using the “AND”, or you may just have missed a hashtag or search string you need to add to your workbook

After your first import, make sure to disable “clear the NodeXL workbook before the data is imported”:

Proceed with your new import(s). Add as many searches as you need to the same workbook.

After you are done, you need to remove duplicates from the vertices and edges sheets


Go to the vertices sheet. From the ribbon, choose “data” and “remove duplicates”

Deselect all fields (using the Unselect All button), and pick “vertex”

click “OK”

If no duplicates are found, you should receive the following message:

Go to the “Edges” sheet, “data” tab in the ribbon and “remove duplicates”.

Deselect all and pick the following fields: Vertex 1, Vertex 2, ID, Relationship and Relationship Date (UTC):

Excel will find and remove Edges duplicates:

Save your Excel Workbook.

Good discussion analysis!

Facebooktwitter Facebooktwitter

Using LostCircles’ Graphml files with NodeXL

LostCircles ( uses a proprietary format that NodeXL fails to open and use.

Below is a workaround for this problem and a step by step approach to charting your Facebook network of friends:

  1. Open the “Graphml (No Pics)” file downloaded from LostCircles
  2. Find the <node id=”n0″> tag and delete all the text that precedes it
  3. Copy and paste the text below before the  <node id=”n0″> tag:
<?xml version="1.0" encoding="UTF-8"?>
<graphml xmlns="">
<key"label" attr.type="string" for="node" id="label"/>
<key"Edge Label" attr.type="string" for="edge" id="edgelabel"/>
<key"weight" attr.type="double" for="edge" id="weight"/>
<key"r" attr.type="int" for="node" id="r"/>
<key"g" attr.type="int" for="node" id="g"/>
<key"b" attr.type="int" for="node" id="b"/>
<key"x" attr.type="float" for="node" id="x"/>
<key"y" attr.type="float" for="node" id="y"/>
<key"size" attr.type="float" for="node" id="size"/>
<key"id" attr.type="string" for="node" id="d0"/>
<key"name" attr.type="string" for="node" id="d1"/>
<key"userName" attr.type="string" for="node" id="d2"/>
<key"profile" attr.type="string" for="node" id="d3"/>
<key"dataUrl" attr.type="string" for="node" id="d4"/>
<graph edgedefault="undirected">
  1. Save the file or Save it As a new GraphML file
  2. Open NodeXL and “import from GraphML file”
  3. Group by cluster and put all neighborless vertices in one group
  4. Go to the Vertices sheet
  5. The URL in the Label column is the same as the URL in the profile column (redundant information that you can replace). Change the format of the Label column from Text to General to allow the insertion of formulas (otherwise, your formulas will appear as text and will not be calculated)
  6. Delete all values in the Labels column (enter the first cell, then ctrl+space and delete)
  7. Type =[@name] in the first cell of the Labels column. It should automatically replicate to all the rows
  8. In the graph pane, choose the Harel-Koren Fast Multiscale graph style
  9. From the same dropdown, go to the Layout options and Lay out each group in its own box
  10. Draw the graph – If you have a few hundred friends on Facebook, fairly distributed in groups (family, colleagues, beer buddies, etc.), the layout should be good enough
  11. Calculate all graph metrics
  12. Autofill Columns with Vertex Size linked to Degree with vertex size options ranging from 1 (smallest) to 50 (largest)
  13. Sort the vertices by Degree
  14. Set the label position of vertices 50+ to “nowhere” to hide the least connected friends
  15. A good practice would be to set the tooltip to the username in order to see the names when you hover over a vertex




 Facebooktwitter Facebooktwitter

Showing Bridging Nodes Only in NodeXL

Bridges (edges) and bridging nodes (vertices) in a network are essential in connecting cliques, moderating the debate and introducing new ideas and innovations and filling structural holes in a network (ref. Ronald S. Burt).


When you separate vertices in groups in NodeXL (figure), several columns are added to your “edges” sheet, mainly “Vertex 1 Group” and “Vertex 2 Group”

Refreshing the graph using the “lay out each of the graph’s groups in its own box” (figure)

return a graph where nodes/vertices are separated into groups, each painted in a different color:

Finding edges with high centrality or degree is straightforward in NodeXL but, what if you wanted to find the bridges between groups? people who are transporting/propagating the debate/discussion from one clique to the other?

First, we need to determine the bridging edges between groups:

  • In the Edges vertices, add a column “Bridging” and type the following formula: =IF([@[Vertex 1 Group]]<>[@[Vertex 2 Group]],1,0). This formula should return 1 if the the group of Vertex 1 is different from the group of Vertex 2 (“vertex 1 group” and “vertex 2 group” columns)
  • Hide the edges that do not traverse groups but adding the following formula in the “visibility” column in the “edges” sheet: =IF([@Bridging]=1,”Show”,”Hide”)

If you refresh the graph now, it should look like this:

It is still confusing but most edges have disappeared. Next step is to hide the vertices that are no longer connected to any other vertex (technically, the vertices that do not bridge with other vertices in other groups or cliques):

In the “Vertices” sheet, add a new column, “bridge”. We need to count/sum all the bridging edges where this vertex is connected (left or right). The formula to add in the “bridge” column is: =SUMIF(Edges[Vertex 1],[@Vertex],Edges[Bridging])+SUMIF(Edges[Vertex 2],[@Vertex],Edges[Bridging])

the formula in simple English: Sum the values in the Bridging column only if  the Vertex 1 column in the Edges table contains the name of the current vertex. Do the same if the name of the current vertex is in the vertex 2 column.

A value of zero means that the vertex is not a bridging node. The higher the value, the higher the number of connections of this vertex to people outside its group or circle of friends:

The last step is to hide the non-bridging vertices. In the Visibility column of the vertices sheet, type the following formula: =IF([@Bridge]=0,”Hide”,”Show”)

You can also use “Skip” instead of “Hide” to exclude the non-bridging vertices from future calculations (need recalculation).

To display the names of the vertices, in the “Label” column, type =[@Vertex]

In the image below, for aesthetic purposes, I hid all the bridging nodes that have less than ten connections with other groups (=IF([@Bridge]<10,”Hide”,”Show”) in the Visibility column of the vertices sheet instead of =IF([@Bridge]=0,”Hide”,”Show”):

In a glimpse, we can now see that “canal plus”, “cannes festival”, “nadine labaki”, “sony classics”, etc., have helped disseminate the information to ten groups or more.

The sheet used for this post can be downloaded here.

 Facebooktwitter Facebooktwitter

Converting VCF contacts to Excel or CSV

One VCF or several VCF?

A VCF file can hold several contacts. So, you may have just one VCF for all your contacts (ideal) or one VCF for each contact. If this is the case, you need to merge all your contacts into one file. To do this, open your command prompt and use the following command in the vcf folder:

copy *.vcf all.vcf

This will merge all the vcf(s) into one file name “all.vcf”

Converting to Excel or CSV

Download the “Free VCF file to CSV or Excel converter” macro from here and open it. It will automatically launch Excel and ask you for a file to convert.

Choose “all.csv”

Save the file.

That’s it!Facebooktwitter Facebooktwitter

Fixing Audio Recording Problems with Screen Recorders

This fix has worked with Apowersoft Video Download Capture screen recording program. This solves the problem of recording video but not getting any audio recorded (no sound).

The fix is to enable the Stereo Mix device and to disable the Microphone in the recording devices tab. Leaving Microphone enable will also record ambient sound in the room.

Once you have enabled Stereo Mix as your default device, just select Microphone in your screen recording software (in my case Apowersoft Video Download Capture) as your  audio capture device:

Does this help? let me know.Facebooktwitter Facebooktwitter