WilliamLam.com

  • About
    • About
    • Privacy
  • VMware Cloud
  • Tanzu
    • Application Modernization
    • Tanzu services
    • Tanzu Community Edition
    • Tanzu Kubernetes Grid
    • vSphere with Tanzu
  • Home Lab
  • Nested Virtualization
  • Apple
You are here: Home / Automation / Quick Tip - Convert VMware Cloud Foundation (VCF) Deployment Workbook XLSX to JSON

Quick Tip - Convert VMware Cloud Foundation (VCF) Deployment Workbook XLSX to JSON

02.17.2023 by William Lam // 2 Comments

The deployment wizard for VMware Cloud Builder (CB) can accept either an XLSX or JSON configuration file that describes your desired VMware Cloud Foundation (VCF) deployment.


Interestingly enough, only an XLSX template is available for users to download, edit and then provide that back as user input. While I can appreciate the rich logic that has been built into the CB workbook, I personally would prefer to work with something a bit more straight forward like JSON, especially for the ability to easily source control via Git/etc.

I have been spending some time with VCF 4.5 and CB this week and I have always wondered if there was a way to convert to JSON format given an XLSX as the initial input. While poking around the logs, I noticed a reference to the following script /opt/vmware/bringup/scripts/json-generator.sh which is used by CB to convert an XLSX to JSON document.

For those that prefer to work with JSON, you can simply fill out the XLSX template once and then convert that to the equilvenet JSON using following instructions

Step 1 - SCP the completed XLSX document to CB. In my example, the XLSX document is called my-vcf-deploy.xlsx

Step 2 - Run the following command specifying the source XLSX, destination JSON and vcf-ems string for VCF deployment:

/opt/vmware/bringup/scripts/json-generator.sh my-vcf-deploy.xlsx my-vcf-deploy.json vcf-ems

Step 3 - SCP the generated JSON configuration file back to your local system and you can now use that as input to CB.

More from my site

  • Frequently asked scenarios about Subscription & Entitlement for vSphere+, vSAN+ and VCF+
  • Frequently asked scenarios about Global Inventory for vSphere+, vSAN+ and VCF+
  • Frequently asked scenarios about Cloud Consumption Interface (CCI) for vSphere+, vSAN+ and VCF+
  • Frequently asked scenarios about vCenter Desired State Configuration for vSphere+, vSAN+ and VCF+
  • Frequently asked scenarios about vCenter Lifecycle Management for vSphere+, vSAN+ and VCF+

Categories // Automation, VMware Cloud Foundation Tags // VMware Cloud Foundation

Comments

  1. hisham gamil says

    09/22/2023 at 10:15 pm

    this works with VCF 5 as well ?

    Reply
    • William Lam says

      09/23/2023 at 4:22 am

      yes, it should work the same

      Reply

Thanks for the comment!Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Search

Author

William Lam is a Senior Staff Solution Architect working in the VMware Cloud team within the Cloud Infrastructure Business Group (CIBG) at VMware. He focuses on Cloud Native, Automation, Integration and Operation for the VMware Cloud based Software Defined Datacenters (SDDC) across Private, Hybrid and Public Cloud

Connect

  • Email
  • GitHub
  • LinkedIn
  • RSS
  • Twitter
  • Vimeo

Recent

  • Disabling vCenter Lifecycle Manager automatic download using vSphere API 10/02/2023
  • ESXi on Lenovo ThinkStation P3 Ultra 09/29/2023
  • Quick Tip - vSphere 7.0 Update 3o also supports disabling/enabling vSphere Cluster Services (vCLS) in vSphere UI 09/29/2023
  • Heads Up - New image identifier required by VM Service in vSphere 8.0 Update 2 09/27/2023
  • How to setup private GitLab on a Synology for Project Keswick? 09/26/2023

Advertisment

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

Copyright WilliamLam.com © 2023

 

Loading Comments...