This need to log into a website and upload add a invoice number against a PO for 100's on entries a week.
I have created a basic macro that:
1 Open Excel spread sheet
2 Opens the browse
3 Logs in
4 Go to spread sheet
5 Copy cell A1 (PO number)
6 Go to website
7 Search for PO number on website
8 Open PO entry
9 Go to spread sheet
10 Copy cell B1 (Invoice number)
11 Go to website
12 Paste Invoice number to invoice field
13 Save
Repeat 4 to 13 moving down each row 1 at a time.
However:
1. The macro created uses the reference copies i.e. the PO number such as 123243 rather than the function copy. I want the macro to perform the action rather than the reference
2. I am manually creating the function to move down the spread sheet is there a way to automate this?
I am coming from this from a low level tech background
Updating a website for from a Excel file
Forum rules
iMacros EOL - Attention!
The renewal maintenance has officially ended for Progress iMacros effective November 20, 2023 and all versions of iMacros are now considered EOL (End-of-Life). The iMacros products will no longer be supported by Progress (aside from customer license issues), and these forums will also no longer be moderated from the Progress side.
Thank you again for your business and support.
Sincerely,
The Progress Team
Before asking a question or reporting an issue:
1. Please review the list of FAQ's.
2. Use the search box (at the top of each forum page) to see if a similar problem or question has already been addressed.
3. Try searching the iMacros Wiki - it contains the complete iMacros reference as well as plenty of samples and tutorials.
4. We can respond much faster to your posts if you include the following information: CLICK HERE FOR IMPORTANT INFORMATION TO INCLUDE IN YOUR POST
iMacros EOL - Attention!
The renewal maintenance has officially ended for Progress iMacros effective November 20, 2023 and all versions of iMacros are now considered EOL (End-of-Life). The iMacros products will no longer be supported by Progress (aside from customer license issues), and these forums will also no longer be moderated from the Progress side.
Thank you again for your business and support.
Sincerely,
The Progress Team
Before asking a question or reporting an issue:
1. Please review the list of FAQ's.
2. Use the search box (at the top of each forum page) to see if a similar problem or question has already been addressed.
3. Try searching the iMacros Wiki - it contains the complete iMacros reference as well as plenty of samples and tutorials.
4. We can respond much faster to your posts if you include the following information: CLICK HERE FOR IMPORTANT INFORMATION TO INCLUDE IN YOUR POST
Re: Updating a website for from a Excel file
CIM...!ed-prs wrote:This need to log into a website and upload add a invoice number against a PO for 100's on entries a week.
I have created a basic macro that:
1 Open Excel spread sheet
2 Opens the browse
3 Logs in
4 Go to spread sheet
5 Copy cell A1 (PO number)
6 Go to website
7 Search for PO number on website
8 Open PO entry
9 Go to spread sheet
10 Copy cell B1 (Invoice number)
11 Go to website
12 Paste Invoice number to invoice field
13 Save
Repeat 4 to 13 moving down each row 1 at a time.
However:
1. The macro created uses the reference copies i.e. the PO number such as 123243 rather than the function copy. I want the macro to perform the action rather than the reference
2. I am manually creating the function to move down the spread sheet is there a way to automate this?
I am coming from this from a low level tech background
(Always mention your FCI when you open a Thread, read my Sig..., many Commands are not implemented for all Browsers/Versions...)
Not too sure what "PO" means..., "Process/Product Order"...? (Just to know, it won't really matter for your Case...)
I don't really understand what your Pb('s) is/are, especially Qt_1, would be easier if you posted your Script with a clear Reference to which Line(s) Qt_1 is related... I don't understand the "relationship" between "reference + PO number + copy + action"... Give more Details about what "happens" and what exactly you want...
For Qt_2, if I understand correctly your Qt, but difficult without seeing your Script, simply use the '!LOOP' Mechanism for '!DATASOURCE_LINE':
Code: Select all
SET !DATASOURCE_LINE {{!LOOP}}
- (F)CI(M) = (Full) Config Info (Missing): iMacros + Browser + OS (+ all 3 Versions + 'Free'/'PE'/'Trial').
- FCI not mentioned: I don't even read the Qt...! (or only to catch Spam!)
- Script & URL help a lot for more "educated" Help...
- FCI not mentioned: I don't even read the Qt...! (or only to catch Spam!)
- Script & URL help a lot for more "educated" Help...