1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Imacro Input Data From Text , Excel or CSV File

Discussion in 'Other Scripting Languages' started by Dexter6996, Feb 21, 2016.

  1. Dexter6996

    Dexter6996 Newbie

    Joined:
    Oct 13, 2015
    Messages:
    43
    Likes Received:
    1
    HlW Talent People ,

    I need to submit 1000's of People's name & Email Address in a Website .I want to AUTOMATE the task using IMACROS ...

    I have the name & email list ...

    How can i do it using IMACROS ????

    pls help
     
  2. E=MC²

    E=MC² Junior Member

    Joined:
    Apr 12, 2013
    Messages:
    174
    Likes Received:
    182
    SET !DATASOURCE __FILENAME__ // Replace with the filename, include the file path or put it in the datasources folder
    SET !DATASOURCE_COLUMNS __NUMBER_OF_COLUMNS__ // Replace with number of columns in the file
    SET !DATASOURCE_LINE __LINE_NUMBER__ // Replace preferably with your loop variable

    And in the following lines of script, you can access the fields in the each line
    using {{!col1}}, {{!col2}}, ... {{!col__NUMBER_OF_COLUMNS__}}

    Example:
    SET !DATASOURCE myFile.csv
    SET !DATASOURCE_COLUMNS 9
    SET !DATASOURCE_LINE {{loopVar}}
    PROXY ADDRESS={{!col8}}:{{!col9}}
     
    • Thanks Thanks x 2