WINDOWS

  • 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

  • HOW TO FIND A COMPUTER’S MAC ADDRESS

    AUTHOR: // CATEGORY: IT, Windows

    No Comments
    How to Find a Computer’s MAC Address (Windows 7 and Vista) Print E-mail
    How to find a computer’s MAC address in Windows 7 and Vista.Option 1:

    1) Click the Start Orb at the bottom left of your screen.

    2) Type ncpa.cpl into the search box and press ENTER.

    Active Image

    3) Right-click your Local Area Connection and select Status.

    Active Image

    4) Click Details and the Physical Address is your MAC Address.

    Active Image

    Option 2:

    1. Click on the Windows Logo in the bottom left corner.

    2. In the search box, type in cmd and press enter.

    mac7

    3. In the command prompt, type in getmac (with no spaces) and push enter.

    mac7

    4. The MAC address is labeled Physical Address (denoted by a yellow box below).
    mac

  • EXPORT BOOKMARKS FROM CHROME

    AUTHOR: // CATEGORY: IT, Mac OS X, Windows

    No Comments

    Step 1: In the top-right corner of the browser window, click the Chrome menu

    Step 2: Select Bookmarks > Bookmark Manager.

    Step 3: Click the “Organize” menu in the manager

    Step 4: Select Export bookmarks.

    Chrome will export your bookmarks as an HTML file, which you can then import into another browser.

    Credits: https://support.google.com/chrome/answer/96816?hl=en 

  • HOW TO CREATE A FILE LIST AT A COMMAND PROMPT

    AUTHOR: // CATEGORY: Development, Windows

    No Comments

    How to Create a File List at a Command Prompt

    1. Click Start, point to Programs, and then click MS-DOS Prompt (or Command Prompt in Windows NT).
    2. At a command prompt, locate the drive that contains the folder whose contents you want to list. For example, if you want to create a text file that contains a list of the contents of a folder on drive C, type the following command at a command prompt, and then press ENTER:
      c:
    3. At a command prompt, locate the folder whose contents you want to list. For example, if you want to create a text file that contains a list of the contents in the Windows folder on drive C, type the following commands at a command prompt, and press ENTER after you type each command:
      cd\
      cd windows
    4. Type the following command at a command prompt, and then press ENTER, where filename is the name of the text file that you are creating:
      dir > filename.txt

      For example, if you want to create a file named Windowsfolderlist.txt, type the following command at a command prompt, and then press ENTER:

      dir > windowsfolderlist.txt

      NOTE: The text file that you create is located in the folder that you are in when you follow these steps. In the earlier example, the Windowsfolderlist.txt file is located in the Windows folder.

    5. Use a text editor, such as Notepad, to view or print this file.

    Try other commands like:

    dir source /s >> destination.txt

    e.g. dir c:\ /s >> “c:\users\<username>\desktop\list.txt”

    Or tree /A /F > tree.txt

    Happy Extracting

    Credits:
    https://support.microsoft.com/en-us/kb/196158

    http://www.sevenforums.com/general-discussion/215864-how-can-i-list-folders-sub-folders-file-names-into-txt-file.html

  • CITRIX – GOOGLE CHROME – LAUNCH.ICA FILE

    AUTHOR: // CATEGORY: Development, Mac OS X, Windows

    No Comments

    Presenting Problem

    You click to launch your applications in Google Chrome and the application does not launch. Instead, you see a launch.ica file downloaded from Google Chrome or the launch.ica file is opened up by some incompatible program on your computer (such as by another web browser or a Microsoft Office application).

    Background

    The launch.ica file is a Citrix file used by your web browser to virtualize your Citrix applications. This file is usually downloaded silently from Chrome and opened automatically by the Citrix application installed on your local computer. However, a recent update to Chrome has changed this usual process.

    Google released the Version 42.0 update to Chrome on April 15, 2015. As a part of this update, Chrome now handles certain web content differently. For Citrix , Instead of downloading and automatically launching the launch.ica file like in the past, Chrome now just downloads the file instead. Depending on other local settings, your computer may try to automatically open the launch.ica file with an incompatible program as well.

    Most users have Chrome set to update automatically, hence your Chrome may have already updated to the latest version without your knowledge.

    Solution

    To resolve, we need to tell Google Chrome to continue to automatically open the launch.ica files instead of just download them.

    1. Attempt to launch a Citrix application
    2. When you see the launch.ica file appear at the bottom of your web browser, click on the little arrow next to it and choose Always open files of this type

      • Google Chrome - Version 42.0.2311.90 Update.png

    3. Restart Google Chrome
    4. Log back into Citrix and launch your application again

    Additional Steps

    If the above changes did not resolve your issue, then the Google Chrome update may have affected the default program that your computer uses to open .ica file types. As a result, you need to adjust the default program that opens .ica files on your local computer.

    For Windows Users:

    1. Launch the Control Panel
    2. Open the Default Programs menu (this is under Programs if you are in Category View)
    3. Choose to Associate a file type or protocol with a program
    4. Find the .ica file type and choose to Change program…
    5. Browse to C:\Program Files (x86)\Citrix\ICA Client (you can paste this in the Open with… window)
      • Depending on your computer settings, the appropriate directory might be C:\Program Files\Citrix\ICA Client if the (x86) directory doesn’t exist
    6. Select wfcrun32 from the above directory to set the Citrix Connection Manager as the default program to launch .ica files
    7. Restart Google Chrome
    8. Log back into Citrix and launch your application again

    For Mac Users:

    1. Locate the launch.ica file downloaded from Chrome (typically in your Downloads folder)
    2. Right-click (control + click) on the launch.ica file and select Open With > Other
    3. Browse to your Applications
    4. Select the Citrix Receiver,check the Always Open With checkbox, and click Open

    Credits: https://harborcloud.zendesk.com/entries/81554985-Google-Chrome-Click-to-launch-an-application-and-see-a-launch-ica-file

  • HOW TO DISABLE OUTLOOK 2013 READ RECEIPTS

    AUTHOR: // CATEGORY: Windows

    No Comments

    Read receipts are an interesting feature in mail programs, but it is a feature that is not standardized. Many popular email clients block them, and a lot of the email programs that exist for Mac OS X don’t include them at all, or are complicated to implement. But they do have their uses, so some people still choose to include them with messages that they send from their computer. However, that does not mean that you need to comply with their request. A read receipt is just that – a request from the sender to notify them when you have opened their message. If you are becoming annoyed with receiving these read receipts in Outlook 2013 and no longer want to send read receipts or even be notified that they have been requested, you can turn off read receipts in Outlook 2013.

     

    How to Disable Outlook 2013 Read Receipts

    Whatever your feelings about read receipts might be, there are still people that will insist on using them. There are certain fields and individuals where a read receipt can actually be important and useful, but many people that use them are simply trying to find out that you have opened an email that they sent to you, and it is no more important than a billion other emails that are sent every day without read receipts. So continue reading below to learn the necessary steps for stopping read receipt requests in Outlook 2013.

     

    Step 1: Launch Outlook 2013.

     

    Step 2: Click the File tab at the top-left corner of the window.

    click the file tab

     

     

    Step 3: Click Options in the column at the left side of the window. This is going to open a separateOutlook Options window.

    click options to open the outlook options window

     

     

    Step 4: Click the Mail option in the column at the left side of the Outlook Options window.

    click mail in the left column

     

     

    Step 5: Scroll down to the tracking section, then click the option to the left of Never send a read receipt.

    how to turn off read receipts in outlook 2013

     

     

    Step 6: Click the OK button to close the window and save your changes.

    Credits: http://www.solveyourtech.com/how-do-you-turn-off-read-receipts-in-outlook-2013/

    Happy Outlooking

  • OUT OF OFFICE ASSISTANT

    AUTHOR: // CATEGORY: Windows

    No Comments

    How to turn on “Automatic Replies (Out of Office)” or the “Out of Office Assistant”

    For Microsoft Office Outlook 2013 and 2010

    1. Click the File tab, and then click the Info tab in the menu.

      Outlook File Menu Snapshot

    2. Click Automatic Replies (Out of Office).

      Outlook 2013 Out Of Office feature Snapshot

      Note If you do not see this option, you are not using an Exchange account. Please go to this section: How to enable Automatic Replies in non-exchange account.

    3. In the Automatic Replies dialog box, select the Send Automatic Replies check box.
    4. If you want to specify a set time and date range, select the Only send during this time range check box. Then set theStart time, and then set the End time.
    5. In the Inside my organization tab, type the message that you want to send within your organization, and in theOutside my organization tab, type the message that you want to send outside your organization.
    6. Click OK.
    7. If you selected the “Only send during this time range” option in step 4, the Automatic Replies (Out of Office) feature will continue to run until the date and time set for the End Time in step 5 is reached.
      Otherwise, the Automatic Replies (Out of Office) will continue to run until you repeat step 1 and select the “Do not send automatic replies” option.

    Credits: https://support.microsoft.com/en-us/kb/290846