emmbee9
Contributor
Contributor

vRA 7.6 - problem of bulk import - update (change/edit) of Virtual Machine resources - invalid CSV

vRA 7.6 - problem of bulk import - change/edit of VM resources - invalid CSV

Hello,

i have Version: vRA 7.6.0 (Build: 16657764) in my organization.

I have problem with bulk import of CSV of my VM. I need to add more resources to existing VM. Concreete RAM.

        1) I copied and after edited my 1st blueprint RAM maximum from 8000 MB ram to 12228, and saved it.

emmbee9_0-1623149741671.png

          2) After, i exported bulk export CSV, edited line from this:

Yes,SRV-VRA-TS1,adeb3adc-f856-4982-bb5c-20a7eba03bcd,Test_BG_rezervace_prostredku,OCEAN2_R6_SSD_DEDUP_91_TS,Pro_TEST_BG_PKKV_win2019_server_1-63631307,Pro_TEST_BG_PKKV_win2019_server_1,w2019_vmware_machine_1,admin_mb@ext1.ku.ji.cz,VirtualMachine.Imported.Notes,%E2%80%A2%09%C5%98adi%C4%8D%20dom%C3%A9ny%20%0A%E2%80%A2%09Souborov%C3%BD%20server%0A%E2%80%A2%09Tiskov%C3%BD%20server%0A%E2%80%A2%09Server%20pro%20b%C4%9Bh%20%C3%BA%C4%8Detnictv%C3%AD%20%28pokud%20bude%20i%20nad%C3%A1le%20pou%C5%BE%C3%ADv%C3%A1n%20GINIS%20Express%29%0A%E2%80%A2%09Shibboleth%2FIDP,HOP,VirtualMachine.Imported.ExpireDays,0,HOP,__api.request.callback.service.id,f00d6f3a-5255-4eaa-baf4-2525907473c8,NOP,__api.request.id,b612ea08-17fa-40ea-86b9-452f91982c7a,NOP,__Cafe.Request.BlueprintType,1,NOP,__Cafe.Request.VM.HostnamePrefix,SRV-VRA-TS,NOP,__Cafe.Root.Request.Id,58c3f37a-e31f-4e26-a7de-e2dfad561a14,NOP,__Clone_Type,CloneWorkflow,NOP,__clonefrom,w2019_091020_std_Cisty_vRA_template,NOP,__clonefromid,9dd82f9d-ac44-49a7-a0f0-ec8078daa6d7,NOP,__clonespec,W2019_vRA_server,NOP,__datacollected_ipaddress,192.168.42.230,HOP,__iaas_request_binding_id,c8fe9ade-81cc-4556-a59e-7c434425ab30,NOP,__InterfaceType,vSphere,NOP,__Legacy.Workflow.ImpersonatingUser,,NOP,__Legacy.Workflow.User,admin_mb%40ext1.ku.ji.cz,NOP,__Notes,%E2%80%A2%09%C5%98adi%C4%8D%20dom%C3%A9ny%20%0A%E2%80%A2%09Souborov%C3%BD%20server%0A%E2%80%A2%09Tiskov%C3%BD%20server%0A%E2%80%A2%09Server%20pro%20b%C4%9Bh%20%C3%BA%C4%8Detnictv%C3%AD%20%28pokud%20bude%20i%20nad%C3%A1le%20pou%C5%BE%C3%ADv%C3%A1n%20GINIS%20Express%29%0A%E2%80%A2%09Shibboleth%2FIDP%0A,NOP,__ovf_use_proxy,False,NOP,__ovfAuthNeeded,False,NOP,__request_reason,,NOP,__trace_id,C41JRX9S,NOP,__VirtualMachine.Allocation.InitialMachineState,SubmittingRequest,NOP,__VirtualMachine.ProvisioningWorkflowName,CloneWorkflow,NOP,Cafe.Shim.VirtualMachine.TotalStorageSize,60,NOP,trace_id,C41JRX9S,NOP,VirtualMachine.Admin.AgentID,1b433642-f1af-8f56-49ca-901b143b698e,NOP,VirtualMachine.Admin.Hostname,ClusterTS,NOP,VirtualMachine.Admin.TotalDiskUsage,61440,NOP,VirtualMachine.Admin.UUID,50365e4a-a17a-0767-7ab3-217171b007d7,NOP,VirtualMachine.Cafe.Blueprint.Component.Cluster.Index,0,NOP,VirtualMachine.Cafe.Blueprint.Component.Id,w2019_vmware_machine_1,NOP,VirtualMachine.Cafe.Blueprint.Component.TypeId,Infrastructure.CatalogItem.Machine.Virtual.vSphere,NOP,VirtualMachine.Cafe.Blueprint.Id,Pro_TEST_BG_PKKV_win2019_server_1,NOP,VirtualMachine.Cafe.Blueprint.Name,Pro_TEST_BG_PKKV_win2019_server_1,NOP,VirtualMachine.CPU.Count,2,NOP,VirtualMachine.Disk0.DeviceID,SCSI%20%280%3A0%29,NOP,VirtualMachine.Disk0.ExternalID,6000C29f-cb49-014c-7fe6-2a284874183c,NOP,VirtualMachine.Disk0.IsClone,true,NOP,VirtualMachine.Disk0.IsFixed,False,NOP,VirtualMachine.Disk0.Label,Hard%20disk%201,NOP,VirtualMachine.Disk0.Name,Hard%20disk%201,NOP,VirtualMachine.Disk0.Size,60,NOP,VirtualMachine.Disk0.Storage,OCEAN2_R6_SSD_DEDUP_91_TS,NOP,VirtualMachine.Memory.Size,4096,NOP,VirtualMachine.Network0.Address,192.168.42.230,NOP,VirtualMachine.Network0.AddressType,Static,NOP,VirtualMachine.Network0.Gateway,192.168.42.1,NOP,VirtualMachine.Network0.MacAddress,00%3A50%3A56%3Ab6%3A58%3A46,NOP,VirtualMachine.Network0.Name,dv_LAN_212,NOP,VirtualMachine.Network0.NetworkName,212_NetworkProfile,NOP,VirtualMachine.Network0.NetworkProfileName,212_NetworkProfile,NOP,VirtualMachine.Network0.PrimaryDns,172.30.131.188,NOP,VirtualMachine.Network0.SecondaryDns,172.30.131.132,NOP,VirtualMachine.Network0.SubnetMask,255.255.255.0,NOP,VirtualMachine.Storage.Name,OCEAN2_R6_SSD_DEDUP_91_TS,NOP,VMware.VirtualCenter.Folder,TCK%2Fpkkv_vRA,NOP,Vrm.ProxyAgent.Uri,https%3A%2F%2Fsrv-vra-iaas1.ext1.ku.ji.cz%2FVMPS2Proxy,NOP

         3) To this: (I had information of our support company, try to delete ID/ keep commas, import will create new one. End of line is irrelevant so delete it. So i did it.)

Yes,SRV-VRA-TS1,,Test_BG_rezervace_prostredku,OCEAN2_R6_SSD_DEDUP_91_TS,Pro_TEST_BG_PKKV_win2019_server_1-63631307,Pro_TEST_BG_PKKV_win2019_server_1_12GBRAM,w2019_vmware_machine_1,admin_mb@ext1.ku.ji.cz

        4) I unregistered VM and tried to import new edited CSV. And i have this err:

"Invalid CSV. No machines to proces."

emmbee9_1-1623149741676.png

 

emmbee9_2-1623149741681.png

Please do you someone have idea what is wrong? In attachment – long named file is 1st CSV (Bulk Export 18.03.2021 135135 UTC+0100.csv), short name CSV (bulk_5_ts.csv) is new edited CSV for import (invalid).

0 Kudos
5 Replies
jimmyvandermast
Enthusiast
Enthusiast

So you try to change the amount of RAM for your VM by importing it?

0 Kudos
emmbee9
Contributor
Contributor

Hi,

yes, upper limit of RAM. Customer need to add more RAM to server.

0 Kudos
jimmyvandermast
Enthusiast
Enthusiast

Removing and re-importing the VM makes no sense, as far as I know.

During the request for deployment, that upper limit applies. So you cannot request more than that limit.

After deployment, you can simply add RAM with a day-2 action  (a XaaS Resource Action that links to a vRO Workflow).
When you use the vRO workflow that uses the vRO Action "ChangeVMRAM" under com.vmware.library.vc.vm, you can change RAM to anything without the blueprint limits.

About the import failure, I don't think you should remove that Virtual Machine ID.
So: 
Yes,SRV-VRA-TS1,,Test_BG_rezervace_prostredku
Should still be:
Yes,SRV-VRA-TS1,adeb3adc-f856-4982-bb5c-20a7eba03bcd,Test_BG_rezervace_prostredku

0 Kudos
jimmyvandermast
Enthusiast
Enthusiast

(strange, I sent an answer but I don't see it anymore)

As far as I know, you don't need to remove and re-import the VM to change that.

You can change the amount of memory by using a Day-2 action, an XaaS Resource Action: a vRO Workflow that calls the vRO Action ChangeVMRAM. Then you can change the VM RAM to anything you want, without the limits from the blueprint.  (if you like, you could add an Approval to it, so it needs to be approved first)

About the import error, I think you should not remove that Virtual Machine ID.

0 Kudos
wila
Leadership
Leadership

Hi,

moderator note:

Two of your posts got marked as spam.
I pulled these out of the spam queue and moved one of them to the bin.
No need to repost, one of us moderators will normally see this within a few hours.
If messages go missing you can use the report option to notify a moderator if it gets unnoticed.

--
Wil

| Author of Vimalin. The virtual machine Backup app for VMware Fusion, VMware Workstation and Player |
| More info at vimalin.com | Twitter @wilva
0 Kudos