Number of Keystrokes limited to two?

@david_masters if you need to paste the values in Excel in Number format, you can open the file on the screen and paste it using mouse clicks and keystrokes, in this case it will have the format defined in the excel file.

When you use built-in Excel actions, the value is always a string.

Hi Alesia,
I have been trying to use Ctrl+a then Ctrl+c to copy the data (6 cells with numbers). Switch to another sheet and use Ctrl +v to paste contents.
Nothing is copied and the clipboard appears empty.
Does ctrl+c work?
David

Yes, it should work. Can you share the screenshot of these actions?

See script. Appreciate there might be some redundant steps but thought this simple script should work, The excel spreadsheet has 6 cells populated. I have tried more complicated scripts but to no avail. Thanks, David

@david_masters did you send the script through a direct message?

@david_masters could you share the script please? I didn’t find it anywhere in the thread.

image

1 Like

@david_masters thank you, I get it now.

You cannot use keystrokes if you use built-in Excel actions.
Excel actions work with files in the background, without actually opening them on the screen, so there is no UI for the keystrokes to interact with, and they don’t work.

To use the keystrokes, you need to open the file on the screen - use keystrokes and mouse clicks on window controls for it like in this example.

Here is a sample script. You just need to change the filepath.
open-excel.zip (59.5 KB)

Hi Alesia,
Sorry for the delay in responding to this post. I tried Hot Keys and all good. Can open files, select cells, cut and paste, add formulae and so on.
Question. Why would you use the WF inbuilt capabilities in Excel if you can perform the same steps using Hot Keys? The inbuilt capability seems to be limited to strings whereas Hot Keys are not. Is it to simplify common actions and avoid MS licence fees?
David

1 Like

The built-in Excel actions are executed in background a lot faster than opening the file on the screen and using hot keys.

They are helpful when you need to get a large amount of data that you will use later in the script. Here is a standard example of how you can use it

You still need MS installed on your pc to use it, so it doesn’t influence the license fees.

Hi Alesia,
2 Questions which I hope are simple:

  1. You sent me a zipped file but what is the process for importing the file. Unlike most apps there is a File\Open\Directory\xxx.RPAE. But no such function exists in WF, Can you please advise how this is done.
  2. I ran a series of bots in Control Tower which failed. When I try and re-run the workflow, the icon Run This Process disappears. Why and how do I restore the Run This Process icon again?
    Thanks for your help. Your responses have always been helpful.
    Regards,
    David

Hi David,

You need to copy the folder with the recording to the rpae-project folder in your workspace. You can find details on how to do it here: https://kb.workfusion.com/display/RPAe/How+to+Use+RPA+Recorder#HowtoUseRPARecorder-AddingRecordingAddrecording

To re-run a business process, you need to copy it - it will create a new business process instance. Here is a guide and video on how to do it https://kb.workfusion.com/display/RPAe/How+to+Run+a+Business+Process#HowtoRunaBusinessProcess-Howtore-runabusinessprocess

Hi Alesia,
As always, thanks.
Regards,
David

1 Like

Hi Alesia,
I have successfully followed your instructions in both instances, so thanks.
In re-running the process won’t this create an endless list of instances? Also I have not scheduled a process but does this scheduling of the process automatically create an instance every time it is run.
Finally, I did try and execute the OCR process and it failed. I will keep trying but one of my clients who has used this and other OCR software says they are not reliable. That the failure rate can be high? Has this been your experience?
Regards,
David

Yes, the schedule creates a new BP instance when the process is launched. You can delete instances that you don’t need from the list.

What error did you get when using OCR?
OCR is image-based, so it is important to make sure that the capture images in OCR actions and the images in the documents look the same. It is also possible to set a lower image recognition threshold in RPA Recorder settings.

Hi Alesia,
I have just upgraded to Version 2.2. I deleted the previous version of Express and then downloaded the new version. Express works fine but i appear to have lost my workflows in Control Tower. The Control Tower has reverted to the sample Workflows under the name John Doe.
Will this always happen when you upgrade with one bot of Express/
Regards,
David

Hi David,

Yes, it will happen if you uninstall the current version and install the new one.

If you just update to a new version, all workflows in Control Tower will be saved.

Hi Alesia,
So if you install on a new PC you lose the Workflow?
Regards,
David

Yes, in this case you need to create a backup of your business processes before uninstalling.

You can read how to do it in this KB article
https://kb.workfusion.com/display/RPAe/How+to+Run+a+Business+Process#HowtoRunaBusinessProcess-Businessprocessesbackup

You then will be able to import these business processes in the new Control Tower.

A post was split to a new topic: Issue with OCR step