Hybr®
Cloud Assert HomeDocs Home
2303
2303
  • Introduction
  • Features
    • Summary
    • Service Providers
      • Tenants Management
        • Tenant Onboarding
        • Tenant Portal Access for HYBR Admin
        • Tenant Portal Access for Support Users From Different Domain
        • Tenant Company Management
        • Company with AAD B2C
        • User Management
        • Subscriptions Management
        • Offers Management
        • Plans Management
      • Reseller Management
        • Reseller Offer
        • Reseller Plan
        • Onboarding a CSP Customer and Mapping it with Reseller
      • Billing
        • Credits
        • Microsoft CSP
        • Pricing Profile
          • Pricing Profiles Management
            • How to set Pricing List Import setting for meter
          • Update Pricing Profile from Excel
        • Cost Reset
      • Resource Management
        • Console connect requirements for imported VMs
        • Connection manager
          • Azure Stack Hub Connection Management
          • Azure
          • AWS
        • VM Template management
        • Param Spec
        • Network Management
        • Azure Integration
        • Policy Management
        • Linked Clone
        • Attach and detach networks
        • Delete Options
        • Backup
          • Veeam Backup Configuration
          • Scheduling a backup using Veeam
      • Microsoft CSP
        • MS CSP security consent process
        • Partner Center Refresh Token Expiry Alert
        • New Commerce Experience (NCE)
          • Transition from Legacy to NCE
        • Azure Reservation Management
        • Granular Delegated Admin Privileges
          • Bulk Transition of customers from DAP to GDAP
          • Default roles to be provided for relationship request.
      • Service Catalog
        • FAQ
      • Azure Stack Hub
        • Create and Publish Service Catalog offers
        • Configure Service Catalogue Plan
        • Pricing
        • Security Deposit for an Azure Stack Hub Offer
      • Customization
      • Administration
        • Application Settings
        • Admin Portal Access for Support Users
    • Business Intelligence Dashboards & Reports
      • Dashboards
      • Reports
        • Schedule Reports
    • Reseller
      • Customers Management
        • Customer Onboarding
        • Plans
        • Offers
      • Billing
        • Pricing Profile Management
    • Customer
      • Subscriptions
      • Resource Management
        • Virtual Machines
        • Connect a VM using browser
        • Virtual Networks
        • Resource Templates
        • Resource Groups
      • Microsoft CSP
        • CSP Operations and Status tracking
      • Software-Defined Network (SDN)
      • Company Registration
    • Cloud Cost Management
      • Cloud Dashboards
        • Azure Invoice Comparision
      • Collaborations
      • Resource Tagging
        • Data Processing Rules
      • Cost Allocations & Budgeting
        • Budgeting
      • Recommendations
      • Reconcilation
      • Getting started
        • Kubernetes
        • Azure
        • AWS
        • GCP
        • Tenant Company Creation
  • Advanced Guides
    • CSP Customers with Resellers
  • API Documentation
    • External Integration and API Documentation Overview
    • External Webhook Integration
    • Zapier Integration
      • External application events which trigger event in Hybr
      • Event in Hybr which trigger external Application
  • Support
    • How do I contact support?
    • How do I share feedback?
    • Roadmap
    • Changelog
  • On-Prem Installation
    • Architecture
    • Prerequisites
      • Infrastructure
        • Production
        • POC
      • Identity Providers
        • AAD B2C
        • Microsoft Entra ID
        • ADFS
      • Services
        • VConnect
        • Workflow
        • Microsoft CSP
        • Remote connect using Guacamole
          • Apache Guacamole Setup
          • Troubleshoot
          • Support Links
          • Guacamole Pre-Requisites
        • Console connect for VCenter V7
          • Pre-Requisites
          • Configurations for Nginx (Reverse Proxy Server)
          • Troubleshoot
          • Supporting Commands / Configurations
      • Ports Requirements
    • Deployment
      • Core Components
      • VConnect
      • Billing
    • Configuration
      • Billing
        • Custom Invoice
        • Multilingual Support
      • Cost Management
        • General
    • Updates
      • Billing
      • Cost Management
    • Infrastructure & Application Security - Recommendations
Powered by GitBook
On this page
  • Connect and Load Pricing Profile
  • Update the meters
  • Update the Pricing Profile

Was this helpful?

  1. Features
  2. Service Providers
  3. Billing
  4. Pricing Profile

Update Pricing Profile from Excel

PreviousHow to set Pricing List Import setting for meterNextCost Reset

Last updated 2 years ago

Was this helpful?

Use this option when you need to add or update a large number of meters in the existing Pricing profile. This feature allows the admin to edit and add meters from the existing Pricing profile through Microsoft Excel and to update it back into the Billing system through the Billing tool. When you need to add or update very few meters, using the UI is recommended.

Connect and Load Pricing Profile

  • Get the Pricing Profile ID from Pricing Profile Page in Hybr Billing.

  • Download the below SQL Query and replace the {PricingProfileId} with the Identifier value of the Pricing profile to be loaded.

  • To connect Excel to a Billing database, open Excel, and then create a new workbook or open an existing Excel workbook.

  • In the menu bar at the top of the page, select the Data tab, select Get Data, select From Database, and then select From SQL Server Database.

  • In the SQL Server database dialog box, type the Server and Database name to connect to Billing Database. Select Advanced Options and fill the SQL Statement with the SQL Query prepared in step #2. Select OK to open the credentials window.

  • Enter the credentials to connect to the Database and select Connect.

  • Click Load to load the data in sheet.

Update the meters

  • To edit the existing meter, edit the monthly unit price as required and set IsCollectionEnabled to TRUE.

  • To add new meters, fill in all the fields and set the ID as 0.

  • Save the file.

Update the Pricing Profile

To update the changes to the Pricing profile, follow the below steps.

  • Login to Billing RP server and use the latest Billing Tool.

  • Copy the file inside the Billing tool folder

  • Open the Windows Command Prompt in the Billing tool folder. Replace the variable in the below command and execute to update changes in Pricing Profile.

Billing.exe AddOrUpdateMeteredResourcePricing /sheetName:{sheetName} /ApiEndpoint:{billingApiUrl} /Username:{billingApiUserName} /Password:{billingApiPassword} 
  • Once completed, Meters Updated message should be displayed.

Ensure the MS Access DB engine is installed in the machine from where the billing tool is run. ().

https://www.microsoft.com/en-us/download/confirmation.aspx?id=13255
769B
PricingProfileQuery.sql
Pricing Profile Query