Since you wanna loop for this part only put that inside your original loop like tihs:
Code:
;Want to Loop from here to the end of the script for all Orders in Customer.csv seperated by Linenumbers
Clipboard =
ArrayCount = 0
Loop, Read, C:\Records\Customer.csv
{
ArrayCount += 1
StringSplit, Item, A_LoopReadLine, `"
Status%ArrayCount% = %Item1%
Order%ArrayCount% = %Item6%
Clipboard = %Order2%
Sleep, 100
Send, {CtrlDown}v{CtrlUp}
MouseClick, Left, 153, 507
Sleep, 100
MouseClick, Left, 160, 509
Sleep, 100
WinWait, Requests - Maxthon Browser,
IfWinNotActive, Requests - Maxthon Browser, , WinActivate, Requests - Maxthon Browser,
WinWaitActive, Requests - Maxthon Browser,
MouseClick, Left, 380, 316
Sleep, 100
;Copy Customer Billing/Shipping (Add If/Else for Address 2 exception)
FileDelete, C:\Records\CustomersRP.txt
Sleep, 300
FileAppend, ShipFirst ShipLast;Ship Street;ShipCity ShipZip ShipState; Ship Country; Phone #; BillFirst BillLast; Bill Street; BillCity BillState BillZip; Bill Country; E-mail`n, C:\Records\CustomersRP.txt
WinWait, Order Detail - Maxthon Browser,
IfWinNotActive, Order Detail - Maxthon Browser, , WinActivate, Order Detail - Maxthon Browser,
WinWaitActive, Order Detail - Maxthon Browser,
Clipboard =
Sleep, 100
MouseClickDrag, Left, 754, 244, 536, 244, 0 ;Ship to Name
Sleep, 100
Send, {CtrlDown}c{CtrlUp}
Sleep, 100
FileAppend, %Clipboard%;, C:\Records\CustomersRP.txt
Clipboard =
MouseClickDrag, Left, 772, 260, 534, 260, 0 ;Ship to Street Address
Sleep, 100
Send, {CtrlDown}c{CtrlUp}
Sleep, 100
FileAppend, %Clipboard%;, C:\Records\CustomersRP.txt
Clipboard =
MouseClickDrag, Left, 772, 275, 535, 275, 0 ;Ship to City, Zip, State
Sleep, 100
Send, {CtrlDown}c{CtrlUp}
Sleep, 100
FileAppend, %Clipboard%;, C:\Records\CustomersRP.txt
Clipboard =
MouseClickDrag, Left, 772, 294, 536, 294, 0 ;Ship to Country
Sleep, 100
Send, {CtrlDown}c{CtrlUp}
Sleep, 100
FileAppend, %Clipboard%;, C:\Records\CustomersRP.txt
Clipboard =
MouseClickDrag, Left, 772, 313, 576, 313, 0 ;Phone #
Sleep, 100
Send, {CtrlDown}c{CtrlUp}
Sleep, 100
FileAppend, %Clipboard%;, C:\Records\CustomersRP.txt
Clipboard =
MouseClickDrag, Left, 518, 243, 283, 244, 0 ;Bill to First, Last Name
Sleep, 100
Send, {CtrlDown}c{CtrlUp}
Sleep, 100
FileAppend, %Clipboard%;, C:\Records\CustomersRP.txt
Clipboard =
MouseClickDrag, Left, 522, 258, 282, 258, 0 ;Bill to Street
Sleep, 100
Send, {CtrlDown}c{CtrlUp}
Sleep, 100
FileAppend, %Clipboard%;, C:\Records\CustomersRP.txt
Clipboard =
MouseClickDrag, Left, 522, 275, 283, 275, 0 ;Bill to City, ZIp, State
Sleep, 100
Send, {CtrlDown}c{CtrlUp}
Sleep, 100
FileAppend, %Clipboard%;, C:\Records\CustomersRP.txt
Clipboard =
MouseClickDrag, Left, 398, 290, 282, 290, 0 ;Bill to COuntry
Sleep, 100
Send, {CtrlDown}c{CtrlUp}
Sleep, 100
FileAppend, %Clipboard%;, C:\Records\CustomersRP.txt
Clipboard =
MouseClickDrag, Left, 467, 550, 291, 550, 0 ;E-mail address
Sleep, 100
Send, {CtrlDown}c{CtrlUp}
Sleep, 100
FileAppend, %Clipboard%`n, C:\Records\CustomersRP.txt
Clipboard =
ArrayCount = 0
}
This way it will read a line from csv file and does all these step for it then reads the next line, and so on until it reaches the end of csv file. since order # are always in the same column you don't even have to change the numbers manually as arraycount will reset itself after going through each line of csv file, just like clipboard.
But as BoBo said it is better to use UrlDownloadToFile than cut\copy & paste method.
Login
Register
FAQ
Search
