Category Archives: Technologies

How to Fix EPUB Processing Failure on Google Play Books

Problem:

You uploaded EPUB file to Google Play Books but received Processing Failed error message.

Solution:
  1. Open https://www.zamzar.com.
  2. Click Choose Files and select EPUB file.
  3. Click Convert To and select azw3.
  4. Click Convert Now button.
  5. Download the azw3 file.
  6. Return to https://www.zamzar.com.
  7. Click Choose Files and select azw3 file.
  8. Click Convert To and select EPUB.
  9. Click Convert Now button.
  10. Download the EPUB file.
  11. Upload the EPUB file to Google Play Books.

Note: https://www.zamzar.com offers only 2 free daily conversions.

 

 

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 Convert M4A to WAV File on macOS

Motivation:

You have downloaded some M4A audio files.

You want to extract convert them to WAV files to listen to them in other devices that do not support playing M4A files.

Procedure:

  • In the Music app on your Mac, choose Music > Preferences, then click Files.
  • Copy the path of Music Media folder location. (An example path is Macintosh HD/Users/admin/Music/Music/Media.)
  • Click the Import Settings… button.
  • In the Import Using pop-up menu, set Import Using = Wav Encoder, then click OK to save the settings.
  • Drag M4A files to the Music app.
  • Select songs in your library, then click File > Convert > Create WAV Version.
  • Go to your library folder (i.e. the Music Media folder location) and copy the WAV files to other devices.
  • Delete the M4A files from your library.

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 Install a Clean iOS

Motivation:

You want to sell or give away your iPhone. You want to ensure that the new owner will not access any of your data.

You may also need to give your iPhone to a technician to fix the broken display of your iPhone. You want to ensure that the technician cannot access any of your data.

You may also have so many buggy applications on your iPhone and want to increase stability and performance of your iOS.

Procedure:

  • Import your Photos to a MacBook.
  • Create a backup of data. It is best to let your iPhone synchronize everything with iCloud, including Photos and Contacts.
  • Turn off Find My iPhone.
  • Plug your iPhone to a MacBook.
  • Open Finder. Click on your iPhone on the left panel.
  • Click Restore iPhone… button.
  • Click Backup button.
  • Click Restore and Update button. Click Next button. Click Agree button.
  • Follow the instructions to install a clean iOS to your iPhone.

Post Installation Configuration:

  • Setup your iPhone.
  • Activate your iPhone.
  • Setup Face ID.
  • Restore your Apps & Data from iCloud backup.
  • Synchronize music to your iPhone.
  • Go to Settings > Generals > Software Update > Automatic Updates. Turn off Automatic Updates.
  • Go to Settings > Generals > Display & Brightness > Text Size. Drag the slider to the right to increase text size.
  • Go to Settings > Messages. Enable iMessage.

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 want to cut a MP4 file into files with equivalent length for uploading to specific storage that limits length of an uploaded video.

Solution for trimming MP4 file:

  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) value text boxes.
  9. Click the Add to queue button (with the + icon) on the tool bar.
  10. Click the Encode button on the tool bar.

Solution for splitting MP4 file to multiple files with equivalent length:

    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 specify appropriate time range for each file, for example from 00:00:00:0000 to 00:09:00:0000.
    9. Click the Add to queue button (with the + icon) on the tool bar.
    10. Click the Encode button.

    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 creating the third file, etc.

     

    How to Put Your eBooks into Kindle or Apple Books or Google Play Books

    Motivation:

    You have an ebook with .epub or .mobi format in your MacBook or PC.
    You want to put it into your iPhone or iPAD so that you can read it on the go.

    Solution 1:

    1. Upload your ebook to iCloud Drive.
    2. Install Kindle or Apple Books or Google Play Books on your iPhone or iPAD.
    3. Login your Kindle or Apple or Google account.
    4. Open the Files app to go to iCloud Drive.
    5. Open the ebook.
    6. Tap the Share icon in the lower left hand corner.
    7. Select Kindle or Open in iBooks or Play Books.

    Solution for Google Play Books:

    1. Install Google Play Books on your iPhone or iPAD..
    2. Log in Google Play Book website using your Google account.
    3. Upload your ebook in EPUB format to Google Play Book website.
    4. Open Google Play Books on your iPhone or iPAD.

    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:

    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.