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.
![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
Yuu. Fic writer & book lover. M/Canada.
Re: Computery stuff for aRTD index
Date: 2016-02-15 02:07 am (UTC)- 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.