Insights Hub Business Intelligence – BI Data 无法读取 .csv 文件内容并创建数据源

2023-11-28T15:12:42.000-0500
Applications

摘要

在 BI Data 里选择 Data Lake 数据湖类型的数据源时,选择 .csv 格式文件导入数据数据无法被正常同步。


详细信息

一、错误提示

错误的具体提示参考下图:

image.png
Execution of task 'Convert IDL files and upload to tableau' failed. UnicodeDecodeError('utf-8', b'Build,Station ID,FIXTURE,3S SW Version,3S DateTime,Lens Housing_ID,LCD_ID,LCD Housing_ID,Lens_1_ID,Lens_1_Bindtime,
Lens_2_ID,Lens_2_Bindtime,Calibration motor position,FFL,Best Focus,Fit PSA Choice,PSA Choice,Motor_position1,Motor_step_size,,DH Cavity,Line,Display vendor MP,M,,"DC,4+BR,3",+,MP1,fixture1,
2V12_MP_3S_V1.1.3_20230714,38:41.0,2G2Q1MMF8M0LHL,2G1CGU9F78G2LF,2G2Q1LMF8N03PX,121DC438230000MV,33:36.0,122BR33902000HLK,30:07.0,12,1.725,10.275,0.126,0.15,10.401,0.03,9.891,2.18066,2.40899,2.62863,2.80227,2.86693,
2.83047,2.67355,2.45366,2.20186,1.96799,1.74291,1.53688,1.37996,1.23714,1.13288,1.05549,0.988517,0.932712,0.894724,2.248,2.751,2.867,2.761,2.658,7.79,0.026,0.016,0.022,1271.169,1146.269,-0.283,108,0.48,,DC,4,BR,
3,,,\xd7\xe9\xc1\xa2-MP1-2V12,JDIMP,M,,"CR,3+CX,1",+,MP2,fixture2,2V12_MP_3S_V1.1.3_20230719,38:42.0,2G2Q1MMF8M0C3F,2G1CGU9F78G5T0,2G2Q1RMF8N015H,121CR33825000BWG,35:56.0,122CX1390700027G,30:39.0,10,-1.113,11.113,
0.106,0.15,11.219,0.03,10.709,3.33633,3.39881,3.45523,3.48776,3.48584,3.45244,3.39126,3.31467,3.23156,3.14771,3.06664,2.97005,2.8812,2.79414,2.68725,2.57314,2.43472,2.31859,2.20907,2.074,2.233,3.488,2.753,2.518,
7.69,-0.003,0.022,0.028,1273.662,987.675,-0.137,175,0.6,,CR,3,CX,1,,,\xd7\xe9\xc1\xa2-MP2-2V12,JDI', 1228, 1229, 'invalid continuation byte') (logref:8ee9f6e1-4293-48db-becb-c3b14c154341)


其实从上图和错误代码中我们可以看出主要还是 .csv 文件编码的问题。

二、解决方案

在 BI Data 中,需要作为数据源输入的文件必须要以 "UTF-8" 编码保存。如何确定当前 .csv 文件是以 UTF-8 格式编码?可用 Notepad++ 文本工具打开 .csv 文件,然后按照下图所示判断是否以 UTF-8 格式编码,如果不是可对应做更改:

image.png

知识库文章 ID# KB000126469_ZH_CN

内容

摘要详细信息

关联组件

Insights Hub Insights Hub Business Intelligence