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?
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
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
Yea my bad for putting it here. That does help out a lot
moved to ORchestrator communities for later reference 🙂
Joerg