How can we help you today?

ETL Job shows successful but outputs no data to .csv file when running a PME Extract to Load csv task

Issue

When running an ETL job to extract PME data and load to .csv, the job shows successful but the .csv file is blank

CSV file

Product Line

Power Monitoring Expert 8.x

Power Monitoring Expert 9.0

Power Monitoring Expert 2020

Power Monitoring Expert 2021

Power Monitoring Expert 2022

Power Monitoring Expert 2023

Power Monitoring Expert 2024

Environment

ETL 6.0

Cause

If the Collections parameter of the Load .csv task is not filled out then it will exhibit these symptoms

Resolution

When configuring the Load task, make sure to include data parameters

  1. Click on the input tab of the Field DefinitionETL Job
  2. Select input parameter( This example simply has Source Quantity and Date Time)

ETL Collections Input

3.  Save the job and run it and you will see the data

CSV with data

Schneider Electric Nigeria

Explore more
Product:
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
Product:
  • Products Documentation
  • Software Downloads
  • Product Selector
  • Product Substitution and Replacement
  • Help and Contact Centre
  • Find our Offices
  • Get a Quote
  • Where to buy
  • Schneider Electric Community
  • Careers
  • Company Profile
  • Report a misconduct
  • Accessibility
  • Newsroom
  • Investors
  • EcoStruxure
  • Job Search
  • Blog
  • Legal Information
  • Privacy Policy
  • Cookie Notice
  • Terms of use
  • Change your cookie settings