adding categories and links for the first time

[sanjeev]

Hi all,

I have an installation of indexu running.
I successfully used the dmoz extractor to
extract the rdf's(content and structure) from
rdf.dmoz.org.
I edited the files to use only a subset of the
categories and links, pertinent to Thailand,
i.e Top/Regional/Asia/Thailand
and successfully imported this data into my
indexu database.

Now my question is how do I go about adding the
categories/subcategories/links other than to enter
them one by one from indexu admin panel ?
Isn't there an easier way than that ?
Having to manually input each and every subcategory and link
does not look very elegant, if I may add.
There must be another way.

Thanks in advance.

sanjeev from Bangkok, Thailand

[sanjeev]

I am using indexu3.2 btw.

[esm]

i think the dmoz extractor allows you to extract categories too.


.

[sanjeev]

i think the dmoz extractor allows you to extract categories too.


.

Of course it does !
I have successfully imported the categories into indexu database.
Now must I also add categories/subcategories through the indexu
admin panel ? One by one ?
I hope you realized what my problem is.
Please help.

Thanks in advance,
sanjeev

[esm]

once you have extracted the links or categories, you go to the Database Tables section on the left side of the Admin Control Panel and select the Import hyperlink option. this should allow you to import either the links or categories that you have extracted.


.

[sanjeev]

once you have extracted the links or categories, you go to the Database Tables section on the left side of the Admin Control Panel and select the Import hyperlink option. this should allow you to import either the links or categories that you have extracted.


.

I did that too. I used the indexu admin panel to import my links and categories, and the data is all there in my indexu database.
Now what do I do ?

[esm]

view the categories and links using your browser. once you have imported them, they are ready to be viewed.



.

[sanjeev]

But my index.php page does not have the listings ?
I mean I would like it to appear like this ....pretty much the standard format.

////........categories

Arts and Entertainment (72)
Business and Economy (524)
Education (76)
Employment (69)
Government (106)
Guides and Directories (12)
Health (35)
Localities (60)
Maps and Views (8)
News and Media (56)
Provinces (1537)
Real Estate (4)
Recreation and Sports (32)
Science and Environment (25)
Society and Culture (149)
Transportation (117)
Travel and Tourism (251)
//--------end of categories-----

clicking on a particular category should take me to the subcategories and clicking on them should give me the links. Pretty standard stuff - but the
categories do NOT show up on the main page.
So what do I do ?

Thanks for your help. Greatly appreciated.

sanjeev.

[esm]

can you use phpmyadmin and view the idx_category table and see the categories? the links are in the idx_link table.

[sanjeev]

can you use phpmyadmin and view the idx_category table and see the categories? the links are in the idx_link table.

Yes I can.
idx_category has 360 records.
idx_category_path has 360 records.
idx_link has 2570 records.

But the categories still don't show up on the main index page of
my public area.

Thanks in advance.
sanjeev

[esm]

did you run the update category path from the Admin Control Panel?

you could try running the following sql statement while in phpmyadmin:

select * from $this->table_name where (parent_id = 0 and visible = 1) order by name

or

select * from $this->table_name where parent_id = 0 order by name

or you can check the category records and look at the parent_id and visible fields. Almost all of the categories should have the visible field set to 1. All of the top level categories should have the parent_id set to 0.

if the parent_id is not set to 0, then the category will not show up on the main category page.


.

[sanjeev]

Hi esm,

Thanks. Setting visible=1 solved the problem partially.
Now all my categories as well as subcategories show up on my main
index page.
Now I don't want the subcategories on my main index page,
only categories.
In idx_category ALL records have a parent id of 0. This needs to be changed I guess, so how do I order/change it.

Thanks a ton for your help. I have been playing with indexu trying to get
a decent demo up and running for almost 3 weeks now. :-(

regards,
sanjeev

[esm]

well, I don't recall the extractor doing the categories that way.

all you can do is come up with some manual method to do it.


.

[sanjeev]

well, I don't recall the extractor doing the categories that way.

all you can do is come up with some manual method to do it.


.

I have a registered copy of the dmoz extractor.

All I get for categories is: [category_id, name, category_path]
For links I get: [link_id, category_id, category_path,title, url, description]

There's no mention of any parent_id anywhere in the dmoz extracted files. In the idx_category table parent_id is ALL zero.

I even tried extracting again, this time adding a parent_id attribute,
but the fields all came out blank.

OK. Seems I have to do it manually. I have a total of 360 categories.
Need to break them up into groups and assign the parent_id to the
subcategories.
Any ideas on how to do this ?

Thanks in advance.

sanjeev.

[sanjeev]

Hi Esm,
Supposing I have the following structure. And If I was to assign the parent_id's manually would it be something like this ? Top level
categories (arts and entertainment, Business and economy having parent_id=0)
and others having it sequentially as shown below.
What about subcategories ?

Any clarifications/light you can shed on this matter would be highly
appreciated.

Thanks in advance,
sanjeev.

Arts and Entertainment (72) 0
Architecture (2) 1
Bangkok (6) 2
Clubs and Venues (5) 3
Clubs and Venues (1) 4
Crafts (8) 5
Events (1) 6
Language (24) 7
Literature (6) 8
Movies (5) 9
Music (19) 10
Phuket (1) 11
Restaurants and Bars (6) 12
Visual Arts (13) 13

Business and Economy (524) 0
Bangkok (125) 14
Chiang Mai (55) 15
Computers and Internet (145) 16
Construction and Maintenance (5) 17
Directories (15) 18
Employment (69) 19
Financial Services (24) 20
Industries (108) 21
Legal Services (12) 22
Organizations (7) 23
Phuket (86) 24
Printing (1) 25
Real Estate (4) 26
Restaurants and Bars (6) 27
Shopping (72) 28
Travel Services (96) 29