csv overview

The AEMO Australian Energy Market Operator csv Comma Separated Values. A file format for data using commas as delimiters. data format standard uses a spreadsheet or text editor layout. The payload format allows for:

• Different report records presented in the same file.

• A report record definition to change over time (hence the report version numbers). The nature of changes is designed to cause minimum disruption to existing processes and also allow for transition periods to new report record formats.

• Data in a report record to come from a number of different tables, for example, 5-minute data, 30-minute data, and daily data.

• Each data record is self-contained, for example, correct interpretation requires no other data records.

If you are preparing a payload for upload to AEMO’s systems, the columns and spaces in each layout are vital placeholders and cannot be ignored. Without them, the system cannot read your payload.

The Payload The content in the csv file. For example: For APIs, it is the data sent by a POST request that sits after the API header. For MSATS transactions, it is the data wrapped in the standard aseXML wrapper. For NEM reports it is the csv payload compressed in a zip file. contains C, I and D rows:

• C rows indicate a comment field, for example the file or application description. Participants can change data in these rows.
• I rows indicate header information, do not change the data in the row. All data must be in upper case.
• D rows indicate participant MTPASA availability data, participants can change data in the rows and all data must be in upper case.