NetBotz Downloaded sensor data in CSV file shows special characters
Product Line:
NetBotz
Environment:
NBRK0750
NBWL0755
Cause:
Netbotz allows the user to download CSVs, mainly the Temperature Sensor data CSV, the Rack Access CSV, and the Alarms CSV. When a customer opens a CSV downloaded from Netbotz in Excel, strange characters will sometimes appear.
A specific example is that Temperature Sensor data has a temperature degree symbol, which is replaced by random characters.
This is only a problem when opening a file in Excel.
Other apps like Numbers read the data normally. This is because Excel does not automatically recognize UTF-8, the format of the CSVs.
So, certain bytes in the text file are being read as the ANSI encoding in Excel.
Resolution:
Instead of double-clicking and opening the file directly in Excel, do the following:
Open Excel Go to “New” and create a blank workbook
Go to “Data” in the Excel app
Click the dropdown “Get Data (Power Query)”
Select “From Text (Legacy)”
Select the CSV, in this case the temperature sensor data CSV
The Text Import Wizard should automatically appear. Select the “Delimited” option
On the same screen, click on the “File origin” drop down menu. Select “Unicode (UTF-8)”. Click Next
In the “Delimiters” column, deselect “Tab” and select “Comma”
Click “Finish”. The data should default to the Existing sheet, with the formula =$A$1
The data should appear with no strange characters in the UTF-8 encoding.
Released for: Schneider Electric Philippines
NetBotz Downloaded sensor data in CSV file shows special characters
Product Line:
NetBotz
Environment:
NBRK0750
NBWL0755
Cause:
Netbotz allows the user to download CSVs, mainly the Temperature Sensor data CSV, the Rack Access CSV, and the Alarms CSV. When a customer opens a CSV downloaded from Netbotz in Excel, strange characters will sometimes appear.
A specific example is that Temperature Sensor data has a temperature degree symbol, which is replaced by random characters.
This is only a problem when opening a file in Excel.
Other apps like Numbers read the data normally. This is because Excel does not automatically recognize UTF-8, the format of the CSVs.
So, certain bytes in the text file are being read as the ANSI encoding in Excel.
Resolution:
Instead of double-clicking and opening the file directly in Excel, do the following:
Open Excel Go to “New” and create a blank workbook
Go to “Data” in the Excel app
Click the dropdown “Get Data (Power Query)”
Select “From Text (Legacy)”
Select the CSV, in this case the temperature sensor data CSV
The Text Import Wizard should automatically appear. Select the “Delimited” option
On the same screen, click on the “File origin” drop down menu. Select “Unicode (UTF-8)”. Click Next
In the “Delimiters” column, deselect “Tab” and select “Comma”
Click “Finish”. The data should default to the Existing sheet, with the formula =$A$1
The data should appear with no strange characters in the UTF-8 encoding.
Released for: Schneider Electric Philippines
Need help?
Product Selector
Quickly and easily find the right products and accessories for your applications.
Get a Quote
Start your sales inquiry online and an expert will connect with you.
Where to buy?
Easily find the nearest Schneider Electric distributor in your location.
Help Center
Find support resources for all your needs, in one place.
我们如何通过可持续资源管理来维护生物多样性？
施耐德电气致力于通过可持续资源管理来保护自然生态系统，同时维护高社会、治理和道德标准，以防止生物多样性丧失。作为世界上最具可持续性的企业，也是能源管理和自动化数字化转型的领导者，施耐德电气致力于将生物多样性目标与科学相协调，并开发有助于可再生资源可持续性并减少气候影响的解决方案和技术。探索生物多样性承诺，该承诺将推出我们雄心勃勃的保护和恢复计划，使我们在2030年之前实现生物多样性净损失。我们的包容性目标是与我们的客户和供应商合作，部署我们的气候积极型EcoStruxureTM软件和解决方案，实现可持续资源管理自动化，并有效节约二氧化碳排放。了解我们的Green Premium产品，这些产品通过提高资源效率和循环性、合规性、绿色材料包装和改善环境足迹，支持客户的可持续发展目标。我们的供应链、合作伙伴以及寻求碳减排、可再生能源管理并将其价值链推向净零的客户，都依赖施耐德电气帮助他们加快气候之旅，并通过可持续的资源管理构建可复原性。我们通过以自然资源恢复为重点的生计碳基金(LCF)支持当地社区，以促进可持续生态系统和农村能源供应。施耐德电气是一家认识到大自然和生物多样性保护对于人类繁荣发展重要性的公司，旨在帮助企业塑造可持续资源管理的愿景和长期战略方向。我们的宗旨是让每个人都能充分利用其能源和资源，推动人类进步和可持续的共同发展。