Category: FERC

View Your FERC eTariff XML

After validating your Filing in TariffShark and downloading the zipped XML file, have you ever wanted to look at the XML before you ship it off to FERC?  This blog article describes one method for doing so.

An eTariff filing’s data is coded in XML format.  XML is a plain text format, so it may be viewed using any number of file editors that can open and display plain text.  Because eTariff XML files can be VERY large, the XML file is compressed into a ZIP file.  The ZIP file is what actually gets submitted to FERC when making an eTariff filing.

1. Open ZIP File

Windows knows how to open a ZIP file, so special software is not needed.  Simply double-click the ZIP file downloaded from TariffShark and Windows will open it.  Looking at the open ZIP file is almost exactly like looking at the contents of a folder.  The difference is that folder contents are ready to be used and ZIP file contents must be extracted from (or copied out of) the ZIP file first.

2. Extract XML File

Extracting the XML file from the ZIP file is as easy as dragging it out of the ZIP window and dropping it on your Windows desktop.  This is how we typically do it.

3. Open XML File

There are many programs that can read and display XML files.  Some do a better job of it than others.  The biggest concern is that you use a program that is able to handle very large files because FERC eTariff XML files can be VERY large…sometimes many, many megabytes.

Our tool of choice is Notepad++, which is a free text file editor.  A standard Windows installer version is available for download from the developer’s website here.

Start Notepad++ and select “File | Open…” from the menu to open the XML file that you copied to your desktop in Step 2 above.

About the XML

The XML file contains tags and data.  The tags appear within angle brackets and the data appears between the tags.

1234

In the example above, “” is a tag that indicates the beginning of the Record Id data and “” signals the end of the Record Id data.  Between the tags is the actual data, which is “1234” in the example.

There are a couple of tags in a typical eTariff XML file that you will not be able to read.  These tags contain binary data that can only be read and understood by a computer:

4. Delete XML File

When you’re done viewing the XML, find the XML file that you placed on your desktop in Step 2 above and delete it.

If you have questions about viewing eTariff XML or if you use a different procedure for opening and viewing it, we’d love to hear from you.  Please comment below or contact TariffShark Support.

FERC Posts Updated Filing Types

On November 17, 2011, the Federal Energy Regulatory Commission (FERC) issued a notice under docket RM01-5 entitled “NOTICE OF CHANGES TO ETARIFF REFUND REPORT TYPE OF FILING CODES”.  The full text of the notice may be downloaded from eLibrary.  Below is a summary of the changes to eTariff filing types.

Filing Code: 670
Description: Refund Report
FERC Program: NGA Gas Pipelines
Changes: This filing code used to represent a Compliance-type filing and is being changed to a Report-type filing effective November 27, 2011.  As a result, “Marked Tariff” and “Clean Tariff” attachments will no longer be valid attachments starting on November 27, 2011.

Filing Code: 1190
Description: Refund Report
FERC Program: Federal Power Act Electric (Market Based Rate) Public Utilities
Changes: This is a new Report-type filing type intended for making refund reports pursuant to 18 CFR 35.19a(b) (2011).

Filing Code: 1200
Description: Refund Report
FERC Program: NGPA 311 Gas Pipelines
Changes: This is a new Report-type filing type intended for making refund reports pursuant to 18 CFR 284.123 and 284.224 (2011).

Filing Code: 1210
Description: Refund Report
FERC Program: Oil Pipelines
Changes: This is a new Report-type filing type intended for making refund reports pursuant to 18 CFR 340.1(c) (2011).

Impact to TariffShark

New TariffShark software releases that accommodate the FERC changes are available now.  We strongly recommend that you follow one of the upgrade paths described below.

If you’re running TariffShark Release 1.0 or 1.1.1

  • You may update to TariffShark Release 1.2.  If you do this, only the database and application server components are affected.
  • You may also update to TariffShark Release 2.2 or 3.2.  If you do this, all components (database server, application server, and desktop clients) must be updated.

If you’re running TariffShark Release 2.0 or 2.1.1

  • You may update to TariffShark Release 2.2.  If you do this, only the database and application server components are affected.
  • You may also update to TariffShark Release 3.2.  If you do this, all components (database server, application server, and desktop clients) must be updated.

If you’re running TariffShark Release 3.0 or 3.1.1

  • You may update to TariffShark Release 3.2.  Only the database and application server components are affected.

Hosted Customers

If your TariffShark servers are hosted by us, we will see that you are running the latest FERC-compliant server software on or before December 4, 2011.  The upgrade will be done during the regular maintenance window (weekdays after 7pm and before 7am…or on the weekend).

All software releases (current and past) are available on the Downloads page on the TariffShark website.

As always, if you have questions or comments, please post them below or contact TariffShark Support.

DOCX, XLSX, and PPTX FERC Attachment Support

As of November 1, 2011, TariffShark offers support for the following Microsoft Office 2007/2010 file formats as FERC Attachments:

  • DOCX: Word document
  • XLSX: Excel workbook
  • PPTX: PowerPoint presentation

This TariffShark update is provided as a database hotfix that works against any TariffShark database version.  By running the database script provided, your TariffShark installation will fully support the new FERC Attachment file formats.  This update does not affect TariffShark’s application server software or the TariffShark Premier client application.

Hosted TariffShark Customers

If you are a subscriber to Hosted TariffShark, our engineers have already updated your database, so you’re good to go.

If you have any questions or need help installling the hotfix, please comment below or contact TariffShark Support.

New TariffShark Releases Available Today

On Tuesday, May 31, 2011 (and again on June 7, 2011), FERC posted an updated definition of eTariff filing types.  We blogged about it a couple weeks ago.

New TariffShark software releases that accommodate the FERC changes are available now.  We strongly recommend that you follow one of the upgrade paths described below.

If you’re running TariffShark Release 1.0 (previously called v1.0)…

  • You may update to TariffShark Release 1.1.  If you do this, only the database and application server components are affected.
  • You may also update to TariffShark Release 2.1 or 3.1.  If you do this, all components (database server, application server, and desktop clients) must be updated.

If you’re running TariffShark Release 2.0 (previously called v1.1)…

  • You may update to TariffShark Release 2.1.  If you do this, only the database and application server components are affected.
  • You may also update to TariffShark Release 3.1.  If you do this, all components (database server, application server, and desktop clients) must be updated.

If you’re running TariffShark Release 3.0 (previously called v1.1.172)…

  • You may update to TariffShark Release 3.1.  Only the database and application server components are affected.

Hosted Customers

If your TariffShark servers are hosted by us, we will see that you are running FERC-compliant server software on or before July 1, 2011.  The upgrade will be done during the regular maintenance window (weekdays after 7pm and before 7am…or on the weekend).  We will notify you in advance once the server upgrade has been scheduled…and again when it has been completed.

All software releases (current and past) are available on the Downloads page on the TariffShark website.

As always, if you have questions or comments, please post them below or contact TariffShark Support.