Jump to content
Sign in to follow this  
andrewtclarkson

New to this, wondering if this is possible?

Recommended Posts

andrewtclarkson

There are several processes I complete at work that require a repetition of tasks up to 60 times.

Once I've logged in to the site I repeat the following:

Click link (Worker's name) if work has been invoiced

Click another link on new page ("Print") website downloads a timesheet to PDF

Click downloaded PDF to open it

Print (sent to printer) 2 copies

Save to network drive Workers>company>Timesheets as "Worker Name -Date Range of Timesheet"

Close PDF

Go back to list of worker's names

Repeat with next worker, until entire list has been printed.

I also do this with their invoices, minus saving them.

Is this possible with AutoIt, or do I need to look into different software?

Thanks!

Share this post


Link to post
Share on other sites
water

The IE UDF (User Defined Functions for Microsoft Internet Explorer) is a good place to start.

It's not an easy beginners task. Give it a try and if you get stuck, ask :)


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-01-27 - Version 1.3.3.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites
andrewtclarkson

Good to hear.

Where would I find the User Defined Functions for Microsoft Internet Explorer? I've got some info up in the help file, can you point me to a tutorial perhaps?

Thanks!

Share this post


Link to post
Share on other sites
andrewtclarkson

Small update: Have figured out how to open a new IE window, punch in a name and password.

baby steps!

Now I am working on making it go to the timesheet page.

I think it's doable... will post progress and I'm sure have piles of questions.

Share this post


Link to post
Share on other sites
andrewtclarkson

Questions:

What do I define the $o_object variable as? It's in all of the IE Functions I've seen.

How would use Linkclickbyreference? I assume it clicks a spot on the screen based on coordinates?

How do I use _IEAction to click a Java link?

what does ByRef do/mean?

Thanks!

Edited by andrewtclarkson

Share this post


Link to post
Share on other sites
water

$o_object is a parameter. It's always described below the format of the function call in the help file.

The IE UDF doesn't use screen coordinates, it uses the COM interface.

ByRef means that the parameter isn't passed as value to the function (thus doubling the needed memory) but as a refrence to the storage location where the parameter is stored in the calling function (or main script).

If you can post the html code you like to process we can tell you what to do. We need information about the format (forms, buttons etc.) to help you.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-01-27 - Version 1.3.3.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites
andrewtclarkson

Ok... can you explain that in terms someone brand new to this would understand?

$o_object - what should it be described as and how?

What is the COM interface?

Do I need byRef? Why or why not?

I'm a little wary of posting the code for the site as it's for work, and a lot of sensitive info.

I'll see what I can do.

Share this post


Link to post
Share on other sites
water

$o_object is the name of a parameter. Which information you have to pass as a parameter depends on the function you use and is described there.

COM is a way to interact with the IE. Best described here.

You very seldom need ByRef. It's in the docu to tell you that you have to pass a variable. Constants don't work with ByRef.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-01-27 - Version 1.3.3.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×