Giving the EG a Bit of a Remodel

[ProxCenBound]

Say we combine articles A, B, and C under the name of article A. Can B and C be somehow converted into redirects, Wikipedia style, so that links to them from other articles don't become dead?

[Avengium]

That is a god question. I wonder that too.

[Drashner1]

Say we combine articles A, B, and C under the name of article A. Can B and C be somehow converted into redirects, Wikipedia style, so that links to them from other articles don't become dead?

I think it would depend on how the combination was performed and the type of link.

If B and C were directly copy/pasted into A, including their in text hyperlinks, those links should be copy/pasted along with them. From there B and C would need to be modified to flow together with A and each other.

However, the links that appear at the end of the articles are managed via a different system and would not be transferred. They would have to be re-established manually. The good news is that (in my experience) in most cases where we are merging articles, there is a lot of overlap in the linked articles. As such, a lot of the links would already be in place for A. It is also very easy to establish article links and those that were not held in common could be added very quickly to the final article. Since the B and C articles wouldn't need to be deleted until we are ready, it would be pretty straightforward to note what article links they have at the end, check against what A has, and just establish those that need to be added. Then delete or hide B and C.

No need for any links to become dead, really,

Todd

[ProxCenBound]

What I was mainly asking about is, What about article X that linked to article C? Article C is now gone. Is that link in X dead? Can C be turned into a redirect for A instead?

[Drashner1]

What I was mainly asking about is, What about article X that linked to article C? Article C is now gone. Is that link in X dead? Can C be turned into a redirect for A instead?

Ah, I think I see what you mean now.

If the link to C is an intext hyperlink in article X, then I think the link will be gone.

If it's a case of article C is linked to from the list of related articles at the end of X, the editor could shift it over to the new combined article as part of the update process.

I'm not sure what is involved in generating redirects like what you describe. That would be a Trond (our Webmaster) question. I don't know if that would be an easy change or a hard change or is somehow not a factor due to the way the CMS already operates. I suppose we can ask him.

Todd

[ProxCenBound]

What I was mainly asking about is, What about article X that linked to article C? Article C is now gone. Is that link in X dead? Can C be turned into a redirect for A instead?

Ah, I think I see what you mean now.

If the link to C is an intext hyperlink in article X, then I think the link will be gone.

If it's a case of article C is linked to from the list of related articles at the end of X, the editor could shift it over to the new combined article as part of the update process.

I'm not sure what is involved in generating redirects like what you describe. That would be a Trond (our Webmaster) question. I don't know if that would be an easy change or a hard change or is somehow not a factor due to the way the CMS already operates. I suppose we can ask him.

Todd

I think if you guys ask Trond that would help a lot. If redirects are possible probably impacts how aggressively we merge articles. If redirects are not possible, tracking down 'what links to this page' will be quite difficult.

[Drashner1]

Update the structure and organization of our Links pages, including our Worldbuilding Resource page, calculators, etc. Aim is to make this section of the website easier to navigate and locate resources in. Ideas for additional resources (calculators, useful pages, etc.) welcome and please add by replying to this post.

Todd

[selden]

relativistic spaceflight calculator:
http://www.convertalot.com/relativistic_...lator.html

[Drashner1]

Create a 'worldbuilders resource' specific to OA that people can use to better develop articles for the site. Include existing EG entries that sit 'atop the fourth wall' or otherwise exist partially outside the setting or are more focused on educating readers about the setting or its supporting physics or features than being 'within' the setting.

Todd

[Drashner1]

So, a bit ago I posted something about creating a master timeline using a spreadsheet (which offers 2 dimensions for presenting information compared to the one dimension our current methods are limited to).

Since then I've been doing a bit of playing around with spreadsheets and also some reading on embedding a spreadsheet into a webpage. This evening I actually took a shot at doing one of these, using Excel online and OneDrive (both cloud based) to replicate a sub-section of the Wormhole Gazetteer and then generating an embedding code that created a subset of the spreadsheet in the EG.

It actually worked rather well (allowing for a bit of a learning curve). With a bit of work, I'm confident I could come close to replicating the look of our current tables on the website.

Some fun features that this type of embedded spreadsheet/table has:

1) The embed link stays connected to the master table on OneDrive. This means that we could place copies of the same table on several different EG pages - and update all of them at once just by updating the master table on OneDrive. No more having to remember to update all six timelines or the like.

2) It's possible to generate multiple embed codes from the same spreadsheet, each with different features - for example one embedded table could include sort and filter functions and be interactive for people on the website, while another table doesn't have these and only shows a portion of the first table. Or both could show different portions of the same table. All from one master, and all could be updated at the same time by updating the master. This might be used (with a bit of clever design) to show timelines for different planets or the like - all based on a single master table.

3) The ability to maintain different tables across the site from a central location (OneDrive), either by storing different classes of tables (system data panels, timelines, etc.) in OneDrive or creating a master Excel workbook with different classes to tables stored on different tabs. Or some combo of the two.

Now, all that said, there are a couple of potential issues:

a) The tables produced do have a Microsoft Excel logo in the bottom-left corner of the table.

b) The pages with my experimental tables might have occasionally taken a little bit longer to load as the site queried OneDrive and pulled down the image using the embed code. Or the web or my connection may have just temporarily slowed a bit. Other times there didn't seem to be any lag at all.

I'm not sure either of these are a major issue, but throwing it out there for a consideration.  

To answer a question that is likely to come up:

While I generally prefer Google products, include their cloud based work products, the Excel spreadsheet generator offers functionality that Google Sheets does not. Specifically, while Google Sheets can also generate embed codes, the results are a static table and cannot be sorted or filtered. The embedded table will reflect edits made to the master document, but the end user will see it as just a static table, not something they can interact with.

I suppose the big question would be how many tables would actually need/want sort/filter functions? Of course, if it came down to it we could maintain most of our tables in Google and only those that we wanted to have Sort/Filter functions in Excel/OneDrive.

Regarding Filters: The system allows for filtering by the contents of a cell. With clever design we could take advantage of that. It does not appear to allow filtering by cell color, which would be nice, but probably isn't a show stopper.

Alternatives to Embedded Tables: This line of thought got started when thinking about creating a Master Timeline with spreadsheet functionality. If we decide we would rather not embed tables in the website (and we would want to check with Trond before doing this btw to make sure there isn't a poison pill hiding in there somewhere) we could still create a Master Timeline and use it as a tool to help maintain consistency within the timeline and within articles that are impacted by the passage of history in the setting or by specific events. We could basically just make a link available somewhere and let Editors and members use it to help develop things. Although from what I've seen so far, the embedded functionality could be a nice thing, if we can use it w/o problems.

Thoughts?

Todd

EDIT: If folks would like to see what one of these looks like, I can set up a sample table in an out of the way corner of the site, or create a non-linked page with samples and then post a link here as we sometimes do with articles or the like. If this is something y'all would be interested in seeing/playing with please let me know.

Thanks!