Closed

Write PHP code manipulate Excel worksheet and store data in DB

The right candidate is to convert headers and data from older version of an excel template to a newer version while placing data into a DB. Please see attached files for examples.

The software is to be cloud-based.

The old and new templates have header fields located on different columns in the sheets. The templates have different header-text for same type of data. For example, a field may contain “Name Last” in one template and “Last Name” in another. This is to be mapped and placed into a DB before generating this data into a new mapped excel template.

You must have very clean and good looking dialog interface as well as structured code.

A. Template Header Saving function [see files Template1(old) Template2(old) and Template3(new)]:

1. Read file headers, create and save template headers containing 3 top lines. Name it like: Template1 4321.1234. This is a one-time function for each template.

B. Header Mapping:

1. Present one-page dialog to allow mapping between old Template (in this case template1 & 2) to DB fields.

2. Present one-page dialog to allow mapping between DB fields to new template (in this case template3).

C. Data Store to DB:

1. Read and Save data from old template to DB

D. Create new template with data:

1. Allow user to choose new template name & version to create records into it.

2. Show DB records with “Select” checkbox to choose records to be placed into new template.

3. After user completes “Selection” above, create an excel file with new template headers and placing relevant fields into mapped fields then open the file on desktop.

You must be able to communicate over skype for the duration of this task. Message me at ikbalmaya on skyep if you have further questions.

Skills: C Programming, PHP, Software Architecture

See more: php code to devolep a sale form, php code for developing a home page of a system, data entry worksheet excel, convert html excel php code, send form data excel file php code, send data html form excel php, php code sending data excel, php code export mysql data ms excel, data db import excel java, software write mq4, software write chip epson, useful software write book, software write web specs, php code import data excel mysql, free software write user guide, software write edid, free software write company profile, php code store data file, export data excel using php code charge, software write websites idea, php code extract data excel sheet, software write book images, software write books, software write protection, free software write book

About the Employer:
( 7 reviews ) Norcross, United States

Project ID: #14704955

31 freelancers are bidding on average $188 for this job

TenStar718

Hello, and thanks for the opportunity to bid on your project. [url removed, login to view] I am an expert in many different area’s of web and mobile applications based on the following languages: W More

$210 USD in 3 days
(183 Reviews)
8.2
mascotindia123

Hey Friend, Myself having has 10 + years experience of web site development. Expert in Custom programming in php / Mysql / Jquery / Wordpress/ Joomla / OSC / Magento /OpenCart / Android / Mobile development / Res More

$200 USD in 5 days
(204 Reviews)
7.2
$187 USD in 3 days
(107 Reviews)
6.6
intellisenseIN

Could you clear point number 2 and 3 rest is clear to me and I am ready to start Relevant Skills and Experience [url removed, login to view] Proposed Milestones $277 USD - Websites developments

$277 USD in 7 days
(17 Reviews)
6.1
$155 USD in 3 days
(44 Reviews)
5.9
rmihov

I can write a code to manipulate EXCEL files as you you have descibed. Which cloud you have in mind? I do not see any attached documents. Please re-attach them. Relevant Skills and Experience PHP5 & PHP7, MySQL, CodeI More

$250 USD in 5 days
(58 Reviews)
6.5
Solitare123

I have gone through all the requirements and understand the job role. I ready to take responsibility of this projects with interest and I am available & willing to work. I believe in work. Relevant Skills and Experien More

$200 USD in 3 days
(25 Reviews)
5.8
artistixeit

***We have done similar work according to your requirement *** our focus is on providing satisfactory service to the client…. Please check the work below: [url removed, login to view] http://hollanddutchsports More

$133 USD in 3 days
(6 Reviews)
5.1
ieota

We at IEOTA TECHNOLOGIES have lot of exposure and experience in development for past 4 years served for several clients across the globe. We have fabulous developers who have extreme knowledge in coding and vast experi More

$155 USD in 3 days
(10 Reviews)
4.5
abbalove

Hey, can you give me sample files? Rocky .

$225 USD in 4 days
(21 Reviews)
4.3
satyaowlok

Warm Greetings !!! Hope you are doing well !!! I have gone through all your requirements and understood that you want to php code manipulate into ecxel sheet Relevant Skills and Experience I have expertise in PHP, Wo More

$200 USD in 3 days
(13 Reviews)
4.4
shahalam7303

Hello Sir, I have properly gone through your job description and understood your requirements. I'm very eager to work on this project and will definitely make a successful delivery before deadline. Relevant Skills an More

$155 USD in 3 days
(5 Reviews)
4.6
pinaliv

5 Reasons why you should hire me for your custom website and Application Development. 1. Available 24/7 upon your request 2. Delivery on-time with 100% satisfaction 3. Always think beyond boundaries and. provide More

$220 USD in 3 days
(18 Reviews)
4.8
shahjahansiraj

Hello I have long experience in this field. I can provide you perfect solution. I can work full time or part time for you. Hope to meet you and discuss please. Thanks Relevant Skills and Experience PHP , Software Pro More

$150 USD in 3 days
(14 Reviews)
4.1
attsoftware

i have done the same for an online examination system website Stay tuned, I'm is still working on this proposal.

$250 USD in 3 days
(15 Reviews)
4.2
laiek2424

i have 6 yrs experience in Codeignitor,[url removed, login to view],css,html5,[url removed, login to view],net,c,crystal report etc. Relevant Skills and Experience i have 6 yrs experience in Codeignitor,[url removed, login to view],css,html5,[url removed, login to view],net,c,crystal report e More

$222 USD in 3 days
(22 Reviews)
4.1
GauravNargotra

Hello I am full time freelancer web developer and expert in PHP,MYSQL, WordPress,Joomla, magento, Theme development, wordpress plugin development,Component development,Module development, Relevant Skills and Experienc More

$250 USD in 3 days
(9 Reviews)
3.6
hiteshkumar2

Hello I understand your requirements. I am able to do this work according to your needs. I have 2 year hand on experience in web development and one year as front end developer. I have sound knowledge of Wordpress More

$244 USD in 3 days
(6 Reviews)
3.4
$35 USD in 3 days
(2 Reviews)
3.2
chiragim

Dear hiring manager, Hope you are doing well!! I have gone through the project description. As per the given brief you are looking for a Web expert cum Designer to build a site Responsive site. I am a professi More

$140 USD in 3 days
(5 Reviews)
3.2