Post #1 · Posted at 2011-07-23 04:07:44pm 13.5 years ago
![]() | |
---|---|
![]() |
Member |
617 Posts | |
![]() | |
Reg. 2010-07-08 | |
![]() | |
"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.
I'm willing to help Al with programming/XML standard for the score data if need be.
Post #2 · Posted at 2011-07-23 04:18:47pm 13.5 years ago
![]() | |
---|---|
![]() |
Member |
1,289 Posts | |
![]() | |
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 13.5 years ago
![]() | |
---|---|
![]() |
Member |
43 Posts | |
![]() | |
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.
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.
Post #4 · Posted at 2011-07-23 07:43:49pm 13.5 years ago
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.
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.
Post #5 · Posted at 2011-07-23 11:10:44pm 13.5 years ago
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.
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 13.5 years ago
![]() | |
---|---|
![]() |
Member |
617 Posts | |
![]() | |
Reg. 2010-07-08 | |
![]() | |
"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.
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.
Post #7 · Posted at 2011-07-24 06:01:59am 13.5 years ago
![]() | |
---|---|
![]() |
Admin |
9,396 Posts | |
![]() | |
Reg. 2006-05-01 | |
![]() | |
"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.
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 13.5 years ago
![]() | |
---|---|
![]() |
Member |
617 Posts | |
![]() | |
Reg. 2010-07-08 | |
![]() | |
"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.
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.
Post #9 · Posted at 2011-07-25 07:28:52pm 13.5 years ago
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.
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 13.5 years ago
![]() | |
---|---|
![]() |
Member |
617 Posts | |
![]() | |
Reg. 2010-07-08 | |
![]() | |
"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?
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?
Post #11 · Posted at 2011-07-25 09:30:17pm 13.5 years ago
![]() | |
---|---|
![]() |
Member |
43 Posts | |
![]() | |
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.
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.
Post #12 · Posted at 2011-07-26 12:07:45am 13.5 years ago
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 13.5 years ago
![]() | |
---|---|
![]() |
Member |
617 Posts | |
![]() | |
Reg. 2010-07-08 | |
![]() | |
"Wow, 4 types of corn!" |
Oh, a CSV file would be more convenient come to think about it. The simpler the better.
Post #14 · Posted at 2011-07-26 05:45:00am 13.5 years ago
![]() | |
---|---|
![]() |
Admin |
9,396 Posts | |
![]() | |
Reg. 2006-05-01 | |
![]() | |
"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.
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 13.5 years ago
![]() | |
---|---|
![]() |
Member |
617 Posts | |
![]() | |
Reg. 2010-07-08 | |
![]() | |
"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?
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?
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",""
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?
Post #16 · Posted at 2011-07-27 12:01:02am 13.5 years ago
![]() | |
---|---|
![]() |
Admin |
9,396 Posts | |
![]() | |
Reg. 2006-05-01 | |
![]() | |
"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.
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.