Here is the place where i will describe in details interesting previous projects i made

1.Cardex - excel spreadsheet that pastes data into ssh session in Cardex

Once upon a time (around 2008) in some aviation based warehouse company there were few people who would analaze what they are doing each day and try to make it better the next day. People in this warehouse were dealing with system called Cardex which was order picking/warehouse management software written for ssh type kind of access. This software was used to process orders which came from clients who needed parts for them creating some aviation parts. As we tried the software for few months anyone with analitical mind could see that there was enormous space for improvement. So as we tried to speed up some parts of system that shouldnt be done this way in a first place - we came up with local excel system which would take few warehouse reports as our database for parts combined with order reports for each client and then excel magic to wrap it all in system above system solution which would make your work way faster/better/easier to do - after you got used to it - you could make 3 times the amount of order which normal picker would do. So how was all this possible? First things first is the excel macros which would copy the proper cells from excel and then it was pasted into "Cardex" and cardex took it as it should as input. So for example the process would look like this ->

1. You take orders printed for specific client
2. You take the parts from warehouse for each order e.g. NAS624-12 - could take a lot of time for 100 orders
3. You take each order and try to process it in Cardex (mmareo.exe - putty like terminal client) which would take few steps
4. You pack the order and stick another label with new quantity ( last quantity - order quanttity )

Ad.3- In detail: Each line represents a text input needed to be typed to terminal and confirmed by enter

17 - number for picking screen

9999 - don't remember

140 - from warehouse number

140 - to warehouse number

2010K03933 - control number for part

SHNK0B12 - location for this control number

Q10 - quantity we should take

H - don't remember

Y - confirmation

END - another confirmation

2

7M1PH7

2010K03933

90049PBUD193 - this was supervisor code used to avoid part error which was ignored anyway

90049PBUD193

10

Y

END

P

END

END

all of this input to process single order so instead of doing that we came up with excel that would enter it for you. So instead of entering all this data by yourself you would scan the order with hand scanner to excel, then the system would match your order with proper part placement and that was it. All the rest was done by excel - it would get specific order quantity - you could choose from which location to pick by shortcut - it showed you all the orders for specific part. At first we were using vbasic to paste the data but since vbasic was slow as hell, after a time we came up with solution from AutoHotKey - which would take anything that's in clipboard ( copied from excel ) and pasted it into Cardex - Mmaero.exe window ( which he did flawlessy as i remeber ).

Files needed to recreate how it was:

Picker

Mielec Orders

Last Version

2.Picker - android tool that automates other app

So my father who is a salesman once worked for the company that would make him enter orders by hand into android app.Order which he had in few formats ranging from xls,csv,txt to html. Each of company clients had their own format.So he came to me and asked if he somehow could automate it without clicking it one by one. Preferably just look at the summary of what was entered for him to accept. So after some digging I found app name called Tasker which could send some nice intents into other apps as long i have the app name or something to identify it.So i tried it for my own app and then for the demo of the app my father was using. So we both tried it for some time and forged this streamline process which consisted of:

1.Taking a order file format from the client.

2.Running regex to get proper data in proper format ( getting EAN and quantity )

3.Running job which would enter this data in proper fields ( or proper places in the sceen since not all fields could be accessed with intents ) ( using some timeout to be sure any screen we enter could be easly rendered)

4.My father looking at what was entered and correcting if anything went off rails.

3.Website checker - tool that checks website for new content

I was looking for a new flat to rent. At the time it didn't have a rss feed.So i created a ahk script which would take a webpage and compare it with the one saved before and show me only offers that were in my criteria.