PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |

Go Back   PhotoPost Community > General Forums > General Discussion

General Discussion General use discussion forum for PhotoPost products.

Reply
 
Thread Tools Rate Thread Display Modes
Old August 19th, 2004, 12:39 AM   #1
alma townsend
Member
Verified Customer
 
Join Date: Aug 2004
Posts: 130
Question Category Help

I have setup 489 categories, and want to setup 2 main categories with these 489 as subcats in each. Anyway to do this without having to recreate the same subcats? Anyway to duplicate them?
Thanks for your help
Alma
alma townsend is offline   Reply With Quote
Old August 19th, 2004, 05:25 AM   #2
Chuck S
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 75,208
Some fancy mysql

You need to create the first block say category 1 with all its subcategories

Then you do a mysql export and in a text editor you need to change the main cat entry to another id value say whichever is the next autoincrement number next to come. You then need to edit the parent value in the export of all the subcats to be that new number. You then need to make the id value in all the subcats blank so it will follow the autoincrement on install.

Then take that tweaked mysql sql and run it.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is online now   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 05:35 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.