TGPX - Merge Categories or Edit Database By Hand?

Greenguy · 2018-04-28, 07:48 AM

Dummy's got another TGPX conundrum

We've got 1600 galleries tagged with the category zzzMilf (as well as other categories). We want to change that category to another existing category: Hardcore.

1st thing I tried was to just rename the zzzMilf category to Hardcore, but that just created a 2nd category named Hardcore (each have the exact same settings in the Edit Category area, so it's not like it created a 2nd category named Hardcore due to different settings).

So then I did a "test" on 70 or so galleries. I say "test" because those were scheduled for a future date & you can't export their scheduled date, so I did them 1st. I exported them with basically all the Fields I could, including the Thumb URL. Opened the export, did a search & replace to change zzzMilf to Hardcore, added their scheduled date and imported them back in using the "Replace old gallery data with new gallery data" for Duplicates option. Of course, that deleted all the thumbs because why wouldn't it delete them

So my next option is to export all 1600 galleries, change their status to Disabled (so I can use the existing thumb), do the search & replace, and then import them back in using the "Add duplicates to database" option. But it seems like there should be an easier way to do this

I didn't see an option to merge categories - am I missing something?

Is there a way to edit the database by hand? (txt, csv, etc.) I assume there's a field in the database file for categories that looks like this:
Amateur,Blowjob,ThreesomeFFM,Blonde,Milf,zzzMilf
So opening the database file & doing a simple search & replace seems like the logical thing to do.

Based on replies, I may have follow-up questions

Thanks

2018-04-28, 07:48 AM	#1
Greenguy The Original Greenguy (Est'd 1996) & AVN HOF Member - I Crop Pics For Thumbs In My Sleep Join Date: Feb 2003 Location: Blasdell, NY (shithole suburb south of Buffalo) Posts: 41,754	TGPX - Merge Categories or Edit Database By Hand? Dummy's got another TGPX conundrum We've got 1600 galleries tagged with the category zzzMilf (as well as other categories). We want to change that category to another existing category: Hardcore. 1st thing I tried was to just rename the zzzMilf category to Hardcore, but that just created a 2nd category named Hardcore (each have the exact same settings in the Edit Category area, so it's not like it created a 2nd category named Hardcore due to different settings). So then I did a "test" on 70 or so galleries. I say "test" because those were scheduled for a future date & you can't export their scheduled date, so I did them 1st. I exported them with basically all the Fields I could, including the Thumb URL. Opened the export, did a search & replace to change zzzMilf to Hardcore, added their scheduled date and imported them back in using the "Replace old gallery data with new gallery data" for Duplicates option. Of course, that deleted all the thumbs because why wouldn't it delete them So my next option is to export all 1600 galleries, change their status to Disabled (so I can use the existing thumb), do the search & replace, and then import them back in using the "Add duplicates to database" option. But it seems like there should be an easier way to do this I didn't see an option to merge categories - am I missing something? Is there a way to edit the database by hand? (txt, csv, etc.) I assume there's a field in the database file for categories that looks like this: Amateur,Blowjob,ThreesomeFFM,Blonde,Milf,zzzMilf So opening the database file & doing a simple search & replace seems like the logical thing to do. Based on replies, I may have follow-up questions Thanks __________________ Promote POV Porn Cash By Building & Submitting Galleries to the Porn Luv Network