please help urgently

[mina1982]

please if any one can assist and help me , I have excel sheet inside it some information for our company staff breaks so I want to update our scheduling software with this information , this software is aspect workforce management

[JohnOne]

Are you telling us you are not qualified to do the job you are paid for?

Please post the code you have tried, and someone who knows about excel may be able to help you with it.

[water]

And the question is?

[mina1982]

Are you telling us you are not qualified to do the job you are paid for?

Please post the code you have tried, and someone who knows about excel may be able to help you with it.

no mr.john it's not like this I'm working in the planning team for scheduleing and what I'm trying to do is an extra mile from my side moreover I don't have any experiance in programing so I'm trying the shortest way to do a small program can automaticly when I'm running it to update the breaks from the excel sheet to the main program we are useing

I saw a code in previous post and I think it will help me but the only point is how to edit it to match my program

the code is :

expandcollapse popup

#include <File.au3>
#include <Array.au3>
#include <Excel.au3>
; opens excel workbook
;REST THE WORKBOOK FOR YOUR FILE PATH AND NAME
local $oExcel = _ExcelBookOpen("C:\autoit\lotnumbers.xls")
; reads data into array
$aArray1 = _ExcelReadSheetToArray($oExcel,1,1,0,1,True)
; closes the excel workbook
_ExcelBookClose($oExcel)
; displays the array that was read.
_ArrayDisplay($aArray1)
; counts the number of rows in the array
$rows = UBound($aArray1)-1
; waits for Corridor to become active and maximizes the window
WinActive("CORRIDOR", "")
WinSetState("CORRIDOR","",@SW_MAXIMIZE)
; finds the window called Corridor and navigates to the parts in inventory
WinActivate("CORRIDOR", "")
send("!t")
send("{down 2}")
send("{right}")
send("{down 3}")
send("{ENTER}")
; waits for the Corridor Parts in Inventory to be active
WinWaitActive("CORRIDOR", "", 5)
WinActivate("Current Parts in Inventory Search", "")
;Navigates to Part tab and lot number field
WinWaitActive("CORRIDOR", "", 5)
sleep(500)
ControlCommand("Current Parts in Inventory Search", "", "SysTabControl323", "TabRight", "")
sleep(500)
send("{TAB}")

for $c = 1 to $rows
WinWaitActive("Current Parts in Inventory Search", "Lot number:", 5) ;typo Lot Number should be Lot number:
ControlClick("Current Parts in Inventory Search", "Lot number:", 1070, "left")
;Loads up lot number
ControlSend("Current Parts in Inventory Search", "Lot number:", 1070, $aArray1[$c][0])
sleep(250)
ControlClick("Current Parts in Inventory Search", "Lot number:", 1063, "left") ; Typo in window name, changed ID for scan button to 1063,changed text value
sleep(250)
ControlClick("Current Parts in Inventory Search", "Lot number:", 1663, "left") ; Changed text value
;need to wait for edit lot to become active
WinWaitActive("Edit Lot", "Lot number:", 10)
;set new owner and vendor
;RESET these with Lowcountry Trading for your testing!!!!!!!
ControlClick("Edit Lot", "Lot number:",1053)
Send("{TAB}")
ControlSend("Edit Lot", "Lot number:",1082,"{DEL}A/V ARKANSAS")
Send("{TAB}")
ControlSend("Edit Lot", "Lot number:",1142,"{DEL}A/V ARKANSAS")
sleep(250)

;Click OK
ControlClick("Edit Lot", "Lot number:", 1, "left")
;wait to get back to search dialog
WinWaitActive("Current Parts in Inventory Search", "Lot number:", 5)
Send("{ALT}s"&"n")
next
MsgBox(0,"Lot Updater",$rows&" lots have been updated.")

Edited January 11, 2013 by Jos
added codetags

[mina1982]

And the question is?

what is the proper code that is the question ??

[Myicq]

OK, so try to summarize:

You have a job to do that involves

• taking data from one place (Excel sheet),
• possibly do something to the data (not known)
• Put data some other place (your scheduling software)'

When I have such problems, I analyze and break down into smaller bits.

Find out how to do it manually.

• What data do you want to take from Excel (by rows/columns ? Which ones ? Can you define a loop ?)
• What kind of transformation if any is done ?
• How do you insert into scheduling software.. can it only be done by keyboard entry, if so what fields (names). Exactly what keypresses are needed.

Then just repeat until you're done.

Your initial question is like asking a group of blindfolded people to guide you home. And they don't know where you are, and where your home is.

PS: Pls do put your code between autoit tags.

[water]

Myicq is right.

The forum works this way: You try something yourself, run into a problem then post all available information (your script, error messages etc.) and we then try to help you.

[mina1982]

I wanted to share with you the screen shots for the program maybe this will help

What I Need from autoit is:

• open the excel sheet ( breaks.xlsx ) ( sheet 2 )

• take the 1st ID as copy

• paste in the proper space in the main application which called ( single employee )

• go to the excel to copy the date

• go to the application to paste the date and press enter

• go back to the excel sheet and check the code ( break1 , break2 , break3 , break4 )

• go to the main application and open the specific segment as it's already copied from the excel sheet previously

• go to excel and copy the start time and end time for the specific segment

• in the application edit the segment timing as we got it from excel

• click on save & close

Or

Steps after 5

• In the main application If the segment is not there let auto it create a new segment by clicking F9

• go back to the excel sheet and check the code ( clerical ) for example and copy

• In the main application paste in the code box

• go back to the excel sheet and check the start and end time

• In the main application edit the timing as we got it from excel

• let autoit to click ok , save & close

The attachments will help a lot to understand how it can be done

Guys I really want this code and I can pay even for it??!!!!

Because I know nothing in coding and programing

If you have better idea or logic please reply me urgently

breaks.xlsx

Edited January 13, 2013 by mina1982

[mina1982]

I wanted to share with you the screen shots for the program maybe this will help

What I Need from autoit is:

• open the excel sheet ( breaks.xlsx ) ( sheet 2 )
• take the 1st ID as copy
• paste in the proper space in the main application which called ( single employee )
• go to the excel to copy the date
• go to the application to paste the date and press enter
• go back to the excel sheet and check the code ( break1 , break2 , break3 , break4 )
• go to the main application and open the specific segment as it's already copied from the excel sheet previously
• go to excel and copy the start time and end time for the specific segment
• in the application edit the segment timing as we got it from excel
• click on save & close

Or

Steps after 5

• In the main application If the segment is not there let auto it create a new segment by clicking F9
• go back to the excel sheet and check the code ( clerical ) for example and copy
• In the main application paste in the code box
• go back to the excel sheet and check the start and end time
• In the main application edit the timing as we got it from excel
• let autoit to click ok , save & close

The attachments will help a lot to understand how it can be done

Guys I really want this code and I can pay even for it??!!!!

Because I know nothing in coding and programing

If you have better idea or logic please reply me urgently

breaks.xlsx

[water]

Mina1982,

you have already a thread asking the same question - please read the forum rules and you'll see that this isn't allowed.

In addition you asked me by PM to help you with your problem.

Please be patient. This isn't a 24 hours support forum.

Show us what you have coded so far, what doesn't work and we will try to help you.

We don't hand feed users here, we help users to solve their problems themselves.

[Melba23]

mina1982,

Topics merged - please stick to just the one in future.

M23

[Myicq]

Taking data from XLS should be simple, there are lots of example codes out there.

The inserting in the application.. well without the application it's hard to help really. (now, please do not upload application here..).

You almost wrote solution yourself, just need to find bits on how to activate application, press keys etc.

Its ALL documented.

Now please at least make an efford. Otherwise, I would try to find a freelancer. You should be able to find one online.

And please only PM if you have something that's for me only. I do not have time to support people on a 1:1 base. I can see that you PM'd others as well.

[Melba23]

mina1982,

Sending PMs asking for help is forbidden by the Forum rules - please do not do it again.

M23