Categories import csv, xml, sql etc

[ebee +]

Hi
Just wondering if it is possible to import categories>>sub-categories>>>sub-sub-sub-categories in 68C via SQL statements. Say if we have 100s of these categories (similar to e B a y)..would it be possible to import in phpMyAdmin? Or it is only allowed to manually enter categories in 68C?

Thanks
Best Regards

[seymourjames +]

If you know what you are doing you could do this with phpadmin. I would do a little trial and error first.

[ebee +]

Originally Posted by seymourjames

I would do a little trial and error first.

do you mean no one has tried this before? Ideally it would be handy to know this; that it has been achieved before.
thanks

[Lhotch +]

Originally Posted by ebee

do you mean no one has tried this before? Ideally it would be handy to know this; that it has been achieved before.
thanks

Im not sure how you would expect David to know if anyone else has done this.

I personally have done this on sites with 2000+ categories but it was a case where each parent cat had the same child cats underneath so it was easy to script walking over the supplied category names and ading data to the database.

When you have a myriad of parent cats each with various sub cats things get a lot trickier.

Yes it can be done, but you need to know what your doing with mysql.

[Mike-N-Tosh +]

I've done it several times, but not with straight sql queries. To me it seems like it would take longer to create all those queries than to enter than to just do it through the admin.

I just do it in excel and save it as a CSV file and then use phpMyAdmin to import via file.

Use phpMyAdmin to export to an excel from the table first and select the option to include the columns as a header. then you can use that file to type in/cut & paste or whatever. I've also done it this way to convert clients categories from other classifieds scripts.

[Mike-N-Tosh +]

Just as an fyi: what you are asking has absolutely nothing to do with 68 Classifieds at all. This is simply strict sql and db management.

[ebee +]

Originally Posted by Lhotch

Im not sure how you would expect David to know if anyone else has done this.

Thanks for that Larry. Sorry, I meant if this problem is discussed before on the forums and its known achievements, hurdles etc. would be known by regular mods, users here.

I personally have done this on sites with 2000+ categories but it was a case where each parent cat had the same child cats underneath so it was easy to script walking over the supplied category names and ading data to the database.

When you have a myriad of parent cats each with various sub cats things get a lot trickier.

Yes it can be done, but you need to know what your doing with mysql.

I can cope with INSERT INTO statements hence I got the idea now that it is doable. Thanks to David and yourself for the help.

best regards

[Lhotch +]

If you just have one level of categories its pretty easy, but if there are multiple levels you have to make sure you correctly referencw parent cats etc.