Loading xml schedule switches team

[mjj55409]

I've started a 19th c. sim, and I have an Excel sheet that helps in converting the Retrosheet game logs into xml schedules. Using this, I've created an xml schedule file for 1872. I'm running into a problem when I load the schedule. The team id numbers seem to be swapping upon loading. I'll give you an example.

The first game of the season should be on 4/18/1872 with the Baltimore club visiting the Olympics of Washington. The first line of the GAMES section of my xml schedule reads:

GAME day="1" time="1300" away="7" home="4" /

When I load the schedule and look at the games for 4/18, I see that New York is scheduled to play Brooklyn. So, I go to the schedule editor, export the schedule to another xml file. In this exported file, the first line of the GAMES section reads:

GAME day="1" time="1300" away="3" home="9" /

How is it that 7 becomes 3 and 4 becomes 9? This is a problem across the board, resulting in teams have an inaccurate number of games.

Anyone have any clues? The alternative is to create the schedule by hand in game, which is not so appetizing.

Regards,
Michael

[mjj55409]

I know it is contraindicated to bump a tech support post, but it's been over a week. Any thoughts on this?

I input the schedule for my next season by hand. I don't want to do too much of that, as the scheduler UI leaves something to be desired (but that's another post).

[SandMan]

did you make sure the schedule actually loaded? After you load the schedule go to another screen and then come back to edit schedule. From there do the schedule grid and see that it actually loaded. The name of the schedule should appear in the edit schedule screen. I think it may not be loading and then the game is creating a fictional schedule. Also make sure that the schedule format is in the exact format as your league. I have tested over 100 schedules in the 2007 schedule pack with no errors other than human errors on my part. Also make sure that the schedule heading matches the header information in the other schedules exactly. One mistake and the file will not load.

Is the schedule you trying to load one of the files from the 2007 conversion pack I did, if so let me know which file and I test it out and make sure it works.

Regards,



Sandman

[mjj55409]

It could certainly be human error. I'm sure it has something to do with the team numbers that need to be used in the xml file. To be clear, how are the numbers determined and are they constant across the years? Since this is the 19th c., there are teams folding and new teams entering the league each year. This could be part of the problem.

Assume you have these four teams:

Boston BNA
Chicago CNA
New York NNA
Troy TRO

I'm assuming the team numbers are sorted by id:

1 - Boston
2 - Chicago
3 - New York
4 - Troy

Now, assume that Chicago is deleted and Washington is added. Is the numbering this:

1 - Boston
3 - New York
4 - Troy
5 - Washington

Or this:

1 - Boston
2 - New York
3 - Troy
4 - Washington

[Curtis]

Should be 1,3,4,5 in your example. Would be 1,3,4,2 if Chicago moved to Washington.

[mjj55409]

Originally Posted by Curtis

Should be 1,3,4,5 in your example. Would be 1,3,4,2 if Chicago moved to Washington.

Thanks. This helps. Let me run some more tests.

[Zeyes]

FWIW, it seems the game uses a different numbering when importing schedules than it does when exporting them.

I used a 4-team division, which we'll mock-up like this:

TeamAAA
TeamBBB
TeamCCC
TeamDDD

Entering them alphabetically like that, they're also numbered in the same order. I then deleted CCC, and added a new team, which I then renamed to TeamABC. That way, the 3rd slot team was deleted, the new team went into the 4th slot as per the screen display (and the team ID, as per a csv export), and by alpha-sorting it moved into the 2nd slot.

That covered a few possibilities. :-) Then I imported the same schedule again.

TeamAAA's first home game is set up like this in the schedule file:

<GAME home="1" away="2" time="1905" day="5" />
< GAME day="5" time="1905" away="2" home="1" / >

Correctly, it was TeamBBB @ TeamAAA before the team changes. Afterwards, it was TeamABC @ TeamAAA, which seems to indicate that for importing purposes, OOTP is ordering the teams in alphabetical order in each division when it maps them to the schedule file numbering.

However, if I now export the new schedule, AAA's first home game shows up like this:

<GAME home="1" away="4" time="1905" day="5" />
< GAME day="5" time="1905" away="4" home="1" / >

Apparently, once the schedule was loaded, the regular ordering by Team ID takes over within the game, and TeamABC becomes the 4th team instead of the 2nd.

That messes things up if one repeatedly imports and exports the same schedule...in the above example, re-importing the exported schedule results in the game being TeamDDD @ TeamAAA, because DDD is the 4th team in alpha order.

(And if I export it yet again, the schedule entry becomes < GAME day="5" time="1905" away="3" home="1" / > because TeamDDD is the 3rd team by Team ID. Etc. Etc.)

[bp_]

mjj55409, any update on your situation here?

[mjj55409]

The league I'm having this problem with is on hold for now because of this. I still think it may be a problem, I have a couple of things I want to try before I fully verify it.

[Nutlaw]

Any progress on this one yet?

[Nutlaw]

As there has been no reply to this thread in a week, it will be closed. If you need any further assistance with this issue, please ask a moderator to re-open the thread. Thanks.