I'm trying to fill an online Form, from CSV file. My macro is pretty much functional I'm only stuck at 2 things. I have gone through wiki and google search and tried various things such as using wild cards, record macro in different modes but nothing solved the problem.
Code: Select all
Computer info: Windows 10 (64-bit), Google Chrome Version 62.0.3202.94, Installed this http://wiki.imacros.net/iMacros_for_Chrome#Add_File_Access
Code: Select all
VERSION BUILD=844 RECORDER=CR
SET !DATASOURCE input.csv
SET !LOOP 2
SET !DATASOURCE_LINE {{!LOOP}}
URL GOTO=http://editProduct.php?sid=10257
TAG POS=1 TYPE=INPUT:TEXT ATTR=NAME:skuVarAmazon[] CONTENT={{!COL1}}
TAG POS=1 TYPE=INPUT:TEXT ATTR=NAME:eanVarAmazon[] CONTENT={{!COL2}}
TAG POS=1 TYPE=INPUT:TEXT ATTR=NAME:colorAmazon[] CONTENT={{!COL3}}
TAG POS=2 TYPE=INPUT:TEXT ATTR=NAME:skuVarAmazon[] CONTENT={{!COL1}}
TAG POS=2 TYPE=INPUT:TEXT ATTR=NAME:eanVarAmazon[] CONTENT={{!COL2}}
TAG POS=2 TYPE=INPUT:TEXT ATTR=NAME:colorAmazon[] CONTENT={{!COL3}}
1- Macro get data from CSV file and fill the web page Form. All rows on online Form should fill one by one then macro should stop working after filling all the rows and columns.
2- The online Form URL is same except the end of URL such as: 15421 This part is different for other similar pages. For example: product Apple URL is http://editProduct.php?sid=10257 and product Banana URL is http://editProduct.php?sid=65103
What I am getting after running my macro?
1- My macro does not insert data in all rows. Macro is only inserting CSV first row data into all rows of online Form. I have tried Play and Play (Loop), also tried wild card but nothing worked. To me it seems that every ATTR is same for each row on web page may be that's why data is not being inserted in all rows?
2- I don't want to change the URL again and again. Tried wild card such as http://editProduct.php?sid=* but not working. Is there any way that my macro work for all URL's which are same except the end part of URL.
Does anyone know how to solve these?
Thanks in advance.