Закрыт

Creating a schema out of an Excel spreadsheet

I have an excel sheet that I want to export to sql database. However, the excel file and the row items are not haveing a consisten schema, meaning there is a need to create a separate sheet that reads through the sheet and creates a schema out of the data.

It will be done updates to the original spreadsheet by adding, modifying and deleting product items so this needs to be reflected in the new spreadsheet and the schema created there.

the attached file shows the list of products which are just dumped into rows. However, the only predictable columns are Column D where the category names are registered. Column F,G,H are also predictable as they provide the size, year of production, price.

All the other items in the Column A need to be structured under level 1 through level 4 headings as they are actually hierarchicaly related.

an example row as expected row within the sql database is also provided.

the sample row is created from the main file from row 107-114.

I want an excel sheet that enables users to continue update the product list as is, but have another sheet within the same file to do its magic on the changes within the original sheet and create a structured schema that can be used for export to the database.

Навыки: Разное, Бизнес-анализ, Бизнес-планы , Управление базами данных, MySQL, SQL

Показать больше: structured schema excel, schema update, production spreadsheet, excel spreadsheet business, creating business plans, example of business plans, example business plans, schema, row spreadsheet, export from excel, excel to sql, creating sql, create spreadsheet, create an excel, spreadsheet price list, spreadsheet columns, excel row column, excel column update, excel sql create, schema sql

О работодателе:
( 1 отзыв ) lysaker, Norway

ID проекта: #3141727

11 фрилансеров(-а) готовы выполнить эту работу в среднем за $61

gribfritz

See private message.

$55.25 USD за 7 дней(-я)
(472 отзывов(-а))
7.6
vnb400sl

See private message.

$68 USD за 7 дней(-я)
(139 отзывов(-а))
6.0
amcsummers

See private message.

$119 USD за 7 дней(-я)
(46 отзывов(-а))
5.2
vserv

See private message.

$17 USD за 7 дней(-я)
(24 отзывов(-а))
3.4
innovativementis

See private message.

$68 USD за 7 дней(-я)
(1 отзыв)
2.1
ieinfotech

See private message.

$42.5 USD за 7 дней(-я)
(8 отзывов(-а))
2.5
thethird

See private message.

$42.5 USD за 7 дней(-я)
(1 отзыв)
1.1
efficode

See private message.

$67.15 USD за 7 дней(-я)
(0 отзывов(-а))
4.8
gborromeo

See private message.

$127.5 USD за 7 дней(-я)
(0 отзывов(-а))
0.0
clgarcia

See private message.

$42.5 USD за 7 дней(-я)
(0 отзывов(-а))
0.0
FSchnabel

See private message.

$20 USD за 7 дней(-я)
(0 отзывов(-а))
0.0