Help introducing data from Excel

[DrEinyel]

I made a bot to fill forms automaticaly for a website.

The problem is that currently I have to add the Data manually before running the script.

I wish I could just take the dat from my Excel

[Fox]

@dreinyel said in Help introducing data from Excel:

I made a bot to fill forms automaticaly for a website.

The problem is that currently I have to add the Data manually before running the script.

I wish I could just take the dat from my Excel

Use node js modules.

[DrEinyel]

@fox I don't get this. I feel is super deep and hard for me and it's the only one I need to make this bot perfect :CCCCCCCC

[Allister]

@dreinyel said in Help introducing data from Excel:

@fox I don't get this. I feel is super deep and hard for me and it's the only one I need to make this bot perfect :CCCCCCCC

@DrEinyel, You can also convert the output file in Excel to .csv file type and use the resources as "Lines From File" instead of doing it manually.

How To Convert To CSV: https://www.ablebits.com/office-addins-blog/2014/04/24/convert-excel-csv/

[dnffl0019]

@Fox @Allister , i have a similar issue, and i have a CSV file as well.

This is my CSV file template:

i made my resource as LinesFromFile:

but i don't see how to add these variables. i need to type each line into a form like this:

i saw here in the community that the admin mentioned i can use Parse Lines.. but i don't how to do do that..

Do i go to Type Text > then try to add the variables?..

or do this:

Maybe my issue is similar to DrEinyel as he has to type similar values..

Thank you so much!

[Allister]

@dnffl0019 said in Help introducing data from Excel:

i have a similar issue, and i have a CSV file as well.
i saw here in the community that the admin mentioned i can use Parse Lines.. but i don't how to do do that..
Do i go to Type Text > then try to add the variables?..
Maybe my issue is similar to DrEinyel as he has to type similar values..

@dnffl0019, You will use Parse Line and use selection "From File, User Input, Database" which then select the LineFromFile User Input (resource). If you don't want that line to be used again, uncheck the Reuse-Checkbox.

From there, you will input the variables you would like. If any data in the CSV is 'Missing' you did not add the total number of Variables in the list. Here's a simple example with only 3 data columns of FIRSTNAME, LASTNAME, ADDRESS like in your picture. :)

0_1555296591124_LineFromFile.xml

[dnffl0019]

Awesome thanks a lot! will try it!