Search found 343 matches

by mightycpa
Sat Apr 10, 2021 6:21 pm
Forum: Technical / Scripting
Topic: Python and PIP
Replies: 5
Views: 3062

Re: Python and PIP

bump
by mightycpa
Sat Apr 10, 2021 6:20 pm
Forum: Technical / Scripting
Topic: Solving a puzzle
Replies: 23
Views: 16357

Re: Solving a puzzle

bump
by mightycpa
Wed Apr 07, 2021 1:32 am
Forum: Technical / Scripting
Topic: database insert
Replies: 4
Views: 2506

Re: database insert

From the docs, slightly modified:

Code: Select all

Let>str=Driver={MySQL ODBC 3.51 Driver};Server=someserver.com;Port=3306;Database=example;User=admin;Password=xxxx;Option=3;
DBConnect>str,dbH
 
Let>SQL=insert into mytable (serial, name, rating) values ('12345', 'mightycpa', 10)
DBExec>dbH,SQL,result
 
DBClose>dbH
by mightycpa
Mon Apr 05, 2021 10:23 pm
Forum: Technical / Scripting
Topic: Python and PIP
Replies: 5
Views: 3062

Python and PIP

Hi, I don't know a thing about python, but I'm being sorta forced to use it. I've downloaded the 3.7 file and extracted it into the MacroScheduler folder. Easy enough. What I'm doing requires a particular library, which in turn requires certain packages. The instructions to install the library is a ...
by mightycpa
Mon Apr 05, 2021 7:27 pm
Forum: Technical / Scripting
Topic: Solving a puzzle
Replies: 23
Views: 16357

Solving a puzzle

Any thoughts on how to automate moving the slider to the right spot?

Image

FYI, the puzzle piece does not always appear at the same vertical position. Sometimes it's higher, sometimes lower.
by mightycpa
Sat Apr 03, 2021 12:43 am
Forum: Technical / Scripting
Topic: MS Access VB Error 2220
Replies: 3
Views: 2128

Re: MS Access VB Error 2220

Also, what about making sure the file exists using VB before you open the db and before you get the file? That way, you can narrow it down to path or permissions. You ought to assume your assumption that it obviously knows the path and display everything that you can. You may also wish to run the do...
by mightycpa
Sat Apr 03, 2021 12:12 am
Forum: Technical / Scripting
Topic: MS Access VB Error 2220
Replies: 3
Views: 2128

Re: MS Access VB Error 2220

To run as admin, set RP_ADMIN to 1.
I've never run into that, but have you tried RunProgram using that setting?
by mightycpa
Wed Mar 24, 2021 5:44 pm
Forum: Technical / Scripting
Topic: vbs silent
Replies: 9
Views: 7318

Re: vbs silent

Hi PH. Did you ever find out how to kill that message? I was reading, it seems like it is built-in to Windows, and not just scripting.

I wonder if increasing the timeout might help you:

In the search portion of the windows Start bar, type wscript and set it from there. Does that do anything?
by mightycpa
Tue Mar 23, 2021 11:58 pm
Forum: Technical / Scripting
Topic: ListBox dialog control
Replies: 12
Views: 4591

Re: ListBox dialog control

Dorian, I think I understand, but I had to drink to do it. DM has a form. 3 fields; Sex: 2 possible mutually exclusive choices, Homme and Femme. One or the other, not both. Age: 10(?) possible choices, choose as many as you wish Smoking Status: 3 possible choices (e.g. Low, Medium, High), choose as ...
by mightycpa
Tue Mar 23, 2021 6:47 pm
Forum: Technical / Scripting
Topic: Trying to execute onClick
Replies: 7
Views: 3477

Re: Trying to execute onClick

The docs are a little vague, but they do say this: Finds matching elements and returns an array of element IDs. Requires a session_id created by ChromeStart. strategy can be one of: id name class name css selector link text partial link text tag name xpath value takes the value of the item you are s...
by mightycpa
Tue Mar 23, 2021 4:16 pm
Forum: Technical / Scripting
Topic: Trying to execute onClick
Replies: 7
Views: 3477

Re: Trying to execute onClick

I don't know much about it, but what is the value of elements_1?

It seems to me that a class could represent many objects, whereas a name (like in the docs) will only represent one thing. Maybe you can't click an entire class, even if it is only used once.
by mightycpa
Mon Mar 22, 2021 4:05 pm
Forum: Technical / Scripting
Topic: Favorite browser for Web automation
Replies: 3
Views: 2027

Re: Favorite browser for Web automation

I've actually had some very recent success with Firefox. At first, it didn't seem to be the best choice, but I was having trouble with Edge, even just manually, and the Chrome functions weren't working for me either. So I was kind of forced into using Firefox, and it turned out pretty good. So far, ...
by mightycpa
Fri Mar 19, 2021 9:29 pm
Forum: Technical / Scripting
Topic: Launching a script - SOLVED!
Replies: 16
Views: 8931

Re: Launching a script - SOLVED!

After a little more thorough testing: template.scp //put the files wherever you want //Include> your code between these two lines, just be sure to exit to "MyExit" //Include> your code between these two lines Label>MyExit Include>%SCRIPT_DIR%\load_prog_ini.scp GoSub>NEXT_ONE Let>RP_WAIT=0 //scripts ...
by mightycpa
Fri Mar 19, 2021 6:27 pm
Forum: Technical / Scripting
Topic: passing parameters and compiling
Replies: 9
Views: 5236

Re: passing parameters and compiling

I'm still having one final difficulty - passing parameters when using a RunProgram> command

I've done it two ways:

1) RunProgram>"v_test /v_debug=COMPILED" - RESULT IS FILE NOT FOUND

2) RunProgram>"v_test" /v_debug=COMPILED - RESULT IS PARAMETER IGNORED
by mightycpa
Fri Mar 19, 2021 3:47 pm
Forum: Technical / Scripting
Topic: passing parameters and compiling
Replies: 9
Views: 5236

Re: passing parameters and compiling

Bob, your avatar looks a lot more like one of those old troll dolls from way back when than it does a dinosaur! :lol: In this case, I'm just trying to pass the debug variable along, so security is unimportant to me. If I were interested in securing an ini file, one thing that comes to mind is that I...
Sign up to our newsletter for free automation tips, tricks & discounts