WinAutomation Logo

Welcome!

Welcome to the WinAutomation forum.

This is where we can learn from each other on how we can

best utilize WinAutomation for all your automation needs.

Got a challenging automation scenario?

Have some automation results (e.g. time saved, how much productivity gained)?

Or a query on any particular job?

Basically anything goes. Post them here and discuss away...

Jag

 Hey guys,

Not sure where this post is suppose to go but have a query on the
Display Select From List Dialogue Box

e.g.

Question : "Which Internet Browser Do You Prefer?"
List Options 

: Safari
: FireFox
: Internet Explorer

[If] %????% = ???? Then

[GoTo](Label) [Safari]

Which would then run each different application...

Can anyone elaborate on the ????'s please?

Any advice or assistance would be greatly appreciated!
Thanks a bunch,

- aj


P.S.

Here's an example zip of what Im trying to do.
Pretty simple, but the "IF" commands screw me over :(

Yo! Can you please check the revised version of your job that I attached? I skipped the use of "Go To" and "Label" actions since they are not used. If you want an example with labels let me know and I'll try to create one for you.

Notice that I've used the %SelectedItem% variable to determine which browser was selected. Let me know if anything in the job troubles you.

 Ahhhh.... Codex, you're a legend!

I understand "IF" statements now... Thank you so much!

Just wondering if you also have sample code for :

1) chmod'ing a file on a server to 777?
2) connecting via ftp & creating a MySQL Database?

I understand how to connect to the webserver using the FTP connection
as well as changing directories, then invoking the FTP commands,

But the chmod'ing ftp commands have me stumped.

Any advice or assistance would be so greatly appreciated!
Thank you again Codex,

So glad to have you guys here!

- aj

p.s.

I really enjoy trying to create apps using WA and it's easier
for me to learn viewing sample code from experts such as yourself, so i can do it myself.

That way I learn once, not have to bother you guys much, then help others
here in the forum, like you've helped me.

Really appreciate your help 

 

AJ, I've also replied you with the attachment on the Warrior Forum.

Glad to see that you are making it work for your tasks!

Keep at it!

Jag

Attached you can find a sample file that changes the permissions of a file to 777. If the permissions are not changed successfully, the "Invoke FTP Command" action will return an error.

However, I'm not exactly sure what do you mean by: "creating a MySQL" database. You can't actually create a mysql database through FTP. In order to do that you will either have to connect through a command line tool to the server (e.g. putty) or use web interface (e.g. phpmyadmin).

 Opps, sorry codex, i thought creating a mySql database
was possible through WA... maybe a possible future add on feature? :)

Thank you so much for the example Change FTP Permissions job...
I've nearly completed my first WinAuto APP!

So kool...

Thanks again for your awesome support guys,..
You rock!

- aj

 

[quote]Thank you so much for the example Change FTP Permissions job...[/quote]

No problem m8! :)

[quote]I've nearly completed my first WinAuto APP![/quote]

I remember that feeling! Doesn't it feel really good when you know that a task that required 2 hours of your time per week will be done automatically from now on? :p I still get it when I find a new task that can be automated...

[quote]Opps, sorry codex, i thought creating a mySql database was possible through WA... maybe a possible future add on feature? [/quote]

I know that it is possible to Execute a SQL query with WinAutomation in a local database (there is a dedicated action for it I think). But when it comes to creating a MySQL database in a remote server there are a lot of problems that need to be issued in order for the WinAutomation guyz to create such an action. Let me explain:

1) First of all, I'm gonna assume that we are talking about a Linux server that is hosting our website. The reason for that is that I have only worked with Linux servers and I don't really know what command line tools do Windows servers provide. Also, MySQL usually goes with the LAMP package (Linux, Apache, MySQL, PHP) so let's stick to this assumption for now.

2) There are 2 different cases that we need to examine:
a) Your website is built on a limited hosting plan from a company (e.g. GoDaddy)
b) Your website is built on a dedicated server that you have unlimited access to (e.g. on an Amazon AMI)

In order to create a MySQL database you need connect to your server through SSH (usually), enter MySQL's command line interface and send a CREATE DATABASE command.

In the (a) case, a "Create MySQL Database" action will not work most of the times. The majority of the hosting companies will only allow you to create your databases through their web interface and they usually don't give an API for that.

In the (b) case, an action could probably be made, but it can also be automated by running a specific set of commands through a predefined putty session.

Notice, that in every case, your task can be automated visually, either through the Web Interface or through the command line interface by sending the appropriate keystrokes and waiting for the corresponding repllies to appear.

Hi all...  Just stopping by to say hello and kudos to everyone who has been involved in the development and a part of the community here at winautomation... I've followed some of the topics in the forum for a while and have a trial of the software for now, but have already made some cool jobs with it by learning from your examples and sample jobs, tutorials, etc.  I've bought and tried many different web automation softwares in the past and although I'm no expert or anything, this has been the most that I've been able to do as far as automation of windows, and some marketing web tasks that have been huge time savers.  Most of the software that I've used in the past had such a long learning curve involved that most of my time was spent going thru the manuals, and trying to take endless notes in attempting to gain any ground, not to mention continually trying to remember the syntax and programming languages, etc. which has been a good learning experience as much of it applies to other automation tools and concepts, but wow what a difference with winautomation as you can pretty much take right off with it out of the gate.  I'll definately be adding this to my core arsenal of automation softwares soon.  Thanks again, and Keep up the good work with this awesome tool.)

 

Best,

 

~Dave

Nice knowledgeable forum ... Thanks u guys ...

Hi there,

Brand new.  Purchased the pro edition.  Just looking for a quick hand on what the best threads are to read?  About to start the video tutorials.

 

Looking forward to contributing!

Hi fad3r! 
 

Welcome to our Forum!! 

 

What type of tasks are you looking to automate with WinAutomation? Depending on the task, you'll find a bunch of interesting links  you should look into! 
 

Feel free to open a new thread for any inquiry you have, we'll gladly guide you through!

 

Samantha

Thanks Samantha. I have heard you are working with my friend Frank from Chicago.  Let me know if he gets out of line!  I am looking to automate seo tools right now.  Specifically SEnuke and such

This is true! Frank did make use of our Professional Services and we did work together on his project (hope we're talking about the same Frank!)

 

Quite a few users have been using WinAutomation for random SEO tasks, however, as this industry is rather competitive, there are not a lot of sample scripts available but you can still browse for ideas.

 

FYI SEnuke's automation is discussed in the following threads:

 

http://www.winautomation.com/forum/wait-window

http://www.winautomation.com/forum/automating-senuke-runs

 

Samantha