{"triggers":[],"nodes":[{"uid":"f0938c38-0b74-4a52-abc3-fa9dfbcddd39","commandName":"step","packageName":"Step","disabled":false,"children":[{"uid":"2ab88ff3-490e-4afb-9208-567ee1cf3d75","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":"e6ba80f6-231e-4d0e-a638-1c5818912a30","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":"7931fa39-f2eb-4922-b278-5c46bbfadba4","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":"32548d7d-b712-45c8-8916-1368fd5ba8ec","commandName":"connect","packageName":"Database","disabled":false,"attributes":[{"name":"session","value":{"type":"STRING","string":"Default"}},{"name":"connectionMode","value":{"type":"STRING","string":"DEFAULT"}},{"name":"connectionURL","value":{"type":"STRING","string":"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\"C:\\temp\\LargeExcelTest\\ZipSample.xlsx\";Extended Properties=\"Excel 12.0 Xml;HDR=YES\""}},{"name":"isUserDefinedDriver","value":{"type":"BOOLEAN","boolean":false}}]},{"uid":"7b78240c-30bc-4f2d-b054-057eacd5deba","commandName":"exportToDataTable","packageName":"Database","disabled":false,"attributes":[{"name":"session","value":{"type":"STRING","string":"Default"}},{"name":"query","value":{"type":"STRING","string":"Select * from [Sheet1$] WHERE Zip = 95164"}},{"name":"fetchSize","value":{"type":"NUMBER","number":"3"}},{"name":"timeOut","value":{"type":"NUMBER","number":"15"}}],"returnTo":{"type":"VARIABLE","variableName":"tExcelResult"}},{"uid":"70d8cf84-c9ab-4650-91a8-38e1a3503e61","commandName":"loop.commands.start","packageName":"Loop","disabled":false,"children":[{"uid":"e3427509-5bf6-4e8f-b260-7e42c7ea1ead","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{City}$ State: $rCurrentRow{State}$"}},{"name":"scrollLines","value":{"type":"NUMBER","number":"30"}},{"name":"closeMsgBox","value":{"type":"BOOLEAN","boolean":true}},{"name":"timeOut","value":{"type":"NUMBER","number":"3"}}]}],"attributes":[{"name":"loopType","value":{"type":"STRING","string":"ITERATOR"}},{"name":"iterator","returnTo":{"type":"VARIABLE","variableName":"rCurrentRow"},"attributes":[{"name":"sourceTable","value":{"type":"VARIABLE","variableName":"tExcelResult"}}],"value":{"type":"ITERATOR","iteratorName":"iteratorTableRow","packageName":"DataTable"}}]},{"uid":"ae5870cd-8570-4d4c-bf08-8fb506de82ca","commandName":"step","packageName":"Step","disabled":false,"children":[{"uid":"ed6eb5da-87cb-4d59-97f4-b8322cbacd4d","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":"b97cd93b-8df3-4729-aed4-cb952a6ff69d","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":"5b340a82-514a-4efe-a349-0c398524fa29","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":"7e4a0674-8254-4d7a-871c-6454445bb6e4","commandName":"step","packageName":"Step","disabled":false,"children":[{"uid":"eb2b75ab-0c46-4fe8-9751-d208407ab085","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":"749156d9-511a-4a90-ba6f-1bd3e5a9c29a","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":"b0eebe65-c07f-41c3-ba4a-d8664d982d60","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":"tExcelResult","description":"","type":"TABLE","readOnly":false,"input":false,"output":false,"subtype":"UNDEFINED","defaultValue":{"type":"TABLE","table":{"schema":[{"type":"STRING"}],"rows":[{"values":[{"type":"STRING","string":""}]}]}}},{"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":"DataTable","version":"2.0.0-20200624-042148"},{"name":"Database","version":"2.0.0-20200624-041623"},{"name":"Datetime","version":"2.0.0-20200624-041628"},{"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":"System","version":"2.0.0-20200309-140321"}],"workItemTemplateName":null}