Find Jobs
Hire Freelancers

Cut and paste data entry

$30-250 USD

In Progress
Posted about 15 years ago

$30-250 USD

Paid on delivery
Overview An existing client would like to rebuild an on-line catalog for their mirrors. Essentially, the new design is finished, but data entry is needed. What is needed is information to be taken from an online catalog and placed into a MySQL Table. The source of the online catalog is: [login to view URL], and the sub directories linked from that page. On this page, you will see several links to other pages that have the products. If you click on each of the main section (Frameless all, Lacquer all, wood all, etc..) you will see a listing of products in each section. What I need is the information from those screens moved into the table below. CREATE TABLE `items` ( `id` int(12) NOT NULL auto_increment, `name` varchar(60) NOT NULL, `description` text NOT NULL, `item_id` int(12) NOT NULL, `image1` varchar(40) NOT NULL, `image2` varchar(40) NOT NULL, `image3` varchar(40) NOT NULL, `id_1` int(6) NOT NULL, `size_1` varchar(250) NOT NULL, `price_1` decimal(10,2) NOT NULL, `id_2` int(6) NOT NULL, `size_2` varchar(250) NOT NULL, `price_2` decimal(10,2) NOT NULL, `id_3` int(6) NOT NULL, `size_3` varchar(250) NOT NULL, `price_3` decimal(10,2) NOT NULL, `id_4` int(6) NOT NULL, `size_4` varchar(250) NOT NULL, `price_4` decimal(10,2) NOT NULL, `id_5` int(6) NOT NULL, `size_5` varchar(250) NOT NULL, `price_5` decimal(10,2) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=utf8 AUTO_INCREMENT=40 ; There are two types of item listings on each of the pages: item listings that have one size only, and item listings with multiple sizes. Below is the information that is needed and examples from single and multiple listings. The only information that you need to put in is: Name -> a three digit number from the HTML page. The number is either listed first, in the case of single size entries, or the first 3 digit number in the size listing , Description -> The main description of the item without prices and without the item number, and price Item_id -> a integer from the below table, depending on the section you are getting the information from. If the item is from the Frameless section, the integer would be 3. 2, 'Metal', '' 3, 'Frameless', '' 4, 'Gold', '' 5, 'Laquered', '' 6, 'Wood', '' 11, 'Chevel', '' The next information needed is id_#, price_# and size_# Single size listings only have information in id_1, size_1 and price_1. 2-5 are null. Multiple listings have information in _1 through the number of listings (to a max of _5). The value of id_1 is the same as the id above. Size_1 is equal to addslashes value found by the description Price_1 is found at the end of each line listing. Single size entries are done at that point, multiple line entries get additional information in the _2 line. This would be continued for items with three listings or more. For more clarification, here a HTML form that they use to input the items: Here is an example to the information in the frameless section: I have provided a MySQL example of the first couple of rows: INSERT INTO `items` (`id`, `name`, `description`, `item_id`, `image1`, `image2`, `image3`, `id_1`, `size_1`, `price_1`, `id_2`, `size_2`, `price_2`, `id_3`, `size_3`, `price_3`, `id_4`, `size_4`, `price_4`, `id_5`, `size_5`, `price_5`) VALUES (34, '316', 'Hardboard backing and hooks allow for mounting in a vertical or horizontal orientation. American made for amazing quality. Free shipping in the continental United States.', 3, '[login to view URL]', '', '', 316, '24\\" wide, 34\\" high and 3/8\\" deep', 189.00, 0, '', 0.00, 0, '', 0.00, 0, '', 0.00, 0, '', 0.00), (33, '303', 'Oval Frameless mirror features a 1\\" beveled edge. Hardboard backing and hooks allow for mounting in a vertical or horizontal orientation. American made for amazing quality. Free shipping in the continental United States.', 3, '[login to view URL]', '', '', 303, '22\\" wide, 28\\" high and 3/8\\" deep', 149.00, 304, '20\\" wide, 27\\" high and 3/8\\" deep', 149.00, 305, '23 1/2\\" wide, 33\\" high and 3/8\\" deep', 169.00, 306, '28\\" wide, 40\\" high and 3/8\\" deep', 209.00, 307, '24\\" wide, 36\\" high and 3/8\\" deep', 169.00), (35, '309', 'Hardboard backing and hooks allow for mounting in a vertical or horizontal orientation. American made for amazing quality. Free shipping in the continental United States.', 3, '[login to view URL]', '', '', 309, '23 1/2\\" wide, 30 1/2\\" high and 3/8\\" deep with a 1\\" beveled edge', 229.00, 0, '', 0.00, 0, '', 0.00, 0, '', 0.00, 0, '', 0.00), (36, '318', 'Hardboard backing and hooks allow for mounting in a vertical or horizontal orientation. American made for amazing quality. Free shipping in the continental United States.', 3, '[login to view URL]', '', '', 318, '24\\" wide, 30\\" high and 3/8\\" deep with a 1\\" beveled edge.', 209.00, 0, '', 0.00, 0, '', 0.00, 0, '', 0.00, 0, '', 0.00), (37, '308', 'American made for amazing quality. Free shipping in the continental United States', 3, '[login to view URL]', '', '', 308, '28\\" wide, 28\\" high and 3/8\\" deep with a 1\\" beveled edge', 169.00, 0, '', 0.00, 0, '', 0.00, 0, '', 0.00, 0, '', 0.00), (38, '327', 'Tri-View wall mirror features hinged side mirrors with 1\\" beveled edges. The overall measurements of this mirror are 38 1/2\\" wide, 30\\" high and 3/8\\" deep. American made for amazing quality. Free shipping in the continental United States.', 3, '[login to view URL]', '', '', 327, '38 1/2\\" wide, 30\\" high and 3/8\\" deep', 259.00, 0, '', 0.00, 0, '', 0.00, 0, '', 0.00, 0, '', 0.00), (39, '321', 'Octagon Frameless Mirror features a mirror on mirror with 1\\" beveled edges. Hardboard backing and hooks allow for mounting in a vertical or horizontal orientation. American made for amazing quality. Free shipping in the continental United States.', 3, '[login to view URL]', '', '', 321, '20\\" wide, 28\\" high and 1/2\\" deep', 179.00, 324, '24\\" wide, 32\\" high and 1/2\\" deep', 209.00, 0, '', 0.00, 0, '', 0.00, 0, '', 0.00); n this page, you will see several links to other pages that have the products. If you click on each of the main section (Frameless all, Lacquer all, wood all, etc..) you will see a listing of products in each section. What I need is the information from those screens moved into the table below. Required Deliverables 1). MySQL Table with the information detailed above.
Project ID: 390541

About the project

34 proposals
Remote project
Active 15 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

About the client

Flag of UNITED STATES
Macungie, United States
5.0
1
Member since Feb 20, 2009

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.