|
|
|
|
|
|
|
![]() |
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
![]() |
#1 |
The Original Greenguy (Est'd 1996) & AVN HOF Member - I Crop Pics For Thumbs In My Sleep
|
I have to run the ASSIL shortly, but I just looked at the example I posted in Feb & I think I have some new bells & whistles for it. I'll work on it later this afternoon.
|
![]() |
![]() |
![]() |
#2 |
The Original Greenguy (Est'd 1996) & AVN HOF Member - I Crop Pics For Thumbs In My Sleep
|
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 ![]() ![]() |
![]() |
![]() |
![]() |
|
|