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

Tietoa työnantajasta:
( 7 arvostelua ) Norcross, United States

Projektin tunnus: #14704955

26 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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ä
(39 arvostelua)

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ä
(35 arvostelua)

Hello, and thanks for the opportunity to bid on your project. 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ä
(213 arvostelua)

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ä
(239 arvostelua)
$187 USD 3 päivässä
(113 arvostelua)
$155 USD 3 päivässä
(56 arvostelua)

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

$277 USD 7 päivässä
(18 arvostelua)

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ä
(59 arvostelua)

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ä
(26 arvostelua)

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

$133 USD 3 päivässä
(9 arvostelua)

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ä
(50 arvostelua)

Hey, can you give me sample files? Rocky .

$225 USD 4 päivässä
(43 arvostelua)

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ä
(6 arvostelua)

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ä
(18 arvostelua)

Hello, I will deliver the BEST OUTCOME with in the time and budget, really looking forward to working on this project and I am very [login to view URL] you. Relevant Skills and Experience I am a coder with 9+ years of ex Lisää

$35 USD 3 päivässä
(11 arvostelua)

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ä
(15 arvostelua)

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ä
(15 arvostelua)

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ä
(19 arvostelua)

Dear Sir, Hope you are doing great!! We have worked on more than 200 computer softwares, websites / web portals with any required API /B2B integrations, Mobile apps.(ios&android), Betting Bot(odd/even), mobile gam Lisää

$200 USD 3 päivässä
(13 arvostelua)

Hey. I'll do this job very quickly. I really need it. I look forward to hearing from you in the chat and telling you what to do.

$222 USD 10 päivässä
(3 arvostelua)