Cancelled

Google Category Taxonomy to specific format using PHP

Hi,

I need someone to reformat the following list of categories and subcategories form the following list:

[url removed, login to view]

to this specific format (see first five lines example below) using a PHP script and then export this to a CSV file or MySQL DB:

CatName CategoryID ParentID Level

Animals 1 0 1

Live Animals 2 1 2

Pet Supplies 3 1 2

Bird Supplies 4 3 3

Bird Cages & Stands 5 4 4

and so on...

The CategoryID is as you can see is just a auto increment from 1 to infinite, also, all the main categories have ParentID 0 and the subcategories have ParentID of immediate previous category and have also been stripped from the sequence (e.g. from Animals > Pet Supplies > Bird Supplies > Bird Cages & Stands to Bird Cages & Stands) and the Level (starts at value 1) will correspond to the position of the category from the sequence (Animals = 1, Animals > Live Animals = 2 and so on).

This is how it should not look for subcategories CatName since this will be assumed by the ParentID:

CatName CategoryID ParentID Level

Animals > Live Animals 2 1 2

Animals > Pet Supplies 3 1 2

Animals > Pet Supplies > Bird Supplies 4 3 3

Animals > Pet Supplies > Bird Supplies > Bird Cages & Stands 5 4 4

When processed, this data should be saved to a CSV file or to a MySQL DB in the format above.

If you can do it and can send the PHP script as soon as possible, please bid.

The lowest bid and fasted delivery will win.

This project has a secondary purpose for category mapping of products, so if you do it well you will also get the upcoming project.

Skills: Data Entry, Data Processing, Excel, MySQL, PHP

See more: reformat data, how to win a project bid, five below, c# category, taxonomy, specific, pet delivery, google-form, google form-2, export php, csv php, mysql specific, export mysql data txt, php script mysql export, processing export, need form processing script, google form data, export mysql script, products php script, format file, form data csv php, php mysql taxonomy, auto bid script php, file csv php, export data mysql txt file

About the Employer:
( 2 reviews ) Hove, United Kingdom

Project ID: #1251368

3 freelancers are bidding on average $73 for this job

allhen

Ready to help you with this.

$140 USD in 3 days
(69 Reviews)
5.8
skynyxtech

I am ready for this task ...

$30 USD in 0 days
(1 Review)
1.0
nimmytony

Hi, Please check your PM. Thank You.

$50 USD in 2 days
(0 Reviews)
0.0