Closed

Create an online app using Java to import excel files into MySQL

We need to create a small web application that will allow the user to upload and excel file to a webserver and this file will be processed and imported into mySQL. The web app needs to be able to let the user map excel columns to database columns.

Design is not required so it can be quite plain - we will add the UI to the system afterwards. Basic UI design can be given to the successful candidate.

The end goal is to build a functioning web report that allows for excel upload of data so that the report can be generated. This project is the first part.

User experience is as follows

1. Select Excel file to upload

2. Excel file is uploaded to the webserver into a temp table

3. Web application asks which column in the temp table maps to a column in the main table.

4. Data is moved from temp table to main table, and temp table dropped.

5. Data is displayed in the main table

Preference will be given to freelancers who:

1. Have experience working in a micro services / distributed architecture area

2. Are looking for repeat project hire (see point 1 - we have many projects to work on)

3. Have extensive Java experience (JS also useful)

4. Exposure to CMS Java systems such as Hippo CMS

5. Look to use JSON, REST, SOAP or other web calls to allow for scalable delivery.

6. Developers who understand that security is a must!

Please provide us with a brief overview of how you plan to put this together along with costs and delivery times.

thanks!

Skills: Java, MySQL, Software Architecture

See more: using php import excel file mysql using php, using perl import excel file mysql, import excel data mysql using java, insert image in mysql database using java servlet, how to upload image in database using jsp and servlet, how to upload image in mysql database using jsp, jsp upload file and save in database, how to upload excel file in database using java jsp web application, how to store file in mysql database using java, mysql for excel, upload file to mysql database using jsp, import excel file mysql using java, import excel files mysql php, create online diary using php mysql, create gmail account using java, create bingo game using java, online examination using java, import excel file mysql using vbnet, import excel files quickbooks, php import excel files

About the Employer:
( 0 reviews ) Switzerland

Project ID: #15999457

18 freelancers are bidding on average €1432 for this job

winmaclin

Hello, Desired WEB app can be developed by us to upload an excel file to a webserver & this file will be processed and imported into mySQL. Relevant Skills and Experience - [login to view URL] (userid/password: nar More

€3000 EUR in 60 days
(337 Reviews)
8.5
arcdevsol

Hi there, I would create a REST API in Spark Framework (Java). API would be protected using either JWT or oAuth. On client, I will create the client in Angular & have it communicate with the REST API. Relevant Skills More

€1500 EUR in 25 days
(113 Reviews)
7.3
mmagr99

We have very experinced java in-house developers in a team :) so not a big deal for this project Relevant Skills and Experience yes Proposed Milestones €2352 EUR - java work required

€2352 EUR in 30 days
(32 Reviews)
7.0
€1411 EUR in 30 days
(31 Reviews)
7.0
€1250 EUR in 20 days
(23 Reviews)
6.8
shaileshpatil17

Hi there, We have created mobile app using Java recently with the same functionality. Which was importing Excel sheet and was able to generate reports. Do you want mobile app or web app for same? We can develop it f More

€878 EUR in 20 days
(22 Reviews)
6.4
€1323 EUR in 21 days
(52 Reviews)
6.1
mike199

Hello, I specialise in web development. I live in Oxford. Your project seems interesting and I do have the required skills Relevant Skills and Experience Java, MySQL, Software Architecture Proposed Milestones €1250 E More

€1250 EUR in 20 days
(18 Reviews)
6.1
ratulcse10

Hello I'm interested to build the solution using the Java Spring Framework Please give me a response to talk in details Thanks Relevant Skills and Experience I did a Job Search Engine using Java Sprig You may check ht More

€764 EUR in 7 days
(45 Reviews)
5.9
ominfowave

Dear Client, We really want to discuss on this project and we will surely deliver you best quality service. Let's discuss and we serve a solution for your business needs. Warm Regards, Om Infowave Relevant Skills a More

€1529 EUR in 40 days
(26 Reviews)
6.1
deepakmishra1988

Hi, Appreciate the detailed requirement and the approach. We will make the web app scalable with REST APIs that can be used internally as well exposed. Relevant Skills and Experience Have over 8 years of experience w More

€1323 EUR in 20 days
(42 Reviews)
6.0
xiaolinsoft

Hello. My name is Xiao, and I am a Web developer you are looking for. I am very interested in your job and very confident. Relevant Skills and Experience I have been developing web apps for 5+ years. And I am very exp More

€1500 EUR in 20 days
(10 Reviews)
5.4
MrtDolphin

HI. I am programming king. Relevant Skills and Experience [login to view URL] [login to view URL] [login to view URL] Proposed Milestones €1323 EUR - according to discussion I can build your o More

€1323 EUR in 20 days
(9 Reviews)
5.4
tekzee

Hello, Hope you are doing well. I have read your description I am a freelancer having more than 6 years of experience in the same domain. Relevant Skills and Experience Xcode IDE(Objective-C), Swift, Eclipse IDE, An More

€794 EUR in 20 days
(8 Reviews)
5.2
amitorada

Can you send me sample file of excel to be uploaded on web server . Relevant Skills and Experience I have 7+ years of experience in PHP/MySQL development with good hand on MVC based working pattern. I will give you on More

€1323 EUR in 20 days
(12 Reviews)
5.1
cgullapalli

HI, I have very good experience in Java to transfer Excel data to MySQL. I would like to discuss further in the chat to get the complete detailed scope in addition to the description. -Chandra Relevant Skills and Exp More

€1500 EUR in 5 days
(25 Reviews)
4.8
tapsbharg

Hello, I have been in this industry for last 4 years and such jobs are my daily practice. I can assure you that if you work with me once, you will always work with me for these kind of projects. Relevant Skills and Ex More

€1500 EUR in 20 days
(8 Reviews)
4.7
Kaki08

A proposal has not yet been provided

€1250 EUR in 20 days
(0 Reviews)
0.0