Catobase Problem - lnews and ltrans

Operation Shutdown · 07-15-2004, 11:15 AM

Catobase doesn't seem to be reading the lnews and ltrans text files at all whenver I'm running. These files are in my League_News_Box folder of my league folder and the program seems to be copying them to the data folder when doing the exporting. However, I'm getting an invalid procedure call or argument whenver trying to import the All-Stars and Award Winners and I took a quick look at the batting stats table in Access and none of the players that were traded midseason are getting any split stats, they're all with the team they were traded to. The current league I'm trying to import was imported from version 3 to version 4 to version 5 and into version6, so I don't know if this might be the problem or not. Is there anyway to just use the html pages like the program used to do?

P.S. The only difference I see between a text file created by OOTP 6, and one that was created before was the addition of different HTML tags, either bold or <a> tags to link the player to his player page. Could this be the cause of the problem?

jcato · 07-15-2004, 01:55 PM

If you send me the data files, I'll take a look and see what's causing the problem. You can try the HTML files, too. Make sure the CSV files are in the data directory, copy the HTML files to the data directory and delete the text files in the data directory. Uncheck the Run Exporters... box on the Options screen and then import the stats. When it can't find the text files, it will look for the HTML files and use those.

Operation Shutdown · 07-15-2004, 10:56 PM

Using the html files did the trick. I'll have to remind myself to send in a support ticket later, as I'm way too busy right now to do it.

Long_Long_Name · 08-04-2004, 08:14 PM

I have a question. I'm having a similar problem with ltrans and lnews, but if I disable "run exporter...", won't it affect the year I'm trying to import? I mean, won't it not run the exporter and ruin the whole point of importing stats, since csv files won't be created? Or am I missing something?

Operation Shutdown · 08-04-2004, 08:26 PM

What I had done for that one season was to delete the previous season currently in the CATObase, since it didn't import correctly. So what I did was use the CSV files already created and then move the ltrans and lnews html files into the data directory and re-imported with the run exporter unchecked.

After all that, I found that I could just move the ltrans and lnews text files out of the league_news_box folder, put the lnews and ltrans html files into the data folder and then when done importing I put the text files back into the league_news_box folder. Ohhh, and don't remove the text files before generating the html files, or you'll wind up with blank html files.

Hope this helps...

Long_Long_Name · 08-04-2004, 08:45 PM

I'll be more explicit about my situation.

I can't run CatoBase on my computer, since it doesn't like the date format and gives me a ton of error messages. However, I had a pretty good grasp of how the software worked, so I asked someone else to run it, and I would help him run the software.

I have 5 years to import, 2005 through 2009. The first four are OOTP5, and 2009 is OOTP6. 2005, 2006 and 2008 run smoothly, but I don't have the League_News_Box folder for 2007 and 2009. I, however, have the generated HTML pages for both years. Basically, I have ltrans.html and lnews.html, but neither .txt file. I "built" correct txt pages for lnews, but ltrans seems like hell to do. Anyway, that's when I saw this thread.

Since I don't run the program on my computer and my "helper" isn't online right now, I don't know at exactly what moment CatoBase gives you the "file not found" prompt, or where it stops functioning.

What I gather from this thread is that I should give the following instructions to my man:

Import 2007 Stats with "Run Exporter" checked on.
Remove the 2007 season.
Put html files in "data" folder.
Import 2007 Stats.

Am I missing something, will this work? What instructions should I give my helper? Or am I just screwed no matter what if I don't have txt files?

Treches · 08-05-2004, 07:52 AM

Can't help you on those matters, but I had the same problem running CatoBase on my PC due to the date format. If you change your settings to English USA while toying with the program the trouble disappears. I revert to the original settings after exporting the HTML files.

Long_Long_Name · 08-05-2004, 10:55 AM

Quote:

Originally Posted by Treches

Can't help you on those matters, but I had the same problem running CatoBase on my PC due to the date format. If you change your settings to English USA while toying with the program the trouble disappears. I revert to the original settings after exporting the HTML files.

That gets rid of one problem, but I have so many.

For example, when it reads ltrans file, it tells me "Reprendre sans gestion d'erreur", which translates to something like "Retry without error management".

Also, I'm still having this problem. I tell myself "too bad about the Hall of Fame and All Stars. They should be right anyway." Plus, if that's the only problem, I could always ship it over to someone else, who would do minimal groundkeeping.

Anyway... I still don't know what to do about the seasons where I have ltrans and lnews in html format, but not txt. That's my big issue, anyone can help me?

By the way, super duper danke to Treches, who managed to, in 2 days, create a logo for me AND make Cato somewhat work!

Long_Long_Name · 08-05-2004, 11:16 AM

I got it figured it out, I think. Basically, if you leave "run exporter" checked, with no .txt files and the html ones in the "data" folder, you're fine, right?

Treches · 08-05-2004, 02:06 PM

I'm not too familiar with CatoBase, to tell you the truth. I just happened to set up 15 seasons of the online league I'm in this week. Given 12 or 13 seasons were run using OOTP2, some stuff didn't get imported in the database (i.e. awards) and some other (i.e. gold gloves) weren't even a feature bak then. I never even got the V5's seasons's awards to get imported for some reason and received an error while exporting the HTML files, so I just entered them manually via the option Cato has or by opening the database in Access.

Long_Long_Name · 08-05-2004, 02:09 PM

Ouch,seems like quite an experiment

For the record, everything worked found, except I got double entries (how the hell did that happen?), and it prompted me telling me that while generating HTML pages.

I looked around, and only noticed two problems:
1. My all-star catcher has 42 HOF Standards points - after 4 seasons. That's impossible. In fact, if I check out league leaders, he's not there, and only four guys have ofer 20 (with the best at 38).
2. Except for the first year, no draft registers display anything other than blankness.

Treches · 08-05-2004, 02:23 PM

1 I have no idea, but in order to have the draft list displayed you have to import player histories (text), 'cause I've found Cato gets the list from there and not from the draft list per se.

Operation Shutdown · 08-06-2004, 12:18 AM

Sorry, it's taken a while but I haven't checked this forums in a few days, but yes this is the correct way to do it when the text files aren't working correctly.

Long_Long_Name · 08-06-2004, 12:48 AM

Quote:

Originally Posted by Treches

1 I have no idea, but in order to have the draft list displayed you have to import player histories (text), 'cause I've found Cato gets the list from there and not from the draft list per se.

Ah, thanks, that's very useful. Thank you

The error I get while generating HTML files is the following:

Quote:

-2147467259:
Modifications non effectuées: risque de doublons dans champs index, clé principale ou relation interdisant les doublons. Modifiez les données des champs contenant les doublons, enlevez ou redéfinissez l'index pour permettre les doublons et recommencez.

I get that under the "Calculating Season Pitching Leaderboard Placements", about 40% through.

I don't know the exact vocabulary, but I'll try to translate to the best English as I can (what the hell is a doublon? I'll call it a double entry, since I have no idea what it is).

"-2147467259:
Modifications not made: risk of double entries in index field, primary key or relation forbidding double entries. Modify the data of the fields that contain the double entries, remove or redefine the index to allow the double entries and retry."

Treches · 08-06-2004, 01:25 AM

That's the same error I got anytime I let the program import the awards. It's a potential double entry but never found it surfing the database. Had to delete that year's entries (all stars and gold gloves) and enter them by hand to solve the thing.

jmm8356 · 08-06-2004, 07:38 AM

I think "doublon" must mean "duplicate" or "duplicate entry". Index fields and primary key fields have to be unique (it's like a record ID).

... not that this helps you fix the problem, mind you.

But knowing is half the battle...

07-15-2004, 11:15 AM	#1
Operation Shutdown All Star Reserve Join Date: Jun 2002 Location: Pittsburgh PA Posts: 912	Catobase Problem - lnews and ltrans Catobase doesn't seem to be reading the lnews and ltrans text files at all whenver I'm running. These files are in my League_News_Box folder of my league folder and the program seems to be copying them to the data folder when doing the exporting. However, I'm getting an invalid procedure call or argument whenver trying to import the All-Stars and Award Winners and I took a quick look at the batting stats table in Access and none of the players that were traded midseason are getting any split stats, they're all with the team they were traded to. The current league I'm trying to import was imported from version 3 to version 4 to version 5 and into version6, so I don't know if this might be the problem or not. Is there anyway to just use the html pages like the program used to do? P.S. The only difference I see between a text file created by OOTP 6, and one that was created before was the addition of different HTML tags, either bold or <a> tags to link the player to his player page. Could this be the cause of the problem? __________________ "And Shepherds we shall be, For thee, my Lord, for thee. Power hath descended forth from Thy hand, Our feet may swiftly carry out Thy commands. So we shall flow a river forth to Thee, And teeming with souls shall it ever be. In Nomeni Patri Et Fili Spiritus Sancti." Last edited by Operation Shutdown; 07-15-2004 at 11:20 AM.

07-15-2004, 10:56 PM	#3
Operation Shutdown All Star Reserve Join Date: Jun 2002 Location: Pittsburgh PA Posts: 912	Using the html files did the trick. I'll have to remind myself to send in a support ticket later, as I'm way too busy right now to do it. __________________ "And Shepherds we shall be, For thee, my Lord, for thee. Power hath descended forth from Thy hand, Our feet may swiftly carry out Thy commands. So we shall flow a river forth to Thee, And teeming with souls shall it ever be. In Nomeni Patri Et Fili Spiritus Sancti."

08-04-2004, 08:14 PM	#4
Long_Long_Name Hall Of Famer Join Date: Jan 2002 Location: Montréal Posts: 7,065	I have a question. I'm having a similar problem with ltrans and lnews, but if I disable "run exporter...", won't it affect the year I'm trying to import? I mean, won't it not run the exporter and ruin the whole point of importing stats, since csv files won't be created? Or am I missing something? __________________ Beta Baseball. Join it!

08-04-2004, 08:26 PM	#5
Operation Shutdown All Star Reserve Join Date: Jun 2002 Location: Pittsburgh PA Posts: 912	What I had done for that one season was to delete the previous season currently in the CATObase, since it didn't import correctly. So what I did was use the CSV files already created and then move the ltrans and lnews html files into the data directory and re-imported with the run exporter unchecked. After all that, I found that I could just move the ltrans and lnews text files out of the league_news_box folder, put the lnews and ltrans html files into the data folder and then when done importing I put the text files back into the league_news_box folder. Ohhh, and don't remove the text files before generating the html files, or you'll wind up with blank html files. Hope this helps... __________________ "And Shepherds we shall be, For thee, my Lord, for thee. Power hath descended forth from Thy hand, Our feet may swiftly carry out Thy commands. So we shall flow a river forth to Thee, And teeming with souls shall it ever be. In Nomeni Patri Et Fili Spiritus Sancti."

08-04-2004, 08:45 PM	#6
Long_Long_Name Hall Of Famer Join Date: Jan 2002 Location: Montréal Posts: 7,065	I'll be more explicit about my situation. I can't run CatoBase on my computer, since it doesn't like the date format and gives me a ton of error messages. However, I had a pretty good grasp of how the software worked, so I asked someone else to run it, and I would help him run the software. I have 5 years to import, 2005 through 2009. The first four are OOTP5, and 2009 is OOTP6. 2005, 2006 and 2008 run smoothly, but I don't have the League_News_Box folder for 2007 and 2009. I, however, have the generated HTML pages for both years. Basically, I have ltrans.html and lnews.html, but neither .txt file. I "built" correct txt pages for lnews, but ltrans seems like hell to do. Anyway, that's when I saw this thread. Since I don't run the program on my computer and my "helper" isn't online right now, I don't know at exactly what moment CatoBase gives you the "file not found" prompt, or where it stops functioning. What I gather from this thread is that I should give the following instructions to my man: Import 2007 Stats with "Run Exporter" checked on. Remove the 2007 season. Put html files in "data" folder. Import 2007 Stats. Am I missing something, will this work? What instructions should I give my helper? Or am I just screwed no matter what if I don't have txt files? __________________ Beta Baseball. Join it!

07-15-2004, 01:55 PM	#2
jcato Minors (Triple A) Join Date: Jan 2004 Posts: 200	If you send me the data files, I'll take a look and see what's causing the problem. You can try the HTML files, too. Make sure the CSV files are in the data directory, copy the HTML files to the data directory and delete the text files in the data directory. Uncheck the Run Exporters... box on the Options screen and then import the stats. When it can't find the text files, it will look for the HTML files and use those.

08-05-2004, 07:52 AM	#7
Treches Hall Of Famer Join Date: Dec 2001 Location: Damned Hell Posts: 2,150	Can't help you on those matters, but I had the same problem running CatoBase on my PC due to the date format. If you change your settings to English USA while toying with the program the trouble disappears. I revert to the original settings after exporting the HTML files. __________________ The Computer Baseball League

08-05-2004, 11:16 AM	#9
Long_Long_Name Hall Of Famer Join Date: Jan 2002 Location: Montréal Posts: 7,065	I got it figured it out, I think. Basically, if you leave "run exporter" checked, with no .txt files and the html ones in the "data" folder, you're fine, right? __________________ Beta Baseball. Join it!

08-05-2004, 02:06 PM	#10
Treches Hall Of Famer Join Date: Dec 2001 Location: Damned Hell Posts: 2,150	I'm not too familiar with CatoBase, to tell you the truth. I just happened to set up 15 seasons of the online league I'm in this week. Given 12 or 13 seasons were run using OOTP2, some stuff didn't get imported in the database (i.e. awards) and some other (i.e. gold gloves) weren't even a feature bak then. I never even got the V5's seasons's awards to get imported for some reason and received an error while exporting the HTML files, so I just entered them manually via the option Cato has or by opening the database in Access. __________________ The Computer Baseball League

08-05-2004, 02:09 PM	#11
Long_Long_Name Hall Of Famer Join Date: Jan 2002 Location: Montréal Posts: 7,065	Ouch,seems like quite an experiment For the record, everything worked found, except I got double entries (how the hell did that happen?), and it prompted me telling me that while generating HTML pages. I looked around, and only noticed two problems: 1. My all-star catcher has 42 HOF Standards points - after 4 seasons. That's impossible. In fact, if I check out league leaders, he's not there, and only four guys have ofer 20 (with the best at 38). 2. Except for the first year, no draft registers display anything other than blankness. __________________ Beta Baseball. Join it!

08-05-2004, 02:23 PM	#12
Treches Hall Of Famer Join Date: Dec 2001 Location: Damned Hell Posts: 2,150	1 I have no idea, but in order to have the draft list displayed you have to import player histories (text), 'cause I've found Cato gets the list from there and not from the draft list per se. __________________ The Computer Baseball League

08-06-2004, 12:18 AM	#13
Operation Shutdown All Star Reserve Join Date: Jun 2002 Location: Pittsburgh PA Posts: 912	Sorry, it's taken a while but I haven't checked this forums in a few days, but yes this is the correct way to do it when the text files aren't working correctly. __________________ "And Shepherds we shall be, For thee, my Lord, for thee. Power hath descended forth from Thy hand, Our feet may swiftly carry out Thy commands. So we shall flow a river forth to Thee, And teeming with souls shall it ever be. In Nomeni Patri Et Fili Spiritus Sancti."

08-06-2004, 01:25 AM	#15
Treches Hall Of Famer Join Date: Dec 2001 Location: Damned Hell Posts: 2,150	That's the same error I got anytime I let the program import the awards. It's a potential double entry but never found it surfing the database. Had to delete that year's entries (all stars and gold gloves) and enter them by hand to solve the thing. __________________ The Computer Baseball League

08-06-2004, 07:38 AM	#16
jmm8356 All Star Starter Join Date: Jul 2004 Location: Lafayette IN (by way of Tonawanda NY) Posts: 1,673	I think "doublon" must mean "duplicate" or "duplicate entry". Index fields and primary key fields have to be unique (it's like a record ID). ... not that this helps you fix the problem, mind you. But knowing is half the battle... __________________ 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! )