Google Sheets

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.

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.

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.

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.

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.

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.

Hi,

I've been working on a json (or any other format really) API for exploring simcountry data, with caching and all the bells and whistles.

Inspiration obviously taken from eve online which I played for many years, and did a lot of work with their external facing APIs (very fun tool).

It currently runs in a private network so there is no public access, but if there is interest, I could see about opening it up.

Which brings me to my question to Andy:

Do you have any issues about a public facing API exposing the data contained within the simcountry csv dumps? country data, scores, share prices, etc.

I'd be happy to share source code if desired, since I would be hosting it on my own infrastructure.

To clarify, the only the data contained within is what is contained in the csv dumps on the downloads page (which is already publicly accessible).

I can't speak for Andy, but in past there were a few websites that made use of the CSV files to compile some stats.

Nathan,

I am not sure I understand what you are asking for.

the available data is csv files.
can be used in excel.

Laguna recently asked for more tables to be available in csv format.

The pages are all html and it will require some development work per page to add a csv "Button".

We have a short list of very important functions that we really want to add ASAP.

Please explain what you need to get more out of the data.

I've taken the csv dumps provided and built an API around making that data more accessible in a programmatic way.

Currently it only returns Json but I plan to add a query parameter to most endpoints to return the data in csv.

Some endpoint examples:

Return a list of the last 30 market prices for Aircraft Carriers on white giant:

https://dev.sc.yeetbox.net/api/v1/market/wg/product/Aircraft%20Carriers/history?limit=30&keys=Market%20Price

All market prices in one go: https://dev.sc.yeetbox.net/api/v1/market/fb/prices

Getting information about a specific country: https://dev.sc.yeetbox.net/api/v1/country/Andy/data?world=wg

The API docs can be found here: https://sc.yeetbox.net/

This project originally started out as a "front end" overhaul, but I suck at that so I'm just focusing on high performance and reliable api endpoints instead.

This is just a hobby for

Just realized I used the dev. subdomain in the examples. That is where I test new features, all endpoints can be reached without the dev. subdomain normally

Added stock market endpoints:

https://sc.yeetbox.net/api/v1/stocks/ returns a list of all shares, pass ?world=gr to filter by world (gr for example)

Data on individual shares can be accessed with the following:

https://sc.yeetbox.net/api/v1/stocks/AA%20quin%20Defensive%20Missiles

Pull historical data with the following: https://sc.yeetbox.net/api/v1/stocks/AA%20quin%20Defensive%20Missiles/history