Completado

Email, drop-box, excel workfolow authomation

I need to streamline purchasing documents administration automating what I am doing manually so far; new flow (to-be):

- I will send an email with attached purchasing document and this email must contain:

A. file protocol - in mail subject - this name that will be file name in dropbox folder i.e. HHPI805 (Company Name, Purchasing Invoice, Serial)

B. location in dropbox -in mail body- (i.e. Dropbox/017/Administration/HH/Accounts/11/Purchases/Invoices)

C. Relevant information about invoice:

JOB CODE: i.e. BURCOCHOM_ CHIARINI BLACK BELT OMP

TYPE: document type i.e. PI purchasing invoice

ACCOUNT LEDGER: i.e. TRAVEL

DESCRIPTION: i.e. TRAIN

NET AMOUNT: i.e. 100

VAT: i.e. 20

PAYMENT TYPE: i.e. HSBC CARD

- Program must:

1. re-name the att. pdf with the protocol in mail subject (previous point A.)

2. store it in the given path dropbox folder (previous point B.)

3. fill automatically an online spreadsheet (like google or an xls offline) with following data for each mail (each mail is a row) data are stored in columns:

- Company Name (first 2 digit of the file name)

- Serial (last 3 digit of the file name)

- Document Type

- JOB

- ACCOUNT LEDGER

- DESCRIPTION

- NET

- VAT

- TOT

- PAYMENT TYPE

Please find enclosed an xls sample

Habilidades: .NET, Programación en C#, Excel, Arquitectura de software, Visual Basic

Ver más: Attached is a scanned copy of a form that we need to be created as an Excel sheet, We need our association member list put into an excel database, we need to create a bill format in MS Excel for the patrol pump, php, mysql, python, jquery / prototype, We need advertising images (.jpg) for a new product we are offering. It\ s a box of dog, we need translate some email to portuguese, excel drop box, excel dynamic drop box, travel agents email list india excel, ipad excel app drop box, sample drop box, java drop box sample, drop box description excel, sample travel agency card, drop box info excel data sheet, lock drop box excel, install drop box excel

Información del empleador:
( 25 comentarios ) London, Italy

Nº del proyecto: #15621374

Adjudicado a:

peymann

That is super easy job for me as i have done that many times before. just select me and i will write the code for you, Thank you

€100 EUR en 1 día
(7 comentarios)
4.1

8 freelancers están ofertando el promedio de €150 para este trabajo

ineedWorkJob

Greetings sir, how are you today sir? hope fine. Sir, I have read your project details and i will create a windows software that will automate your workflow excel, dropbox and email too. Sir, i can deliver th Más

€200 EUR en 3 días
(225 comentarios)
7.1
€180 EUR en 5 días
(9 comentarios)
5.6
awxmem

Hello, I have 7+ years of experience in Python programming. The specified automation protocol can be implemented in Python. I have also good experience with the recent Dropbox API v2 and Google API.. Looking for Más

€225 EUR en 5 días
(13 comentarios)
5.1
khudammunir

Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking and Content Writing experience with Advance MS Excel Dashboards, MS & Google Office, WordPress, Social Me Más

€150 EUR en 1 día
(23 comentarios)
5.1
€155 EUR en 3 días
(3 comentarios)
2.4
mdyounuskhan726

Hello , I amYounus. I am very much interested on your project . I feel that I am the exact match for your requirements after thoroughly reviewing the job description and desired skills. I have a lot of experience i Más

€34 EUR en 3 días
(2 comentarios)
1.3
Sohelmithun

Hi, I am good at Excel and vba. I have checked the description and would be a pleasure to assist you on your project. Looking forward to discuss in the chat to get the scope of work. Sohel R.

€155 EUR en 3 días
(0 comentarios)
0.0