Testing
// Read CSV from Resource Element
var csvContent = csvResource.getContentAsMimeAttachment().content;
// Convert bytes to string
var csv = csvContent;
// Split into lines
var lines = csv.split("\n");
// Create Properties object
var props = new Properties();
// Skip header row
for (var i = 1; i < lines.length; i++) {
var line = lines[i].replace("\r", "");
if (line == "") {
continue;
}
var columns = line.split(",");
var hostname = columns[0].trim();
var password = columns[1].trim();
props.put(hostname, password);
System.log("Added : " + hostname);
}
// Update Configuration Element
configElement.setAttributeWithKey("hostPasswords", props);
System.log("Import completed.");
Comments
Post a Comment