You are viewing all content relevant to "How do I automate?" in Forums

 

Thursday, July 14, 2011 - WinAutomation Online Seminar - Files & Folders Manipulation

WebSeminar - Files & Folders Manipulation - How to turn your repetitive tasks into a child's play!

Thursday, July 14, 2011 7:30 PM - 9:00 PM EET

         

For all topics below, Jobs will be created on the spot, to help each participant get an idea about how they should get around any difficulties they are facing. 

On this Webinar we'll explain the use of several actions, such as:

Regular Expressions Thread

Hi

If I wanted to pull the names and prices of products costing more than $X from an amazon.com search results page, what "text to find" or would I use? Would that be a regex? I see Jag and Thomas using all sorts of complex looking stuff when parsing text....is there a library where I can see what it all means?

Here is the code from the page.

How do I automate this specific task?

If you got a specific workflow you want to get automated with WinAutomation, this is your place. We will be here to help.  And if you can, help others too. Everyone benefits!

Specific text on specific row in txt file

Hi,

I'm a newbie and I hope you guys can help me with this one:

I modify text in a txt file. The file is saved as 'somename.txt'. The file contains a number of headlines with text below. One headline with text below could look like this (including the --- part):

---
(008) 2b HEADLINE TEXT
---
This is the first paragraph of text below the headline above.

This is the second paragraph of text below the headline above.

This is the third paragraph of text below the headline above.

Replace all files in directory with 1 file...

 I hope I can explain what I want done well enough for everyone to understand.

So here goes...

 

Let's say I have file "A.dds", and a directory with many different files with different file names, but all the same .dds format. I want to replace each and every file in that directory with "A.dds", while keeping the same file names as they originally had.

 In the end, every file in that directory should be the exact same file as A.dds but all keep the same file names as before.

 

DOS Netsh command

I am trying to get this to run in a DOS window...

 

sendkeys:

netsh http add urlacl url=http://+:8000/AcuoTagMapper/service user=%ComputerName%\AcuoServiceUser{Enter}

 

But no matter what I try I cannot get the text "\AcuoServiceUser"  to show up after the computer name. Is there an escape sequence or something I need?

 

building a string with %ComputerName%\\AcuoserverServiceUser works but not with just a single \

 

Thanks!

A crazy idea...

Hiya Samantha -

This is a crazy idea...

Can we make our own tables in an established .waj file and reference them via another program? How about the same program (an exe accessing its .waj)? I don't know if SQLite does table locking or not (hope not). I'm curious about that - that would open a world of possibilities if we could do that.

My fear is that every save of a .waj file overwrites what is already in there and thus destroying any tables we might make on our own for our own purposes.

Thoughts/comments? Thank you!

Querying multiple Access DB's

I was wondering if there is a way to replace the connection string reference database name.  Example:

 

Current Ref: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=R:\001.mdb;Persist Security Info=False

 

2nd Ref: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=R:\002.mdb;Persist

Security Info=False

 

Next Line: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=R:\003.mdb;Persist Security Info=False

 

 

Help automating this

I have three excel files attached, but if it’s better to start on one file by using (sheet 1 & sheet 2) it make no difference for me as long as the desired out come is achieved.

 

Some issues making a job to submit articles to webpage

I want to submit several articles at a time to an article submission service.

 

Currently it is too slow when winauto writes out the text as if it were a human (via send keys)- when these are 300-500 word articles at a time. Can I get it to just paste the whle block somehow? One method I just rememebred is open the text file and record mouse clicks to copy and paste. This is proving rather irritating and messy with all the mouse clicks; is there a cleaner way to do it than this?