Suoritettu

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

Taidot: .NET, C# -ohjelmointi, Excel, tietojärjestelmäarkkitehtuuri, Visual Basic

Näytä lisää: 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

Tietoa työnantajasta:
( 25 arvostelua ) London, Italy

Projektin tunnus: #15621374

Myönnetty käyttäjälle:

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 1 päivässä
(7 Arvostelua)
4.1

8 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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 Lisää

€200 EUR 3 päivässä
(225 arvostelua)
7.1
€180 EUR 5 päivässä
(9 arvostelua)
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 Lisää

€225 EUR 5 päivässä
(13 arvostelua)
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 Lisää

€150 EUR 1 päivässä
(23 arvostelua)
5.1
€155 EUR 3 päivässä
(3 arvostelua)
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 Lisää

€34 EUR 3 päivässä
(2 arvostelua)
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 3 päivässä
(0 arvostelua)
0.0