NOTICE DATE: July 29,
2010
NOTICE TYPE: M-A071210-02
UPDATE: EXTRACTS - Informational
SHORT DESCRIPTION: Zonal
Extracts and Reports Download File Name Changes and corresponding User Guides
posted
INTENDED AUDIENCE: All
Market Participants
DAY AFFECTED: August 8,
2010
LONG DESCRIPTION:
ERCOT has an upcoming change to the extract and reports download file name
format, from Texas Market Link (TML) and the Retail API, scheduled for Sunday,
August 8, 2010. To accompany this change updated Zonal User Guides have been
posted to ERCOT.com website (http://www.ercot.com/services/mdt/userguides/index).
There is no change to the display file naming convention.
The new download file name format using IE7:
Explanation of file name parts:
·
Prefix – Values include ext,
rpt, cdr or msc.
·
Report type ID - The report ids
for all reports are listed in the ERCOT Market Information List (EMIL) posted
on the Nodal ERCOT website (http://nodal.ercot.com/readiness/reports/index.html).
It will also be available on MIS Services page at Nodal Go-live.
·
DUNSNUMBER - This is the
DUNSNUMBER. For a 9 digit DUNS, there will be 7 zeros padded to the left of the
DUNS. For a 13 digit DUNS, there will be 3 zeros padded to the left of the
DUNS. Total length will be 16 digits + the period. For all Public and Secure
reports this field will contain 16 zeros.
·
Posting Date – This is the
posting date of the file.
·
Posting Time – This is the
posting time of the file.
·
Filename – This is the
common name of the file. This is a free text area that will be less than 648
digits + the period that uses alphanumeric, as well as underscores and dashes.
·
Extension – This is the file
extension. Common ones used are csv, doc, pdf, xls, zip.
The new download file name format using IE6:
·
Prefix – Values include ext,
rpt, cdr or msc. The [#] is most commonly [1].
·
Report type ID - The report ids
for all reports are listed in the ERCOT Market Information List (EMIL) posted
on the Nodal ERCOT website (http://nodal.ercot.com/readiness/reports/index.html).
It will also be available on MIS Services page at Nodal Go-live.
·
DUNSNUMBER - This is the
DUNSNUMBER. For a 9 digit DUNS, there will be 7 zeros padded to the left of the
DUNS. For a 13 digit DUNS, there will be 3 zeros padded to the left of the DUNS.
Total length will be 16 digits + the period. For all Public and Secure reports
this field will contain 16 zeros.
·
Posting Date – This is the
posting date of the file.
·
Posting Time – This is the
posting time of the file.
·
Filename – This is the
common name of the file. This is a free text area that will be less than 648
digits + the period that uses alphanumeric, as well as underscores and dashes.
·
Extension – This is the file
extension. Common ones used are csv, doc, pdf, xls, zip.
Additional Information:
The Retail API All/All call that currently returns all extracts and reports for
all of time available for market participants to download will change to only
return 3 days of extracts and reports. This change is in support of performance
enhancements being performed to better support zonal and nodal market data
downloads.
CONTACT: If you have any
questions, please contact your ERCOT Account Manager. You may also call the
general ERCOT Client Services phone number at (512) 248-3900 or contact ERCOT
Client Services via e-mail or your ERCOT Account Manager. You may also call the
general ERCOT Client Services phone number at (512) 248-3900 or contact ERCOT
Client Services via email at [log in to unmask].
If you
are receiving email from an ERCOT distribution list that you no longer wish to
receive, please follow this link in order to unsubscribe from this list: http://lists.ercot.com.
DP/DH
From: ERCOT Client
Relations
Sent: Monday, July 12, 2010 4:09 PM
To: [log in to unmask];
[log in to unmask];
[log in to unmask]
Cc: [log in to unmask]; [log in to unmask];
[log in to unmask]; 1 ERCOT Client Service Reps
Subject: M-A071210-01 EXTRACTS - Informational
NOTICE DATE: July 12,
2010
NOTICE TYPE: M-A071210-01
EXTRACTS - Informational
SHORT DESCRIPTION: Zonal Extracts
and Reports Download File Name Changes
INTENDED AUDIENCE: All
Market Participants
DAY AFFECTED: August 8,
2010
LONG DESCRIPTION:
ERCOT has an upcoming change to the extract and reports download file name
format, from Texas Market Link (TML) and the Retail API, scheduled for Sunday,
August 8, 2010. There is no change to the display file naming convention.
The new download file name format using IE7:
Explanation of file name parts:
·
Prefix – Values include ext,
rpt, cdr or msc.
·
Report type ID - The report ids
for all reports are listed in the ERCOT Market Information List (EMIL) posted
on the Nodal ERCOT website (http://nodal.ercot.com/readiness/reports/index.html).
It will also be available on MIS Services page at Nodal Go-live.
·
DUNSNUMBER - This is the
DUNSNUMBER. For a 9 digit DUNS, there will be 7 zeros padded to the left of the
DUNS. For a 13 digit DUNS, there will be 3 zeros padded to the left of the
DUNS. Total length will be 16 digits + the period. For all Public and Secure
reports this field will contain 16 zeros.
·
Posting Date – This is the
posting date of the file.
·
Posting Time – This is the
posting time of the file.
·
Filename – This is the
common name of the file. This is a free text area that will be less than 648
digits + the period that uses alphanumeric, as well as underscores and dashes.
·
Extension – This is the file
extension. Common ones used are csv, doc, pdf, xls, zip. Will be 3 digits.
The new download file name format using IE6:
·
Prefix – Values include ext,
rpt, cdr or msc. The [#] is most commonly [1].
·
Report type ID - The report ids
for all reports are listed in the ERCOT Market Information List (EMIL) posted
on the Nodal ERCOT website (http://nodal.ercot.com/readiness/reports/index.html).
It will also be available on MIS Services page at Nodal Go-live.
·
DUNSNUMBER - This is the
DUNSNUMBER. For a 9 digit DUNS, there will be 7 zeros padded to the left of the
DUNS. For a 13 digit DUNS, there will be 3 zeros padded to the left of the
DUNS. Total length will be 16 digits + the period. For all Public and Secure
reports this field will contain 16 zeros.
·
Posting Date – This is the
posting date of the file.
·
Posting Time – This is the
posting time of the file.
·
Filename – This is the
common name of the file. This is a free text area that will be less than 648
digits + the period that uses alphanumeric, as well as underscores and dashes.
·
Extension – This is the file
extension. Common ones used are csv, doc, pdf, xls, zip. Will be 3 digits.
Additional Information:
The Retail API All/All call that currently returns all extracts and reports for
all of time available for market participants to download will change to only
return 3 days of extracts and reports. This change is in support of performance
enhancements being performed to better support zonal and nodal market data
downloads.
CONTACT: If you have any questions,
please contact your ERCOT Account Manager. You may also call the general ERCOT
Client Services phone number at (512) 248-3900 or contact ERCOT Client Services
via e-mail or your ERCOT Account Manager. You may also call the general ERCOT
Client Services phone number at (512) 248-3900 or contact ERCOT Client Services
via email at [log in to unmask].
If you
are receiving email from an ERCOT distribution list that you no longer wish to
receive, please follow this link in order to unsubscribe from this list: http://lists.ercot.com.
DP