View Single Post
Old 2018-02-13, 10:54 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,705
Send a message via ICQ to Greenguy
Thumbs up TGPX Tip For Importing Galleries From File

I've been using the Import From File option in TGPX a lot lately. I use a spreadsheet, copy* the data to Textpad, replace the tabs with a pipe (|) and copy/paste it into the textbox. I know this isn't exactly news, but what is news is that I was able to add a drop down menu to select categories instead of guessing & constantly forgetting it's "Butts" and not "Butt" or having to go to the Manage Categories page & copy/pasting from there. And you can simply copy/paste the form into multiple cells for when you have multiple categories.

*For multiple categories, you have to copy/paste just them 1st into Textpad, replace the tabs with a comma, copy/paste them back into the 1st category column, and then do the rest (otherwise you have all your categories separated by pipes & TGPX thinks they are different fields)

Also, the Scheduled column is formatted so that TGPX likes the date. The rest of the cells are formatted to Clip any Text Wrapping

EDIT TO ADD:
To have your categories in the drop down menu, copy & paste them on the far right where mine are. I'm 99.44% sure that will work, but if not, LMK & I'll walk you thru setting it up

So if anyone wants it, it should be accessible via this link:
https://docs.google.com/spreadsheets...it?usp=sharing

EDIT TO ADD:
You can't see the drop down menus when you go look at that link because I have editing turned off, but if you download it to your drive or to Excel, the drop down menus are there (you'll see the arrow in the cells in Google Sheets, but you do have to click the cell in Excel to see the menu)





EDIT TO ADD:

Make sure to read the "If I Knew Then What I Know Now" version that was added 2018-06-06
__________________

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