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 02-13-2018, 09: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: Orchard Park, NY (current home of the lackluster Bills)
Posts: 36,944
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)

__________________
Submit To The Porn Luv Network! | My Host Has Mojo!
Greenguy is offline   Reply With Quote
Old 02-13-2018, 12:41 PM   #2
jollyhumper
Ich werde in die Tannen gehen
 
jollyhumper's Avatar
 
Join Date: Feb 2012
Location: Norway
Posts: 910
Send a message via ICQ to jollyhumper
Awesome. I've only used the Import from File-feature for quite some time now, but not on your level.
You improved my workflow with this. I'll try it asap

Jolly
jollyhumper is offline   Reply With Quote
Old 02-13-2018, 02:30 PM   #3
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: Orchard Park, NY (current home of the lackluster Bills)
Posts: 36,944
Send a message via ICQ to Greenguy
Quote:
Originally Posted by jollyhumper View Post
Awesome. I've only used the Import from File-feature for quite some time now, but not on your level.
You improved my workflow with this. I'll try it asap

Jolly
I am finding it does speed things up a lot, especially with stuff like you want to schedule 10-20 galleries from one sponsor for listing every other day. Putting "=I2+2" in the cell below the date & then copy/pasting it into the date cells next to a list of galleries is a hell of a lot easier then doing it by hand or using the calendar in the admin.

The idea for the drop down came to me when I was going to sleep last night, so I'm glad that I remembered to try it as well as figuring out how worked

-------

If anyone does need help with anything as far as this or any spreadsheet, just ask. While I've had no formal training with them, I'll pat myself on the back & say that I'm pretty fucking good when it comes to spreadsheets
__________________
Submit To The Porn Luv Network! | My Host Has Mojo!
Greenguy is offline   Reply With Quote
Old 02-13-2018, 03:46 PM   #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: Orchard Park, NY (current home of the lackluster Bills)
Posts: 36,944
Send a message via ICQ to Greenguy
WHOOPS! I had to edit the Scheduled column because TGPX didn't like the date format I had in there. It has to be:
2018-02-14 00:00:00

I had this in there, which I copied from the admin:
02-14-2018 12:00am
But I just imported some & none of them were scheduled

I also had to format the Scheduled column to be Plain Text because Google Sheets was taking the 1st zero off the timestamp:
2018-02-14 0:00:00

Of course, this fucks you if you want to do that automatic date trick I described above

Let me work on this.....
__________________
Submit To The Porn Luv Network! | My Host Has Mojo!
Greenguy is offline   Reply With Quote
Old 02-13-2018, 03:50 PM   #5
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: Orchard Park, NY (current home of the lackluster Bills)
Posts: 36,944
Send a message via ICQ to Greenguy
Quote:
Originally Posted by Greenguy View Post
WHOOPS! I had to edit the Scheduled column because TGPX didn't like the date format I had in there. It has to be:
2018-02-14 00:00:00

I had this in there, which I copied from the admin:
02-14-2018 12:00am
But I just imported some & none of them were scheduled

I also had to format the Scheduled column to be Plain Text because Google Sheets was taking the 1st zero off the timestamp:
2018-02-14 0:00:00

Of course, this fucks you if you want to do that automatic date trick I described above

Let me work on this.....
Ignore all that - I think I fixed it.

BUT if you already saved a copy, go grab the version I have on there now just to be safe
__________________
Submit To The Porn Luv Network! | My Host Has Mojo!
Greenguy is offline   Reply With Quote
Old 02-13-2018, 04:28 PM   #6
sarettah
Heh Heh Heh! Lisa! Vampires are make believe, just like elves and gremlins and eskimos!
 
Join Date: Apr 2005
Posts: 76
I might be missing something here but why are you going through the textpad, etc when you could just go file->Download As->comma-separated to get your .csv file format that it appears you are creating?


I am probably missing something. But since I don't use TGPX it really doesn't matter ;p

.
sarettah is online now   Reply With Quote
Old 02-13-2018, 05:22 PM   #7
Toby
Lonewolf Internet Sales
 
Toby's Avatar
 
Join Date: Mar 2005
Location: Houston
Posts: 4,670
Send a message via ICQ to Toby
Quote:
Originally Posted by sarettah View Post
I might be missing something here but why are you going through the textpad, etc when you could just go file->Download As->comma-separated to get your .csv file format that it appears you are creating?

I am probably missing something. But since I don't use TGPX it really doesn't matter ;p
TGPX Import From File requires pipe delimited text files. That makes sense when you consider that a comma within a description is likely, where a pipe is not.
Toby is offline   Reply With Quote
Old 02-13-2018, 05:46 PM   #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: Orchard Park, NY (current home of the lackluster Bills)
Posts: 36,944
Send a message via ICQ to Greenguy
Quote:
Originally Posted by Toby View Post
TGPX Import From File requires pipe delimited text files. That makes sense when you consider that a comma within a description is likely, where a pipe is not.
That and I f'ing hate csv files. Excel gets really confused anytime you change anything that isn't simple text in a cell. Like if you make a column wider so you can read it, then click save. It tells you you're saving it & that it's not compatible & blah blah blah. If you then click OK, the file is saved. But when you close the window, it asks you if you wanted to save the file, which you just did. So you click Yes & it asks you want file name you want to save it as (as if you selected Save As instead of Save) So you save it as the file name it currently is & it warns you that you're over-writing the file, then gives you the blah blah blah warnings again. It's f'ing mind numbing
__________________
Submit To The Porn Luv Network! | My Host Has Mojo!
Greenguy is offline   Reply With Quote
Old 02-13-2018, 06:06 PM   #9
Toby
Lonewolf Internet Sales
 
Toby's Avatar
 
Join Date: Mar 2005
Location: Houston
Posts: 4,670
Send a message via ICQ to Toby
Excel also tends to put text fields within quotes when you export to text.

I just create my import file in EditPad (NotePad on steroids), with no category, then select category or three when I make thumbs. I use the same file across three sites, and the categories aren't the same.
Toby is offline   Reply With Quote
Old 02-13-2018, 06:46 PM   #10
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: Orchard Park, NY (current home of the lackluster Bills)
Posts: 36,944
Send a message via ICQ to Greenguy
Toby - TGPX Question for ya: I just did an import & for the 1st time, I included a Preview URL image to use as the thumb, but I didn't crop it ahead of time. Am I missing something or is there no way to crop/edit the image I sent in with the import?
__________________
Submit To The Porn Luv Network! | My Host Has Mojo!
Greenguy is offline   Reply With Quote
Old 02-13-2018, 09:30 PM   #11
Toby
Lonewolf Internet Sales
 
Toby's Avatar
 
Join Date: Mar 2005
Location: Houston
Posts: 4,670
Send a message via ICQ to Toby
You didn't miss anything, there's no way to auto-crop an imported image. What you can do however, is set up the gallery scanner to crop the imported images after you've completed the import.

Last edited by Toby; 02-13-2018 at 09:34 PM..
Toby is offline   Reply With Quote
Old 02-13-2018, 09:50 PM   #12
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: Orchard Park, NY (current home of the lackluster Bills)
Posts: 36,944
Send a message via ICQ to Greenguy
Quote:
Originally Posted by Toby View Post
You didn't miss anything, there's no way to auto-crop an imported image. What you can do however, is set up the gallery scanner to crop the imported images after you've completed the import.
Sadly, most galleries these days 302 Redirect, which causes TGPX to think the link is broken & thus, no images from the gallery show up
__________________
Submit To The Porn Luv Network! | My Host Has Mojo!
Greenguy is offline   Reply With Quote
Old 02-14-2018, 01:18 AM   #13
jollyhumper
Ich werde in die Tannen gehen
 
jollyhumper's Avatar
 
Join Date: Feb 2012
Location: Norway
Posts: 910
Send a message via ICQ to jollyhumper
Quote:
Originally Posted by Greenguy View Post
Sadly, most galleries these days 302 Redirect, which causes TGPX to think the link is broken & thus, no images from the gallery show up
If you export with the Direct URL instead of the 'regular' url in NATS, many programs will give you a link that does not give a 302.
Unfortunately, this is not true for all

Jolly
jollyhumper 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 -5. The time now is 12:04 AM.


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