Posts tagged “Converting”

Import a contact list from a CSV file to your Android

If you keep a spreadsheet file with all your contacts you can easily import them to your phone. This is done by uploading the CSV file to your gmail account where you import it.

First step: Save a CSV file

Follow the Gmail Help page, which describes what your columns are supposed to be called and so on. Save the file to a CSV file.

Second step: Importing the CSV file to Gmail

  1. Sign in to Gmail
  2. Click Contacts (located below your list of views) on any Gmail page.
  3. Click Import in the top portion of the Contact Manager.
  4. Click the Browse… or Choose File button and locate the CSV file you’d like to upload.
  5. Select the file and click the Import button.

If some of the fields in the CSV file are left out Gmail will tell you why. Also a smart thing is to make a Category for your contacts, this way you can delete them all again if you made a big mistake.

Many thanks to Google Android Bruger Blog!

Encoding videos for the N810

I found this very useful program called Media Converter 2, that is very useful to convert videos for to play on the N810.

I converted Cromartie High School for the trip I’m going on this morning. I used N810 High settings, 2 passes and audio gain.

Before I started encoding I needed to extract the subtitles from the MKV files, cause the program doesn’t include them automatically unless they are in the folder where your source file is and are called the same as the source, just with the extension .srt. I extracted the subs with mkvextractgui which is a very nice little application, for extracting video, subtitles and audio from MKV files.

The end result is pretty good, playable in Canola2, I don’t complain and I’m going to laugh so much in the train.