Two small tasks: import txts into one excel file; import sql into excel file

In Progress

Hi I need two small things to be done (one of them is maybe a bit tricky but an expert should be able to do that with ease):

Task 1:

I have a folder with lots of text files and I want a script/ tool of some kind that reads the text in two options in a single MS Excel file. This can be a flag in the code or as easy as the developer likes. Maybe some python script or so. The script should have a flag where it reads all the text in the same structure into a single excel file, add a line (can be empty) between the next text file that is read into the same excel file. All concatenated in a single worksheet. I should just be able to change the code (flag or so) that the text is either completely imported or just the last line of each text file. (see picture 1). All the text files have the same structure (picture 1). (text delimiter is comma ',')

Task 2:

The same thing only now the source is a MySQL database table (many of them) one example is picture 2. Here I want another script or so that reads all the MySQL tables into a single excel file. Also with an empty line(row) between imported files. The source is as picture 2 but the excel file should then show me (column headings): INDEX; Timestamp; NumberToBeEntered; NumberEntered; Error(this is a new column that just has 0 or 1 it the numbers were not identical); KeysPressed; Corrections(New Column that counts the number of '+' characters in the column keys pressed); Score. This is a separate excel/result file.

The developer is free to choose whatever tool or language he or she wants to use as long as I get the Excel files at the end. CSV files are also ok of course. I probably have some more tasks like these in the future so I'd like to stay in touch with the developer if that works well.

That's it :)

Skills: Excel, Java, MySQL, Python, Visual Basic

See more: where to get python code, where can i get python, task as java developer, java and excel, free java developer, excel expert course, free excel course, excel course free, small java task -- 2, python excel, java+excel, java excel, import two, import sql, excel python, excel java, c++ c java python mysql,, small python task, table excel java, java table excel, mysql characters, excel file mysql, java file comma, read structure file, python script import csv mysql

Project ID: #5503881

Awarded to:

Baxter2008

Hello Angrytribble I am an Excel VBA developer. I can build both of these scripts that you need as two different Excel macros. Both of these would have a single button each to click followed by a file/folder selecti More

£25 GBP in 2 days
(30 Reviews)
4.4

37 freelancers are bidding on average £37 for this job

eperfections

10+ years experience. 600+ projects completed successfully. I am very interested in this project. I have written many such parsing scripts. Please send me sample files. Ready to start ASAP.

£99 GBP in 3 days
(400 Reviews)
7.3
dobreiiita

Hi, I am Java expert and can surely help you here with this project, Please communicate to discuss further. Thank you

£105 GBP in 2 days
(296 Reviews)
7.0
Teloquence

Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementaiton.

£100 GBP in 0 days
(229 Reviews)
7.0
shenchilang

Hi, I'm an experienced developer, and I'm interested in your project. Some sample input files will help. Thanks.

£30 GBP in 1 day
(80 Reviews)
6.5
maverick44000

Hi Tirbble. I have read the description and the job can be done in 2 days. Lets discuss the project so we may begin. Regards. Usman.

£50 GBP in 2 days
(55 Reviews)
6.2
super2lao

A proposal has not yet been provided

£27 GBP in 1 day
(42 Reviews)
5.9
dpune

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

£20 GBP in 1 day
(65 Reviews)
5.7
Beacon09

Hi, I can create PHP scripts for both tasks, that you will be able to run on the web or on your local PC using WAMP. I have previous experience of doing similar work. Both scripts will output CSV. Please let me More

£21 GBP in 3 days
(25 Reviews)
5.6
NTechcorporate

Hi, Hope you are doing well! We have gone through your requirement and we understand that you are looking for highly skilled, qualified, and experience Python development team for your project. Our developer More

£103 GBP in 1 day
(12 Reviews)
5.6
anuyadav1

A proposal has not yet been provided

£20 GBP in 1 day
(34 Reviews)
5.4
hieutc

Hi, All the thing you required could be done, I just need to discuss with you about the option: 1. I think for easier in distribution, I will do it in Excel Macro (VBA). For task 1, is it ok if the macro as you ab More

£30 GBP in 1 day
(13 Reviews)
5.3
liuyu81

I can implement the required features in Python. The code may need to incorporate third-party, open-source packages to handle Excel files and MySQL database. Getting both tasks done requires hours of coding and testing More

£35 GBP in 2 days
(17 Reviews)
5.2
elboukharimu

Aucune proposition n'a encore été fournie.

£84 GBP in 3 days
(26 Reviews)
5.1
proauthor

Dear employer, I can give you a java program (with an option to switch a flag) to read the files and generate/input the content. Please send in more details to proceed with the project. I'm ready to start working o More

£20 GBP in 1 day
(33 Reviews)
5.0
szymszteinsl

Hi! I am professional C/C++/C#/Java programmer. I can do this project with highest quality. Best Regards, Szymszteinsl

£61 GBP in 3 days
(24 Reviews)
5.1
eMaM151987

Hello i am expert java developer , i am interested at your project , i am ready to develop that tools for you ,so i am waiting your response for discuss any thing you need Regards

£44 GBP in 4 days
(25 Reviews)
4.9
srdas2012

Hi. We have done number some similar jobs but in VB Script or VBAVB6/VB.Net/C# Applications If it is ok with VB Please message us Below are the similar jobs done in Freelancer(Data Transfer from one database to More

£32 GBP in 2 days
(23 Reviews)
4.8
LeoBareto

La propuesta todavía no ha sido proveída

£29 GBP in 1 day
(4 Reviews)
4.7
paris2785

Excel and VBA expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check my portfolio for: 1.Real Estate (video demonstration) 2.Orders (video demonstrat More

£20 GBP in 5 days
(31 Reviews)
4.6
rockeinstone

Can you send me a sample for the task #1 ? I can do it for you quickly. Thanks. Rocky ..........

£45 GBP in 2 days
(24 Reviews)
4.3