Paste from Excel Importer

In Progress

We are a team of developers seeking some extra help. Have you seen the mailChimp mail list importer? this is what we need.

User pastes some Excel data into a text box. This is parsed and presented back to the user so he can map the columns to the corresponding fields in a database table.

At the core, you sould develop a function that is called with two parameters:

1. a string containing the data

2. an array of fields to match. (ex. Id=>integer, date=>datetime, name=>varchar)

You will also create an elegant web interface where the user decides which column maps to which field. Sugesting matching names as default choices.

- User might paste data with or without column headings, so you should take that into account.

- User might paste values that don´t correspond to datatype... so you should do some basic validation of this and disable incorrect field choices.

- User should be able to drop unecessary columns.

The output should be an associative array with the resulting data.

To show your understanding of this requirements and qualify for this project, please send PM with a sample output of 2 rows and 2 columns of the result of:

print_r($yourResultingArray)

- for an extra chance of wining this project, tell us about another nice feature you feel this importer should have.

If your work turns out to be fast and high quality, we will very likely be hiring you in an hourly base for many other widgets.

Thank you!

Skills: jQuery / Prototype, PHP

See more: what is string matching, web developers for hiring, we are hiring web developers, tell php developers what you need, string matching in c, prototype widgets, prototype validation, prototype maps, prototype map, prototype help, prototype date, names of web developers, matching string, map string, jquery team, jquery developers, hiring php developers, excel developers, developers hiring, developers for hiring, hiring developers, string matching, hiring we developers], excel function, excel ex

Project ID: #4747776

Awarded to:

ceruleusX

Hi, I'm PHP/MySQL/jQuery expert and I woul really like to work on this. Thanks in advance.

$15 USD / hour
(10 Reviews)
3.9

4 freelancers are bidding on average $21/hour for this job

rajeshsonisl

Quality work assured. Ready to get started. Thanks.

$41 USD / hour
(396 Reviews)
7.0
truongnx15fl

Hi, I have experience in building a page for importing form copy/paste data from excel. The result of your sample print_r function somehow looks like array([0] => array('id' => 1, 'date' => 'YYYY-MM-DD', name => 'Sampl More

$10 USD / hour
(33 Reviews)
4.8
jparimal

Hello Sir, I am professional php programmer working on PHP/Smarty/JavaScript/HTML/AJAX/jQuery/CodeIgniter/ZendFramework/Drupal, since last 6 years(individually). Below are some of my works. --------------------- More

$16 USD / hour
(16 Reviews)
4.7
shreeyait

Please check our private message.

$11 USD / hour
(2 Reviews)
2.1
davudsamuael

Hi, My name is David and I am working as a Project Coordinator for Offshorent, located in Philadelphia suburbs. We are interested to have a long term relationship with you. Availability: Immediately / Daily We p More

$12 USD / hour
(0 Reviews)
0.0