VMware Cloud Community
segadson
Contributor
Contributor
Jump to solution

Parse CSV File

I Have this CSV File like below:

Site,Prime,Mfg,Model,Serial Number,Asset,Host name,PO,Contact,Location,Carrier,Tracking Number,Order in rack (1 is bottom),MAC1,MAC2,MAC3,MAC4,WWN1,WWN2,WWN3,WWN4,MAC5,MAC6,MAC7,FUNCTION,RACK,POD

LocationA,,HP,ModleA,,,server001,,,,,,20,,,,,,,,,,,,,Rack1,POD001

LocationB,,HP,ModleA,,,server002,,,,,,19,,,,,,,,,,,,,Rack1,POD001

LocationC,,HP,ModleA,,,iserver003,,,,,,18,,,,,,,,,,,,,Rack1,POD001

LocationB,,HP,ModleA,,,server004,,,,,,17,,,,,,,,,,,,,Rack1,POD001

LocationA,,HP,ModleA,,,server005,,,,,,16,,,,,,,,,,,,,Rack1,POD001

Is there a way to parse it into name/value pair arrays so then I can use a sql script to import the data?

Reply
0 Kudos
1 Solution

Accepted Solutions
Burke-
VMware Employee
VMware Employee
Jump to solution

Are you trying to do this in a workflow? If so, this message should be moved to the Orchestrator Community.

Assuming that is the case, please review this article as it steps you through the process of providing a csv file as a workflow input along with actually parsing the file:

http://www.virtualiseme.net.au/index.php/learning-vco-part-1-bulk-vm-creation-by-csv/

If this message is regarding doing this in a plug-in (the purpose of this particular community), then I can't help and the above article is unlikely to help Smiley Wink

If my answer resolved or helped you, please mark it as Correct or Helpful to award points. Thank you! Visit http://www.vcoteam.info & http://blogs.vmware.com/orchestrator for vRealize Orchestrator tips and tutorials - @TechnicalValues on Twitter

View solution in original post

Reply
0 Kudos
3 Replies
Burke-
VMware Employee
VMware Employee
Jump to solution

Are you trying to do this in a workflow? If so, this message should be moved to the Orchestrator Community.

Assuming that is the case, please review this article as it steps you through the process of providing a csv file as a workflow input along with actually parsing the file:

http://www.virtualiseme.net.au/index.php/learning-vco-part-1-bulk-vm-creation-by-csv/

If this message is regarding doing this in a plug-in (the purpose of this particular community), then I can't help and the above article is unlikely to help Smiley Wink

If my answer resolved or helped you, please mark it as Correct or Helpful to award points. Thank you! Visit http://www.vcoteam.info & http://blogs.vmware.com/orchestrator for vRealize Orchestrator tips and tutorials - @TechnicalValues on Twitter
Reply
0 Kudos
segadson
Contributor
Contributor
Jump to solution

Yea my bad for putting it here. That does help out a lot

Reply
0 Kudos
tschoergez
Leadership
Leadership
Jump to solution

moved to ORchestrator communities for later reference 🙂

Joerg

Reply
0 Kudos