OOTPB2007 Export Tracker? - Page 2

mikev · 09-24-2007, 01:09 PM

Quote:

Originally Posted by Getch

Try changing csv to one of:

csv:../csv
csv:../../csv
csv:../../theguba/csv

None of those worked. Same error message.

Getch · 09-24-2007, 01:17 PM

Two things:

1. I stupidly forgot to capitalize csv, so hopefully you did CSV:../csv, etc. Case matters.

2. Try moving the csv directory to cgi-bin/csv. Then make the setup.txt parameter "CSV:csv". If THAT doesnt work, then shoot me. It's better to be here probably, since you shouldn't let you .csv files be viewable to the public.

mikev · 09-24-2007, 01:19 PM

Okay. I'll report back in 2 minutes.

Wow. You know you're in *nix mode when you hit "ESC, ESC, W, Q, ENTER" instead of clicking the "post quick reply" button.

mikev · 09-24-2007, 01:21 PM

Tried it. same result.

I cry.

Getch · 09-24-2007, 01:38 PM

Clearly something else is going on then... if you trust me, I could log on myself to your system and try to get to the bottom of this. PM the info to me if you're ok with that.

I'm at work and can't get outside the firewall, so I'll have to do this tonight.

mikev · 09-24-2007, 01:48 PM

I think I know what's wrong.

The cgi-bin directory isn't the actual cgi-bin directory. It's a symbolic link I created.

Let me try and move everything and try again.

mikev · 09-24-2007, 01:51 PM

sigh.

tried it in the default cgi-bin and it still did teh same thing.

Getch · 09-24-2007, 03:12 PM

The symbolic links explain the oddness of your directory setup. My offer still stands if you want me to log in and look into it.

mikev · 09-24-2007, 03:48 PM

lemme know when you have time and I'll get you the info.

Getch · 09-25-2007, 10:24 AM

For those of you who were on the edge of their seats about this discussion wiht mikev, the issue looked to be something with how Perl was reading the files from the server. Maybe someone out there has a clue what was going on?

For some reason, an odd whitespace character was being picked up by Perl at the end of the line, but Perl wouldn't remove it with the "chomp" command. When I outputted the line, it would print bizarre results... if the string was "csv", it would print " v". It's as if the character was removing the first 2 characters of the string, even though the character was at the end of the string.

I fixed by modifying some RegEx's, but I have no clue what was going on.

sox9418 · 09-25-2007, 10:31 PM

Guess I'm confused - why are you looking at CSV files for exports?

If you want to know if the team file is newer than the league file on the FTP, you can check for the file existence, compare it to the date on the league file, and determine if it's more recent than the league file. This is pretty easy in PHP. Are you looking to get something more out of the CSV files?

f.montoya · 09-26-2007, 08:01 AM

Quote:

Originally Posted by sox9418

Guess I'm confused - why are you looking at CSV files for exports?

If you want to know if the team file is newer than the league file on the FTP, you can check for the file existence, compare it to the date on the league file, and determine if it's more recent than the league file. This is pretty easy in PHP. Are you looking to get something more out of the CSV files?

Getch's export tracker uses the csv's to detect the team names and team ID's. I know that a php export tracker is much simpler having made one myself but Getch's is unique in that it uses the same styles.css as the game generated league reports so it fits seamlessly into 2007 league websites.

Getch · 09-26-2007, 09:52 AM

Yep... team names, ID's, logos, as well as league and sub-league structures, so you don't have to type it all in yourself. Here it is for the league I am in:

http://www.overthemound.com/cgi-bin/exportTracker.html

sox9418 · 09-27-2007, 09:04 PM

Ah, OK - nice looking.

09-24-2007, 01:17 PM	#22 (permalink)
Getch Major Leagues Join Date: Jan 2006 Posts: 480	Two things: 1. I stupidly forgot to capitalize csv, so hopefully you did CSV:../csv, etc. Case matters. 2. Try moving the csv directory to cgi-bin/csv. Then make the setup.txt parameter "CSV:csv". If THAT doesnt work, then shoot me. It's better to be here probably, since you shouldn't let you .csv files be viewable to the public. __________________ Get my OOTP Online Utilities for online leagues! One utility, seven tools: Allstar Voting Development Tracker Export Tracker Last Sim's Stats and Performances Manager's Contact Page Ratings Report Rookie Draft OOTP OU for OOTP 8 OOTP OU for OOTP 9 Readme

09-24-2007, 01:19 PM	#23 (permalink)
mikev Hall Of Famer Join Date: Dec 2004 Location: Bay Area, CA Posts: 3,188	Okay. I'll report back in 2 minutes. Wow. You know you're in nix mode when you hit "ESC, ESC, W, Q, ENTER" instead of clicking the "post quick reply" button. __________________ 70% of the earth's surface is covered by water. The other 30% is taken care of by Patrick Willis.* Global Unified Baseball Association - Vice Commish and California Crusaders GM

09-24-2007, 01:21 PM	#24 (permalink)
mikev Hall Of Famer Join Date: Dec 2004 Location: Bay Area, CA Posts: 3,188	Tried it. same result. I cry. __________________ 70% of the earth's surface is covered by water. The other 30% is taken care of by Patrick Willis. Global Unified Baseball Association - Vice Commish and California Crusaders GM

09-24-2007, 01:38 PM	#25 (permalink)
Getch Major Leagues Join Date: Jan 2006 Posts: 480	Clearly something else is going on then... if you trust me, I could log on myself to your system and try to get to the bottom of this. PM the info to me if you're ok with that. I'm at work and can't get outside the firewall, so I'll have to do this tonight. __________________ Get my OOTP Online Utilities for online leagues! One utility, seven tools: Allstar Voting Development Tracker Export Tracker Last Sim's Stats and Performances Manager's Contact Page Ratings Report Rookie Draft OOTP OU for OOTP 8 OOTP OU for OOTP 9 Readme

09-24-2007, 01:48 PM	#26 (permalink)
mikev Hall Of Famer Join Date: Dec 2004 Location: Bay Area, CA Posts: 3,188	I think I know what's wrong. The cgi-bin directory isn't the actual cgi-bin directory. It's a symbolic link I created. Let me try and move everything and try again. __________________ 70% of the earth's surface is covered by water. The other 30% is taken care of by Patrick Willis. Global Unified Baseball Association - Vice Commish and California Crusaders GM

09-24-2007, 01:51 PM	#27 (permalink)
mikev Hall Of Famer Join Date: Dec 2004 Location: Bay Area, CA Posts: 3,188	sigh. tried it in the default cgi-bin and it still did teh same thing. __________________ 70% of the earth's surface is covered by water. The other 30% is taken care of by Patrick Willis. Global Unified Baseball Association - Vice Commish and California Crusaders GM

09-24-2007, 03:12 PM	#28 (permalink)
Getch Major Leagues Join Date: Jan 2006 Posts: 480	The symbolic links explain the oddness of your directory setup. My offer still stands if you want me to log in and look into it. __________________ Get my OOTP Online Utilities for online leagues! One utility, seven tools: Allstar Voting Development Tracker Export Tracker Last Sim's Stats and Performances Manager's Contact Page Ratings Report Rookie Draft OOTP OU for OOTP 8 OOTP OU for OOTP 9 Readme

09-24-2007, 03:48 PM	#29 (permalink)
mikev Hall Of Famer Join Date: Dec 2004 Location: Bay Area, CA Posts: 3,188	lemme know when you have time and I'll get you the info. __________________ 70% of the earth's surface is covered by water. The other 30% is taken care of by Patrick Willis. Global Unified Baseball Association - Vice Commish and California Crusaders GM

09-25-2007, 10:24 AM	#30 (permalink)
Getch Major Leagues Join Date: Jan 2006 Posts: 480	For those of you who were on the edge of their seats about this discussion wiht mikev, the issue looked to be something with how Perl was reading the files from the server. Maybe someone out there has a clue what was going on? For some reason, an odd whitespace character was being picked up by Perl at the end of the line, but Perl wouldn't remove it with the "chomp" command. When I outputted the line, it would print bizarre results... if the string was "csv", it would print " v". It's as if the character was removing the first 2 characters of the string, even though the character was at the end of the string. I fixed by modifying some RegEx's, but I have no clue what was going on. __________________ Get my OOTP Online Utilities for online leagues! One utility, seven tools: Allstar Voting Development Tracker Export Tracker Last Sim's Stats and Performances Manager's Contact Page Ratings Report Rookie Draft OOTP OU for OOTP 8 OOTP OU for OOTP 9 Readme

09-25-2007, 10:31 PM	#31 (permalink)
sox9418 Major Leagues Join Date: Dec 2001 Location: Boston, MA Posts: 310	Guess I'm confused - why are you looking at CSV files for exports? If you want to know if the team file is newer than the league file on the FTP, you can check for the file existence, compare it to the date on the league file, and determine if it's more recent than the league file. This is pretty easy in PHP. Are you looking to get something more out of the CSV files?

09-26-2007, 09:52 AM	#33 (permalink)
Getch Major Leagues Join Date: Jan 2006 Posts: 480	Yep... team names, ID's, logos, as well as league and sub-league structures, so you don't have to type it all in yourself. Here it is for the league I am in: http://www.overthemound.com/cgi-bin/exportTracker.html __________________ Get my OOTP Online Utilities for online leagues! One utility, seven tools: Allstar Voting Development Tracker Export Tracker Last Sim's Stats and Performances Manager's Contact Page Ratings Report Rookie Draft OOTP OU for OOTP 8 OOTP OU for OOTP 9 Readme

09-27-2007, 09:04 PM	#34 (permalink)
sox9418 Major Leagues Join Date: Dec 2001 Location: Boston, MA Posts: 310	Ah, OK - nice looking.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode