{"triggers":[],"nodes":[{"uid":"91a93d55-c43f-43a1-b16a-af36c339882f","commandName":"step","packageName":"Step","disabled":false,"children":[{"uid":"9e272fe5-3d14-414e-8abc-9ad6eff6a051","commandName":"assign","packageName":"Datetime","disabled":false,"attributes":[{"name":"option","value":{"type":"STRING","string":"variable"}},{"name":"dateTime","value":{"type":"VARIABLE","packageName":"System","variableName":"Date"}}],"returnTo":{"type":"VARIABLE","variableName":"dtStartTime"}},{"uid":"407f2753-d619-428f-964e-5db83614bb6c","commandName":"toString","packageName":"Datetime","disabled":false,"attributes":[{"name":"source","value":{"type":"VARIABLE","variableName":"dtStartTime"}},{"name":"selectPattern","value":{"type":"STRING","string":"CUSTOM"}},{"name":"patternInput","value":{"type":"STRING","string":"MM/dd/yyyy hh:mm:ss"}}],"returnTo":{"type":"VARIABLE","variableName":"sStartTime"}},{"uid":"9d095934-1205-463d-8448-773030638ad2","commandName":"addItem","packageName":"List","disabled":false,"attributes":[{"name":"sourceList","value":{"type":"VARIABLE","variableName":"lDates"}},{"name":"listItem","value":{"type":"VARIABLE","variableName":"sStartTime"}},{"name":"itemPosition","value":{"type":"STRING","string":"END"}}]}],"attributes":[{"name":"title","value":{"type":"STRING","string":"Set Start Time"}}]},{"uid":"93dcc3a1-7a91-4953-bb3f-ccbbd52143eb","commandName":"OpenSpreadsheet","packageName":"Excel_MS","disabled":false,"attributes":[{"name":"session","value":{"type":"STRING","string":"Default"}},{"name":"filePath","value":{"type":"FILE","string":"file:///C:/temp/LargeExcelTest/ZipSample.xlsx"}},{"name":"isSpecificSheet","value":{"type":"BOOLEAN","boolean":false}},{"name":"fileAccessMode","value":{"type":"STRING","string":"EDIT"}},{"name":"isSecure","value":{"type":"BOOLEAN","boolean":false}},{"name":"containsHeader","value":{"type":"BOOLEAN","boolean":false}},{"name":"loadAddIns","value":{"type":"BOOLEAN","boolean":false}}]},{"uid":"36859fd4-8b66-411c-8186-d3547da9f209","commandName":"loop.commands.start","packageName":"Loop","disabled":false,"children":[{"uid":"8a015c7d-138e-45ff-9329-9e970077f7cb","commandName":"if","packageName":"If","disabled":false,"children":[{"uid":"51cd84b7-773e-4849-8437-c5559e5946f7","commandName":"messageBox","packageName":"MessageBox","disabled":false,"attributes":[{"name":"title","value":{"type":"STRING","string":"Automation Anywhere Enterprise Client"}},{"name":"content","value":{"type":"STRING","expression":"City: $rCurrentRow[1]$ State: $rCurrentRow[2]$"}},{"name":"scrollLines","value":{"type":"NUMBER","number":"30"}},{"name":"closeMsgBox","value":{"type":"BOOLEAN","boolean":true}},{"name":"timeOut","value":{"type":"NUMBER","number":"3"}}]}],"branches":[],"attributes":[{"name":"condition","attributes":[{"name":"variable","value":{"type":"STRING","expression":"$rCurrentRow[0]$"}},{"name":"operator","value":{"type":"STRING","string":"EQ"}},{"name":"value","value":{"type":"STRING","string":"95164"}},{"name":"matchCase","value":{"type":"BOOLEAN","boolean":true}}],"value":{"type":"CONDITIONAL","conditionalName":"stringVariable","packageName":"String"}}]}],"attributes":[{"name":"loopType","value":{"type":"STRING","string":"ITERATOR"}},{"name":"iterator","returnTo":{"type":"VARIABLE","variableName":"rCurrentRow"},"attributes":[{"name":"session","value":{"type":"STRING","string":"Default"}},{"name":"loopSelection","value":{"type":"STRING","string":"ALL_ROWS"}}],"value":{"type":"ITERATOR","iteratorName":"loop.iterators.excel","packageName":"Excel_MS"}}]},{"uid":"3448ed4e-ecda-4a52-8b4e-8f53cfe88a86","commandName":"step","packageName":"Step","disabled":false,"children":[{"uid":"75dcbbb5-bc79-4a1b-b855-23fcc3211a4d","commandName":"assign","packageName":"Datetime","disabled":false,"attributes":[{"name":"option","value":{"type":"STRING","string":"variable"}},{"name":"dateTime","value":{"type":"VARIABLE","packageName":"System","variableName":"Date"}}],"returnTo":{"type":"VARIABLE","variableName":"dtEndTime"}},{"uid":"b300d134-abfa-4ee7-89ee-cacfeb7299d0","commandName":"toString","packageName":"Datetime","disabled":false,"attributes":[{"name":"source","value":{"type":"VARIABLE","variableName":"dtEndTime"}},{"name":"selectPattern","value":{"type":"STRING","string":"CUSTOM"}},{"name":"patternInput","value":{"type":"STRING","string":"MM/dd/yyyy hh:mm:ss"}}],"returnTo":{"type":"VARIABLE","variableName":"sEndTime"}},{"uid":"16be65d1-dca3-47c3-a3d1-b9f8a1c5b564","commandName":"addItem","packageName":"List","disabled":false,"attributes":[{"name":"sourceList","value":{"type":"VARIABLE","variableName":"lDates"}},{"name":"listItem","value":{"type":"VARIABLE","variableName":"sEndTime"}},{"name":"itemPosition","value":{"type":"STRING","string":"END"}}]}],"attributes":[{"name":"title","value":{"type":"STRING","string":"Set End Time"}}]},{"uid":"40bb6299-6553-47c1-b49c-47b12d65abd0","commandName":"step","packageName":"Step","disabled":false,"children":[{"uid":"078f1071-ed3d-4989-ad83-4bd9b2574db7","commandName":"javascript.commands.openScript","packageName":"JavaScript","disabled":false,"attributes":[{"name":"session","value":{"type":"STRING","string":"Default"}},{"name":"scriptOption","value":{"type":"STRING","string":"SCRIPT"}},{"name":"script","value":{"type":"STRING","string":"function dateDiffToString(dates) {\n  //Read Dates from List\n  var date0 = new Date(dates[0]);\n  var date1 = new Date(dates[1]);\n\n  //Subtract\n  diff = Math.abs(date0 - date1);\n\n  //Use mod to find times\n  ms = diff % 1000;\n  diff = (diff - ms) / 1000\n  ss = diff % 60;\n  ss = (\"0\" + ss).slice(-2);\n  diff = (diff - ss) / 60\n  mm = diff % 60;\n  mm = (\"0\"+mm).slice(-2)\n  diff = (diff - mm) / 60\n  hh = diff % 24;\n  hh = (\"0\"+hh).slice(-2)\n\n  return hh + \":\" + mm + \":\" + ss;\n}"}}]},{"uid":"37e5508d-d4bb-4346-8797-544597fa28a6","commandName":"javascript.commands.executeFunction","packageName":"JavaScript","disabled":false,"attributes":[{"name":"session","value":{"type":"STRING","string":"Default"}},{"name":"functionName","value":{"type":"STRING","string":"dateDiffToString"}},{"name":"argument","value":{"type":"VARIABLE","variableName":"lDates"}}],"returnTo":{"type":"VARIABLE","variableName":"prompt-assignment"}}],"attributes":[{"name":"title","value":{"type":"STRING","string":"Calculate Difference"}}]},{"uid":"acb0f775-234c-49d1-bcc5-c1083c2e95ec","commandName":"messageBox","packageName":"MessageBox","disabled":false,"attributes":[{"name":"title","value":{"type":"STRING","string":"Automation Anywhere Enterprise Client"}},{"name":"content","value":{"type":"STRING","expression":"Total Processing Time: $prompt-assignment$"}},{"name":"scrollLines","value":{"type":"NUMBER","number":"30"}},{"name":"closeMsgBox","value":{"type":"BOOLEAN","boolean":false}}]}],"variables":[{"name":"prompt-assignment","description":"A variable you can use for assignments","type":"STRING","subtype":"UNDEFINED","readOnly":false,"input":false,"output":false},{"name":"rCurrentRow","description":"","type":"RECORD","readOnly":false,"input":false,"output":false,"subtype":"UNDEFINED","defaultValue":{"type":"RECORD","record":{"schema":[],"values":[]}}},{"name":"dtStartTime","description":"","type":"DATETIME","readOnly":false,"input":false,"output":false,"defaultValue":{"type":"DATETIME","string":""}},{"name":"sStartTime","description":"","type":"STRING","readOnly":false,"input":false,"output":false,"subtype":"UNDEFINED","defaultValue":{"type":"STRING","string":""}},{"name":"lDates","description":"","type":"LIST","readOnly":false,"input":false,"output":false,"subtype":"STRING","defaultValue":{"type":"LIST","list":[]}},{"name":"dtEndTime","description":"","type":"DATETIME","readOnly":false,"input":false,"output":false,"defaultValue":{"type":"DATETIME","string":""}},{"name":"sEndTime","description":"","type":"STRING","readOnly":false,"input":false,"output":false,"subtype":"UNDEFINED","defaultValue":{"type":"STRING","string":""}}],"breakpoints":[],"packages":[{"name":"Datetime","version":"2.0.0-20200624-041628"},{"name":"Excel_MS","version":"4.0.0-20200630-062036"},{"name":"If","version":"2.0.0-20200624-041646"},{"name":"JavaScript","version":"2.0.0-20200630-062021"},{"name":"List","version":"2.0.0-20200624-041923"},{"name":"Loop","version":"2.0.0-20200624-041924"},{"name":"MessageBox","version":"2.0.0-20200624-041925"},{"name":"Step","version":"2.0.0-20200317-030334"},{"name":"String","version":"3.0.0-20200624-042145"},{"name":"System","version":"2.0.0-20200309-140321"}],"workItemTemplateName":null}