CatoBase ltrans type mismatch SOLVED....possible OOTP bug?

Zweiblumen · 10-19-2004, 03:52 PM

So, I figured out what has been causing my ltrans import type mismatches, and I hope it fixes everyone else's too.

The ltrans file is pseudo HTML, with each player that is listed being inside an anchor tag with a reference to that player's html report page. Most player report pages have names like p1234.html and appear in the ltrans file as such, but for some reason a handful of players get entered into the ltrans file with html page names with an 'r' instead of a 'p'. When I remove those lines from the ltrans file, or change the r's to p's the import goes smoothly. I haven't tried an export yet, but hopefully it will work.

However, I wonder if this points to a possible OOTP bug. If you generate the league transaction report the same players that have the r1234.html report names are broken links. Strangely, if you go to the player pages themselves and ask for the html report it works, and the file is named with an 'r'. These players also have no career histories associated with them.

I'm going to crosspost this (or at least the bit about the odd entries in the ltrans file) in the troubleshooting forum, but I don't expect much back. It's a rather technical issue so I suspect only Markus can shed any light. At least we can continue to Cato, for now...

jmm8356 · 10-19-2004, 03:59 PM

Well, the r### numbers are reserved for retired players, AFAIK... but I can't figure any scenario where you'd have retired players in the transactions, since retirements are recorded in the League News (lnews), without links.

So that does seem fishy... good find and good info.

Zweiblumen · 10-19-2004, 04:09 PM

Also, I should have noted that if you're looking for the fastest way to fix your ltrans.txt to import into Cato, a search and replace from =r to =p will get you there, since the player html page name always comes right after an = sign.

jmm=> I did wonder if 'r' meant retired, but these players haven't actually retired. Perhaps they plan to in the coming season?
<checks computer>
Since I had simmed a number of seasons before trying to Cato, I do have the season that follows the one I noticed this problem in.....more odd behavior. No notes about these players retiring, but I can't find them anywhere. They do not appear when I do a 'Find player by name'

This is very odd indeed.

Long_Long_Name · 10-19-2004, 09:36 PM

I'll try to contribute. I noticed one of my players, Robert Lubbers, retired and was inducted in the hall of fame in 2018. However, in 2019, he's still active, and he links to r___.html. There's something fishy there

Zweiblumen · 10-19-2004, 09:55 PM

Strangely, though players have retired in my league, my 'View all retired players' page is empty....is anyone else seeing this?

enuttage · 10-24-2004, 08:04 PM

Thanks bro.

This fix helped a lot. Much obliged for the end to my frustrations. Cheers to Aggieland from the ATX.

-E

ctorg · 10-25-2004, 10:51 AM

Good find. If the issue comes up again, I'll know what to look for. Thanks for reporting it.

ctorg · 10-25-2004, 10:51 AM

dola,

It is odd that retired players would show up in transactions, isn't it?

enuttage · 10-25-2004, 10:52 AM

Unfortunately, the import side of things went smooth, but the export of HTML was a bloody mess.

Error 55 popping up everywhere. Back to the drawing board...

-Eric

crict · 10-26-2004, 09:37 PM

No solutions? Is it OK with 6.11?

After I finished my season in 6.10, I had to do the =r trick to get it to import, and I stopped exportation when I realized that player pages had twice the last season stats, one under the correct year, the other at year 0.

enuttage · 10-27-2004, 11:26 PM

Bump.

I'd like to know if others have this working yet as well.

-E

Mr.Opinion · 10-28-2004, 02:00 AM

I've been playing around with it for 2 days now, having the same problem. Tried removing primary keys, allowing duplicates, everything I can think of in the catobase database. Nothin though.

Zweiblumen · 10-28-2004, 08:53 AM

I haven't had any export problems (aside from the extreme slowness of my computer

) after doing my =r to =p changes in the ltrans files. As far as I can tell, the output looks good. I have seen a few minor issues here and there that seem unrelated, but no show stoppers.

Also, I never did get a response back from Mr Cato himself. I entered a support ticket a week ago. I also emailed him and offered my help with CatoBase bug fixing and development, as I'm a programmer in need of a project, but haven't heard anything back. It's always bad when the lead developer of a closed source project like Cato goes missing. If it were open I could just hop in and start fixing stuff.

Oh well.

10-19-2004, 03:52 PM	#1
Zweiblumen Major Leagues Join Date: Mar 2004 Location: Boston, MA Posts: 326	CatoBase ltrans type mismatch SOLVED....possible OOTP bug? So, I figured out what has been causing my ltrans import type mismatches, and I hope it fixes everyone else's too. The ltrans file is pseudo HTML, with each player that is listed being inside an anchor tag with a reference to that player's html report page. Most player report pages have names like p1234.html and appear in the ltrans file as such, but for some reason a handful of players get entered into the ltrans file with html page names with an 'r' instead of a 'p'. When I remove those lines from the ltrans file, or change the r's to p's the import goes smoothly. I haven't tried an export yet, but hopefully it will work. However, I wonder if this points to a possible OOTP bug. If you generate the league transaction report the same players that have the r1234.html report names are broken links. Strangely, if you go to the player pages themselves and ask for the html report it works, and the file is named with an 'r'. These players also have no career histories associated with them. I'm going to crosspost this (or at least the bit about the odd entries in the ltrans file) in the troubleshooting forum, but I don't expect much back. It's a rather technical issue so I suspect only Markus can shed any light. At least we can continue to Cato, for now...

10-19-2004, 03:59 PM	#2
jmm8356 All Star Starter Join Date: Jul 2004 Location: Lafayette IN (by way of Tonawanda NY) Posts: 1,673	Well, the r### numbers are reserved for retired players, AFAIK... but I can't figure any scenario where you'd have retired players in the transactions, since retirements are recorded in the League News (lnews), without links. So that does seem fishy... good find and good info. __________________ Jeremy from Tonawanda --- Go Cubbies! --- Unofficial Theta Tester(tm) "Oh, we got both kinds. We got country and western!" From OOTP 6: Designated for Assignment FAQ (Includes both problems and solutions! Ooooo! )

10-19-2004, 09:36 PM	#4
Long_Long_Name Hall Of Famer Join Date: Jan 2002 Location: Montréal Posts: 7,065	I'll try to contribute. I noticed one of my players, Robert Lubbers, retired and was inducted in the hall of fame in 2018. However, in 2019, he's still active, and he links to r___.html. There's something fishy there __________________ Beta Baseball. Join it!

10-24-2004, 08:04 PM	#6
enuttage Hall Of Famer Join Date: Mar 2002 Location: Hill Country Posts: 2,428	Thanks bro. This fix helped a lot. Much obliged for the end to my frustrations. Cheers to Aggieland from the ATX. -E __________________ The former GM of the WHBL Managua Four Roses *"The best way to find out if you can trust somebody is to trust them."*

10-25-2004, 10:51 AM	#7
ctorg Global Moderator Join Date: Nov 2002 Location: Queens, NY Posts: 9,848	Good find. If the issue comes up again, I'll know what to look for. Thanks for reporting it. __________________ My music "When the trees blow back and forth, that's what makes the wind." - Steven Wright Fjord emena pancreas thorax fornicate marmalade morpheme proteolysis smaxa cabana offal srue vitriol grope hallelujah lentils

10-19-2004, 04:09 PM	#3
Zweiblumen Major Leagues Join Date: Mar 2004 Location: Boston, MA Posts: 326	Also, I should have noted that if you're looking for the fastest way to fix your ltrans.txt to import into Cato, a search and replace from =r to =p will get you there, since the player html page name always comes right after an = sign. jmm=> I did wonder if 'r' meant retired, but these players haven't actually retired. Perhaps they plan to in the coming season? <checks computer> Since I had simmed a number of seasons before trying to Cato, I do have the season that follows the one I noticed this problem in.....more odd behavior. No notes about these players retiring, but I can't find them anywhere. They do not appear when I do a 'Find player by name' This is very odd indeed.

10-19-2004, 09:55 PM	#5
Zweiblumen Major Leagues Join Date: Mar 2004 Location: Boston, MA Posts: 326	Strangely, though players have retired in my league, my 'View all retired players' page is empty....is anyone else seeing this?

10-25-2004, 10:52 AM	#9
enuttage Hall Of Famer Join Date: Mar 2002 Location: Hill Country Posts: 2,428	Unfortunately, the import side of things went smooth, but the export of HTML was a bloody mess. Error 55 popping up everywhere. Back to the drawing board... -Eric __________________ The former GM of the WHBL Managua Four Roses *"The best way to find out if you can trust somebody is to trust them."*

10-26-2004, 09:37 PM	#10
crict Minors (Rookie Ball) Join Date: Jan 2003 Posts: 37	No solutions? Is it OK with 6.11? After I finished my season in 6.10, I had to do the =r trick to get it to import, and I stopped exportation when I realized that player pages had twice the last season stats, one under the correct year, the other at year 0.

10-27-2004, 11:26 PM	#11
enuttage Hall Of Famer Join Date: Mar 2002 Location: Hill Country Posts: 2,428	Bump. I'd like to know if others have this working yet as well. -E __________________ The former GM of the WHBL Managua Four Roses *"The best way to find out if you can trust somebody is to trust them."*

10-28-2004, 02:00 AM	#12
Mr.Opinion All Star Reserve Join Date: May 2003 Location: SkiFree Lodge Posts: 883	I've been playing around with it for 2 days now, having the same problem. Tried removing primary keys, allowing duplicates, everything I can think of in the catobase database. Nothin though. __________________

10-28-2004, 08:53 AM	#13
Zweiblumen Major Leagues Join Date: Mar 2004 Location: Boston, MA Posts: 326	I haven't had any export problems (aside from the extreme slowness of my computer ) after doing my =r to =p changes in the ltrans files. As far as I can tell, the output looks good. I have seen a few minor issues here and there that seem unrelated, but no show stoppers. Also, I never did get a response back from Mr Cato himself. I entered a support ticket a week ago. I also emailed him and offered my help with CatoBase bug fixing and development, as I'm a programmer in need of a project, but haven't heard anything back. It's always bad when the lead developer of a closed source project like Cato goes missing. If it were open I could just hop in and start fixing stuff. Oh well. Last edited by Zweiblumen; 10-28-2004 at 08:55 AM.