PC

  • EXCEL: EXPORT .CSV FILE WITH JAPANESE CHARACTER

    AUTHOR: // CATEGORY: Development, IT, PC, Windows

    No Comments

     

    To fully retain the characters while saving it on a CSV format and to somehow be able to import/re-use the data in the future.

    You can follow these steps.

    1. In Microsoft Excel, open the *.xlsx file.
    2. Select Menu | Save As.
    3. Enter any name for your file.
    4. Under “Save as type,” select Unicode Text.
    5. Click Save.
    6. Open your saved file in Microsoft Notepad.
    7. Replace all tab characters with commas (“,”).
    • Select a tab character (select and copy the space between two column headers)
    • Open the “Find and Replace” window (Press Ctrl+H) and replace all tab characters with comma .

    Replace Tabs with commas in Notepad

    1. Click Save As.
    2. Name the file, and change the Encoding: to UTF-8.
    3. Change the file extension from .txt to .csv.
    4. Click Save.
    5. Open the .csv file in Excel to view your data.

    Credit:

    https://stackoverflow.com/questions/24087432  /excel-xlsx-file-saving-as-csv-file-korean-and-japanese-cracking-badly

  • ADOBE PHOTOSHOP AND LIGHTROOM SHORTCUTS

    AUTHOR: // CATEGORY: Graphic Design, IT, Mac OS X, PC

    No Comments

    We all know how we love shortcuts … check out the below shortcuts and cheat sheets to make designing quicker.

    Photoshop CC

    setupablogtoday-photoshop-cheat-sheet-fin

    Lightroom CC

    lightroom-keyboard-shortcuts-cheat-sheet

    Happy tapping

  • GO TO > PAGE – WORD 2013

    AUTHOR: // CATEGORY: IT, PC

    No Comments

    So you got a huge document and want to move quickly between pages. Use the Go To navigator in Word 2013. Hit CTRL + G for the below and enter the page number.

    Untitled

    Happy Scrolling …

    Credits: http://answers.microsoft.com/en-us/office/forum/office_2013_release-word/how-to-jump-to-a-specific-page-number-in-office/ac7b9bf5-47b0-43b6-9fb4-1787cbff20d7

  • WAMP SERVER PORT ISSUE

    AUTHOR: // CATEGORY: Development, Joomla, mySQL, Open Source, PC, Wordpress

    1 Comment

    Okay … So on Windows 7 sometimes after installing WAMP you have an issue starting the WAMP Server. This is caused by port 80 using used by IIS. So to change the Apache port for WAMP complete the following:

    How to change WAMP server port number windows 7

    1. Go to c:\wamp\bin\apache\Apache (your version)\conf
    2. Open httpd.conf file
    3. Search for Listen 80
    4. Change the line “Listen 80” to “Listen 8080” (or Listen You can use any no)
    5. Save the file and close it
    6. Then open http://localhost:8080/ , next to the localhost place the port no you changed in the httpd.conf file

    This solution is really helpful to use both IIS and WAMP server.

    Credits:

    http://atechguide.com/fix-wamp-server-offline/

  • MULTI BOOT USB FLASH DRIVE

    AUTHOR: // CATEGORY: Development, Linux, Mac OS X, Open Source, PC

    No Comments

    Okay, so I love having recovery tools on a bootable USB drive.

    One of my life savers is Hiren Boot Tools (Download the ISO here). Then I had a great idea. What I’ll do is buy a HUGE 64GB USB flash thumb drive and make different partitions. I.e. one for Hiren, one for Windows 7 Installer, one for BackTrack (for you know what – wireless sniffing), one for Ubuntu etc. However I came into a bit of an issue. On Windows only the first partition is identified, however on MacOsX or Linux (Unix) all the partitions are found. However, I’m currently working on more Windows machines. So after some research I came across Yumi Multi Boot Loader.

    I highly recommend the app … it runs multiple loaders on a single partition and does it very neatly.

    Download from here

    Creating a YUMI Multiboot MultiSystem Bootable USB Flash Drive
    YUMI works much like Universal USB Installer, except it can be used to install more than one distribution to run Live from your USB. Distributions can also be uninstalled using the same tool!

    YUMI - Multiboot USB Creator

    YUMI’s Main Multiboot Boot Menu

    YUMI - Multiboot Boot Menu

    Credits:

    http://www.pendrivelinux.com/yumi-multiboot-usb-creator/

    Happy multi-booting

  • TOEFL SAMPLE EXAM

    AUTHOR: // CATEGORY: PC

    No Comments

    Preparing for the TOEFL Exam – check out the official sample exam on the link below.

    http://www.ets.org/Media/Tests/TOEFL/exe/toeflSample.exe

    Note: Windows Only

    Good Luck

    Credits: http://www.ets.org/toefl/ibt/prepare/sample_questions

  • FACEBOOK TOUCH / CHECKIN FROM BROWSER

    AUTHOR: // CATEGORY: Mac OS X, PC

    No Comments

    So you on your PC and you’d like to check-in into Facebook – navigate to https://touch.facebook.com Login and you’ll have the check-in option. Enjoy

  • SQL ANYWHERE SERVICES FROM COMMAND PROMPT

    AUTHOR: // CATEGORY: Development, PC

    No Comments

    Start up SQL Anywhere Services from command prompt on NT

    There are cases when customer would like to start up a SQL Anywhere Services at a specific time or after a database backup. The following is a way to start up a SQL Anywhere Services from outside Sybase Central or NT Services (as in Control Panel, Servi
    1. Open the 32-bit registry editor (C:\WINNT\system32\regedt32.exe).

    On the taskbar, click on “Start” then select “Run”. Type in regedt32 or regedit.

    1. Double click on HKEY_LOCAL_MACHINE -> SYSTEM -> CurrentControlSet -> Services

    1. For ASA versions 6.x.x/7.x.x/8.x.x, scroll down until you see ASANY. For SQL Anywhere version 5.x.x, scroll down until you see SQLANY. Any services created in SQL Anywhere Service Manager (or from Sybase Central) should be listed here.

    1. The name of each individual service would appear as

    ASANYx_y or SQLANYx_y

    where ‘x’ represents the Service Type:


    a – Sample Application

    c – Client
    e – Standalone Engine
    l – Agent for Replication Server

    o – Open Server Gateway
    r – SQL Remote Message Agent

    s – Network Server

    and ‘y’ represents the Service Name as seen in the ‘Name’ column in Sybase SQL Anywhere Service Manager.

    Find out which key is for the service you want to start from the DOS prompt. Write down the name of the key. Note that the key is

    Case sensitive for version 5.x.x but is not case sensitive for version 6.x.x/7.x.x/8.x.x.

    1. In DOS, the command to start up any registered NT Services (which include SQL Anywhere/Adaptive Server Anywhere Services) is ‘net start’.

    Therefore, the syntax to start up a SQL Anywhere Service from a command prompt (DOS prompt) would be:

    net start <key for the service from registry editor>
     

    1. Similarly, the NT command to stop any registered NT Services is ‘net stop’  


    Therefore, the syntax to stop a SQL Anywhere/Adaptive Server Anywhere Service from a command prompt (DOS prompt) would be:


    net stop <key for the service from registry editor>

    Credit to: http://www.sybase.com/detail?id=10915

  • ARABIC NUMBERS IN OFFICE 2010

    AUTHOR: // CATEGORY: PC, Saudi Arabia

    No Comments

    Working in Saudi, we need to adapt to using the Saudi keyboard and numerals. When installing MS Office 2010 by default (after installing the Arabic Keyboard in Windows) – Arabic text is displayed correctly, however Arabic numerals are typed in the base language i.e. English. To fix …

    In Word 2010:

    – Go to File > Options > Advanced.

    – Scroll down to the Show document content section – you will find the Numeral option. Set it to Context.

    Screenshot

    – and you done …

    Happy typing …

  • ONLINE DUPLICATE CHECKER

    AUTHOR: // CATEGORY: Development, Open Source, PC

    No Comments

    Ever have a list of data and want to quickly check for duplicates. Now I know it’s possible in SQL or even Excel but if you looking for a really easy online way without tweaking check out http://www.somacon.com/p568.php – Paste your data in the form click on Display / Update Counts and view the results …

    Happy duplicate checking …