In Progress

Upload large zip or csv files into mysql on local computer for further treatment in c#

I want a program in C# / MySQL, that would be able to:

STEP1

upload about 50 zip or CSV files. These files contain historical financial data and are very large for a total size of about [url removed, login to view] zipped. I can send you a file example if you want.

1/ import files from a local computer. The files are either in ZIP or csv (a file example can be provided if necessary).

Table format (a table example can be provided if necessary).

orig_id bigint (20,0) not null primary key

id_minute bigint (20,0) not null

desc varchar(20) not null

datetime varchar(25) null

v1 decimal(10,5) null

v2 decimal(10,5) null

2/ sort data by datetime ascending

3/ remove any duplicate. duplicate if datetime & v1 & v2 in above/below records are equal

4/ add orig_id to every record

5/ group by minute (beginning & end of minute).

a) Please also allow possibility to only group by end of minute (or beginning of minute) instead of having beginning & end of minute values

b) Please also allow possibility to group by a variable number of minutes

6/ ad id_minute to every record by minute

7/ merge new data with historical data

8/ since process is very long, provide ability to text/email when each process is finished

The reason you will need to process file by file instead of importing all files together and doing the process only once is because the file size would be large to freeze the computer.

STEP2

Once the 50 files are uploaded into mysql, design process to upload a monthly file to upload and do the same steps to then append to the past data.

Thank you

Skills: C# Programming, Database Administration, MySQL, Software Architecture, Software Testing

See more: upload files, variable in programming, steps to computer programming, or in c programming, local programming, key programming software, i want all key programming, design process steps, computer programming program, computer programming 1, computer for programming, c computer programming, c# beginning, beginning programming, beginning c sharp, beginning c programming, about computer programming, programming in c++, computer programming software, beginning computer programming, treatment, software in c, financial programming, computer architecture, computer architecture -- 2

About the Employer:
( 10 reviews ) United States

Project ID: #4168195

Awarded to:

uconomixtec

Hello, Please check the private message for the details of my bid.

$240 USD in 3 days
(33 Reviews)
5.9

11 freelancers are bidding on average $209 for this job

barundebnath

Hi, I am expert in text processing. Send me details of the computer where this processing will happen (ie. RAM, 32/64 Bit OS etc) Thanks

$250 USD in 7 days
(63 Reviews)
6.2
Rahul2012

C# and my sql expert : [url removed, login to view]

$150 USD in 2 days
(17 Reviews)
5.4
ETNASoftware

Hello, I have couple of guys who would be perfect fit with extended technological background & experience with custom software development. Strong C# capabilities. Examples of our projects: [url removed, login to view] More

$250 USD in 1 day
(1 Review)
5.0
techwelf

Hi we checked your requirement,We could develop as per your need. u could check that out. we would work till your satisfaction. Thanks & Regards Techwelfare Please check inbox for our previous work.

$241 USD in 12 days
(20 Reviews)
5.0
kapoorprateek82

Hi, I have 5+ years of developing .net applications. I am interested to work on this project. I can give you output with complete accuracy and deliver in time. Please see private message.

$150 USD in 7 days
(7 Reviews)
3.7
mohsin649

Thanks for considering my [url removed, login to view]

$250 USD in 7 days
(4 Reviews)
3.6
marioalonzo

Greetings! I would like to build the solution, if I may. I made a similar tool last year, using C# , .Net framework 3.5 and MySql .Net connector 5.2. I just request of a single milestone, payable until you rec More

$200 USD in 15 days
(0 Reviews)
1.8
malanhi

Hi , I worked with a big mysql database and expert .Net .I will build for you a .net Application for this .

$200 USD in 7 days
(0 Reviews)
0.0
SheldonCoop

Hello! Will be done

$150 USD in 3 days
(0 Reviews)
0.0
szsolutionsvw

We are fastest growing software company in Gujarat, India.

$220 USD in 10 days
(0 Reviews)
0.0