wzubke Posted April 18, 2013 Posted April 18, 2013 Has anyone ever used AutoIt to script in a healthcare environment? In our case it would be to help create interoperability between two EMR systems (Meditech and eclinicalworks) Thanks,
water Posted April 18, 2013 Posted April 18, 2013 Welcome to AutoIt and the forum! I don't think it matters in which environment you have to script but which kind of applications you need to automate. Web Applications, Java, Webforms ... I know none of this two so can you please describe the applications and what you need to do a little bit? My UDFs and Tutorials: Reveal hidden contents UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
Mechaflash Posted April 18, 2013 Posted April 18, 2013 (Just in case no one does) Is there a more specific question you have? Is there a feature you're hoping AutoIt has for your needs? What is your concern? Reveal hidden contents “Hello, ladies, look at your man, now back to me, now back at your man, now back to me. Sadly, he isn’t me, but if he stopped using ladies scented body wash and switched to Old Spice, he could smell like he’s me. Look down, back up, where are you? You’re on a boat with the man your man could smell like. What’s in your hand, back at me. I have it, it’s an oyster with two tickets to that thing you love. Look again, the tickets are now diamonds. Anything is possible when your man smells like Old Spice and not a lady. I’m on a horse.”
Moderators Melba23 Posted April 19, 2013 Moderators Posted April 19, 2013 wzubke,I have helped others with Autoit scripts to enable healthcare apps to interact - an app is an app after all. But you need to be VERY, VERY careful with errorchecking and limit-setting within the code given the critical nature of the likely outcomes. Can you post some screenshots of the apps to which you refer and explain in a bit more detail what exactly you want AutoIt to do to get them to interact. We would be delighted to help you, but we need a lot more information if we are to end up with something as reliable as this sounds as though it needs to be. M23 Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind Open spoiler to see my UDFs: Reveal hidden contents ArrayMultiColSort ---- Sort arrays on multiple columnsChooseFileFolder ---- Single and multiple selections from specified path treeview listingDate_Time_Convert -- Easily convert date/time formats, including the language usedExtMsgBox --------- A highly customisable replacement for MsgBoxGUIExtender -------- Extend and retract multiple sections within a GUIGUIFrame ---------- Subdivide GUIs into many adjustable framesGUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView itemsGUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeViewMarquee ----------- Scrolling tickertape GUIsNoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxesNotify ------------- Small notifications on the edge of the displayScrollbars ----------Automatically sized scrollbars with a single commandStringSize ---------- Automatically size controls to fit textToast -------------- Small GUIs which pop out of the notification area
wzubke Posted April 22, 2013 Author Posted April 22, 2013 Thanks for everyones quick response and I apologize for taking so long in responding back! One of the first projects I would like to be able to address is death record data we receive files from the state in a fixed width text format which I am looading into a database and mapping to our patient poplation. We then print a report and someone is required to go into both of our systems and update the info manually. so we must search out the record we wish to update using the data I have already mapped and navigate through the EMR. The patient lookup screen can be brought up with Alt+L from anywhere in the software. Once there we simply plug the patient info and pull up the record (probably not as simple to automate as one would think). On the first page we send the Alt+I keystroke to open the info page. Wait a bit. Send Alt+I again for the additional info screen. Image attached This screen is where the data is input and saved. The Deceased flag must me checked date entered and notes populated based on what the state supplies. I realize more detail would be needed to fully analyze this scenario but I am mostly wondering at this point if AutoIt is secure and functional enough to work in this environment?
Moderators Melba23 Posted April 22, 2013 Moderators Posted April 22, 2013 wzubke, Quote I am mostly wondering at this point if AutoIt is secure and functional enough to work in this environment?As I explained above, if AutoIt is able to access the app then with suitable errorchecking I believe that it is. You can always add a final MsgBox asking if the data commital should proceed so that a human can check what has been entered before evrything is finalised. Your next task will be to use the AutoIt Window Info tool to see if you can read from the various controls on that GUI. Assuming you did a standard install, the tool can be found at C:Program FilesAutoIt3Au3Info.exe - just fire it up and see if you get valid data in the "Control" tab when you drag the little gunsight over the fields you want Autoit to access. If you do, then please post the results so we can see if this is a nice well-behaved app that is easy to deal with - or not. M23 Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind Open spoiler to see my UDFs: Reveal hidden contents ArrayMultiColSort ---- Sort arrays on multiple columnsChooseFileFolder ---- Single and multiple selections from specified path treeview listingDate_Time_Convert -- Easily convert date/time formats, including the language usedExtMsgBox --------- A highly customisable replacement for MsgBoxGUIExtender -------- Extend and retract multiple sections within a GUIGUIFrame ---------- Subdivide GUIs into many adjustable framesGUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView itemsGUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeViewMarquee ----------- Scrolling tickertape GUIsNoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxesNotify ------------- Small notifications on the edge of the displayScrollbars ----------Automatically sized scrollbars with a single commandStringSize ---------- Automatically size controls to fit textToast -------------- Small GUIs which pop out of the notification area
Mechaflash Posted April 22, 2013 Posted April 22, 2013 My question for u is whether or not the human interaction between the two systems is always being utilized as a check to ensure that the data from the first system is accurate prior to entering it into the next system? I've learned that if users are given information to verify as opposed to enter and verify, they are more likely to overlook the details because it's easier to just say "yeah it looks good... I didn't enter the info so it wouldn't be my fault." than "I entered the info... I better double-check it". Reveal hidden contents “Hello, ladies, look at your man, now back to me, now back at your man, now back to me. Sadly, he isn’t me, but if he stopped using ladies scented body wash and switched to Old Spice, he could smell like he’s me. Look down, back up, where are you? You’re on a boat with the man your man could smell like. What’s in your hand, back at me. I have it, it’s an oyster with two tickets to that thing you love. Look again, the tickets are now diamonds. Anything is possible when your man smells like Old Spice and not a lady. I’m on a horse.”
wzubke Posted April 22, 2013 Author Posted April 22, 2013 We would probably use some manual auditing initially to ensure there are not issues once we verify it is working correctly we would remove the human element if possible.
kylomas Posted April 22, 2013 Posted April 22, 2013 wzubke, Two suggestions.. 1 - create a journaling mechanism to log before and after images of changes 2 - create a recovery environment These suggestions are somewhat vague because volume, size and redundancy requirements are unknown. kylomas Forum Rules Procedure for posting code "I like pigs. Dogs look up to us. Cats look down on us. Pigs treat us as equals." - Sir Winston Churchill
Mechaflash Posted April 22, 2013 Posted April 22, 2013 On 4/22/2013 at 6:58 PM, 'wzubke said: We would probably use some manual auditing initially to ensure there are not issues once we verify it is working correctly we would remove the human element if possible.I would suggest to audit how many errors are coming from the data (prior to entering into the other system). If you believe you can remove the human element, then I wouldn't even bother with utilizing the GUI to perform the automation... why not just transfer data between the databases directly? Reveal hidden contents “Hello, ladies, look at your man, now back to me, now back at your man, now back to me. Sadly, he isn’t me, but if he stopped using ladies scented body wash and switched to Old Spice, he could smell like he’s me. Look down, back up, where are you? You’re on a boat with the man your man could smell like. What’s in your hand, back at me. I have it, it’s an oyster with two tickets to that thing you love. Look again, the tickets are now diamonds. Anything is possible when your man smells like Old Spice and not a lady. I’m on a horse.”
wzubke Posted April 22, 2013 Author Posted April 22, 2013 We do not have update access to the databases except through the software the vendors provide. Seems silly I know, welcome to the world of healthcare!
Mechaflash Posted April 22, 2013 Posted April 22, 2013 And of course you guys have contacted the vendor requesting access to the database because your company owns the database and the data that is contained within and that they are not at liberty to hold you access to that data? I work in the financial district dealing with hospital clients, and this is something we had to do to get access to our database (we're under the same restrictions as you are cause of HIPPA etc...). However, the liability then lies on your shoulders should there be a breach of security having to deal with the transfer of data not being solely in their hands. Reveal hidden contents “Hello, ladies, look at your man, now back to me, now back at your man, now back to me. Sadly, he isn’t me, but if he stopped using ladies scented body wash and switched to Old Spice, he could smell like he’s me. Look down, back up, where are you? You’re on a boat with the man your man could smell like. What’s in your hand, back at me. I have it, it’s an oyster with two tickets to that thing you love. Look again, the tickets are now diamonds. Anything is possible when your man smells like Old Spice and not a lady. I’m on a horse.”
wzubke Posted April 22, 2013 Author Posted April 22, 2013 I have requested read only access for reporting purposes and they are resistant to even that!
FloridaMark Posted December 11, 2014 Posted December 11, 2014 (edited) <snip> Edited December 11, 2014 by Melba23 Advert removed
Moderators Melba23 Posted December 11, 2014 Moderators Posted December 11, 2014 FloridaMark,We do not accept advertising for commercial pay-ware products, even if they are related to the thread. Please do not do it again. M23 Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind Open spoiler to see my UDFs: Reveal hidden contents ArrayMultiColSort ---- Sort arrays on multiple columnsChooseFileFolder ---- Single and multiple selections from specified path treeview listingDate_Time_Convert -- Easily convert date/time formats, including the language usedExtMsgBox --------- A highly customisable replacement for MsgBoxGUIExtender -------- Extend and retract multiple sections within a GUIGUIFrame ---------- Subdivide GUIs into many adjustable framesGUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView itemsGUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeViewMarquee ----------- Scrolling tickertape GUIsNoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxesNotify ------------- Small notifications on the edge of the displayScrollbars ----------Automatically sized scrollbars with a single commandStringSize ---------- Automatically size controls to fit textToast -------------- Small GUIs which pop out of the notification area
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now