Task description

Published by Elen Virabyan on 2017-02-24

Switzernet

 

Description

 

This document describes the task for the pre validation of your candidature.

 

Description of your task

 

You will be given:

Ø  a root access to a windows server

Ø  an access to a test e-mail account

Ø  emails with sample Excel files

 

You have to:

Create a script/program/application which:

Ø  automatically surveys the incoming e-mails

Ø  detects the e-mails containing the Excel files

Ø  opens the Excel files and understands the format

Ø  if the format is valid, the application reads the Excel file and inserts into the database table (a unique table for all incoming Excel files)

Ø  there must be a web interface, via which the imported excel files can be consulted

 

Validation

 

Installation and testing proofs must be emailed to jobs@switzernet.com.

Proofs must contain screenshots, description of your test and a link to the web interface to check the values imported into the DB.

Email subject: [2'h1r'1 tech trainee] Fristname Lastname

 

 

*   *   *

https://docs.switzernet.com/public/081212-use-scp/main_files/image006.gif

Copyright © 2017 Switzernet