Support Forums

Categories import csv, xml, sql etc

This is a discussion on Categories import csv, xml, sql etc within the Pre Sales Questions forums, part of the Pre-Sales & Testimonials category; 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 ...


Go Back   68 Classifieds Forums > Pre-Sales & Testimonials > Pre Sales Questions

Reply
 
Thread Tools Display Modes
Old 11-19-2010, 12:32 PM   #1
Customer
 
Join Date: Oct 2008
Posts: 31
Rep Power: 12
ebee is on a distinguished road
Question Categories import csv, xml, sql etc

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
ebee is offline   Reply With Quote
Old 11-19-2010, 12:41 PM   #2
All Hands On Deck
 
 
Join Date: Mar 2008
Posts: 3,342
Rep Power: 84
seymourjames is a jewel in the rough
Default

If you know what you are doing you could do this with phpadmin. I would do a little trial and error first.
__________________
"The fool doth think he is wise, but the wise man knows himself to be a fool.".

TemplateCodes.com for 68C, Version 4 Templates & Modules
Get the Best U.S Hosting, Best U.K Hosting
seymourjames is offline   Reply With Quote
Old 11-19-2010, 01:03 PM   #3
Customer
 
Join Date: Oct 2008
Posts: 31
Rep Power: 12
ebee is on a distinguished road
Default

Quote:
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
ebee is offline   Reply With Quote
Old 11-19-2010, 01:25 PM   #4
curmudgeon
 
Join Date: Mar 2006
Posts: 5,413
Rep Power: 138
Lhotch is a glorious beacon of light Lhotch is a glorious beacon of light Lhotch is a glorious beacon of light
Default

Quote:
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.
__________________
Larry

Knowledge learned is more valuable than knowledge given.
Lhotch is offline   Reply With Quote
Old 11-19-2010, 01:45 PM   #5
Developer & Moderator
 
 
Join Date: Jan 2007
Location: Pennsylvania, USA
Posts: 2,311
Rep Power: 69
Mike-N-Tosh is just really nice Mike-N-Tosh is just really nice
Default

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
IndianaPC.org - A community website (v3.1.10 Developer - heavily modified & used as the CMS)
Sandbox [localhost(v3.1.10, v4.0.9, 4.1.10,4.2,5.0)] for development and customization
Visit My blog: reviews, tips, tricks, tutorials and my store with Templates, Mods & Docs
Web Hosting | Web Design & Development | 68 Classifieds Customizations
I am not a 68C employee, just a user and try to help out
Mike-N-Tosh is offline   Reply With Quote
Old 11-19-2010, 01:49 PM   #6
Developer & Moderator
 
 
Join Date: Jan 2007
Location: Pennsylvania, USA
Posts: 2,311
Rep Power: 69
Mike-N-Tosh is just really nice Mike-N-Tosh is just really nice
Default

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.
__________________
Mike-N-Tosh
IndianaPC.org - A community website (v3.1.10 Developer - heavily modified & used as the CMS)
Sandbox [localhost(v3.1.10, v4.0.9, 4.1.10,4.2,5.0)] for development and customization
Visit My blog: reviews, tips, tricks, tutorials and my store with Templates, Mods & Docs
Web Hosting | Web Design & Development | 68 Classifieds Customizations
I am not a 68C employee, just a user and try to help out
Mike-N-Tosh is offline   Reply With Quote
Old 11-19-2010, 01:52 PM   #7
Customer
 
Join Date: Oct 2008
Posts: 31
Rep Power: 12
ebee is on a distinguished road
Default

Quote:
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.

Quote:
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
ebee is offline   Reply With Quote
Old 11-19-2010, 03:13 PM   #8
curmudgeon
 
Join Date: Mar 2006
Posts: 5,413
Rep Power: 138
Lhotch is a glorious beacon of light Lhotch is a glorious beacon of light Lhotch is a glorious beacon of light
Default

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.
__________________
Larry

Knowledge learned is more valuable than knowledge given.
Lhotch is offline   Reply With Quote
Reply

Tags
None

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Import categories and cities Unregistered Pre Sales Questions 8 02-17-2010 04:55 PM
Categories > Sub Catagories import available? ebee Pre Sales Questions 3 05-31-2009 09:07 AM
import script ombre Technical Support 10 01-16-2009 04:15 PM
Import ads from XZERO gstar Pre Sales Questions 9 09-10-2008 06:51 PM


All times are GMT -4. The time now is 07:48 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2011, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0