I would like to fill out a form every 10 minutes if a csv exists and use the csv file as the data file for the form fields.
1 Like
Microsoft Excel has a programming language called, VBA (Visual Basic for Application), that you can use to code/create a program to do what you just outlined. It even has a recorder feature that you can use to assist you in writing Visual Basic code. You can have your form fields made in MS Word and VBA works there too–you can open a Word document via code, and copy and paste between your sheet and form. Afterwards, you can have code for Word to save the document maybe with a timestamp. As well, maybe you could even look into getting Windows system to activate your spreadsheet macro every ten minutes. So, with VBA, you can get your information from your “csv”, move it (copy and paste) to your Word form and set up either a Windows timer or keep your spreadsheet on a timed loop.
Just a note that the spreadsheet code would be a macro and could have security issues on a work network.
If you want to use Katalon Studio, it has a recorder feature also.
hi @mannyferro
you can schedule the execution on the testops or using KRE if you want to execute it locally
- testops
1 Like
Kindly share more details on your use case.
Am I right in thinking this is more to do with RPA than automation? Ie you monitor a directory, wait for a file, then process it? If so, Katalon is probably not the right tool. You are missing tonnes of detail though