Greenguy's Board


Go Back   Greenguy's Board > General Business Knowledge
Register FAQ Calendar Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Search this Thread Rate Thread Display Modes
Old 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
 
Greenguy's Avatar
 
Join Date: Feb 2003
Location: Blasdell, NY (shithole suburb south of Buffalo)
Posts: 41,704
Send a message via ICQ to Greenguy
Question 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
Greenguy is offline   Reply With Quote
Old 2018-04-28, 08:33 AM   #2
Pagan
Perverted Empress
 
Pagan's Avatar
 
Join Date: Feb 2005
Location: Finland
Posts: 4,606
Send a message via ICQ to Pagan
I have no idea how you did tried to do this. I rename categories through the Settings frequently.



In the top image, that first category is Anal Lesbians. I have been changing these to one word just because. I went to Settings, Categories, and found the one I want to change. Clicked on the pencil, made my change... I made it AnalLes. And if you look at the lower screenshot, you can see no more Anal Lesbian category. If it had done the copy thing, you still would have seen Anal Lesbian, then Anal MILF, right? But no.. you do see the new AnalLes category though.
__________________
Submit Here!
Pagan is offline   Reply With Quote
Old 2018-04-28, 10:07 AM   #3
Toby
Lonewolf Internet Sales
 
Toby's Avatar
 
Join Date: Mar 2005
Location: Houston
Posts: 4,826
Send a message via ICQ to Toby
You can easily mass edit to change category. Do a search that pulls up all the galleries to be changed, then change the category of the first and click the double disk icon to save changes to all matching galleries. Just that simple.

Double check to make sure the old category has 0 galleries, then it can be deleted.

Last edited by Toby; 2018-04-28 at 10:17 AM..
Toby is offline   Reply With Quote
Old 2018-04-28, 10:19 AM   #4
Greenguy
The Original Greenguy (Est'd 1996) & AVN HOF Member - I Crop Pics For Thumbs In My Sleep
 
Greenguy's Avatar
 
Join Date: Feb 2003
Location: Blasdell, NY (shithole suburb south of Buffalo)
Posts: 41,704
Send a message via ICQ to Greenguy
Quote:
Originally Posted by Pagan View Post
I have no idea how you did tried to do this. I rename categories through the Settings frequently.
<snip>
In the top image, that first category is Anal Lesbians. I have been changing these to one word just because. I went to Settings, Categories, and found the one I want to change. Clicked on the pencil, made my change... I made it AnalLes. And if you look at the lower screenshot, you can see no more Anal Lesbian category. If it had done the copy thing, you still would have seen Anal Lesbian, then Anal MILF, right? But no.. you do see the new AnalLes category though.
You didn't have a category already named AnalLes with galleries in it.

Quote:
Originally Posted by Toby View Post
You can easily mass edit to change category. Do a search that pulls up all the galleries to be changed, then change the category of the first and click the double disk icon to save changes to all matching galleries. Just that simple.
All the galleries are tagged with multiple different categories, so let's say the 1st one is tagged:
Amateur,Blowjob,ThreesomeFFM,Blonde,Milf,zzzMilf
If I change zzzMilf to Hardcore & then click the icon, won't that apply those 6 categories to ALL of the galleries?
__________________

Promote POV Porn Cash By Building & Submitting Galleries to the Porn Luv Network
Greenguy is offline   Reply With Quote
Old 2018-04-28, 10:31 AM   #5
Toby
Lonewolf Internet Sales
 
Toby's Avatar
 
Join Date: Mar 2005
Location: Houston
Posts: 4,826
Send a message via ICQ to Toby
Quote:
Originally Posted by Greenguy View Post
If I change zzzMilf to Hardcore & then click the icon, won't that apply those 6 categories to ALL of the galleries?
Yeah, if zzzMilf is one of multiple categories, then the mass edit will not work.
Toby is offline   Reply With Quote
Old 2018-04-28, 10:32 AM   #6
Greenguy
The Original Greenguy (Est'd 1996) & AVN HOF Member - I Crop Pics For Thumbs In My Sleep
 
Greenguy's Avatar
 
Join Date: Feb 2003
Location: Blasdell, NY (shithole suburb south of Buffalo)
Posts: 41,704
Send a message via ICQ to Greenguy
Any other options you can think of besides this?

Quote:
Originally Posted by Greenguy View Post
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.
__________________

Promote POV Porn Cash By Building & Submitting Galleries to the Porn Luv Network
Greenguy is offline   Reply With Quote
Old 2018-04-28, 11:08 AM   #7
Toby
Lonewolf Internet Sales
 
Toby's Avatar
 
Join Date: Mar 2005
Location: Houston
Posts: 4,826
Send a message via ICQ to Toby
Quote:
Originally Posted by Greenguy View Post
Any other options you can think of besides this?
No, but I'm also not all that confident it will capture the thumbs from the disabled and connect them with the import.
Toby is offline   Reply With Quote
Old 2018-04-28, 11:15 AM   #8
Greenguy
The Original Greenguy (Est'd 1996) & AVN HOF Member - I Crop Pics For Thumbs In My Sleep
 
Greenguy's Avatar
 
Join Date: Feb 2003
Location: Blasdell, NY (shithole suburb south of Buffalo)
Posts: 41,704
Send a message via ICQ to Greenguy
Quote:
Originally Posted by Toby View Post
No, but I'm also not all that confident it will capture the thumbs from the disabled and connect them with the import.
It will. I learned that a couple months ago
__________________

Promote POV Porn Cash By Building & Submitting Galleries to the Porn Luv Network
Greenguy is offline   Reply With Quote
Old 2018-04-28, 11:16 AM   #9
Greenguy
The Original Greenguy (Est'd 1996) & AVN HOF Member - I Crop Pics For Thumbs In My Sleep
 
Greenguy's Avatar
 
Join Date: Feb 2003
Location: Blasdell, NY (shithole suburb south of Buffalo)
Posts: 41,704
Send a message via ICQ to Greenguy
I'm gonna wait to do that just in case anyone else has an idea for me
__________________

Promote POV Porn Cash By Building & Submitting Galleries to the Porn Luv Network
Greenguy is offline   Reply With Quote
Old 2018-04-28, 01:06 PM   #10
Pagan
Perverted Empress
 
Pagan's Avatar
 
Join Date: Feb 2005
Location: Finland
Posts: 4,606
Send a message via ICQ to Pagan
Quote:
Originally Posted by Greenguy View Post
You didn't have a category already named AnalLes with galleries in it.
No, I didn't have an AnalLes category before, but I had Anal Lesbian. I edited the name of the category. I thought that was what you were trying to do. Anal Lesbian had 71 galleries. It is now gone. The edited AnalLes category now has 71 galleries. You do have to go back and edit any page templates that called out the old name.

If you edit the name of ANY category, then it will be applied automatically to all of the galleries with that old category.

Just imagine it this way - your categories are just like filing cabinet drawers. If you have one labeled Anal, and want to change it to Ass, all you have to do is change the name of the filing cabinet drawer and it will apply that change to all of the contents inside. The templates have their own drawer, so you have to manually update those.


So, if you did NOT have a hardcore category before and wanted to put everything that had that zzzMILF category there, all you have to do is go to Settings and change the Category name. It will apply to all of the galleries in the old zzzMILF drawer because now that drawer is called Hardcore.

If, though, you exported galleries before you made the change... then imported them afterwards, they still have the old category on them, and they WILL make a new category for them. The other way to do it is NOT designate a category when you do your import and select it -- Bad Categories go into --->
__________________
Submit Here!
Pagan is offline   Reply With Quote
Old 2018-04-28, 01:14 PM   #11
Greenguy
The Original Greenguy (Est'd 1996) & AVN HOF Member - I Crop Pics For Thumbs In My Sleep
 
Greenguy's Avatar
 
Join Date: Feb 2003
Location: Blasdell, NY (shithole suburb south of Buffalo)
Posts: 41,704
Send a message via ICQ to Greenguy
Oddly enough, dummy does know all that
__________________

Promote POV Porn Cash By Building & Submitting Galleries to the Porn Luv Network
Greenguy is offline   Reply With Quote
Old 2018-04-28, 01:51 PM   #12
JustRobert
Bow Ties Are Cool
 
JustRobert's Avatar
 
Join Date: Jun 2006
Location: California
Posts: 9,338
Looks like we might be doing it 1 at a time

I can start once I'm done with the new cats being added.
__________________
Submit Your Galleries To The Porn Luv Network!
JustRobert is offline   Reply With Quote
Old 2018-04-28, 02:23 PM   #13
Greenguy
The Original Greenguy (Est'd 1996) & AVN HOF Member - I Crop Pics For Thumbs In My Sleep
 
Greenguy's Avatar
 
Join Date: Feb 2003
Location: Blasdell, NY (shithole suburb south of Buffalo)
Posts: 41,704
Send a message via ICQ to Greenguy
No way we're doing 1600 individual edits

The export/disable/import option does work, just seems like there might be an easier way
__________________

Promote POV Porn Cash By Building & Submitting Galleries to the Porn Luv Network
Greenguy is offline   Reply With Quote
Old 2018-04-29, 04:19 AM   #14
pc
Shift Out / X-On
 
pc's Avatar
 
Join Date: Jul 2007
Location: unknown
Posts: 2,298
Send a message via ICQ to pc
There is a way of saving thumbs but you need to export them and import them back in a desired format. The easiest way is to create a page and pull them all as a text, line by line with pipe delimiter where you have all fields with thumbs urls. Copy and Paste into TGPX Import tool.
pc is offline   Reply With Quote
Old 2018-04-29, 08:08 AM   #15
Greenguy
The Original Greenguy (Est'd 1996) & AVN HOF Member - I Crop Pics For Thumbs In My Sleep
 
Greenguy's Avatar
 
Join Date: Feb 2003
Location: Blasdell, NY (shithole suburb south of Buffalo)
Posts: 41,704
Send a message via ICQ to Greenguy
Quote:
Originally Posted by pc View Post
There is a way of saving thumbs but you need to export them and import them back in a desired format. The easiest way is to create a page and pull them all as a text, line by line with pipe delimiter where you have all fields with thumbs urls. Copy and Paste into TGPX Import tool.
Do you mean when I export them, to include the Thumb URL - like http://www.pornluv.com/llist/thumbs/420.jpg - and when I import them, to include that for the "Preview URL" field? If so, that's what I assumed would work, but when you import & select "Replace old gallery data with new gallery data" for Duplicates, it deletes all the old data for that gallery, including the thumb.

OR

Are you talking about this from admin/docs/galleries-export.html



OR

I could load all those galleries on a page & have my Image Downloader grab all 1600 thumbs, then upload them to the /thumbs/ directory after I import everything, but that too seems like a lot of extra work.
Attached Images
File Type: png Capture.PNG (25.8 KB, 232 views)
__________________

Promote POV Porn Cash By Building & Submitting Galleries to the Porn Luv Network
Greenguy is offline   Reply With Quote
Old 2018-04-29, 09:56 AM   #16
pc
Shift Out / X-On
 
pc's Avatar
 
Join Date: Jul 2007
Location: unknown
Posts: 2,298
Send a message via ICQ to pc
Quote:
Originally Posted by Greenguy View Post
Do you mean when I export them, to include the Thumb URL - like http://www.pornluv.com/llist/thumbs/420.jpg.... but when you import & select "Replace old gallery data with new gallery data" for Duplicates, it deletes all the old data ...
One silly option is to RENAME thumb folder for a moment and then select replace
pc is offline   Reply With Quote
Old 2018-04-29, 10:04 AM   #17
Greenguy
The Original Greenguy (Est'd 1996) & AVN HOF Member - I Crop Pics For Thumbs In My Sleep
 
Greenguy's Avatar
 
Join Date: Feb 2003
Location: Blasdell, NY (shithole suburb south of Buffalo)
Posts: 41,704
Send a message via ICQ to Greenguy
Quote:
Originally Posted by pc View Post
One silly option is to RENAME thumb folder for a moment and then select replace
So it goes to delete the thumb, can't find it, and just moves on? That is an idea. Of course, it'd fuck up 75 sites in the process as they try to load thumbs that aren't there
__________________

Promote POV Porn Cash By Building & Submitting Galleries to the Porn Luv Network
Greenguy is offline   Reply With Quote
Old 2018-04-29, 11:56 AM   #18
pc
Shift Out / X-On
 
pc's Avatar
 
Join Date: Jul 2007
Location: unknown
Posts: 2,298
Send a message via ICQ to pc
Well , that's the idea
pc is offline   Reply With Quote
Old 2018-04-30, 11:32 AM   #19
JustRobert
Bow Ties Are Cool
 
JustRobert's Avatar
 
Join Date: Jun 2006
Location: California
Posts: 9,338
Quote:
Originally Posted by Greenguy View Post
No way we're doing 1600 individual edits

The export/disable/import option does work, just seems like there might be an easier way
I went ahead and changed mine one at a time while we binged Lost In Space yesterday while being hungover so there is only like 1200 now
__________________
Submit Your Galleries To The Porn Luv Network!
JustRobert is offline   Reply With Quote
Old 2018-05-01, 06:45 AM   #20
Greenguy
The Original Greenguy (Est'd 1996) & AVN HOF Member - I Crop Pics For Thumbs In My Sleep
 
Greenguy's Avatar
 
Join Date: Feb 2003
Location: Blasdell, NY (shithole suburb south of Buffalo)
Posts: 41,704
Send a message via ICQ to Greenguy
One option I never thought of was to just procrastinate doing anything while your partner changes all of them by hand without you knowing, so to JustRobert, I say
__________________

Promote POV Porn Cash By Building & Submitting Galleries to the Porn Luv Network
Greenguy is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
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 -4. The time now is 06:50 AM.


Mark Read
Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
© Greenguy Marketing Inc