in location

OR

I'm looking for

  • Wholesalers
    • Uncheck All Check All
  • EXPERTISE
    • Expand
    • Expand
    • Expand
    • Uncheck All Check All
  • Switchboard Manufacturers
    • Uncheck All Check All
OR

The best way to see what Clipsal electric products can do for your home is seeing them in action at a Clipsal Powerhouse Display Centre.

Product stock may vary according to location. If you're after a specific product range, please check with your chosen location before visiting.

10 Results
    Load More Load Complete
    Change Location

    Power Monitoring Expert - Data Export Report - if language used is Chinese, and Chinese characters are used for the column headings, the Chinese characters will not display correctly in Excel.

    Issue
    If the Power Monitoring Expert (PME) Data Export Report is opened in Excel, and Chinese characters have been used such that they appear in the column headings, Excel will not display them correctly. This is an Excel issue, not a PME issue.

    Product Line
    Power Monitoring Expert

    Environment
    Viewing the Data Export Report in Excel if Chinese characters are used in device names or custom measurement names.

    Cause
    Ths problem occurs because the Data Export Report is saved in CSV format, and by default, Excel reads CSV files as non-unicode.
    PME correctly exports the file as unicode (UTF-8), however if opened in Excel directly, Excel reads the file as non-unicode.

    Resolution

    How To Open a Unicode CSV in Excel (the right way)

    When we scrape data from Non-English languages and give you a CSV file, the data may appear corrupted or unreadable (when you double click and open the file in Excel). 
    This issue occurs because we scrape the data as unicode text, but Excel reads CSV files in non-unicode by default.

     

    To configure Excel to use unicode on your exported CSV reports:

    1. Start Microsoft Excel
    2. In Excel, click the Data tab, and in the Get External Data ribbon/panel, click From Text .

       

    3. In the Import Text File dialog box, in the lower-right corner (to the right of the File name box), select Text Files (*.prn;*.txt;*.csv) as the file type, browse to the location where you exported/downloaded the CSV file, and then click Open (or Import).

       

    4. In the Text Import Wizard - Step 1 of 3 dialog box, select Delimited, and from the File origin drop-down list, select 65001: Unicode (UTF-8) (or the appropriate language character identifier for your particular environment). 
      In the Preview box, make sure that your unicode text displays properly, and then click Next.

       

    5. In the Text Import Wizard - Step 2 of 3 dialog box, in the Delimiters section, make sure that only Comma is checked, and then click Finish.

       

    6. In the Import Data dialog box, select New worksheet (or Existing worksheet if you have one), and then click OK.

    Didn’t find what you were looking for?

    Try Searching Again View Our Categories

    Need further assistance?

    Our Customer Care department provides total customer service solutions for our residential, industrial and commercial applications.

    Get Assistance