Simcountry is a multiplayer Internet game in which you are the president, commander in chief, and industrial leader. You have to make the tough decisions about cutting or raising taxes, how to allocate the federal budget, what kind of infrastructure you want, etc..
  Enter the Game

Google Sheets

Topics: Off-Topic: Google Sheets

Laguna

Thursday, October 31, 2024 - 11:14 pm Click here to edit this post
Anybody else having issues copying tables from Simcountry on to Google Sheets? I used to be able to copy tables on there just fine, but now my browser gets stuck trying to process.

Andy

Saturday, November 2, 2024 - 10:25 pm Click here to edit this post
what did you try to do?
can you give me the example.
we will try it here.

probably a lot of formatting between the numbers.

Laguna

Saturday, November 2, 2024 - 11:10 pm Click here to edit this post
Thanks, Andy.

I am copying the table in "Products in stock; buy and sell" and pasting into Google Sheets.

Just the simple act of pasting takes about a 1m, or never finishes.

I am on Firefox, btw. If it works fine for you on another browser, let me know, please.

Andy

Monday, November 4, 2024 - 12:33 pm Click here to edit this post
The problem is that this page looks like text and numbers but there is a lot of formatting info in between them.
if you ask the browser to show the source of the page you will see
that the real data is herd to find.

it will be nice if it would work.

what we need is in fact a function that creates a csv (comma separated
file) that is readable by excel.
Same way we create the data dumps that are available on the site.

Some pages will be very nice to have in that format.

I will discuss here and come back with more info.

Andy

Tuesday, November 5, 2024 - 09:58 am Click here to edit this post
All our tables on the screen are HTML.

most of the page content is formatting code and the data is embedded in between.

The pages are generated on request, when you click on the link.

to make it possible to copy to excel, the data needs to be written in csv format which means that all these pages must be done in very different way and placed as a link on the current page.

This is nice to have and a major development effort.

we are quite busy with very urgent issues that need to have priority.

many of these issues are described on the forum and we are quite busy
resolving/adding them.

some will be added in the coming upgrade this week and more in each following upgrade.

Laguna

Tuesday, November 5, 2024 - 10:19 am Click here to edit this post
That's perfectly reasonable. This is a very minor thing.

If I were to ask something of this sort, I'd ask something akin to EVE Online's Excel add-in, that pulls all the info from the game.

Never used it, or played the game, but it seems to be the benchmark for this sort of thing.


Add a Message