Automate manual process (data conversion)

Ukończone Opublikowano Feb 5, 2015 Płatność przy odbiorze
Ukończone Płatność przy odbiorze

We are a service company providing (among others) data conversion services for our various clients.

We receive on a daily basis Microsoft Excel (.csv) files containing data series via FTP. These data files are stored in various client-specific folders following a defined naming convention.

The following steps have to be executed:

1. Formally check the receipt and content of the files required

a. In case a file is missing or otherwise corrupt, send email alert to sender and our responsible person

2. Open file by file (e.g. with MS Excel) and transform the content according to the following rules (max. of three rules)

a. Check each value against a set of data values provided in a corresponding MS Excel table

b. Correct values violating rules accordingly

c. Correct values according to certain simple formulas

3. Create an MS Excel output file (different format, less content) and store in individual folders following a defined naming convention

4. Send created files to individual recipients via FTP / email (list provided)

a. In case whatever error occurs during the above steps, the resulting file has to be stored but may not be sent to the final recipients.

5. Document any action step including success / failure in a log-file

6. Archive log-file and only transmit to our responsible person in case of any failure

Obsługa e-mail Excel Visual Basic

Numer ID Projektu: #7091494

O projekcie

14 ofert Zdalny projekt Aktywny Feb 25, 2015

Przyznany użytkownikowi:

maoo92

Buna ziua! As vrea sa aflu mai multe detalii despre proiectul dumneavoastra. Cred ca as putea sa il finalizez in trei patru zile. Daca vreti sa imi oferiti mai multe detalii si sunteti interesat de oferta mea putem dis Więcej

€150 EUR w ciągu 3 dni
(0 ocen)
2.4

14 freelancerów złożyło ofertę za €178 w tym projekcie

bouslimi1979

Hi, I m interested by your project and I hope it will be a long term cooperation. I m an Excel/VBA expert (please check my profil for feedbacks). I ll foloww the mentionned steps and will check if we can't code some ma Więcej

€155 EUR w ciągu 3 dni
(335 Oceny)
7.9
zExcel

A proposal has not yet been provided

€200 EUR w ciągu 2 dni
(257 Oceny)
7.7
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 220 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive Więcej

€200 EUR w ciągu 15 dni
(123 Oceny)
6.3
kmpal

Hi, I am an experienced developer with vast experience in .NET, MVC and SQL available for this project. I am full time freelancer available 10 hours daily. Thanks and best regards Khalid Skype - khalidpal Więcej

€250 EUR w ciągu 15 dni
(30 Oceny)
5.9
srinichal

I am an expert in delivering custom tools and scripts willing to discuss further about the project needs

€252 EUR w ciągu 3 dni
(50 Oceny)
6.0
DavidJRG

I'm a software architect, expert developer and DBA with more than 18 years of experience. I can develop this solution in VB or in C# (my preference), using Visual Studio 2013 and the .NET Framework 4.5 (or 4.0 if Wi Więcej

€150 EUR w ciągu 3 dni
(3 Oceny)
3.5
K9JT

A proposal has not yet been provided

€150 EUR w ciągu 5 dni
(13 Oceny)
3.2
SourceBest

Hi I have extensive experience in various data management activities and development of modules that will help to minimize the manual works. Would be able to offer a quality code which will work as you require. Plea Więcej

€222 EUR w ciągu 7 dni
(3 Oceny)
2.2
SWAPANCHOWHAN

Dear Sir, I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I have 5 year experience in projects related to VBA macros for excel and vb.net. This will Więcej

€120 EUR w ciągu 5 dni
(5 Oceny)
2.2
pushar71

Hi, We are a software company in India, i have a team of professionals who have been doing back office work since last several years, we have handled such tasks for few clients in the past and currently doing a gov Więcej

€222 EUR w ciągu 3 dni
(1 Ocena)
1.3
suejakk

A proposal has not yet been provided

€155 EUR w ciągu 10 dni
(0 Oceny)
0.0