Network Automation Software We are currently migrating this forum
over to our HelpSystems domain. Please
post all new threads in our new
HelpSystems Community Portal.
Post to the HelpSystems Forum
You are not currently logged on. You must be logged on in order to post. Log on
Or Create a new account
AutoMate Discussion
Decrease font size
Increase font size
Topic Title: Newbie
Topic Summary: How to cut and paste from excel to a website
Created On: 03/29/2006 02:28 PM
Status: Read Only
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
View similar topics View similar topics
View topic in raw text format. Print this topic.
 03/29/2006 02:28 PM
User is offline View Users Profile Print this message

Author Icon
DennisLucas
Journeyman (50-99)

Posts: 66
Joined: 03/29/2006

I have the dubious task of creating accounts at a 3rd party website.  

I have an excell spread sheet that has users 1st and last name, login id, password, position and email address.
I need to figure out a way to accomplsih the following:

1. cut and paste each corresponding cell to its corresponding place on the website.
so.  fist name gets pasted to the first name box etc....etc...
2. once all the info is imputed > I have to acknowledge the account by pressing okay and then go back in change the password so its automatically mailed to them.
2.  I have over 1000 ids to create and dont know where to start.  Any help would be greatly appreicated.
 03/29/2006 02:34 PM
User is offline View Users Profile Print this message

Author Icon
DennisLucas
Journeyman (50-99)

Posts: 66
Joined: 03/29/2006

B777CVA password 1st Name last name Collections email address

This is an example of the data the needs to be manipulated.

Edited: 03/29/2006 at 02:35 PM by DennisLucas
 03/29/2006 02:37 PM
User is offline View Users Profile Print this message

Author Icon
DennisLucas
Journeyman (50-99)

Posts: 66
Joined: 03/29/2006




This is where the data needs to be entered.
 03/30/2006 07:14 AM
User is offline View Users Profile Print this message

Author Icon
Bart van Lagen
Supreme Guru (1000+)

Posts: 1400
Joined: 04/25/2005

In the Task-Builder you could start with:

Excel -> Open Workbook
Excel -> Activate Worksheet
Excel -> Cells to dataset
Excel -> Close Workbook

Next is:

Internet -> Open Web Page

Next is:

Loop -> Loop dataset

While looping the dataset use:

Interactivity -> Move Mouse to Object
Interactivity -> Set Text
Interactivity -> Send Keystrokes
etc


The best way to learn Automate is: start scripting and see how far you can get. If you get stuck: as here.

-------------------------
Bart van Lagen
ICT Department.
St Jansdal Hospital
Harderwijk, Netherlands
Automate 7.1.1.0 / BPA 7.1.1.0
Windows 2003SP2SRV


Edited: 03/30/2006 at 07:17 AM by Bart van Lagen
Statistics
18258 users are registered to the AutoMate Discussion forum.
There are currently 0 users logged in.
The most users ever online was 5551 on 01/08/2018 at 11:11 AM.
There are currently 1306 guests browsing this forum, which makes a total of 1306 users using this forum.

FuseTalk Enterprise Edition v4.0 - © 1999-2020 FuseTalk Inc. All rights reserved.

Sitemap Network Automation Software Blog