Suljettu

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.

Taidot: C-ohjelmointi, PHP, tietojärjestelmäarkkitehtuuri

Näytä lisää: 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

Projektin tunnus: #14704955

31 freelanceria on tarjonnut keskimäärin 188 $ tähän työhön

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 Lisää

210 $ USD 3 päivässä
(183 arvostelua)
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 Lisää

200 $ USD 5 päivässä
(204 arvostelua)
7.2
187 $ USD 3 päivässä
(107 arvostelua)
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 7 päivässä
(17 arvostelua)
6.1
155 $ USD 3 päivässä
(44 arvostelua)
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 Lisää

250 $ USD 5 päivässä
(58 arvostelua)
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 Lisää

200 $ USD 3 päivässä
(25 arvostelua)
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 Lisää

133 $ USD 3 päivässä
(6 arvostelua)
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 Lisää

155 $ USD 3 päivässä
(10 arvostelua)
4.5
abbalove

Hey, can you give me sample files? Rocky .

225 $ USD 4 päivässä
(21 arvostelua)
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 Lisää

200 $ USD 3 päivässä
(13 arvostelua)
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 Lisää

155 $ USD 3 päivässä
(5 arvostelua)
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 Lisää

220 $ USD 3 päivässä
(18 arvostelua)
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 Lisää

150 $ USD 3 päivässä
(14 arvostelua)
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 3 päivässä
(15 arvostelua)
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 Lisää

222 $ USD 3 päivässä
(22 arvostelua)
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 Lisää

250 $ USD 3 päivässä
(9 arvostelua)
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 Lisää

244 $ USD 3 päivässä
(6 arvostelua)
3.4
35 $ USD 3 päivässä
(2 arvostelua)
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 Lisää

140 $ USD 3 päivässä
(5 arvostelua)
3.2