How would you start automating my job? - Part 2

Posted by Jurily on Stack Overflow See other posts from Stack Overflow or by Jurily
Published on 2010-05-14T17:59:10Z Indexed on 2010/05/14 18:04 UTC
Read the original article Hit count: 315

Filed under:
|
|
|
|

(Followup to this question)

After surviving the first wave of incoming shipments (9 hours of copy/paste), I now believe I have all the requirements.

Here is the updated workflow:

  • Monkey collects email attachments (4 Excel spreadsheets, 1 PDF)
  • Monkey creates central database, does complex calculations (right now this is also an Excel spreadsheet)
  • Monkey sends data to two bosses, who set the retail prices independently; first one to reply wins
  • Monkey sends order form to our other warehouses, also Excel
  • Monkey sends spreadsheets to VIP customers, carefully sanitized and formatted (4 different discount categories)
  • Jurily enters the data into the accounting system. I've given up on automating this part, there's too much business logic involved, and the database is a pile of sh^W legacy

My question: What technologies would you use for a quick and dirty solution? I'm mostly sold on C#, but coming from a Linux/C++ background, I'm horribly confused about my choices in Microsoft-land.

For bonus points: How would you redesign the whole system from the ground up?

P.S. in case you were wondering, my job title is System Administrator.

© Stack Overflow or respective owner

Related posts about c#

Related posts about Windows