OOTPB2007 Export Tracker? - Page 2

mikev · 09-24-2007, 02: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, 02: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, 02: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, 02:21 PM

Tried it. same result.

I cry.

Getch · 09-24-2007, 02: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, 02: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, 02:51 PM

sigh.

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

Getch · 09-24-2007, 04: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, 04:48 PM

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

Getch · 09-25-2007, 11: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, 11: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, 09: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, 10: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, 10:04 PM

Ah, OK - nice looking.

09-24-2007, 02:17 PM	#22
Getch All Star Reserve Join Date: Jan 2006 Posts: 868	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 the OOTP Online Utilities for online leagues! Includes Gamecast, Development, Live Sims, Voting and more. Check here for more details

09-24-2007, 02:19 PM	#23
mikev Hall Of Famer Join Date: Dec 2004 Location: Bay Area, CA Posts: 4,014	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. __________________ Global Unified Baseball Association - Vice Commish and Oakland Oaks GM

09-24-2007, 02:21 PM	#24
mikev Hall Of Famer Join Date: Dec 2004 Location: Bay Area, CA Posts: 4,014	Tried it. same result. I cry. __________________ Global Unified Baseball Association - Vice Commish and Oakland Oaks GM

09-24-2007, 02:38 PM	#25
Getch All Star Reserve Join Date: Jan 2006 Posts: 868	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 the OOTP Online Utilities for online leagues! Includes Gamecast, Development, Live Sims, Voting and more. Check here for more details

09-24-2007, 02:48 PM	#26
mikev Hall Of Famer Join Date: Dec 2004 Location: Bay Area, CA Posts: 4,014	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. __________________ Global Unified Baseball Association - Vice Commish and Oakland Oaks GM

09-24-2007, 02:51 PM	#27
mikev Hall Of Famer Join Date: Dec 2004 Location: Bay Area, CA Posts: 4,014	sigh. tried it in the default cgi-bin and it still did teh same thing. __________________ Global Unified Baseball Association - Vice Commish and Oakland Oaks GM

09-24-2007, 04:12 PM	#28
Getch All Star Reserve Join Date: Jan 2006 Posts: 868	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 the OOTP Online Utilities for online leagues! Includes Gamecast, Development, Live Sims, Voting and more. Check here for more details

09-24-2007, 04:48 PM	#29
mikev Hall Of Famer Join Date: Dec 2004 Location: Bay Area, CA Posts: 4,014	lemme know when you have time and I'll get you the info. __________________ Global Unified Baseball Association - Vice Commish and Oakland Oaks GM

09-25-2007, 11:24 AM	#30
Getch All Star Reserve Join Date: Jan 2006 Posts: 868	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 the OOTP Online Utilities for online leagues! Includes Gamecast, Development, Live Sims, Voting and more. Check here for more details

09-25-2007, 11:31 PM	#31
sox9418 Major Leagues Join Date: Dec 2001 Location: Boston, MA Posts: 323	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, 10:52 AM	#33
Getch All Star Reserve Join Date: Jan 2006 Posts: 868	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 the OOTP Online Utilities for online leagues! Includes Gamecast, Development, Live Sims, Voting and more. Check here for more details

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