CSV export does not respect cost filter, pricing timescale, etc

[lincolnlim]

Hi,

Thanks for inclusion of the pricing for the SQL Enterprise instances, after my recent request. Much appreciated.

I noticed an issue, and hope you'll assist to improve it.

When I select Cost: Annually, Reserved : 3Yr - Full Partial, then select all Columns for Reserved Cost of all the Windows Instances,

• on the website, it shows the Annually price or Unavailable
• on the exported CSV, it shows some Annually price, some Hourly price and Unavailable

Appreciate if you can set all as Annually price in the CSV, as per the website.

Thanks.

[lincolnlim]

Noticed that now, all pricing in exported CSV, is in Hourly, despite I've selected option "Cost: Annually", on the website, clicking the CSV button.

Hope you to have your great help, to convert both Online Website and Exported CSV, both to Annual Pricing, whenever the option "Cost: Annually" is selected on the website.

Thanks for your help.

[cristim]

I didn't look at the code yet but I assume the CSV feature is simply dumping the JSON data source which is always storing the hourly rate.

It would have to be updated to reflect the desired pricing period.

If you strongly need this, please create a PR with a proposed implementation, we would gladly accept such a contribution.

[powdahound]

Related from #353:

1. While selecting the column on portal it shows the required columns but when I export that to CSV it takes all of the columns available in the CSV and then I have to manually delete all the unnecessary columns from the CSV.
2. If I select the costing from Hourly to Monthly it again displays correctly on the portal but in CSV it only gets hourly values.

[nunod2]

"If you strongly need this, please create a PR with a proposed implementation, we would gladly accept such a contribution."
I would love to but new to this, wouldn't know where to start. Anyone know where to get the full AWS Price list in Excel (CSV) and not JSON?