Our Brands

Welcome to the Schneider Electric Website

Welcome to our website.
		
How can we help you today?
ETL EGX extract task fails for PAS600 and PAS800 FW 1.6.0 csv files

Issue
ETL EGX extract task fails for PAS600 and PAS800 FW 1.6.0 csv files.

Product Line
PAS600/800
ETL
EPO/PME

Environment
PAS600 FW1.6.0/PAS800 FW1.6.0
ETL V5.0/V6.0

Cause
In PAS FW 1.6.0 csv file format is modified, all the fields in csv file are included with double quotation (“”) to support special characters for international languages and for better file transfer performance.


Resolution

Please find attached the ETL hotfix151123, which has a fix for the issue reported on ETL V6.0 EGX300 extract job failure due to change in csv file format of Panel Server. The new format of the csv files were with double quotes and in this fix it is parsed to resolve the error.

Work around - Below work around is obsolete.  Please use the ETL hotfix attached.

Work around for this issue is to run the attached PowerShell script in the system before the ETL job runs.

Please find the attached PowerShell script to remove the " in the .csv file. Follow the below steps

1. Modify the PowerShell script with your input folder in the highlighted section. If you have multiple folders, repeat the same in the script.
Script1
2. Run the PowerShell script once after the SFTP publishing interval.
3. Configure windows task scheduler to run the script periodically once after the SFTP interval.
4. Important Note : Please modify the ETL extract task settings -> File Limit section -> Sort Files by Last Write Time.
ETLSort1
5. Make sure that the modified PowerShell script schedule executes before the ETL jobs schedule.

This will resolve the issue.

Note
  1. This issue is not present in lower firmware versions. i.e., lesser than FW1.6.0
  2. This issue is addressed in ETL hotfix.

Schneider Electric Malaysia

Attachment(s)
151123.zip [38.59 KB]
PAS_V1_6_Modification_V_1_0.zip [331 Bytes]
Explore more
Range:
Users group

Discuss this topic with experts

Visit our Community for first-hand insights from experts and peers on this topic and more.
Explore more
Range:

Need help?

  • Start here!

    Find answers now. Search for a solution on your own, or connect with one of our experts.

  • Contact Support

    Reach out to our customer care team to receive more information, technical support, assistance with complaints and more.

  • Where to buy?

    Easily find the nearest Schneider Electric distributor in your location.

  • Search FAQs

    Search topic-related frequently asked questions to find answers you need.

  • Contact Sales

    Start your sales enquiry online and an expert will connect with you.

I'd like to receive news and commercial info from Schneider Electric and its affiliates via electronic communication means such as email, and I agree to the collection of information on the opening and clicks on these emails (using invisible pixels in the images), to measure performance of Schneider Electric's communications and to improve them. For more details, please read our Privacy Policy.

  • Products Documentation
  • Software Downloads
  • Product Selector
  • Product Substitution and Replacement
  • Help and Contact Centre
  • Find our Offices
  • Get a Quote
  • Where to buy
  • Careers
  • Company Profile
  • Report a misconduct
  • Accessibility
  • Newsroom
  • Investors
  • EcoStruxure
  • Job Search
  • Blog
  • Privacy Policy
  • Cookie Notice
  • Terms of use
  • Change your cookie settings
Your browser is out of date and has known security issues.

It also may not display all features of this website or other websites.

Please upgrade your browser to access all of the features of this website.

Latest version for Google Chrome, Mozilla Firefox or Microsoft Edgeis recommended for optimal functionality.