Post by Steve on Feb 7, 2021 7:24:17 GMT
What has been added to the update?
New Features:
1. New Action - SEND EMAIL
SEND EMAIL sends an email to one or many recipients.
More info at www.turnssoft.com/conditions.html#sendemail
* | ***
* | SETUP
* | ***
* | - Setup email configuration details manually
1 | RUN ACTION | SEND EMAIL | SETUP::smtp.gmail.com::587::SSL::username@gmail.com::SecretPassword
* | - Setup email configuration from a file
2 | RUN ACTION | SEND EMAIL | SETUP:D:\macro\File\email_setup.mmmacro
* | - Setup email with a prompt to enter the configuration details
3 | RUN ACTION | SEND EMAIL | SETUP::PROMPT
* | ***
* | SEND
* | ***
* | - Send email with all options entered
4 | RUN ACTION | SEND EMAIL | SEND::TO=recipicant@gmail.com;steve@turnssoft.com::FROM=username@gmail.com::SUBJECT=MMM at %time%::HTML=False::BODY=Line 1: %date%'\n'Line 2
* | - Send email with the options from a file
5 | RUN ACTION | SEND EMAIL | D:\macro\File\email_send.mmmacro
* | - Send email with the configuration and options from a file
6 | RUN ACTION | SEND EMAIL | D:\macro\File\emailsendfull_full.mmmacro
2. New Action - MYSQL
MYSQL can connect to remote MYSQL databases and send mysql structured statements
More info at www.turnssoft.com/conditions.html#mysql
* | ***
* | SETUP
* | ***
* | - Setup MYSQL connection manually
1 | RUN ACTION | MYSQL | CONNECT::mariadb.local::mydatabase::remoteuser::SecretPassword
* | - Setup MYSQL connection from a file
2 | RUN ACTION | MYSQL | CONNECT::\Macro\File\mysql_setup.mmmacro
* | - Setup MYSQL connection with a prompt to enter the connection details
3 | RUN ACTION | MYSQL | CONNECT::PROMPT
* | ***
* | QUERY
* | ***
* | - Query the database and return the results to the internal %MYSQL_RESULT% variable
2 | RUN ACTION | MYSQL | QUERY::SELECT * FROM customers where id > 30;
* | - Display the results in a message box
3 | RUN ACTION | MESSAGE PROMPT | %mysql_result%::mysql result::2
* | ***
* | STATEMENT
* | ***
* | - Send and execute MYSQL statements
4 | RUN ACTION | MYSQL | SQL::show databases;
5 | RUN ACTION | MYSQL | SQL::INSERT into CUSTOMERS (id, order_date, order_name, order_email) values ( null, '2021-03-20', 'Johnathan Thurston', 'JT@cowboys.com' );
6 | RUN ACTION | MYSQL | SQL::DELETE FROM customers where id > 50;
SEND EMAIL sends an email to one or many recipients.
More info at www.turnssoft.com/conditions.html#sendemail
* | ***
* | SETUP
* | ***
* | - Setup email configuration details manually
1 | RUN ACTION | SEND EMAIL | SETUP::smtp.gmail.com::587::SSL::username@gmail.com::SecretPassword
* | - Setup email configuration from a file
2 | RUN ACTION | SEND EMAIL | SETUP:D:\macro\File\email_setup.mmmacro
* | - Setup email with a prompt to enter the configuration details
3 | RUN ACTION | SEND EMAIL | SETUP::PROMPT
* | ***
* | SEND
* | ***
* | - Send email with all options entered
4 | RUN ACTION | SEND EMAIL | SEND::TO=recipicant@gmail.com;steve@turnssoft.com::FROM=username@gmail.com::SUBJECT=MMM at %time%::HTML=False::BODY=Line 1: %date%'\n'Line 2
* | - Send email with the options from a file
5 | RUN ACTION | SEND EMAIL | D:\macro\File\email_send.mmmacro
* | - Send email with the configuration and options from a file
6 | RUN ACTION | SEND EMAIL | D:\macro\File\emailsendfull_full.mmmacro
2. New Action - MYSQL
MYSQL can connect to remote MYSQL databases and send mysql structured statements
More info at www.turnssoft.com/conditions.html#mysql
* | ***
* | SETUP
* | ***
* | - Setup MYSQL connection manually
1 | RUN ACTION | MYSQL | CONNECT::mariadb.local::mydatabase::remoteuser::SecretPassword
* | - Setup MYSQL connection from a file
2 | RUN ACTION | MYSQL | CONNECT::\Macro\File\mysql_setup.mmmacro
* | - Setup MYSQL connection with a prompt to enter the connection details
3 | RUN ACTION | MYSQL | CONNECT::PROMPT
* | ***
* | QUERY
* | ***
* | - Query the database and return the results to the internal %MYSQL_RESULT% variable
2 | RUN ACTION | MYSQL | QUERY::SELECT * FROM customers where id > 30;
* | - Display the results in a message box
3 | RUN ACTION | MESSAGE PROMPT | %mysql_result%::mysql result::2
* | ***
* | STATEMENT
* | ***
* | - Send and execute MYSQL statements
4 | RUN ACTION | MYSQL | SQL::show databases;
5 | RUN ACTION | MYSQL | SQL::INSERT into CUSTOMERS (id, order_date, order_name, order_email) values ( null, '2021-03-20', 'Johnathan Thurston', 'JT@cowboys.com' );
6 | RUN ACTION | MYSQL | SQL::DELETE FROM customers where id > 50;
3. DEBUG entry added to statically declare the defined record time
Shout out to hpw and zeak (minimousemacro.proboards.com/thread/334/option-fixed-timing-keyboard-recording)
'SET::STRING TIME VALUE::X' will hard set the record capture time for mouse, clicks, and keyboard presses to X value.
1 | RUN ACTION | DEBUG | SET::STRICT TIME VALUE::250
2 | RUN ACTION | DEBUG | SET::STRICT TIME VALUE MOUSE::50
3 | RUN ACTION | DEBUG | SET::STRICT TIME VALUE CLICKS::100
4 | RUN ACTION | DEBUG | SET::STRICT TIME VALUE KEYS::150
1 | RUN ACTION | DEBUG | SET::STRICT TIME VALUE::250
2 | RUN ACTION | DEBUG | SET::STRICT TIME VALUE MOUSE::50
3 | RUN ACTION | DEBUG | SET::STRICT TIME VALUE CLICKS::100
4 | RUN ACTION | DEBUG | SET::STRICT TIME VALUE KEYS::150
Improvements:
1. Message Prompt Types.
An overhaul to the MESSAGE PROMPT action by adding message box types and designing a new 'Add Condition' interface for adding message prompt actions.
* | New message types
1 | RUN ACTION | MESSAGE PROMPT | A information message::INFO::INFORMATION2 | RUN ACTION | MESSAGE PROMPT | A critical message::CRIT::CRITICAL
3 | RUN ACTION | MESSAGE PROMPT | A exclamation message::EX::EXCLAMATION
4 | RUN ACTION | MESSAGE PROMPT | A question message::?::QUESTION
* | Multi-line messages
5 | RUN ACTION | MESSAGE PROMPT | This is line 1'/n'This is on line 2'/n'This is on line 3
* | A new graphical menu for building the MESSAGE PROMPT
5 | RUN ACTION | MESSAGE PROMPT | This is line 1'/n'This is on line 2'/n'This is on line 3
* | A new graphical menu for building the MESSAGE PROMPT
2. DEFINE INTEGER VARIABLE and DEFINE DECIMAL VARIABLE now accept a static '=' assignment at declaration
Shout out to WWO for the suggestion (minimousemacro.proboards.com/thread/394/define-integer-variable-value-created)
1 | RUN ACTION | DEFINE INTEGER VARIABLE | %INTEGER%::=100
2 | RUN ACTION | DEFINE DECIMAL VARIABLE | %DECIMAL%::=1.1
2 | RUN ACTION | DEFINE DECIMAL VARIABLE | %DECIMAL%::=1.1
3. Minor GUI Improvements
Add Condition page 'ELSE' moved inline with other condition options
Add Condition page 'ELSE' moved inline with other condition options
Fixes:
1. Multiple fixes for BOOLEAN variable logic (MMM_BZ19)
BOOLEAN variables that were not defined now default to FALSE rather than skip during boolean evaluation
BOOLEAN variables declared as YES now evaluate to TRUE
BOOLEAN variables declared as OFF, 0, AND NO now evaluate to FALSE
BOOLEAN variables that were not defined now default to FALSE rather than skip during boolean evaluation
BOOLEAN variables declared as YES now evaluate to TRUE
BOOLEAN variables declared as OFF, 0, AND NO now evaluate to FALSE
2. Fix for decimal math chaining failing to evaluate more than one variable (MMM_BZ18)