How to manage the import/export of the Symbol list in EcoStruxure Machine Expert - Basic?
Depending on Microsoft Excel and Windows settings, the .csv file created when exporting the Symbol list from ESME-Basic* could not be displayed as expected in MS Excel.
Likewise, we could get some errors when importing the Symbol list in ESME-Basic.
Example of error during the import:
Hereafter, a summary of the different combinations:
1) List Separator in Windows settings => Comma: “,”
Export options in ESME-Basic:
• Unicode + Semicolon => need to adapt in Excel by selecting semicolon as delimiter => save as .csv-utf8 file => import in ESME-Basic by selecting semicolon => Error
• Unicode + Comma => need to adapt in Excel by selecting comma as delimiter => save as .csv-utf8 file => import in ESME-Basic by selecting comma => OK
• ANSI + Semicolon => need to adapt in Excel by selecting semicolon as delimiter=> save as .csv file => import in ESME-Basic by selecting semicolon => Error
• ANSI + Comma => correctly displayed in Excel without doing any adaptation => save as .csv file => import in ESME-Basic by selecting comma => OK
2) List Separator in Windows settings => Semicolon: “;”
Export options in ESME-Basic:
• Unicode + Semicolon => need to adapt in Excel by selecting semicolon as delimiter=> save as .csv-utf8 file => import in ESME-Basic by selecting semicolon => OK
• Unicode + Comma => need to adapt in Excel by selecting comma as delimiter => save as .csv-utf8 file => import in ESME-Basic by selecting comma => Error
• ANSI + Semicolon => correctly displayed in Excel without doing any adaptation => save as .csv file => import in ESME-Basic by selecting semicolon => OK
• ANSI + Comma => need to adapt in Excel by selecting comma as delimiter=> save as .csv file => import in ESME-Basic by selecting comma => Error
Through these different tests, we can see the error appears when the list separator of Windows is different from the separator selected in ESME-Basic.
When handling Unicode file, take care to select csv-utf8 format when saving as the .csv file in MS Excel.
Note 1: How to change the List separator in Windows?
Note 2: How to change the Delimiter in MS Excel?
*ESME-Basic: EcoStruxure Machine Expert - Basic
Likewise, we could get some errors when importing the Symbol list in ESME-Basic.
Example of error during the import:
Hereafter, a summary of the different combinations:
1) List Separator in Windows settings => Comma: “,”
Export options in ESME-Basic:
• Unicode + Semicolon => need to adapt in Excel by selecting semicolon as delimiter => save as .csv-utf8 file => import in ESME-Basic by selecting semicolon => Error
• Unicode + Comma => need to adapt in Excel by selecting comma as delimiter => save as .csv-utf8 file => import in ESME-Basic by selecting comma => OK
• ANSI + Semicolon => need to adapt in Excel by selecting semicolon as delimiter=> save as .csv file => import in ESME-Basic by selecting semicolon => Error
• ANSI + Comma => correctly displayed in Excel without doing any adaptation => save as .csv file => import in ESME-Basic by selecting comma => OK
2) List Separator in Windows settings => Semicolon: “;”
Export options in ESME-Basic:
• Unicode + Semicolon => need to adapt in Excel by selecting semicolon as delimiter=> save as .csv-utf8 file => import in ESME-Basic by selecting semicolon => OK
• Unicode + Comma => need to adapt in Excel by selecting comma as delimiter => save as .csv-utf8 file => import in ESME-Basic by selecting comma => Error
• ANSI + Semicolon => correctly displayed in Excel without doing any adaptation => save as .csv file => import in ESME-Basic by selecting semicolon => OK
• ANSI + Comma => need to adapt in Excel by selecting comma as delimiter=> save as .csv file => import in ESME-Basic by selecting comma => Error
Through these different tests, we can see the error appears when the list separator of Windows is different from the separator selected in ESME-Basic.
When handling Unicode file, take care to select csv-utf8 format when saving as the .csv file in MS Excel.
Note 1: How to change the List separator in Windows?
Note 2: How to change the Delimiter in MS Excel?
*ESME-Basic: EcoStruxure Machine Expert - Basic
게시 대상: 슈나이더 일렉트릭 Korea
도움이 필요하신가요?
제품 선택기
애플리케이션에 적합한 제품과 액세서리를 빠르고 쉽게 찾을 수 있습니다.
견적 받기
영업 관련하여 온라인으로 문의하시면 전문가가 연락드립니다.
구매처
해당 지역의 가장 가까운 슈나이더 일렉트릭 대리점을 쉽게 찾을 수 있습니다.
지원 센터
한 곳에서 모든 요구 사항에 대한 지원 리소스를 찾아보십시오.