CSV Exporter Released

CommishJoe · 01-12-2003, 09:33 PM

<a href = "http://www.trueleaguebaseball.com/modules.php?name=Downloads&d_op=viewdownload&cid=3 ">Link to Exporter</a>

It's the 2nd link.

I've included a batch program that will run both the PLAYER and TEAMS programs with one command. TEAMS will export both TEAM and LEAGUE information.

Readme is included, but feel free to contact me with any problems.

Enjoy!!

Cooleyvol · 01-12-2003, 10:13 PM

I'm assuming that I'm supposed to double click the exporter.bat file to get this thing off the ground, but when I do, it says something like this:

"C:/Program Files/OOTP4Util/CSV/>player.exe "c:/temp" "c:/temp"
I can't open , c:/temp/players.dat

"C:/Program Files/OOTP4Util/CSV/>teams.exe "c:/temp" "c:/temp"
I can't open , c:/temp/teams.dat

Am I doing something wrong? Am I supposed to point it to the HTML files somehow?

Any help would be most appreciated.

TotalEnd98 · 01-12-2003, 10:15 PM

Paging Jeff Cato... Mr. Cato to the General Discussions Board, please...

What are the chances we can get the Cato history utility and this miracle machine to work together and make life that much easier?

Cooleyvol · 01-12-2003, 10:21 PM

Nevermind........I edited the paths and its working fine now.

Tell me this: Is this all I need to do in order to run the history utility that requires CSV files to be run?

CommishJoe · 01-12-2003, 10:23 PM

The history utility makers need to update their programs to use the new file formats.

Cato helped me debug these programs, so I know he will be updating. I can't speak for the rest.

Cooleyvol · 01-12-2003, 10:25 PM

Quote:

Originally posted by CommishJoe
The history utility makers need to update their programs to use the new file formats.

Cato helped me debug these programs, so I know he will be updating. I can't speak for the rest.

Isnt Cato's the only one using CSV reports to get its data?

CommishJoe · 01-12-2003, 10:27 PM

I don't know.

Willy · 01-12-2003, 11:36 PM

Joe this is awesome. Very easy to use and a ton of data. Unbelievable

Willy

fantom1979 · 01-13-2003, 12:21 AM

Quote:

Originally posted by Cooleyvol
Isnt Cato's the only one using CSV reports to get its data?

I dont know if Cato is the only one, but I know that Wallmans does NOT use CSV reports.

Drood · 01-13-2003, 01:54 AM

Yep, Wallmans, you just feed it the HTML.

Few problems lately though.

Willy · 01-13-2003, 03:20 AM

Joe,
I sent a PM your way.

Willy

kq76 · 01-13-2003, 07:48 AM

Great exporter Joe. I think it's my favorite so far, fast and simple.

One thing tho, if I'm not mistaken I believe that the player_field.csv file uses last year's stats, not this year's. Did you mean to do this?

CommishJoe · 01-13-2003, 08:52 AM

Quote:

Originally posted by kq76
Great exporter Joe. I think it's my favorite so far, fast and simple.

One thing tho, if I'm not mistaken I believe that the player_field.csv file uses last year's stats, not this year's. Did you mean to do this?

Nop, but I know where the mistake is. I'll fix it tonight and release 1.1

D Love · 01-13-2003, 10:02 AM

Forgive the newbie question, but this exporter doesn't allow for re-importing, does it?

CommishJoe · 01-13-2003, 10:05 AM

Quote:

Originally posted by D Love
Forgive the newbie question, but this exporter doesn't allow for re-importing, does it?

Nop. This is only for getting information out of the data files.

D Love · 01-13-2003, 11:03 AM

Joe, is a re-importable csv report something that anyone has ever tried to make work? I just thought it would be neat for mass changes. Just curious as to whether it's realistically possible for someone to be able to put something like that together.

CommishJoe · 01-13-2003, 11:06 AM

Quote:

Originally posted by D Love
Joe, is a re-importable csv report something that anyone has ever tried to make work? I just thought it would be neat for mass changes. Just curious as to whether it's realistically possible for someone to be able to put something like that together.

It should be possible from a technical standpoint. However, since I am not exporting internal "values" (for obvious reasons

), I'm not sure how OOTP would handle it.

Andy · 01-29-2003, 06:28 PM

Quote:

Originally posted by Cooleyvol
I'm assuming that I'm supposed to double click the exporter.bat file to get this thing off the ground, but when I do, it says something like this:

"C:/Program Files/OOTP4Util/CSV/>player.exe "c:/temp" "c:/temp"
I can't open , c:/temp/players.dat

"C:/Program Files/OOTP4Util/CSV/>teams.exe "c:/temp" "c:/temp"
I can't open , c:/temp/teams.dat

Am I doing something wrong? Am I supposed to point it to the HTML files somehow?

Any help would be most appreciated.

You said in a later post that you figured it out by editing the paths. What did you edit the paths to?

kq76 · 01-29-2003, 06:36 PM

Quote:

Originally posted by Andy
You said in a later post that you figured it out by editing the paths. What did you edit the paths to?

I assume he did as the readme file says to:

"...players(or teams).exe "c:\temp" "c:\temp". The first path is where your .dat files are in the DB. The 2nd path are where you'd like the CSV files to generate too. The quotes are necessary in both paths."

CommishJoe · 01-29-2003, 06:55 PM

Yep ... what he said

I included the batch program to try to make your life a little easier too.

01-12-2003, 09:33 PM	#1
CommishJoe Global Moderator Join Date: Feb 2002 Location: Minneapolis, MN Posts: 5,238	CSV Exporter Released <a href = "http://www.trueleaguebaseball.com/modules.php?name=Downloads&d_op=viewdownload&cid=3 ">Link to Exporter</a> It's the 2nd link. I've included a batch program that will run both the PLAYER and TEAMS programs with one command. TEAMS will export both TEAM and LEAGUE information. Readme is included, but feel free to contact me with any problems. Enjoy!! __________________ Joe Success isn’t owned. It’s leased. And rent is due every day.

01-12-2003, 10:23 PM	#5
CommishJoe Global Moderator Join Date: Feb 2002 Location: Minneapolis, MN Posts: 5,238	The history utility makers need to update their programs to use the new file formats. Cato helped me debug these programs, so I know he will be updating. I can't speak for the rest. __________________ Joe Success isn’t owned. It’s leased. And rent is due every day.

01-12-2003, 10:27 PM	#7
CommishJoe Global Moderator Join Date: Feb 2002 Location: Minneapolis, MN Posts: 5,238	I don't know. __________________ Joe Success isn’t owned. It’s leased. And rent is due every day.

01-12-2003, 11:36 PM	#8
Willy Major Leagues Join Date: Dec 2001 Location: Regina, Sk Posts: 443	Joe this is awesome. Very easy to use and a ton of data. Unbelievable Willy __________________ Consoles are for little kids.

01-13-2003, 03:20 AM	#11
Willy Major Leagues Join Date: Dec 2001 Location: Regina, Sk Posts: 443	Joe, I sent a PM your way. Willy __________________ Consoles are for little kids.

01-12-2003, 10:13 PM	#2
Cooleyvol Hall Of Famer Join Date: Dec 2001 Location: Union City, TN Posts: 6,383	I'm assuming that I'm supposed to double click the exporter.bat file to get this thing off the ground, but when I do, it says something like this: "C:/Program Files/OOTP4Util/CSV/>player.exe "c:/temp" "c:/temp" I can't open , c:/temp/players.dat "C:/Program Files/OOTP4Util/CSV/>teams.exe "c:/temp" "c:/temp" I can't open , c:/temp/teams.dat Am I doing something wrong? Am I supposed to point it to the HTML files somehow? Any help would be most appreciated.

01-12-2003, 10:15 PM	#3
TotalEnd98 All Star Starter Join Date: Dec 2001 Location: New York Posts: 1,687	Paging Jeff Cato... Mr. Cato to the General Discussions Board, please... What are the chances we can get the Cato history utility and this miracle machine to work together and make life that much easier?

01-12-2003, 10:21 PM	#4
Cooleyvol Hall Of Famer Join Date: Dec 2001 Location: Union City, TN Posts: 6,383	Nevermind........I edited the paths and its working fine now. Tell me this: Is this all I need to do in order to run the history utility that requires CSV files to be run?

01-13-2003, 01:54 AM	#10
Drood Registered User Join Date: Aug 2002 Posts: 425	Yep, Wallmans, you just feed it the HTML. Few problems lately though.

01-13-2003, 07:48 AM	#12
kq76 Global Moderator Join Date: Nov 2002 Posts: 12,022	Great exporter Joe. I think it's my favorite so far, fast and simple. One thing tho, if I'm not mistaken I believe that the player_field.csv file uses last year's stats, not this year's. Did you mean to do this?

01-13-2003, 10:02 AM	#14
D Love All Star Reserve Join Date: Mar 2002 Location: Queens, NY Posts: 904	Forgive the newbie question, but this exporter doesn't allow for re-importing, does it?

01-13-2003, 11:03 AM	#16
D Love All Star Reserve Join Date: Mar 2002 Location: Queens, NY Posts: 904	Joe, is a re-importable csv report something that anyone has ever tried to make work? I just thought it would be neat for mass changes. Just curious as to whether it's realistically possible for someone to be able to put something like that together.

01-29-2003, 06:55 PM	#20
CommishJoe Global Moderator Join Date: Feb 2002 Location: Minneapolis, MN Posts: 5,238	Yep ... what he said I included the batch program to try to make your life a little easier too. __________________ Joe Success isn’t owned. It’s leased. And rent is due every day.