Sign in to follow this  
Followers 0
mina1982

please help urgently

13 posts in this topic

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

Share this post


Link to post
Share on other sites



And the question is?


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - 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

#4 ·  Posted (edited)

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 :

#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 by Jos
added codetags

Share this post


Link to post
Share on other sites

And the question is?

what is the proper code that is the question ??

Share this post


Link to post
Share on other sites

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.


I am just a hobby programmer, and nothing great to publish right now.

Share this post


Link to post
Share on other sites

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.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - 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

#8 ·  Posted (edited)

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

post-77464-0-58083900-1358074083_thumb.j

post-77464-0-29135200-1358074085_thumb.j

post-77464-0-35082100-1358074087_thumb.j

breaks.xlsx

post-77464-0-78122500-1358074103_thumb.j

Edited by mina1982

Share this post


Link to post
Share on other sites

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

post-77464-0-91568900-1358204848_thumb.j

post-77464-0-61018700-1358204852_thumb.j

post-77464-0-29984000-1358204853_thumb.j

post-77464-0-39210200-1358204854_thumb.j

breaks.xlsx

Share this post


Link to post
Share on other sites

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.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - 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

mina1982,

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

M23


Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind._______My UDFs:

Spoiler

ArrayMultiColSort ---- Sort arrays on multiple columns
ChooseFileFolder ---- Single and multiple selections from specified path treeview listing
Date_Time_Convert -- Easily convert date/time formats, including the language used
ExtMsgBox --------- A highly customisable replacement for MsgBox
GUIExtender -------- Extend and retract multiple sections within a GUI
GUIFrame ---------- Subdivide GUIs into many adjustable frames
GUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView items
GUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeView
Marquee ----------- Scrolling tickertape GUIs
NoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxes
Notify ------------- Small notifications on the edge of the display
Scrollbars ----------Automatically sized scrollbars with a single command
StringSize ---------- Automatically size controls to fit text
Toast -------------- Small GUIs which pop out of the notification area

 

Share this post


Link to post
Share on other sites

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.


I am just a hobby programmer, and nothing great to publish right now.

Share this post


Link to post
Share on other sites

mina1982,

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

M23


Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind._______My UDFs:

Spoiler

ArrayMultiColSort ---- Sort arrays on multiple columns
ChooseFileFolder ---- Single and multiple selections from specified path treeview listing
Date_Time_Convert -- Easily convert date/time formats, including the language used
ExtMsgBox --------- A highly customisable replacement for MsgBox
GUIExtender -------- Extend and retract multiple sections within a GUI
GUIFrame ---------- Subdivide GUIs into many adjustable frames
GUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView items
GUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeView
Marquee ----------- Scrolling tickertape GUIs
NoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxes
Notify ------------- Small notifications on the edge of the display
Scrollbars ----------Automatically sized scrollbars with a single command
StringSize ---------- Automatically size controls to fit text
Toast -------------- Small GUIs which pop out of the notification area

 

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  
Followers 0