yuuago | Contact/Spam post

CONTACT
Anonymous commenting is on and IP logging is off. (This goes for the rest of my journal too). If you have something you want to say to me that's unrelated to other posts in my journal, this is the place for it. I love talking to people, so just comment away!

Note: My journal has a permanent "reverse friends-cut" policy. If you find yourself tired of reading my daily nonsense, just remove - no worries!

[*Most recent page]

Flat | Top-Level Comments Only

From:

aguacatillo

eeeeeeeeee, this is a stunningly friendly format for me to work in, so well-organised and systematic! It looks like perhaps I could make a spreadsheet that has blanks in several columns which you would fill in? (RSI is awful, isn't it, i got some from work last year and major sympathy on your misery with that!!) & on the other end of things it would be possible to pull complete info back out of the spreadsheet - sorted by chapter and/or any other labels that appear in something like the Type column - and format its text for posting, as long as the format could be pre-defined with reference to the column headings/contents -- idk how long that part usually takes, but if it's a while with lots of copy-pasting and repetitive formatting mark-up, then it might be better to automate it.

~~can't give myself more time tonight to work out more details to run by you,~~ i wrote that and then jumped into it anyway for half an hour and found that despite the annoying javascript-or-something layer the comments are embedded in, i can still get them all, which is good; but i'm optimistic that i may be able to start properly on sunday

From:

yuuago

You are a gentlesloth and a scholar. I'm so glad to be in cahoots with you.

It looks like perhaps I could make a spreadsheet that has blanks in several columns which you would fill in?

That would be excellent, yes. :D Probably something similar to what the example spreadsheet has: type of comment, characters, and a misc notes section. The original spreadsheet has two sections for characters, but maybe I would only need one. It would depend on what would be most convenient for the automation. I guess I would need a way to trim down/remove Minna's comments (sometimes they're... long and/or irrelevant) but if it's just a spreadsheet, then removing anything extraneous will be no problem.

it would be possible to pull complete info back out of the spreadsheet - sorted by chapter and/or any other labels that appear in something like the Type column - and format its text for posting, as long as the format could be pre-defined with reference to the column headings/contents

This would be amazing. It would be possible to do it myself, but the thought of copypasting and hand-coding everything makes me want to cry.

Formatting: The forum uses BBCode, so I'd need it to spit out in that format. (I have vague thoughts about putting a version of the index up on DW for shits and giggles, so an HTML version would be useful too, but the forum is our primary concern right now.) Another limitation is character limits for individual posts - I'm sure there is one, but I don't know what it is (I can find out, though). Dividing things up manually wouldn't be difficult, but if it can be automated, that might be easier (for me, at least). Though, I guess it depends on how much data there is. It might be that there will be a lot that I won't post - chitchatty commentary etc that is not directly relevant to the comic; this will get deleted from the working copy of the spreadsheet, of course. So, I dunno.

In terms of how it should look, I was thinking something like this (sorry for the BBCode, but I'm sure you can guess at what it would look like)

Page: [url=http://www.minnasundberg.fi/comic/page168.php]168[/url] Comment#: N/A*
Date: 7/27/2012
Type: Characterization
Character(s): Hannu, Joona & Jonna
Note: Commentary on occuptation + attitude
Minna's comment:
[quote]Looks like those two are always on a break. Worst employees of the month-warning? Hannu isn't that great either, he may not take quite as many breaks, but he makes up for that by a tendency of losing focus on what he's supposed to be doing, which often results in the burning of things that should not burn. And yes, Hannu is a baker.[/quote]

That way, it will have all the information, in a simple format. For characters - is it possible for you to pull from two columns and put them in under one heading? If not, then I'm fine putting multiple characters under one column, as I did with Type.
*Comment# would come from the URL of the comment - such as#IDComment434143302 etc and the direct comment link would be there, in the same way as the page# link.

For the Extra Art, it would look similar, but not quite the same. This one, I think it would be best to sort it by both type and date. So that way, we would have all of the SSSS preview art together, and all of extra aRTD together, all of the aRTD preview panels, etc.

So this section would look something like:
[b]SSSS[/b]
Page 162. 7/20/2012. Characters: Main cast. Notes: SSSS preview lineup.
http://www.minnasundberg.fi/comic/page162.php

Page (XYZ) 7/21/2012. Characters: Lalli. Notes: First Lalli solo illustration.
(Url here)

[b]aRTD previews[/b]
Page ABC. 9/10/12. Characters: Hannu. Notes: Preview of chapter 7.
(Url here)

Like that.

That's what I have off the top of my head right now. Is there anything else you think we'll need for this? And of course - at this current time, our main concern is getting all of this into spreadsheet(s) in the first place, so that I can look at it and figure out how to put together the index.

Edited (clarification/fiddling) Date: 2016-01-29 04:54 am (UTC)

From:

aguacatillo

bunch of questions! if there are some you don't know/care no problem, i'll do what seems sensible along the way. there will probably be more questions as things come up too, as well as changes you'll want to ask for once initial spreadsheets start existing.

- text formatting:
when there are bolded words and stuff - is the preference to (a) remove it so all is plain text and there's no longer any record of what words were bolded (b) keep the html brackety markup (c) convert it to SSSS forum coding (my guess is this mostly will replace angle brackets with square ones) (d) see if i can make it show up with the words actually bolded, etc. in gdocs (not actually sure if this is possible?)

my first impulse is either (b) (and leave the html-to-BBcode conversion for the next stage) or double up columns of (a) and (b) if (a) makes for much easier reading.

- dates for comment-thread comments:
the date the page they are on was posted, or the date the comment itself was posted if different? (or both, in different columns)

- what i'm thinking of for columns:
· author's notes: Page, Page date, Type (will be blank), Content (the whole text of the note, so you'll have trimming to do for the ones where you don't just delete the whole line), Character column(s) (will probably be blank), Notes (will be blank), Page URL.
· comment threads: Page, Date(s), Type (will be blank), RepliedTo (the whole text of the comment that Minna's comment is in reply to), Comment (the username + whole text of a comment whose author is listed as Minna Sundberg), Character column(s) (will probably be blank), Notes (will be blank), Page URL, Comment URL.
· art: i'm going to think about this later when i'm more familiar with how the pages are put together.

suggestions/feedback/reordering/rename ideas on those? other potential columns include one saying whether a thing is art/note/comment, or what chapter number it is from.

- how many spreadsheets:
1 for art, 1 for author's notes, 1 for comment-thread comments, or should any of those be combined? (combining them may lead to columns that are frequently empty, like a RepliedTo column would be empty for art & author's notes.)

- and then far in the future after you've done all the organising and info-compiling and everything, as long as everything still lives in spreadsheets it ought to be possible to automatically turn spreadsheets into formatted forum posts (including combining same-chapter data from across multiple spreadsheets, and separating it all into single-post chunks respecting the character limit), but that's something to think about later.

- the plan for now (where 'now' does not imply 'today' but does imply 'before i get around to any more parts of this'): make initial author's notes and comment-thread spreadsheet(s) happen, and work out their best format.

From:

yuuago

Hmm let's see.

when there are bolded words and stuff
Do you have an example page so that I can see what kind of thing you mean? I can't think offhand of any cases where it would actually be important to preserve the formatting but if I see an example it might be easier to judge.
Option A, removing coding, would be easier to read, but if there are cases where formatting is important, then I guess we should go with Option B, convert to BBCode.

for comment-thread comments: the date the page they are on was posted, or the date the comment itself was posted if different? (or both, in different columns)
Hmm... I don't think we need to be 100% accurate to the day with this, because she usually replied within a day or two. On the other hand, accuracy... If it's easy to put columns for both dates, that would be good, if not just go with the page date.

Re: columns, that sounds great! Including whether it's art/note/comment would be great too. Chapter# is not 100% necessary, because it's easy to divide things up based on page#, I think. What do you think?

Re: # of spreadsheets, having a separate one for each thing sounds the best to me. It'll be easy to check data across the spreadsheets if necessary based on page number and date, anyway.

The far-in-the-future thing sounds wonderful. :) but indeed, it's for later.

I'm so excited!!! So, does the above sound fine to you? Do you have any more questions? For me, there's just one thing that I just thought of.

There are a few aRTD things on the SSSS site. This is not something I'll need for you to grab for me. (As far as I know, it's just some fanarts from the blog, and also one or two mentions in the descriptions/comment section) The amount is small enough that I think I will be able to put it together manually. But is there an easy way to account for aRTD stuff on the SSSS site in the aRTD spreadsheets?

From:

aguacatillo

'k, i've started with an authors note sheet (that's easier for me than comments, which are up next, whenever next is) --

Replies:

- i agree chapter number can be derived from page number, i won't make a column for it

- example of bolded words and stuff:
having looked at where html formatting is used, you're right that it pretty much makes no difference. I've just stripped it out for this spreadsheet version. You can see original at https://justpaste.it/rgso to check whether you agree with getting rid of it.

-Including whether it's art/note/comment
done.

- is there an easy way to account for aRTD stuff on the SSSS site in the aRTD spreadsheets:
if you add rows for each thing you want to include, and maybe put in something on the page # or Thing fields to indicate that it's from SSSS, that should work fine

New things:

- initial author's note spreadsheet exists, i twitter-dm'd link. p.s. i'm probably incompetent at gogle docs so kindly bear with me as needed

- the comments are very long! it looks like i can read the whole thing by double clicking it? (very inexperienced with gdocs, yes) but like... does that work as a long-term hundreds-of-pages thing? (as you'll probably be entirely deleting many of these rows anyway.) would something else work better? or perhaps re-order the columns so Content is a different place like after Characters?

- page number format, including numbering for double-wide pages:
right now I have just the number (rather than "Page ###"), and for double pages I have the two numbers separated by comma (no space after comma). Very easy to change though.

- date format:
in the page source they're written out like "September 2, 2013" but not really standardised (sometimes no comma, sometimes abbreviated month name). I'd like to try to eventually standardise this, but I don't care to what (words, or just numbers, what order, 4 digit years or 2, leading 0's on one-digit days/months or not)? It seems that auntie gdocs does this automatically when i import the spreadsheet.

- characters column:
it's just an initial list that you'll have to hand-correct - it pulls out character names from the text but it's not very smart so there will be some missing and probably some listed that shouldn't be. is it helpful for the characters column to be pre-populated like this or would it be better to start off blank? i can also keep this automatic characters column but add blank column(s) next to it for you to type, whatever's most convenient.

- all these format questions are just for what's in the spreadsheet; they can be changed later for the forum posts.

- comments/suggestions/change requests/any weird things in it you notice (because i haven't read through in detail)?

- you can edit that gdoc in any way; it's just an import of the output of my program so it's extremely easy to restore another untouched copy.

From:

yuuago

-Bolded words and stuff: Since it isn't used much, let's go with the stripped file then, it's easier, and the less code the better.

-SSSS: For author notes/comments on SSSS pages, I'll do it for page number, such as SSSS20 or whatever. And for stuff on the blog, I think it's all art only (no extra info) so when we get that together I'll put SSSSBlog or something in the Type field. There are a few things on dA that weren't crossposted to the site, so I'll probably throw that in the art spreadsheet as well, but again, I'll mark them as dA or similar.

---
Regarding new things:

Takk for the link, as I mentioned in twitter reply, it looks great. You're right about the author notes being... long. I was planning to prune all of them down to relevant info, but you're right, they sure are... long. I experimented with text wrapping (select column - format - text wrap), which makes it more legible, but still quite... long. Hmm. For now, moving the Content column to be placed between Characters and Notes might be a good idea. And then we can move it again later if it will look better that way.

Page number format looks good, it can stay as it is, I think.

Characters: Hmm... If it's something that I'm going to have to hand-correct anyway, it might be best to keep it blank. Adding to it is no problem, and if I forget to add something that's not so bad, but it would be weird to have stuff in there that shouldn't actually be there, especially if I eye-skip that error by accident.

So far I don't have any other change requests.

Okay, so - this will be the copy I'm to work from, then? (After above adjustments are made). If so, you know I'm totally gonna start on this after those tweaks. :V :V

And if you want to set it so that editing is locked to us specifically rather than anyone who has the link, you can share it to yuuago at gmail dot com
It doesn't make any difference really, but it's more secure that way.

From:

aguacatillo

in this version:

- applied text wrapping
- moved content between characters and notes
- Characters now blank
- now shared by email rather than anyone-with-link

- would you like the python script that generated it? i don't know if this is something you would use at all but it's no trouble to email it.

and yes, if you're alright with this version then i suppose it is the copy to work from (⁎⚈᷀᷁ω ⚈᷀᷁⁎)

presumably, i will be asking another set of questions when i get to threaded comments (which will not be this week *~* ), but feedback & change requests are always welcome any time as the pop up

From:

yuuago

Changes: Okay, that looks good. :Db

Python script: I can't code and don't know what I would do with it, sooo nah. I appreciate the offer, though.

-Righto, I'll start working from this then! Probably will start on it tonight. Probably going to go at it slowly, but... we will see. There's actually not that much there, when you get right down to it, which is encouraging.

One question: for formatting in character column, when there are multiple characters, do you think it would be better if I separate with space, or with comma? ie "Hannu Ville" vs "Hannu, Ville" The latter is easier to read, I think, but will it make any difference re: coding and the transfer we plan to do etc?

From:

aguacatillo

separate with space, or with comma:
A comma generally makes things a bit easier on my end, but I can make do either way so it's up to you '3'

nice icon :p

Edited (qt) Date: 2016-02-17 06:28 pm (UTC)

From:

yuuago

Commas for everyone, then!

~~except for loki-- wait, wrong mythology~~

From:

yuuago

As an FYI, once I get going on inputting/trimming stuff, I'll be marking it with colour (because I don't foresee myself doing these in order...) which I will then strip out once everything is finished.

Just figured I'd let you know in case you looked at it and something looked weird. ;p Though I haven't started on that yet, just deleting stuff that is very obviously not-content right now.