With my automation i need a long text to be posted in hundred of websites, kind of wordpress.
Using a csv i have to paste the long text in every single line so that makes a hundred copies of the long text.
And csv filesize becames too big
Any way to get the text from another file like a txt? Each loop same text
So i can put Usernames only in the csv
If it’s the same text why don’t you just put in in a variable?
8 different texts, and changes every day.
When it is in codes, very hard to change
Any other possibilities?
I do not find this limitation, what is big your text file ?
You can split text in more columns of csv and paste it one after one and submit in the form.
Otherwise open text file, select the text (with keyboard emulation), save it in clipboard and paste it, with ui vision you can do this.
But there are more solution to do this.
Hello. Let me try to be more clear.
I am automating blog posts. Around a hundred blogs.
I am posting 8 long articles each day.
So my csv file is; ( last time it was 16mb )
line1 -> blog1. com : username : password : some settings : article1 : article2 : article3 : article4 : article 5 : article 6 : article7 : article8 (sometimes 10 articles)
line2 -> blog2. com : username : password : some settings : article1 : article2 : article3 : article4 : article 5 : article 6 : article7 : article8 (sometimes 10 articles)
line3 -> blog3. com : username : password : some settings : article1 : article2 : article3 : article4 : article 5 : article 6 : article7 : article8 (sometimes 10 articles)
so there are around 100 lines, sometimes 150, sometimes 75 etc.
And for each article ; there is 100s of them.
100 copies of article1
100 copies of article2 …
Is there any way to save articles without copies?
Can i do something like this
FIRST IDEA OF MINE
details.csv : 100 lines, each line only has blog address and login details
articles.csv : 1 line, each column has 1 acticle, plus some details ( keywords titles etc ) to in total around 20 rows
So there wont be 100s of copies of articles
macro1 : starts, logins, ends, sends to macro2 (100lines.csv )
macro2 : starts, adds articles, ends, sends back to macro1 (1line.csv )
macro1: logins to NEXT blog(next line), sends to macro2
macro2 : same stuff as before
macro1 : logins to NEXT blog…
so macro1 always goes to next line, in a loop,
but macro2 does the same all the time
so there won’t be any copies
it’s safer ( no browser crash )
its quicker ( 16mb csv load takes around 30 seconds, and each loop it loads again )
IF I ADD ARTICLES ON CODE
it is not easy to change them every day.
But in CSV , it is easier to change titles, keywords, articles
Ui vision with desktop automation can automate desktop, you can open text file, select text inside file (with key and mouse emulation) and copy it in clipboard, after you can paste in websites form.
There are more solution to automate your work but require time to create a custom macro.
I already automate a form with 200 lines of text.
Thanks. I tried so hard, installed softwares needed for desktop automation, but somehow i am stuck inside browser, i couldnt make it desktop
Any way to use different .cvs files in one macro?
first csv will go to next line each loop ( like always )
other csv file will be on 1st line for each loop
is that possible?
You can use unlimited csv in same macro.
Before use a csv you must open it with csvread command after you can paste the content of COL
OK I’ll try.
But heres the thing i cant figure out in my mind.
While one csv will read next line each loop, the other csv needs to be alwasy same line.
How do i achieve this?
Loop can control by macro, you have control of loop and inside you can execute your command.
I can not create for you a custom macro, i’m busy of work.
In my opinion your is a simple work, need only a best macro code.