Created a BASH script to convert json to csv

Scott Zupek

Active Member
Nov 5, 2018
27
1
43
44
I have created a bash script that will strip the special characters from the .json file and organize via comma delimited CSV file. Original JSON file provided by the pvesh get <resource> --output-format json

You will have duplicate headers but it's still useful for SQL import commands.

Read the commands at the top of the script and make sure to do chmod +x on the file if you plan to use it.

Only trying to make life easier for admins.

Thanks,
Scott.
 

Attachments

  • prod_convert2csv.zip
    2.6 KB · Views: 59

About

The Proxmox community has been around for many years and offers help and support for Proxmox VE, Proxmox Backup Server, and Proxmox Mail Gateway.
We think our community is one of the best thanks to people like you!

Get your subscription!

The Proxmox team works very hard to make sure you are running the best software and getting stable updates and security enhancements, as well as quick enterprise support. Tens of thousands of happy customers have a Proxmox subscription. Get yours easily in our online shop.

Buy now!