TGPX Tip For Importing Galleries From File

[jollyhumper]

Originally Posted by Greenguy

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.

This one I don't really get. (Remember, I seriously suck at spreadsheets. It's math, y know...)
How do I put that formula 'behind' the date?

And, when I copy and paste the date into a new field, will it then auto-update according to formula?

Originally Posted by 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.

So if I get this correctly, when I import a preview-url, I can get the scanner to crop that image. (in other words, scanner will not try to import from gallery-url (and often get a 302)?

Jlly

[Greenguy]

Originally Posted by jollyhumper

This one I don't really get. (Remember, I seriously suck at spreadsheets. It's math, y know...)
How do I put that formula 'behind' the date?

And, when I copy and paste the date into a new field, will it then auto-update according to formula?

This ain't math Let's say you have 10 galleries & you want to schedule 1 for every other day. On the example I posted where the date is 2018-02-14 00:00:00, click the cell below the date. Then:
1 - Type = on your keyboard
2 - Click the cell above it with the date
3 - Type + and then the number of days you want to add to the date in the cell above it
4 - Hit Enter on your keyboard.

Using my example from above where you're adding 2 days to the date, before you hit enter it'll read:
=I2+2
When you hit Enter, it'll read:
2018-02-16 00:00:00

Now, right click & copy that cell with the 2018-02-16 00:00:00 date in it. Then select the next 8 cells under the date & paste. That will give you:
2018-02-14 00:00:00
2018-02-16 00:00:00
2018-02-18 00:00:00
2018-02-20 00:00:00
2018-02-22 00:00:00
2018-02-24 00:00:00
2018-02-26 00:00:00
2018-02-28 00:00:00
2018-03-02 00:00:00
2018-03-04 00:00:00

Bob's your uncle

One thing to note when using formulas in spreadsheets (the "=I2+2" thing is a formula): before you sort anything, select all the (in this case 10) cells that have a date in them, then right click & copy. Then right click & select Paste Special ---> Paste Values Only. That will change the cell from being a formula to being just the date.

If you're not going to sort anything, ignore all that

Originally Posted by jollyhumper

So if I get this correctly, when I import a preview-url, I can get the scanner to crop that image. (in other words, scanner will not try to import from gallery-url (and often get a 302)?

No. That's what I hoped it'd do. The only way you can import thumbs is if the Preview URL is the size of the thumb you want to use. Otherwise, what I do after I import is search the galleries & check the Thumbs No Preview box. Then I go to each gallery, save an image to use for the thumb, and import/crop it by clicking the green up arrow under where the thumb would be displayed.

Hope all that is clear enough for your math deprived brain

[Greenguy]

One other thing about dates & Google Sheets: I have the properties of the cells in the Scheduled column set to be Year-Month-Date Hours:Minutes:Seconds with 2 digits for everything except the year. If you double click a cell with a date in it, a calendar will pop up where you can click a different date. Problem is it'll either remove the preceding 0 from the hours:
2018-02-14 0:00:00
Or it'll shitcan the Hours:Minutes:Seconds completely:
2018-02-14
It's fucking

The way around this is to copy a cell with a date in it. Then double click the cell you want a date in & paste the date in there. Before you hit enter, edit the date by hand (try it & you'll see what I mean) You have to do this because TGPX must have the date like this:
2018-02-14 00:00:00
And it gets really confused if the date is like this:
2018-02-14 0:00:00

[jollyhumper]

Thanks

It worked (the date thing). Cool!

May I ask why you use Email, name and IP in your import?
If I submit it'll go straight into the review-queue, or do you do that differently as well?

Do you consider tags and keywords not important, since it's not in the sheet?

Can I add and remove categories in the list, or do I also have to change something in the categories-cell so It will detect the changes I make?

Thumbs, I right click the preview and downloads it. deletes the big one and reupload as you mentions (green arrow).
I'm starting to get a routine on it, so it goes really fast, only thing is the strain this puts on my mouse-arm. So If there was another way...



Jlly

[Greenguy]

Come with me my friend

Originally Posted by jollyhumper

May I ask why you use Email, name and IP in your import?

They're fields I was putting in when I did the submits by hand - not sure what happens when you don't import them (probably go blank - and IP isn't really important for your galleries - I assume that's in there to catch cheaters)

Originally Posted by jollyhumper

If I submit it'll go straight into the review-queue, or do you do that differently as well?

After you click Analyze Input, you can change the Status from Pending to Approved & that will keep them out of the review queue. BUT that will screw up the Approved Date so if you're listing them by that date on the pages, they won't show up properly (I can explain that in detail if you want) so what I do is, instead of reviewing via that Pending Galleries link that shows the info on top in a new window with a small height, I just search the galleries for Pending & Submitted.

Originally Posted by jollyhumper

Do you consider tags and keywords not important, since it's not in the sheet?

I just don't use them. Add a column or 2 if you want

Originally Posted by jollyhumper

Can I add and remove categories in the list, or do I also have to change something in the categories-cell so It will detect the changes I make?

Yes. All those cells with the drop downs are formatted to read all the cells from N2 on down that have data in them. Also, if you insert a column (like above) before the columns with the drop downs (starting at J) it will automatically change the formatting on the drop down cells to look in the next column over (if that makes sense)

Originally Posted by jollyhumper

Thumbs, I right click the preview and downloads it. deletes the big one and reupload as you mentions (green arrow).

I never thought of that! Yes, I do believe that would work

Originally Posted by jollyhumper

I'm starting to get a routine on it, so it goes really fast, only thing is the strain this puts on my mouse-arm. So If there was another way...

Use your nose