2 iMacros scripts I need to convert. help please

mitchit · April 12, 2025, 6:05pm

You will see some doubles in the first script because imacros was a little glitchie.

VERSION BUILD=8940826 RECORDER=FX
TAB T=1
SET !DATASOURCE "O:\Shared\filer\datasources\late.csv"
SET !Loop 1
SET !Datasource_line {{!LOOP}} 
URL GOTO=https://domain.com/custbill.php?acct={{!COL1}}&cpage=CC
TAG POS=1 TYPE=INPUT:SUBMIT FORM=ACTION:custinvadd.php ATTR=NAME:submit
TAG POS=1 TYPE=INPUT:SUBMIT FORM=ACTION:custinvadd.php ATTR=NAME:submit
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:theform ATTR=NAME:invdesc CONTENT=Late<SP>Payment<SP>Fee.
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:theform ATTR=NAME:invamnt CONTENT=10
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:theform ATTR=NAME:invdate CONTENT=03/01/2025
TAG POS=1 TYPE=SELECT FORM=NAME:theform ATTR=NAME:ptype CONTENT=%fee
TAG POS=1 TYPE=INPUT:SUBMIT FORM=NAME:theform ATTR=NAME:DONE
TAG POS=1 TYPE=INPUT:SUBMIT FORM=ACTION:../php/billing.php ATTR=NAME:C

VERSION BUILD=9030808 RECORDER=FX
TAB T=1
SET !DATASOURCE "O:\Shared\filer\datasources\StillNeedtoPay.csv"
SET !Loop 1
SET !Datasource_line {{!LOOP}}
URL GOTO=https://domain.com/custstate.php?acct={{!COL1}}&cpage=CC
TAG POS=1 TYPE=A ATTR=TXT:Email<SP>Statement
TAG POS=1 TYPE=INPUT:SUBMIT FORM=ACTION:custstate.php ATTR=NAME:submit
TAG POS=1 TYPE=INPUT:SUBMIT FORM=ACTION:../php/statement.php ATTR=NAME:C

Plankton · April 14, 2025, 7:29am

Welcome former iMacros user … many of us switched to the open-source Ui.Vision iMacros successor lately

As for your two macros, they are easy to convert. But as these are private websites, I can not do it for you. But here are some hints:

You read from a CSV file. In Ui.Vision you can use the csvRead command for this. Have a look at the DemoReadCSVwithWhile macro to get started. You can reuse this macro without any changes (just the path to the csv file). Then replace the part RUN | Sub/Sub_DemoCsvRead_FillForm with a call to a macro that fills in your form.

For the form-filling part, it is probably the fastest solution if you re-record this part. Instead of {{!COL1}} (imacros syntax) use ${!COL1} in Ui.Vision.