Terminé

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

Compétences : .NET, Programmation C#, Excel, Architecture Logicielle, Visual Basic

en voir plus : 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

Concernant l'employeur :
( 25 commentaires ) London, Italy

Nº du projet : #15621374

Décerné à:

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

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% EUR en 1 jour
(7 Commentaires)
4.1

8 freelance font une offre moyenne de €150 pour ce travail

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(225 Commentaires)
7.1
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 5 jours
(9 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 5 jours
(13 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(23 Commentaires)
5.1
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(3 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(2 Commentaires)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(0 Commentaires)
0.0