|
|
|
|
|
|
|
![]() |
|
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
|
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 |
![]() |
![]() |
![]() |
#2 |
That's what she said
|
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... ![]() J ![]() |
![]() |
![]() |
![]() |
#3 | |||||
The Original Greenguy (Est'd 1996) & AVN HOF Member - I Crop Pics For Thumbs In My Sleep
|
Come with me my friend
![]() 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) Quote:
Quote:
![]() Quote:
Quote:
![]() Quote:
![]() |
|||||
![]() |
![]() |
![]() |
|
|