View Single Post
Old 2018-06-06, 02:22 PM   #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,706
Send a message via ICQ to Greenguy
Here's the "If I Knew Then What I Know Now" version: TGPX Spreadsheet For Importing Galleries v2.0

The only difference is that the data for the dropdown menus is stored on a seperate sheet because the way I had it, that data was in the far left column & if you sorted the sheet by any other column, it'd fuck up the category list which is in alphabetical order.

Also, each of the dropdown menus is set to read the entire column off the CategoriesData sheet, so when you edit the categories over there to match your categories, you don't have to worry about the dropdown menus looking in a specific range of cells.

Speaking of the category dropdowns, if you click the little down arrow* on the right, it'll show you all the categories & then you can click the one you want. But, if you click anywhere else in the cell, you can simply type the 1st letter of the category you want & it'll bring up just those categories that start with that letter. What's even cooler is that if you have 1 TGPX running a bunch of sites & you have your categories coded for each site, typing the 1st letter will work for those, too. Example:
These are the categories for Anal Sex Fest:
zASF-Amateur
zASF-Asian
zASF-AssToMouth
zASF-BBW
zASF-BigAss
zASF-BigCock
zASF-Black
zASF-Gaping
zASF-Group
zASF-Hardcore
zASF-Interracial
zASF-Latina
zASF-Lesbian
zASF-Mature
zASF-Milf
zASF-Petite
zASF-Rough
zASF-Teen
The sheet I use has just those categories in the dropdown. If you typed "G" into the cell, you'd expect to see nothing, because none of those categories start with the letter G. Instead, you get just:
zASF-Gaping
zASF-Group
I don't know if it works in Office/Excel, but is does in Google Sheets.

* Remember, to see those, you have to download the spreadsheet & then open it in Office/Excel or Google Sheets or whatever.

Now, Jolly asked about Tags & Keywords. If you want to use any of the other fields (see below) all you have to do is insert a column somewhere before All Cats, put the title in the 1st row & Bob's your uncle. And, the order the columns are in doesn't matter except for your 1st import as long as you use them in that order each time. The 1st time you import, you select what field matches your data once you click Analyze Input. TGPX will default to what you used for those fields the previous import. The one problem I have encountered with this is if you use a date field for some of the galleries you're importing. Most of the time, if it's a blank field, TGPX leaves it blank. But if it's a date that blank, it puts some really strange date in there that you can NOT edit once the gallery is imported. So be careful with dates

All TGPX Import Fields in alphabetical order:
Categories
Clicks
Date of Deletion
Date Scheduled
Description
E-mail Address
Format
Gallery URL
Icons
Keywords
Nickname
Partner
Preview Size
Preview URL
Sponsor
Submit IP
Tags
Thumbnails
Type
Weight

If anyone has questions, just ask. If you're stumped, I'd be more than happy to with your copy of the spreadsheet if you want. I can fuck shit up on a scale of biblical proportions, but one thing I am good at is data & spreadsheets
__________________

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