Export CSV and Read ExportCSVandRead True Finance Dev -1 04ce2409-1b46-4488-aa3f-32c61099d9b6 GJnsU+6AhG67UrtRteOdrZ42Pzkw8Vlo U6ElqEZgui6nh2sL5DzZctuZgOOebwFIes8w0LnkiIYUxYuzFra0fpZDxOxpPTjUBz9AwC7LA69QYH0JLChTOuRRrvHYiyb9d3RhXWfQrgvenmVVMx0Xi/+GNkbwJ+hJ4t0DK2aI0XimO8KtihQI2AEBy8bpAk0b8SkML1aMj6b4YzfD9iKCt8o0KJfOY9qMZ33AqmYBTTXcI4MaH3YTWqfGfb0VyadURHajAPtpV6Y6sCzQRkx9ARkzjKOnYE9NSmPsXkoDNO1YZu7ih+DVBvlzX+bCKuejSMhcOQJ9ajUFYy4UwM5wyx6X9QMtsnNoCMyRK0sVKZ5G/cg/1Wmz9rt6WeC+Uke/s0zvBvvmvvA4e10+xuVE+isVF8Xd+JLJz8is8fRSDmT/zbdFpIIHWl+f+wy6Z5jKol49lUkB+kD96wLiqMzd+t2+0k3Kg3TG7plLOJyIHBUdG92A42DoQNLRef1xTErU9+gFSCeqvZ9suJHoO7Lzg2AXINP6Kjtotar/WdgyhiS09EOSO5tVzX+6idC7lRhspBefboqmLotNpxpeFAwHTPRN3ujapuFKgAganBv6is5o36sYkDrHP70amH3ybAgNpRVVo2dzpX+mnSxInhOQtJQ7pQXDIa3ms7dDpyyp6tJr7xzlYN/O0ob5URjSU7UKwmeTug1z7UZCcUUnY2zCkpRTl5A7XuhHwFXxjal/H1+VKy4H9+7UTPCG/yoian9U72lY9ADpBPNMrIZ755Mp0lFcoAPz486UAm1K97IMTfHbrKLfR3f4i5b3m1R1xJUUKCxVBqUrDgJ2h7EROwNvHBetfr2Vz8xqhhvD6twS2mbe2GZDi2SM5CmE0jyjX+N227wXOP+2lEMiJIX8T6V52tKpqO+KKGRTZda2VU9/9I/8B3Gsk6sxAxHS8J0ewF2ntnbKX/2FEFg3ayd20gJXXqe21Bq9bQL1u3vA7NBx+XQXKrhn71B9cGRpG90ORufqIF9jZQHgBuqs1uzze6MqIO2GTa1GzghqFsExhu7f+1wyRSvHU5sJ9ecEAk0tWxdeyI/x3jPZFCvFI0yz6T+V2A== PKK-3510 -1 4c700819-0237-43fe-84ca-fb6aef87ad8a /Prif3uLdEUcbUf6HCon/phBYRZA8EVm QzIl+0dSlpyNIUCTQvloo+283ZfLw0IoO+qtBYNXAueK2P+DHPyLuCoOljhEj0eskCBdJSQ1plCy/lC+gvCA/MA7lhshA0BJKwyoX04KvWCRlPsm0AyI7pOHLFjLJn2Wb7naSD9VFNKE5ZiTRmUOiJmIlhrrqDp81tYjpxJ58FSyWr8bm9RndEAN47G8dQ+LippQnrSW7d7RLH3odZqwWxtz+RYD3JizxhQSe6zBS+Iu5UYwHVtz1EtGyj6AQz+l+lMZD6h3iIjGay/WumlCqox/LfQ4+b6Pre2uMpnEuisTPgBqsD8PkZ50QPOuGB5sxAXZgJuC0Lu1MbHjF6l71Wafxy5kdjUflQetPdAKvyFqBGv4Y/QONRpah2VwO7rl1EdMLsKaplyUJG7zbnyzvYkHtgo4iOJ//b5uxabrhNGy1xXBp6lOUvWwqznDp8lwLoKI6LY8qL7oVNS6HGtXQeP86lsuDfpz7YEv4FrnA8h9SgSNGj4+rBT93SGLRVxSS0q1sLv/yNaQE5snc7tpN7XExFQoTo/kT8rP3yXwKmPz9C/OrU22D/RrWJB7jvwe+5hwWK79y+pHUoDxsDs/t4AfbGh2H0OeAK9/ZAB/P50+7BgGYEklpUO54plx1op4+0P0xfn9NS23EjUn7I77Xa4hKPZwSnq3cXuCskujnmlz/WhOaVyX6vujAK9FUX/J5g6AEhhH9nQ7NSB8cc7/d2gvQseuzb04/3EeNnNuT0/+/A328mb1G+2Xzi82s5BO3pGlObn0M10T8NPE+wufzSA+aXr1PpiiTnQWeI0nrvI8oDbGtvxVIb+t+8txETwlnWuZzDoRIWRDg1feEHecuWWcq1J9yeGDtf4xphvslADx7PNaatnaxNmz7I+V/suGuC0VQbjvFAKgXaRxOkeXj3PnXgr6YzHGk2AggjlP6bj+duyfnCvP1/a39blXwrQCssOjOl1/Ccqv+PK3e8e6iLpQS+Ug0LuHXzpsetVReLSgnuENqMa6TpR6KehOoLrEuA67CxGgG4tNxm0xxcGddH0V9riTQo5dA6MHThb/QmY= Entries DataSource 9068 10f5a810-a8ea-48cd-9c3b-25736e85bc00 Entries System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System\v4.0_4.0.0.0__b77a5c561934e089\System.dll System.Core, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Core\v4.0_4.0.0.0__b77a5c561934e089\System.Core.dll System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.Net\assembly\GAC_64\System.Data\v4.0_4.0.0.0__b77a5c561934e089\System.Data.dll System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Xml\v4.0_4.0.0.0__b77a5c561934e089\System.Xml.dll Laserfiche.Workflow.Activities.83, Version=8.3.0.0, Culture=neutral, PublicKeyToken=d8428ff9263e6cda C:\Program Files\Laserfiche\Laserfiche Workflow 9\Laserfiche.Workflow.Activities.83.DLL Laserfiche.RepositoryAccess, Version=9.1.0.0, Culture=neutral, PublicKeyToken=3f98b3eaee6c16a6 System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System\v4.0_4.0.0.0__b77a5c561934e089\System.dll System.Core, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Core\v4.0_4.0.0.0__b77a5c561934e089\System.Core.dll System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.Net\assembly\GAC_64\System.Data\v4.0_4.0.0.0__b77a5c561934e089\System.Data.dll System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Xml\v4.0_4.0.0.0__b77a5c561934e089\System.Xml.dll Microsoft.VisualBasic, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.VisualBasic\v4.0_10.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualBasic.dll Laserfiche.Workflow.Activities.83, Version=8.3.0.0, Culture=neutral, PublicKeyToken=d8428ff9263e6cda C:\Program Files\Laserfiche\Laserfiche Workflow 10.2\Laserfiche.Workflow.Activities.83.dll Laserfiche.RepositoryAccess, Version=9.1.0.0, Culture=neutral, PublicKeyToken=3f98b3eaee6c16a6 C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Laserfiche.RepositoryAccess\v4.0_9.1.0.0__3f98b3eaee6c16a6\Laserfiche.RepositoryAccess.dll Laserfiche.DocumentServices, Version=9.1.0.0, Culture=neutral, PublicKeyToken=3f98b3eaee6c16a6 C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Laserfiche.DocumentServices\v4.0_9.1.0.0__3f98b3eaee6c16a6\Laserfiche.DocumentServices.dll Running Completed Terminated en-us rcilaserfiche 2018-10-16T19:49:31.547Z 27128 3 PKK-3510 8bbaa1c5-a08c-4889-b58d-e49d43c4f4f5 C:\My\Documents\Settings\Laserfiche\Workflows\Export CSV and Read.wfx Assign Global Tokens AssignGlobalTokens True Creates new tokens and updates the values of existing tokens. XLSXPath C:\temp\CSV\ XLSXName ENTRIES.csv EntryIDs Try-Catch Save to Windows TryCatchSavetoWindows True Prevents a workflow from terminating if an activity encounters an error. A catch branch lets you specify activities that will be performed if the try branch encounters an error. Try Branch TryBranch True Defines the default actions that will be attempted. SDK Script Save to Windows SDKScriptSavetoWindows True A scripting activity that provides a connection to the SDK. 4c700819-0237-43fe-84ca-fb6aef87ad8a VB Laserfiche.Workflow.Designer.Scripting.WFVBScript, Laserfiche.Workflow.Designer.Base, Version=8.3.0.0, Culture=neutral, PublicKeyToken=d8428ff9263e6cda H4sIAAAAAAAEAH1UUY/aMAx+R+I/WPcwQGKZeJy0m8Su3Qnt2KErOu41tIZG1yYoSVv67+e00FLoaF8a+7P9+audRXpQ2hoISmMxHQ4WnTN7UkmCoRVKGvaMErUIezB0lijtUkWY3Lg9bvmNcY1H2xpfuEG9E2GM7A0PygirdDkPQzSmF+SpMEupYIA6F4QaDkb5jM3gKwSWa3tTbfHaInwZDQfu/ctTNAceImyU/twlqphTo7mwJQtCLQ5WyD0LvD/1IeA5WrURMlIF1QN6RqPRD5OlKdflz8ay0ioXERogRUBpSJVGSNHGKjJgY24h5BK2CDqTUMQoyYhQnBiAOVcGfiIDwsCBGlc6xYi1lb91S6+ybSJCeEq4obarLLPa456FjOnXkSBv89pX4b5fIG6bOVnXMRGoG3BUOrTvcfwPz4qrVpaGCiN4zVHrSq4g24J/xDCzOJ600CrLhqgjlCrTENKIAfWCDNZE4JfKZORLq8uF3Ck4aEU0iE8hkoTYuQGqiKKDTF33ZKFhrgF7tJW3nTmohw5MDevyiEQKdS0PuCFNLe5RwyOpwy6IRN0oj6I+XoKPFbexCwusdr+3inpGu1afKN95kuH44Qx7mLC1qnH9udzodnIte3M52N1cy/Ksh0t2+qyYNUr1BZ3Xz0XdWd1mTat/8wjno6N66RqfRJ02dK4HoLvcl67Frt1x9lskyPyjMNaMG8m/NIpN3MhcNeSeqwQeJkhD2JegG0s3CdXvp1rdMtfKeb5TTGLRSOEf3T2F+grrs9rh091L0HEr+fQ+LUeJNqk2uEO158OB+2zuu+HgH3aWqQ/1BQAA 3089faa2-2a25-48d3-a969-1626654eed42 3089faa2-2a25-48d3-a969-1626654eed42 Catch Branch CatchBranch True Defines the actions that will take place if a specific error occurs. System.Exception Route to Error Cannot Export RoutetoErrorCannotExport False Routes a Laserfiche entry to a specified folder. 4c700819-0237-43fe-84ca-fb6aef87ad8a \Expenses\Maintenance\ADP Employee Mapping\3. Errors Expense History String true Append Error: Cannot Save Excel. %(CatchBranch_Message) 5ebc0415-2f7f-4471-bbcd-7a710fd990bb End Workflow Save error EndWorkflowSaveerror True Completes or terminates a workflow. Error: Cannot Save Excel. %(CatchBranch_Message) Try-Catch Load ADP File TryCatchLoadADPFile True Prevents a workflow from terminating if an activity encounters an error. A catch branch lets you specify activities that will be performed if the try branch encounters an error. Try Branch Load ADP TryBranchLoadADP True Defines the default actions that will be attempted. Query Data QueryData True Retrieves records from the selected data source and creates tokens. 10f5a810-a8ea-48cd-9c3b-25736e85bc00
Catch Branch Load ADP CatchBranchLoadADP True Defines the actions that will take place if a specific error occurs. System.Exception Route to Error Cannot Load to Database RoutetoErrorCannotLoadtoDatabase False Routes a Laserfiche entry to a specified folder. 04ce2409-1b46-4488-aa3f-32c61099d9b6 \Expenses\Maintenance\ADP Employee Mapping\3. Errors Expense History String true Append Error: Cannot Load Excel %(CatchBranchLoadADP_Message) ca713c55-1ba0-4e1c-a2dd-13d60cfb9d66 End Workflow EndWorkflow True Completes or terminates a workflow. Error: Cannot Load Excel %(CatchBranchLoadADP_Message)
For Each Row ForEachRow True Runs the contained activities for each row returned by a Custom Query or Query Data activity, or for each result returned by activities that return collections of information. Assign Token Values AssignTokenValues True Creates new tokens and updates the values of existing tokens. EntryIDs EntryIDs AssignGlobalTokens %(ForEachRow_ENTRYID) Track Tokens TrackTokens True Records the values of selected tokens when the workflow runs. You can view these values in the Tokens tab in the workflow's Search Details pane.
True True True True False True True True False True false 1.0
9068 Entries DataSource DataSource Export CSV and Read <SourceInformation DataSourceType="Dsn" DSNType="System" Authenticated="true"> <Location> <HostName>Entries</HostName> <ServerInstance /> <DatabaseName /> <LocationType>None</LocationType> </Location> <Authentication> <UserName></UserName> <SecureString Version="2" Value="" /> </Authentication> <Adapter IsNil="true" /> <OtherOptions ActualType="Laserfiche.Collections.PropertyBag, Laserfiche.Base, Version=9.0.0.0, Culture=neutral, PublicKeyToken=607dd73ee2bd1c00"> <Properties /> </OtherOptions> </SourceInformation>