Category Archives: Technologies

How to Automatically Create a Subtitle for a Video

Motivation:

You have MP4 video file.
You want to create a subtitle to understand the video content.

Solution:
  1. Split MP4 file to 9-minutes files (please refer to https://huybien.com/how-to-trim-or-cut-mp4-files-without-re-encoding/ for details).
  2. Log in https://www.veed.io
  3. Click the “+” icon.
  4. Upload a 9-minutes MP4 file.
  5. Click the “Subtitles” tab.
  6. Click the “Auto Translate” button. Select the language for the subtitle.
  7. Click the “Start” button. Wait for the process to be complete.
  8. Click the “Export” button.
  9. Ensure that the “Burn Subtitle” option is selected.
  10. Click the “Export Video” button. Wait for the process on the left to be complete.
  11. Click the “Download MP4” link.

 

How to Move Outlook Data to a New Computer

Motivation:

You need to move Outlook data and settings from an old computer to a new computer.

Solution:

1. On the destination (new) computer:

    • Type Control Panel in Search box.
    • Click on Control Panel.
    • Select Large icons for View by.
    • Click Mail (32-bit).
    • Click Add. Set Profile Name = Outlook.
    • Follow the instructions to setup an account.

2. On the source (old) computer:

    • Open Outlook.
    • On the File menu, click Data File Management.
    • Click the data file that you want to compact, and then click Settings.
    • Click Compact Now.
    • Close Outlook.

3. Copy and overwrite all the contents of %USERPROFILE%\Local Settings\Application Data\Microsoft\Outlook to the destination computer. Create the Outlook folder if it does not exist.

4. Open Outlook in the destination computer.

Note: If you are using POP3 protocol then all the messages will be re-downloaded again once. If this is true for you then

    • Let Outlook finish downloading the messages, then
    • Click on Unread Mail folder below the Search Folders,
    • Select all the messages,
    • Press Shift, right click and click Delete to permanently delete them all.

 

How to Trim or Cut MP4 Files Without Re-Encoding

Motivation:

You have MP4 files with unwanted portions. You want to trim these portions.
You may also want to cut a MP4 file into files with equivalent length for uploading to specific storage that limits length of an uploaded video.

Solution:

  1. Download XMedia Recode.
  2. Unzip the downloaded package.
  3. Click on the XMedia Recode.exe file to open the application.
  4. Open a MP4 file.
  5. Under the Format tab set
    Profile = Custom
    Format = MP4
    File Extension = mp4
  6. Click the Video tab and set Mode = Copy on the middle panel.
  7. Click the Audio tab and set Mode = Copy on the middle panel.
  8. Click the Filters/Preview tab and set Start Time and to (End Time).
  9. Click the Add to queue button (with the + icon) on the tool bar.
  10. Click the Encode on the tool bar.

If you want to split a MP4 file to multiple files with equivalent length for uploading to specific storage that limits length of an uploaded video by time then follow the procedure below.

    1. Download XMedia Recode.
    2. Unzip the downloaded package.
    3. Click on the XMedia Recode.exe file to open the application.

Open a MP4 file.

  1. Under the Format tab set
    Profile = Custom
    Format = MP4
    File Extension = mp4
  2. Click the Video tab and set Mode = Copy on the middle panel.
  3. Click the Audio tab and set Mode = Copy on the middle panel.
  4. Click the Filters/Preview tab and specify appropriate time range for each file, for example from 00:00:00:0000 to 00:09:00:0000.
  5. Click the Add to queue button (with the + icon) on the tool bar.
  6. Click the Encode on the tool bar.
  7. Repeat the procedure for the same file with different time ranges. For example use time range from 00:09:00:0000 to 00:18:00:0000 for creating the second file, then time range from 00:18:00:0000 to 00:27:00:0000 for crating the third file, etc.

How to add multiple IPs to an Amazon EC2 virtual machine

Motivation:

You have a Server 2008 R2 machine on Amazon EC2.

You want to secure multiple domains using different  SSL/TLS certificates.

Server 2008 R2 does not support Server Name Indication (SNI). Therefore you need to add multiple IPs to Server 2008 R2 machine to use different SSL/TLS certificates.

Solution:
  1. Create an EC2 virtual machine.
  2. Click on Network Interfaces tab.
  3. Click Create Network Interface button or select an existing network interface and select Actions > Attach.
  4. Click on a network interface ID, click Actions, click Manage IP Addresses, click on the network interface name (beginning with eth…), click the Assign new IP Address button, enter a private IP Address (e.g. 172.30.0.32), click the Save button, click the Confirm button.
  5. Click Elastic IPs tab, click the Allocate Elastic IP address button, click the Allocate button, optionally name the new allocated IP.
  6. Select the new allocated IP, click on Actions , click Associate Address, choose Network interface, then choose a private IP of the network interface with which the elastic IP will be associated, click the Associate button.
  7. Login Windows.
  8. View the network configuration using below command, note the Default Gateway and DNS Servers information.
ipconfig /all

9. Open Control Panel\All Control Panel Items\Network and Sharing Center.

10. Click Change adapter settings link, click a Local Area Network Connection Network.

11. Manually enter one IP address, Default Gateway and DNS Servers information.

12. Click Advance… button to open Advanced TCP/IP Settings screen, and add the private IPs in the 4th step to the machine.

13. Restart the machine.

If you get any issue then try limit the number of private IPs of a network interface to 4 (including the default private IP).

How to change language of an EPUB file

Problem: Sometimes you have an EPUB file encoded with a wrong language tag.
Therefore when you use the Read aloud feature of the Google Play Books application the book is read aloud in a wrong language.

Solution:

  1. Download the EPUB file to a PC.
  2. Change the extension from EPUB to ZIP.
  3. Open the .ZIP file.
  4. Open the content.opf file using the Notepad app.
  5. If you cannot file this content.opf file then please navigate to the OEBPS folder.
  6. Find the tag <dc:language> and change its value (e.g. from <dc:language>en</dc:language>to <dc:language>vi</dc:language>).
  7. If you cannot find the tag <dc:language> then just add a new tag right above the </metadata> tag (e.g.
    <dc:language>vi</dc:language>
    </metadata>
  8. Save the content.opf file and rezip the EPUB file.
  9. Change the file extension from ZIP to EPUB.

How do we make an image look darker using Photoshop?

How do we make an image look darker using Photoshop?

  • Use Ctrl+J to duplicate the image layer
  • Click on the top layer and change the blend mode to either Multiply or Overlay
  • Go to Image > Adjustments > Levels
  • Adjust the middle node (sliding right makes darker image, sliding left makes lighter image) till you get your desired outcome.

How do we change a layer’s opacity?

  • Right click a layer > Blending Options…
  • Change the Opacity value

How do we straighten a photo (transform perspective while cropping)?

  • Hold down the Crop tool and select the Perspective Crop tool
  • Draw a marquee around the distorted object. Match the edges of the marquee to the rectangular edges of the object.
  • Press Enter (Windows) or Return (Mac OS) to complete the perspective crop.

How do we crop a photo with 4×6 ratio?

  • Hold down the Crop tool and select the 2:3 (4:6) from the drop down box on the top panel.
  • Resize the grid to appropriate size.
  • Right click on the image and select Crop.

How do we horizontally straighten a photo?

  • Hold down the Ruler tool and draw a line as the new horizontal.
  • Click Straighten Layer on the top panel.