Advertisements

Actually getting autoexpect to work on Windows solved

So I heard about this really cool tool called autoexpect… so I read here that Expect is

http://blogs.activestate.com/activestate/2005/09/expect_for_wind.html

part of activestates free offering, so of course I download it, but Expect can’t be found!

So after more searching I found that you have to add it

http://community.activestate.com/faq/where-is-expect

(USE teacup install Expect)

But then after more research I find that it’s impossible for Autoexpect to work inside of the ActiveState version.

This post explains in detail why http://coding.derkeiler.com/Archive/Tcl/comp.lang.tcl/2008-03/msg00917.html

Anyways so what is a guy to do? So I installed cygwin, and installed all of the packages (took a long time but guaranteed that expect would be there). Then of course I couldn’t find autoexpect.

Well autoexpect is just a script anyways, so I was able to download it using this guys site and instructions.

http://wi-fizzle.com/article/191

Wish I could have those hours of my life back….

Advertisements

Automating Software Testing Adage ERP, Coolearth Warehouse Management, VeggieTests

So I have been working on an easy VB.net app for submitting QC tests to adage through the TEE interface. As mentioned in this post https://michaelellerbeck.com/2008/04/03/how-to-setup-adage-to-allow-qc_testresults/

Well I wanted to setup an automated test that would basically go from a shop order released to production (In Adage ERP, the lot creation (In Coolearth WMS), and then some sample tests in VeggieTests.

I scripted it in AutoIt, for the windows apps this works great but for the telnet apps it just has to guess. I have started investigating using Expect for the telnet WMS testing.

This is a quick little flash file of one automated run through.

http://sites.google.com/site/mellerbeck/Home/veggieTests.swf?attredirects=0

[VpxdMain] Failed to initialize: not well-formed (invalid token) VMWARE

This is caused by ESX 3.5 Update 2 not being compatible with the Virtual Center. You will need to upgrade to VirtualCenter 2.5 Update 2.

VB.net ramblings

How to capture a Control + Something

First enable key preview on your form then use the key down event

Private Sub Form1_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEv

entArgs) Handles Me.KeyDown
If e.Modifiers = Keys.Control Then
If e.KeyCode = Keys.Enter Then
MessageBox.Show(“Ctrl + Enter”)
End If
End If
End Sub
How to click a button, use the performclick method.

Went to remote wipe an iphone today….

Basically, if you have never applied a security policy to the phone, then it will ask the person who stole it if they want it to be wiped….

That is very strange.

These two posts explain it http://blogs.technet.com/sbs/archive/2007/01/11/remote-wiping-a-device-with-no-user-input.aspx

http://www.mountainvistatech.com/2009/02/05/block-and-delete-but-no-wipe-option-in-microsoft-mobile-admin/

You get the options to Block, and Delete, but no option to wipe.

ATM I can’t get a security policy to push out to an iphone…. guess I will have to research some more.

Business Process Reengineering gone wrong

In the same vein as my previous post Going Paperless all wrong I see the trend of BPR going all wrong, and usually hand in hand with some sort of paperless initiative.

For a simple example lets analyze a vacation request sheet. I will arbitrarily set the paper based process at automation Level 1. This is the process, a standard form is circulated that includes what dates you will be gone, what tasks need to be done while you are gone, and sign offs by various people to affirm they will cover for you and realize that you are going on vacation. This paper is then handed to a payroll person who enters in the appropriate vacation dates into Kronos Time and Attendance.

What then happens is that someone (usually a manager) in a remote location ‘analyzes’ this process and looks for a way to improve it. At Level Zero I place the manager who decides to start scanning this vacation request sheet after it has been filled out. Eventually, OK I’m being a little absurd here (but not too absurd) this will lead to a filing system resembling a law library with this form being coded as HR-FORM-200-VAC-02/02/2008 and then a copy of each and every vacation request placed into a shared folder named something like M:\HR\Vacation Requests\19982\JimBob\

I have issues with this sort of setup on a few fronts. The largest glaring one is why is this document being retained, and what value is gained by doing so. There would be no legal requirement to do so that I know of.

At level .5 the manager would come to the realization that we ‘NEED‘ to create some sort of digital form to make this process easier and more efficient! They would go out and drop $700 bucks on Adobe Pro (Hey I’m a manager I need this software) so they could make an exact digital version of the paper form with spots for people to type the info into. They could also do something similar with Word. If they were really evil they would decide to develop something using an Access database. In my worst case scenario this form would be emailed around and then of course end up getting printed out and faxed to the payroll person. And then maybe scanned (see Level zero above)

There are many variations on this type of ‘Reengineering’, usually by people who have purchased a cheap scanner and want to go paperless! Or they made some insane yearly goal for their management on how THEY were going to design and implement a paperless workflow for the Vacation request process.

Unbeknownst, or sometimes even beknownst to them. Quietly, in the background, IT has been creating test servers. And what is being installed and tested on these test servers? A Kronos module for handling vacation requests. This allows someone to request vacation either through their Timecard or through a self service Kiosk. It then allows a manager to approve or reject the request, sending back the status to the employee. If the vacation is approved an email is generated, and the timecard is automatically updated to reflect the time off. This process allows the manager to work directly with the employee and the payroll person never gets involved. The process is audited and trackable for what ever legal requirements you may have. And it uses systems already in place. I will call this level 3.

This is of course a very black and white example, and paints IT in a very favorable light. It never is this easy. But, there is a department that is full of Business Anaylsts. And they usually try to analyze business processes and improve them. They don’t go out and try to sell things like sales people, and they sure as heck don’t want to do any accounting. Why is it then, that it seems most departments think you can just buy an ‘IT system’ turn it on and then all of their problems will go away. IT does touch on pretty much everything these days, but I guess in the inverse everyone thinks that they can implement just a little of IT.

Now I understand that ‘in the trenches’ and ‘on the front lines’ managers want to get things done. They want to improve business processes. Usually they make goals to do so. But business process reeingineering is hard. You need to try to capture all of the requirements of the whole, and know what existing systems are in place or being implemented before you go and buy some ‘solution’. Traveling solution salesmans are the worst, their software will of course solve all of your problems.

When I see this sort of behavior I start to suspect BMS or Bored Management Syndrome. I wonder if there are aspects of their daily jobs that could instead be focused on instead of ‘going paperless’ or whatever the newest trend is. Instead they try to buy and implement something that usually is redundant to a system that is already in place. This is managment gone amok.

Creating a User in Adage ERP, using this user for TEE

So in Adage, under Systems Administration

Go to, Database User Name. This is where you setup the link between an NT username and the Database user name and password. So create that link first.

Then open up Users, I just copied a previous user and then select the above created User Name for the OS User Name.

Now I need to be logged on to windows as the same NT User

And my eie.cfg file will look like,

//
// External Interface Engine Configuration
//
// 1) NT Username
// 2) ADAGE Database Name (ODBC System DSN Name)
// 3) Database User ID
// 4) Database Passwd for User
// 5) Adage User ID
// 7) Log Level
//
sterrell|Q26_D07_o|user1|user1|PTP1|4|