Question
Accenture
IN
Last activity: 6 Aug 2018 11:41 EDT
Move a set of files to another folder using OpenSpan
Hi,
How can I loop through a list of files (say excel files) and move those to another folder without using c# ?
Any Inputs ?
Regards,
Accepted Solution
Pegasystems Inc.
US
You could use Static methods to essentially create an automation to do this.
To add that Static method (or any really) to an automation;
- Right-click on the Toolbox window and select "Choose Items".
- Select the "Pega Robotics Static Members" tab.
- Select the "From Global Assembly Cache" radio button.
- Browse to the assembly containing the method you want; in this case, MSCORLIB.
- Locate the "Directory" node.
- Expand it and check the GetFiles method.
- It will now show on your Toolbox and can be dragged into an automation for use.
- Do the same steps for the "Path" node and the "Combine" and "GetFileName" methods.
- Do the same steps for the "File" node and the "Move" method.
Accenture
IN
Hey Thanks a lot Thomas , Its working fine !
Pegasystems Inc.
US
In Build 8.0.1079 a new component was added to the Toolbox called FileUtils. Here are the methods available. You may need to add this to the Toolbox manually if you upgrade.
Accenture
IN
Hey Jeff,
Thanks for the Info!
Genpact
IN
Nice utility, thanks to you for upgrading the tool. It will be a big help if such kind of utilities are available within toolbox. Similarly, please add convertor utility in future which will be useful during excel data conversions.
Pegasystems Inc.
US
What type of conversion do you mean? There are not many restrictions on what you can do already.
Flex Technology Inc
IN
Hi Jeff,
I need to ensure that whether all the files are pasted in the desired location but we don't have the count of files.
Users should place the files in the folder. Do we have a solution?
Thanks!