TGPX Tip For Importing Galleries From File

[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