Encerrado

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.

Habilidades: Programação C, PHP, Arquitetura de software

Veja mais: php code to devolep a sale form, php code for developing a home page of a system, data entry worksheet excel, php, android, wordpress, 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

Acerca do Empregador:
( 7 comentários ) Norcross, United States

ID do Projeto: #14704955

24 freelancers estão ofertando em média $192 nesse trabalho

TenStar718

Hello, and thanks for the opportunity to bid on your project. https://www.freelancer.com/u/TenStar718.html I am an expert in many different area’s of web and mobile applications based on the following languages: W Mais

$210 USD in 3 dias
(249 Comentários)
8.7
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 Mais

$200 USD in 5 dias
(264 Comentários)
7.6
$155 USD in 3 dias
(69 Comentários)
7.1
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: [login to view URL] http://hollanddutchsports Mais

$133 USD in 3 dias
(17 Comentários)
6.6
$187 USD in 3 dias
(113 Comentários)
6.7
intellisenseIN

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 in 7 dias
(22 Comentários)
6.2
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 Mais

$155 USD in 3 dias
(43 Comentários)
5.8
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 dias
(52 Comentários)
5.8
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 Mais

$200 USD in 3 dias
(26 Comentários)
5.8
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 Mais

$250 USD in 3 dias
(39 Comentários)
5.4
abbalove

Hey, can you give me sample files? Rocky .

$225 USD in 4 dias
(43 Comentários)
5.1
EastIndiacom

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 Mais

$35 USD in 3 dias
(38 Comentários)
5.1
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 Mais

$155 USD in 3 dias
(6 Comentários)
4.6
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 Mais

$200 USD in 3 dias
(20 Comentários)
4.6
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 Mais

$150 USD in 3 dias
(15 Comentários)
4.1
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 Mais

$220 USD in 3 dias
(19 Comentários)
4.8
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 Mais

$244 USD in 3 dias
(17 Comentários)
5.1
alliedamit

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 Mais

$200 USD in 3 dias
(13 Comentários)
4.1
managerwmg

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 in 10 dias
(3 Comentários)
3.2
ksinghrajeev

A proposal has not yet been provided

$250 USD in 20 dias
(3 Comentários)
2.9