Author Topic: SWOS 96/97 - complete database (incl. player skills)  (Read 42121 times)

0 Members and 1 Guest are viewing this topic.

Offline SKID

  • RES
  • *
  • Posts: 90
  • Gender: Male
Re: SWOS 96/97 - complete database (incl. player skills)
« Reply #30 on: 19 July 2007, 05:13:32 »
Whiteulver,
can you create a database in MS Excel format for offline using? IMHO it would be a great thing - Excel has sorting, searching and filtering tools
Possibly I am the only ONE Russian guy on this forum :)

Offline Playaveli

  • 'Sherlock'
  • Administrator
  • SWOS Legend
  • *****
  • Posts: 8422
  • Gender: Male
  • "SWOS - A way of life" (J.R.)
    • Visit me on Facebook
Re: SWOS 96/97 - complete database (incl. player skills)
« Reply #31 on: 19 July 2007, 08:47:18 »
Use HTTrack Website Copier and save the whole thing on your PC. ;)

And Excel isn't a dynamic PHP database.

For those about to SWOS - We salute you
http://www.facebook.com/playaveli.swos

Offline SKID

  • RES
  • *
  • Posts: 90
  • Gender: Male
Re: SWOS 96/97 - complete database (incl. player skills)
« Reply #32 on: 19 July 2007, 11:00:40 »
I want all database in one place as in Pablo's SWOS editor - all players in one sheet
I don't need a dynamic PHP database.
Online database as I see doesn't has any advantages if we compare it with possibilities of the editors.
Possibly I am the only ONE Russian guy on this forum :)

Offline Playaveli

  • 'Sherlock'
  • Administrator
  • SWOS Legend
  • *****
  • Posts: 8422
  • Gender: Male
  • "SWOS - A way of life" (J.R.)
    • Visit me on Facebook
Re: SWOS 96/97 - complete database (incl. player skills)
« Reply #33 on: 19 July 2007, 11:09:39 »
Of course it has advantages!

You can check player skills and clubs without having editor installed. Even if you are somewhere in the world on other PCs with internet...

For those about to SWOS - We salute you
http://www.facebook.com/playaveli.swos

Offline SKID

  • RES
  • *
  • Posts: 90
  • Gender: Male
Re: SWOS 96/97 - complete database (incl. player skills)
« Reply #34 on: 19 July 2007, 16:42:34 »
But I will not even need a PC if I will have an Excel-format of database!!!...Because I have Excel in my smartphone ;)
Possibly I am the only ONE Russian guy on this forum :)

Offline whiteulver

  • PRO
  • **
  • Posts: 172
  • Gender: Male
    • Sensible World Of Editor Soccer
Re: SWOS 96/97 - complete database (incl. player skills)
« Reply #35 on: 19 July 2007, 17:49:21 »
I want all database in one place as in Pablo's SWOS editor - all players in one sheet
I don't need a dynamic PHP database.
Online database as I see doesn't has any advantages if we compare it with possibilities of the editors.

An editor has 2 usage.

Editing and browsing.

Since many people here dont  use the editing option, most use browsing option, to search players etc.

The advantage of online database is that you can see swos players from your PC(with windows, linux or Mac), from your 3G mobile etc.

Offline LIK

  • Superstar
  • ****
  • Posts: 624
  • Gender: Male
Re: SWOS 96/97 - complete database (incl. player skills)
« Reply #36 on: 22 July 2007, 15:37:03 »
Great work  ;)
--- --- ---

Offline SKID

  • RES
  • *
  • Posts: 90
  • Gender: Male
Re: SWOS 96/97 - complete database (incl. player skills)
« Reply #37 on: 23 July 2007, 05:13:28 »
OK, as I see I will not have a database in Excel format. Why? - is it impossible to create it?

I understand that online database is for online browsing :) But not everybody has access to internet or has it but not constantly, even with GSM/3G phones. So I think that ideal situation is to have offline databases with SWOS Editors or Excel. Editors don't have many options for global filtering, for example, filtering ALL players by some criterias simultaneously. Excel is more flexible that's why I want xls-database.

I don't understand your reactions.
I asked CONCRETE question - "Can you create a database in MS Excel format for offline using?"
And you answered "Use HTTrack Website Copier and save the whole thing on your PC" and "The advantage of online database is that..."
I know that having online database + editors is better than only having editors. But I asked CONCRETE question!!! I don't need advices about how and when I can or must use online database.

- Do you know where to buy a RED T-Shirt?
- Try YELLOW, it's better.

;)

Possibly I am the only ONE Russian guy on this forum :)

Offline Playaveli

  • 'Sherlock'
  • Administrator
  • SWOS Legend
  • *****
  • Posts: 8422
  • Gender: Male
  • "SWOS - A way of life" (J.R.)
    • Visit me on Facebook
Re: SWOS 96/97 - complete database (incl. player skills)
« Reply #38 on: 23 July 2007, 09:37:45 »
Why don't you write a PM to Whiteulver? That's better...

So you'll make sure he reads it.

For those about to SWOS - We salute you
http://www.facebook.com/playaveli.swos

Offline whiteulver

  • PRO
  • **
  • Posts: 172
  • Gender: Male
    • Sensible World Of Editor Soccer
Re: SWOS 96/97 - complete database (incl. player skills)
« Reply #39 on: 23 July 2007, 17:33:58 »
OK, as I see I will not have a database in Excel format. Why? - is it impossible to create it?

I understand that online database is for online browsing :) But not everybody has access to internet or has it but not constantly, even with GSM/3G phones. So I think that ideal situation is to have offline databases with SWOS Editors or Excel. Editors don't have many options for global filtering, for example, filtering ALL players by some criterias simultaneously. Excel is more flexible that's why I want xls-database.

I don't understand your reactions.
I asked CONCRETE question - "Can you create a database in MS Excel format for offline using?"
And you answered "Use HTTrack Website Copier and save the whole thing on your PC" and "The advantage of online database is that..."
I know that having online database + editors is better than only having editors. But I asked CONCRETE question!!! I don't need advices about how and when I can or must use online database.

- Do you know where to buy a RED T-Shirt?
- Try YELLOW, it's better.

;)



The problem is this...

1) I dont have the time or the knowledge to make a code that exports swos database to excel file.

2) I dont have the time to write a code for exporitng swos database to .csv file (excel compatible)

Solution:

1) Use my editor to export teams to html files and convert them to excel files. (Excel can open html files)

2) Use online database ;)

3) Hire a programmer to do it, individual for your self :)

Offline SKID

  • RES
  • *
  • Posts: 90
  • Gender: Male
Re: SWOS 96/97 - complete database (incl. player skills)
« Reply #40 on: 24 July 2007, 04:31:43 »
Your editor doesn't export skills, prices, special abilities
Possibly I am the only ONE Russian guy on this forum :)

Offline Rijntje

  • 1337 SWoSs0r
  • Superstar
  • ****
  • Posts: 531
  • Gender: Male
Re: SWOS 96/97 - complete database (incl. player skills)
« Reply #41 on: 27 July 2007, 01:43:36 »
Whiteulver, I must truly say that you are like God or something.

Awesome database, very handy for my careers and other swos-player-research-nerdiness :D

Thank You!

Offline Pallister

  • Make SWOS - not WAR !!!
  • SWOS Legend
  • *****
  • Posts: 2724
  • Gender: Male
  • Only Amiga makes it possible!
    • *Amiga Shop*
Re: SWOS 96/97 - complete database (incl. player skills)
« Reply #42 on: 02 September 2007, 16:20:26 »
I'm so thankful for this database. I found Expedit Dossou Gbeteeeeeee because of this and added him to my team now. He's going to be a legend. And he would be the same, not-knowing average soccer player as before without u ;D

Offline daimaou

  • The King of the Banana Shots
  • SWOS Legend
  • *****
  • Posts: 1414
  • Gender: Male
Re: SWOS 96/97 - complete database (incl. player skills)
« Reply #43 on: 02 September 2007, 18:19:37 »
I'm so thankful for this database. I found Expedit Dossou Gbeteeeeeee because of this and added him to my team now. He's going to be a legend. And he would be the same, not-knowing average soccer player as before without u ;D

LOL

Offline xflea

  • Mr. Friendly League
  • SWOS Legend
  • *****
  • Posts: 1672
  • Gender: Male
  • hard rockin' amigo
Re: SWOS 96/97 - complete database (incl. player skills)
« Reply #44 on: 19 October 2007, 15:10:33 »
whiteulver - great work mate! your online database is simply brilliant

I always wanted to have the whole SWOS database in excel format and now it was a trivial thing to do - I just displayed ALL the players in the search mode (you were right - needs a lot of memory and good connection) and imported into excel

here it is:

http://xflea.republika.pl/swos/swos-database.zip
about 1MB .zip, 5MB .xls

I have made a few additions/changes:
1. I erased all CUSTOM teams
2. I made 2 spreadsheets: 1st for PLAYERS statistics (25.264 players altogether) and 2nd for TEAMS statistics (1.579 teams altogether)
3. I calculated the total number of points for each player/team
4. I changed the names of teams that are same in different leagues (eg. BARCELONA in Spain and BARCELONA in Ecuador are now BARCELONA (ESP) and BARCELONA (ECU) respectively)
5. I divided teams into 2 types: LEAGUE and NATIONAL

Some remarks:
1. there are no formulas in this excel file - I saved it all AS VALUES - it works MUCH faster...:)
2. many thanks to "Blind Playaveli" for beta-testing...:P
3. columns are:
in "players" spreadsheet:
No [number]
Name
Pos [position]
Nat [nationality]
PA [passing]
VE [velocity]
HE [heading]
TA [tackling]
CO [control]
SP [speed]
FI [finishing]
TOT [total number of skill points]
Value
Team
League
Type [LEAGUE or NATIONAL]
in "teams" spreadsheet:
Team
League
Type [LEAGUE or NATIONAL]
PA [passing]
VE [velocity]
HE [heading]
TA [tackling]
CO [control]
SP [speed]
FI [finishing]
TOT [total number of skill points]
Value
here are numbers summarized for each team...

enjoy! :D