Importing Categories

Mark Brookes · 07-27-2006

Hi in my installation & configuration of ver 1.2 I have got as far as wanting to import my categories from another program.

I have been looking at phpMyAdmin table ??_categories and can see what most fields are about.

however there are 2 fileds that I simply cant understand. Please could some knowledgeable person tell me what they are for and what sort of values I should consider for them

num_cols

Don’t know what this is – in my test data some are NULL and some are “0”

neighbour

Don’t know what this is – in my test data some are NULL and some are “0”

Thanks
Mark

redeye · 07-27-2006

I think num_cols relates to the "Number of columns" field in edit category page in admin.
Not sure what it does. Originally thought it would set the number of columns that display in the sub-categories box for the individual category, but have tried that with no effect.

Only "neighbour" I can think of is Neighbouring categories. All my fields are set to 0 or null also, but I don't have Neighbouring categories enabled.

Mark Brookes · 07-27-2006

Thank you for your reply:

Quote:

Originally Posted by redeye

I think num_cols relates to the "Number of columns" field in edit category page in admin.
Not sure what it does. Originally thought it would set the number of columns that display in the sub-categories box for the individual category, but have tried that with no effect.

Now isn't that interesting

I had not noticed that field at the bottom of EDIT categories, I had just noticed that the screen looked the "same" as create categories - oops!

So ... hopefully there are some more knowledgeable people around who can help us both

redeye · 07-27-2006

Quote:

Originally Posted by Mark Brookes

So ... hopefully there are some more knowledgeable people around who can help us both

My bets on Greg, he's old enough to know everything

vccowner · 04-17-2007

Hi, I have eSyndicat installed and am trying to upload the common_categories.zip but there seems to be a number of SQL errors in it. Does anyone know if a revised version is in the offing? Need to be up and going promoting the new site (LinksOnDemand.org) in the next couple of weeks. Is there an alternate source file available?

Sergey Ten · 04-17-2007

Hello and welcome to our support forum vccowner,

Please read this post:
http://www.esyndicat.com/forum/about9949.html

John Turner · 04-17-2007

Hi vccowner,
Please follow this link
http://www.esyndicat.com/downloads/c...categories.zip

There is new common categories dump optimized for V2.1.03 with instructions.

jeykumar · 12-25-2008

This link doesn't seem to work. Can somebody help help how I can import categories in bulk?.

Regards,
Jey Kumar.

Simon Gooffin · 12-27-2008

Hi jeykumar

You can get the Common Categories Dump here.

alexhaidar · 01-21-2009

I am going crazy, I did the install perfectly, but all the pages I create are broken, none of the cateory pages are working, the system is a mess.

07-27-2006	#1
Mark Brookes Moderator Join Date: Mar 2006 Posts: 650	Importing Categories Hi in my installation & configuration of ver 1.2 I have got as far as wanting to import my categories from another program. I have been looking at phpMyAdmin table ??_categories and can see what most fields are about. however there are 2 fileds that I simply cant understand. Please could some knowledgeable person tell me what they are for and what sort of values I should consider for them num_cols Don’t know what this is – in my test data some are NULL and some are “0” neighbour Don’t know what this is – in my test data some are NULL and some are “0” Thanks Mark

07-27-2006	#2
redeye Moderator Join Date: Feb 2006 Location: UK Posts: 579	I think num_cols relates to the "Number of columns" field in edit category page in admin. Not sure what it does. Originally thought it would set the number of columns that display in the sub-categories box for the individual category, but have tried that with no effect. Only "neighbour" I can think of is Neighbouring categories. All my fields are set to 0 or null also, but I don't have Neighbouring categories enabled. __________________ LIFE IS SHORT ENOUGH SO DON'T MESS WITH ME FOOL! eSyndicat "integrated" into e107 CMS Yarm-Online BikerLinx

04-17-2007	#6
Sergey Ten eSyndiCat Lead Developer Join Date: Apr 2006 Location: Kyrgyzstan, Bishkek Posts: 5,710 Blog Entries: 13 Latest Blog Entry:	Hello and welcome to our support forum vccowner, Please read this post: http://www.esyndicat.com/forum/about9949.html __________________ Best regards, Sergey Ten *sten at intelliants.com* eSyndiCat Directory Script myBlog Submit your eSyndiCat Directory

12-27-2008	#9
Simon Gooffin Administrator Join Date: Sep 2005 Location: Intelliants LLC Posts: 8,382 Blog Entries: 2 Latest Blog Entry: thinking of downloads area	Hi jeykumar You can get the Common Categories Dump here. __________________ Best Regards, Web Directory Script, Auto Classifieds Script , Affiliate Management Script, Article Directory Script Recommended Hosting, Free Live Help Software IF YOU NEED TO CONTACT ME DO THIS IN HELPDESK. All PMs will be ignored

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

04-17-2007	#5
vccowner Newbie Join Date: Mar 2007 Posts: 3	Hi, I have eSyndicat installed and am trying to upload the common_categories.zip but there seems to be a number of SQL errors in it. Does anyone know if a revised version is in the offing? Need to be up and going promoting the new site (LinksOnDemand.org) in the next couple of weeks. Is there an alternate source file available?

04-17-2007	#7
John Turner eSyndicat Support Team Join Date: Sep 2006 Posts: 1,428	Hi vccowner, Please follow this link http://www.esyndicat.com/downloads/c...categories.zip There is new common categories dump optimized for V2.1.03 with instructions.

12-25-2008	#8
jeykumar Join Date: Feb 2007 Posts: 4	This link doesn't seem to work. Can somebody help help how I can import categories in bulk?. Regards, Jey Kumar.

01-21-2009	#10
alexhaidar Join Date: Jan 2009 Posts: 1	I am going crazy, I did the install perfectly, but all the pages I create are broken, none of the cateory pages are working, the system is a mess.