Đã hoàn thành

Excel file to Mysql upload design and coding with a lot of future work

We are looking for an individual or a team with php/ajax/bootstrap experience to do the following task:

- After logging into a website (check if user has logged in and has the correct privilege) the login page is currently working but the page that shows after needs to have the design implemented using the template,

- Using the Modern admin template's UI elements, components and design as well as the current database structure and functions on PHP files, create a page that will check whether the logged in user is in the correct rights group and then allow uploading an excel file which will be parsed and its contents written to a database table.

This page must have a sidebar as well and use the vertical-modern-menu-template.

Sidebar contents will be user rights dependent as well, you can add 2-3 for now just as placeholders.

We are using the Modern Admin Template (bootstrap) as such all pages must use the elements/components provided by the Modern Admin Template.

- The excel file has over 1041 columns of mostly text/varchar columns, with 1-2 to 100+ rows of data, all of which must be uploaded,

- Once uploaded, display the uploaded data on a table using the the actual name of each field (taken from a separate table called fullfieldnames),

- Make sure the fields that have the text Time_Allowed on them are displayed as number of minutes and amounts are displayed in their proper format,

- If another file is uploaded with the same Job No. (first field), then inform user that this is a dupe,

- If file cannot be imported due to mismatched field names the user must be informed of this,

- There must be no console errors or alerts/console logs/errors (file not found, script, etc.),

- The page must be responsive,

Upon successful upload of the file, log the following:

- The user who uploaded, time uploaded, corresponding job number into the changelog table.

- Code MUST be clean, follow best practices, documented and done with future development in mind,

- This must work on a Windows Server 2016 with IIS 10 installation, if any changes or additions are needed to the server (such as [login to view URL] modification, installation of node.js, etc.), details for this must be provided to me within 2 hours from start of work.

The database with the changelog, users, import, field names privileges and options as well as the template needed will be provided for ease of development.

The selected freelancer/team will have the opportunity to work on other aspects of this project for the next several months (4+ months) if this work is done with quality and clean/documented code with future development in mind and if the price is reasonable.

Please provide a fair price and note that this must be completed within 4 to 6 hours without errors in the import and display of imported data. Please do not bid if you cannot complete this within 4 to 6 hours from project award time as otherwise no payment given, only bid if you agree to this condition.

If you have any ideas for a better system due to the number of columns it can be modified and it will be appreciated as well.

Feel free to ask any questions you may have before accepting this project to make sure it's as clear as possible.

Thank you.

Kĩ năng: PHP, MySQL, HTML, AJAX, CSS

Xem nhiều hơn: php create excel file mysql, import excel file mysql using vbnet, reading excel file mysql database java, import excel file mysql database php, create excel file mysql data, data excel file mysql joomla, import excel file mysql export using php, write excel file mysql php, upload excel file mysql database php, code bulk upload excel file mysql database php, php classes upload excel file mysql, sample code upload excel file mysql components joomla , sample code upload excel file mysql php, upload excel file mysql database asterisk, upload excel file mysql php, upload excel file mysql database using php

Về Bên Thuê:
( 31 nhận xét ) Toronto, Canada

ID dự án: #22133722

Được trao cho:

AndreiVldmrvch

⭐Hello client⭐ I have read carefully your proposal. I am a professional full stack developer. * No Upfront-Amount needed to Begin your Project * Ready to Start as Immediate, Unlimited Revisions & Proper Testing * Keep Thêm

$250 CAD trong 4 ngày
(37 Đánh Giá)
6.0

12 freelancer đang chào giá trung bình $205 cho công việc này

taijin95

Hi. I am individual developer. I have just checked your job posting in detail. I can upload your excel file to mysql using PHP and ajax. I am sure that I can do it. Please contact me and let's start your project. Thank Thêm

$125 CAD trong 7 ngày
(17 Nhận xét)
5.1
StormLion227

Hello. My name is Marko and I am an Engineering Graduate with an MBA degree. I am a full time freelancer and I will work hard on this till completion. A AJAX, CSS, HTML, MySQL, PHP Expert on freelancer.com and I d Thêm

$200 CAD trong 1 ngày
(57 Nhận xét)
5.5
Alexsfodik

Hello, How are you. I read your description carefully and am very interesting in your project. I can start right now and I can confirm high quality. If you hire me,I will do my best for your job and you can get the bes Thêm

$125 CAD trong 7 ngày
(1 Nhận xét)
2.4
panther0103

Hello, Dear. I am a full time free develop and web expert. Let's make a great result out of the limit together. Please contact me if you want an outstanding result that exceeds your imagination. I am always trying to b Thêm

$200 CAD trong 7 ngày
(6 Nhận xét)
2.6
undeeadwork

⭐Dear client.⭐ [login to view URL] This is my preview work. This is similar to your job. If you are interested in my job, let's discuss the project in detail. Best regards.

$180 CAD trong 1 ngày
(4 Nhận xét)
2.6
kamschat

Hi! Nice to meet you! I have over 7 years experience of mysql server management. I have enough passion , strength and endurance. I will do my best to make clients satisfied with good quality and to meet timeline. I va Thêm

$110 CAD trong 7 ngày
(4 Nhận xét)
2.0
hubertnoyessie

Hi I’m software architect and have a lot of experience in build a robust and maintenance software. I have experimented this kind of work in my previous company. Let me describe it to you; The compagnies have at leas Thêm

$444 CAD trong 5 ngày
(3 Nhận xét)
2.0
jstopguru

Hello, Greetings!! I will love to assist you with this task, and I can start working immediately. Kindly message me so that we can discuss it further. Best Regards Boris

$250 CAD trong 7 ngày
(1 Nhận xét)
1.8
anexponent

Hi there, i went through your project and would like to work with you on this. I am well adept in PHP. I have done similar project though with frameworks.

$125 CAD trong 7 ngày
(0 Nhận xét)
0.0
meikramullah

Hello dear How are you? i have read your job details with high attention. ----first: authentication logic is required for this, one question. for this project, is it allow to use any framework such as Laravel or Codeig Thêm

$400 CAD trong 1 ngày
(0 Nhận xét)
0.0
vincentmabutas

I know how to use PHP and also I create and design web application depending on what task is needed and lastly I do have an experience in terms of creating database.

$50 CAD trong 2 ngày
(0 Nhận xét)
0.0