Logo

Score Tracker Import/Export functionality?

Thread Locked Back To Forums

Post #1 · Posted at 2011-07-23 04:07:44pm 12.6 years ago

Offline seishinbyou
seishinbyou Avatar Member
617 帖子
Japan
Reg. 2010-07-08

Game Center Nickname: aijbot
"Wow, 4 types of corn!"
Is there interest in XML import/export of score data? I would think that would be an excellent feature if implemented.

I'm willing to help Al with programming/XML standard for the score data if need be.
http://aaronin.jp/shashin/konmainewbanner.jpg

Post #2 · Posted at 2011-07-23 04:18:47pm 12.6 years ago

Offline Kon
Kon Avatar Member
1,288 帖子
United States
Reg. 2007-07-02

"OMG KON!"
Posting just to say I am seconding this request.

Post #3 · Posted at 2011-07-23 04:45:34pm 12.6 years ago

Offline SilverHx
SilverHx Avatar Member
43 帖子
Italy
Reg. 2011-07-15

It could be a nice feature to have, but let me tell you why I would probably still use SSS for IIDX score keeping: you can import your savegame data. I know it's kinda a pain to implement that, because of the different formats the games use, but that's the major reason I use SSS over other scorekeeping websites.

Speaking of memorymani, why don't you add a way to make it compatible with ZIV by providing a proper API? That could be a step in the right direction, although I'm not particularilly fond of that piece of software.

I also prefer how the signature looks like in SSS, but that's just personal flavour.
beatmaniaIIDX is srs business
One more extra score - My youtube channel

http://iidx.solidstatesquad.com/siginclude/646.png

Post #4 · Posted at 2011-07-23 07:43:49pm 12.6 years ago

Offline PanStyle
PanStyle Avatar Member
1,054 帖子
France
Reg. 2007-07-05


Last updated: 2011-07-23 11:16pm
Back in V3 or V4... wasn't something like this in the score tracker. I barely remember...
That would be a nice stuff. I used to made my own list ans some other friends too (sometimes by copy-pasta the score tracker).
A customable export option would be nice.

I mean, the score tracker is so customisable. If we could export what we have it could be awesome (like choosing DDRX arcade, expert difficulty, ordered by level, only songs without pfc). You know what i mean i think.

And of course i'm talking about the DDR Score Tracker. But maybe some IIDX player would have to have the same thing for IIDX.
http://i26.photobucket.com/albums/c113/lordtoon/User%20Names/PanStyle.png http://zenius-i-vanisher.com/ddrsig/1336.png?t=1284597568

Post #5 · Posted at 2011-07-23 11:10:44pm 12.6 years ago

Offline al2k4
al2k4 Avatar Admin
9,387 帖子
United Kingdom
Reg. 2006-05-01

Nintendo Switch Friend Code: SW-6451-2397-9509
"BEMANI Sound Team"

Last updated: 2011-07-23 11:11pm
I don't think there was ever an export option, I think maybe just a printable score sheet or something like that. I'll put this on my ever-growing to-do list.

About the IIDX import, it will take me forever to map the charts to the IDs that are currently on this site, so that is low-priority at the moment.

Post #6 · Posted at 2011-07-24 05:48:01am 12.6 years ago

Offline seishinbyou
seishinbyou Avatar Member
617 帖子
Japan
Reg. 2010-07-08

Game Center Nickname: aijbot
"Wow, 4 types of corn!"
Oh, I'd even be interested in a completely stripped down version that lets you import a CSV list with (song ID/identifier) and letter grade. Fill in the details on the site/score tracker later.

Of course, there is the matter of the unique song ID/identifier but I assume this is already done in the backend of the database somewhere.
http://aaronin.jp/shashin/konmainewbanner.jpg

Post #7 · Posted at 2011-07-24 06:01:59am 12.6 years ago

Offline al2k4
al2k4 Avatar Admin
9,387 帖子
United Kingdom
Reg. 2006-05-01

Nintendo Switch Friend Code: SW-6451-2397-9509
"BEMANI Sound Team"
In the backend for score tracking purposes:

Each game is assigned from hundreds of charts to a few thousand charts depending on how big the game is.

A chart is uniquely identifiable if I get the game ID and difficulty pair somehow.

Each score is assigned to a chart, rather than a game/difficulty pair.

Post #8 · Posted at 2011-07-25 06:43:03pm 12.6 years ago

Offline seishinbyou
seishinbyou Avatar Member
617 帖子
Japan
Reg. 2010-07-08

Game Center Nickname: aijbot
"Wow, 4 types of corn!"
Okay, then how about this (even if it will require a bit of a setup)

Make a separate mapping table that would associate a song (ID) and difficulty (ID) pair with a chart.
It would be an interim table, but as far as XML data goes, you could use the song/difficulty IDs and then match them in that interim table before matching the score data you wish to import/export with the actual chart ID.

(really bad, generalized example of import data)

<scoredata>
<song>.59</song><difficulty>Expert</difficulty><style>single</style><modifiers>(stuff here)</modifiers><grade>AA</grade><score>6500000</score><marvellous></marvellous><perfect></perfect><great></great><good></good><boo></boo><miss></miss><ok></ok>
</scoredata>

Of course, perhaps a lot of these tags might not even be necessary for import if you can fill in the data later.

Then in the interim table (or one per mix?), you could have a simple table with:

* Song ID
* Difficulty ID (including Single/Double)
* Chart ID

So that when the match is made, the data can be imported.

Or something like that anyways. How does that sound? If we started with a very tiny mix (say, DDR 1st), I wouldn't mind being the guinea pig for some import/export sessions.
http://aaronin.jp/shashin/konmainewbanner.jpg

Post #9 · Posted at 2011-07-25 07:28:52pm 12.6 years ago

Offline al2k4
al2k4 Avatar Admin
9,387 帖子
United Kingdom
Reg. 2006-05-01

Nintendo Switch Friend Code: SW-6451-2397-9509
"BEMANI Sound Team"

Last updated: 2011-07-25 07:29pm
Just realised a mistake in my post earlier. A chart is uniquely identifiable with three fields:

Game ID + Song ID + Difficulty

There is a case where Song ID and Difficulty is not enough, for example bag on EXTREME and bag on X where 12ths got fixed.

If you used bag and Single Expert only it could reference EITHER of those charts so we need a game ID in there somehow or just ignore those where more than two charts are applicable to that song/difficulty pair.

Post #10 · Posted at 2011-07-25 08:04:26pm 12.6 years ago

Offline seishinbyou
seishinbyou Avatar Member
617 帖子
Japan
Reg. 2010-07-08

Game Center Nickname: aijbot
"Wow, 4 types of corn!"
Okay, fine enough. Even though it makes things a bit more complicated, add a Game ID field to both the interim table and the XML data and you are good to go.

bag is such a messy example anyways since it was "fixed" once in SN2, "fixed" again on X/X2 and then the original Extreme chart was re-released as the Challenge chart on X2. Keeping songs limited to mix should prevent most of the potential conflicts with charts and reworked quantization.

Of course, this does create the possibility that someone could register two scores for the same song on two different mixes and have it count as two separate scores :/ Maybe something like making sure the song/difficulty pairs are unique on the player end would help? But then if you "UNIQ" it, which score do you go by?
http://aaronin.jp/shashin/konmainewbanner.jpg

Post #11 · Posted at 2011-07-25 09:30:17pm 12.6 years ago

Offline SilverHx
SilverHx Avatar Member
43 帖子
Italy
Reg. 2011-07-15

SSS doesn't rely on game/song/diff combination. Same songs in different styles are merged into one single entry, with a few exceptions, like GAMBOL or THE SAFARI, which provide a different notechart for different games.

But I agree that each chart should be identified by game/song/diff. It's more flexible, and it's more transparent for the user: after all, at least in IIDX, almost each game has a different timing and they definitely have different gameplay options, which can make playing easier/harder.
beatmaniaIIDX is srs business
One more extra score - My youtube channel

http://iidx.solidstatesquad.com/siginclude/646.png

Post #12 · Posted at 2011-07-26 12:07:45am 12.6 years ago

Offline al2k4
al2k4 Avatar Admin
9,387 帖子
United Kingdom
Reg. 2006-05-01

Nintendo Switch Friend Code: SW-6451-2397-9509
"BEMANI Sound Team"

Last updated: 2011-07-26 12:09am
Quote: SilverHx
SSS doesn't rely on game/song/diff combination. Same songs in different styles are merged into one single entry, with a few exceptions, like GAMBOL or THE SAFARI, which provide a different notechart for different games.

That's how it is here. There is not a new chart PER game, it's just when the chart changes substantially enough for me to create a new one.

On a related note, wouldn't exporting/importing a CSV file be more convenient?

Post #13 · Posted at 2011-07-26 04:12:07am 12.6 years ago

Offline seishinbyou
seishinbyou Avatar Member
617 帖子
Japan
Reg. 2010-07-08

Game Center Nickname: aijbot
"Wow, 4 types of corn!"
Oh, a CSV file would be more convenient come to think about it. The simpler the better.
http://aaronin.jp/shashin/konmainewbanner.jpg

Post #14 · Posted at 2011-07-26 05:45:00am 12.6 years ago

Offline al2k4
al2k4 Avatar Admin
9,387 帖子
United Kingdom
Reg. 2006-05-01

Nintendo Switch Friend Code: SW-6451-2397-9509
"BEMANI Sound Team"
http://zenius-i-vanisher.com/v5.2/ddrscoretracker_csvexport.php

Only works if you're logged in but that's the CSV export for yourself.

Post #15 · Posted at 2011-07-26 07:18:59pm 12.6 years ago

Offline seishinbyou
seishinbyou Avatar Member
617 帖子
Japan
Reg. 2010-07-08

Game Center Nickname: aijbot
"Wow, 4 types of corn!"
Okay, I entered in one random score and tested it out. So far it looks good, though the codes are a bit cryptic for the notechart, song and game IDs. Maybe in the end stages of this you can have a FAQ with all the IDs and what they map to so a humble/crazy user could craft their own CSV files?

Quote
notechartid,songid,difficulty,gameid,songname,dancepoints,marvelous,perfect,great,good,almost,boo,speed,boost,appearance,turn,dark,scroll,arrow,other,pass,fullcombo,timestamp,comment,picture,video
285,1530,scha,286,"Xepher",1088,431,99,0,0,0,0,2.5x,Off,Normal,Normal,Off,Normal,Note,Normal,1,1,1311707427,"","http://zenius-i-vanisher.com/v5.2/viewpicture.php?pictureid=15721",""

Now, if I wanted to import the data again (I know this isn't done yet), would I be asked if I wanted to nuke my old data first (and overwrite with what is imported)? Also, if there are other unrelated scores in the tracker when you import, will those scores remain or will all scores be wiped when the user does an import?
http://aaronin.jp/shashin/konmainewbanner.jpg

Post #16 · Posted at 2011-07-27 12:01:02am 12.6 years ago

Offline al2k4
al2k4 Avatar Admin
9,387 帖子
United Kingdom
Reg. 2006-05-01

Nintendo Switch Friend Code: SW-6451-2397-9509
"BEMANI Sound Team"
A chart is not assigned to any difficulty so that might be an issue, a chart is only issued a Song ID ONLY.

There is a separate table that links <chart + game + difficulty + song> together, just to put this in perspective:

There are 4,868 unique charts in the database at the moment.
There are 60,213 links linking chart/game/difficulty/song together.

I will make a list of the games with their game IDs and a list of the songs with their song IDs, I think that would help somewhat.
Thread Locked Back To Forums

0 User(s) Viewing This Thread (Past 15 Minutes)

©2006-2024 Zenius -I- vanisher.com -5th style- IIPrivacy Policy
Web Server: 4% · Database: 4% · Server Time: 2024-03-28 17:10:33
This page took 0.01 seconds to execute.
Theme: starlight · Language: chinesetraditional
Reset Theme & Language