Switch to English version?

Yes

Переключитись на українську версію?

Так

Переключиться на русскую версию?

Да

Przełączyć się na polską wersję?

Tak

Login
Registration
- Welcome to Freelancehunt
  
  Work risk-free, saving time and money
  
  Login Registration

Post your project for free and start receiving proposals from freelancers within minutes after publication!

41 USD

Parking of a website in a database

41 USD

Data Parsing

6 out of 6

project complete

publication
open for proposals
terms confirmation
reservation
work underway
project complete

Project translated automatically. Log in or register, to view the original

The main task is to parsing data from a site to a new MySQL database.Copy the entire catalogue from the site with partners, including its structure by categories.We need exactly the BD with the product classification with their hierarchy, exactly as on the site: https://www.digikey.com/products/enExample:Integrated Circuits (ICs) > Clock/Timing - Application Specific There is a group of Integrated Circuits (ICs) in which the Clock/Timing - Application Specific subgroup and there are some details.This subgroup of details has a lot of different parameters.And these parameters in different groups and subgroups differ in type and number.It is necessary to copy the necessary data for us from the page (the site has the possibility to draw 500 lines per page for convenience, and even the possibility to download in the CSV format of the entire table, but there is probably some limitation to protect the information)If possible, it would be bad to realize the possibility not to add in the BD unnecessary data for us, since.Bd will be so big and excessive information for us to nothing.For example, the data from these columns are not interesting to us "Compare Parts", "Datasheets", "Image", "Digi-Key Part Number", "Quantity Available", "Unit Price USD", "Minimum Quantity" Some positions differ only by the data "Digi-Key Part Number" and "Quantity Available", which we don't need.Therefore, if you remove these data, there will be lines where all the data are absolutely identical.It will need to implement some mechanism of removal of these duples immediately at the stage of parsing.For us, the most basic is the data in the columns "Manufacturer Part Number", "Manufacturer" and the group and subgroup to which these data belong, and of course it is necessary that such data do not duplicate.The program itself for periodic parsing we don’t need, it’s precisely a ready BD.

Необходимая структура БД:

Таблица 1: Brands
id – уникальный
brand_name – наиманование бренда на английском из столбца «Manufacturer»

Таблица 2: Sections Разделы (типы устройств)
id – уникальный
section_name – наименование раздела или подраздела на английском
parent_id – id для определения принадлежности section_name к разделу или подразделу

Таблица 3: Partnumbers
id – уникальный
part_number – уникальный парт-номер без пробелов, только заглавными из столбца «Manufacturer Part Number»
type_id – id раздела из таблицы 2
brand_id – id бренда из таблицы 1
params – параметры в формате json (имя параметра: значение) из всех оставшихся нужных столбцов

Client's review of cooperation with Vladislav N.

Quality

Professionalism

Cost

Contactability

Deadlines

The work is done quickly and in time. I recommend cooperation

Profile deleted | Safe

Freelancer's review of cooperation with client

Payment

Task setting

Clarity of requirements

Contactability

Clear TZ, the customer is always in contact. Thank you for cooperation!

Vladislav N. | Safe

Proposals 6
Discussion 2

by default date online rating cost completion time

Winning proposal41 USD

Vladislav N.

284

Winning proposal41 USD

Good day . Ready to disperse all information (at the condition that we take data from the list page). Duplicates and unnecessary data will be deleted. The results will be submitted in the form of MySQL.
Here is the main problem that each category has its own set of characteristics. Therefore, we need to discuss with you how to organize tables in the base (depend on your use scenario).

Show original

Translate

14 March 2019, 13:13

66 USD

Yury Zhilin

66 USD

I do, it is possible to pay on the collection card, the deadline indicated with the stock
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~

Show original

Translate

13 March 2019, 15:45

Another 4 proposals concealed

Vladislav N.

Добрый день. В каком формате вам нужна база данных: MySql, SqlServer, набор csv файлов?

Profile deleted

MySQL

Current freelance projects in the category Data Parsing

A specialist in Telegram promotion is required. 29 USD Tasks: invite real users from the username database to new chats and send messages to the target database. Only quality traffic and work with a live audience are of interest — performers using bots, fake engagement, or low-quality methods are requested NOT TO DISTURB. Work… Data Parsing, Social Media Marketing (SMM) ∙ 1 day 3 hours back ∙ 6 proposals	29 USD
Collection of B2B database of companies in Germany 40 USD Goal: To obtain a list of potential employers (clients) for B2B mailing. Region: Munich (München) + radius of 50 km. Required niches: Construction companies (Bauunternehmen) Food enterprises (Lebensmittelhersteller, meat processing plants, bakeries) Logistics and… Data Parsing, Lead Generation & Sales ∙ 1 day 5 hours back ∙ 26 proposals	40 USD
Carrier database Interested in compiling a database of carriers in Ukraine for the year 2026, including tankers, tarpaulins, grain carriers, and others. It is preferable to develop a table. Information Gathering, Data Parsing ∙ 1 day 6 hours back ∙ 29 proposals
Consultation on parsing Instagram account subscribers Hello. It is necessary to conduct a preliminary assessment of the feasibility of the following task. I have a list of Instagram accounts. The goal is to obtain contact information (primarily email addresses) of users who follow these accounts. Previously, I encountered companies… Data Parsing ∙ 4 days 22 hours back ∙ 12 proposals
A specialist is needed to find contacts of decision-makers in Ukraine. It is necessary to gather a database (or ready database) of contacts of decision-makers (DMs) in companies in Ukraine. Information Gathering, Data Parsing ∙ 5 days 2 hours back ∙ 18 proposals

Profile deleted

Parking of a website in a database

Client's review of cooperation with Vladislav N.

Freelancer's review of cooperation with client

Current freelance projects in the category Data Parsing

A specialist in Telegram promotion is required.

Collection of B2B database of companies in Germany

Carrier database

Consultation on parsing Instagram account subscribers

A specialist is needed to find contacts of decision-makers in Ukraine.