Quote:
Originally posted by dougaiton
This seems like a great utility, but I get a bit confused. Trying to set it up for an initial leguea (having exported and all that, set teh league paths), it says update files: teams.csv, but I can't find the csv file anywhere! Any ideas...
Yeah, its just they don't appear when I try to update. I don't know whether my version of Xcel recognises CSV files as Excel workbooks, and as there isn't an 'All Files' version...
|
Excel 2000 and XP should work. I don't understand exactly where you're having a problem, so I'm going to copy the directions here and then try to explain them better. I realize my directions may be a bit complicated, but I was trying to make them as comprehensive as possible to ensure that as few as possible people would have problems. Most utilities seem to come with minimal directions that are usually just not enough for a lot of people. I was trying to do the opposite.
***
Directions: (updated for v5.34)
You can just press the "Add New Year" button (to the right) and follow the directions in the windows that appear. However, I do recommend that you read the more detailed list of the directions below at least once before you use the utility for the first time.
1) Before each year you want to add, use CommishJoe's Exporter5 (available at
http://bosi.jpbaseball.com/downloads.php) to export your league's CSVs.
2a) If this is the first time you use this version of the utility, do the following:
i) Press the "CSVs Path" button to select the folder where your CSVs are.
ii) Press the "Archive Path" button to select the folder for the output file.
iii) Press the "First Year Added" button to input the first year of CSVs added.
2b) If this is not the first time you use this version of the utility, just check that the reference information (to the left) is correct. If it is not, correct it using the aforementioned change buttons. Editing the reference information cells themselves will not work.
3) Press the "Add New Year" button and follow its directions just to double check that everything is correct.
4) Wait till all the windows that popped up disappear.
5) Peruse the output file (it will have your league's name at the end of the filename) for whatever interests you. The sort buttons might be useful, but problems may arise if the sorts are not undone before saving.
6) If you want to put your league's archive on a webpage, from the output workbook file menu select "Save As Webpage" and then "Save".
Once you are familiar with the window messages, to get through them faster, press your enter key twice instead of using the mouse to click the options.
***
Ok, so you can press the add new year button and follow the directions that pop up or read the directions ahead of time. I think that's self-explanatory. I will specifically explain the ahead of time directions, but the popups are virtually the same.
Step 1 tells you to use CommishJoe's (CJ from here on) Exporter to create your CSV files from the league files. You will need the latest version of CJ's Exporter for this. I suspect that this might be your problem right here. It has its own help page, but the pertinent info is:
***
In Windows Explorer, bring up exporter.bat (right click and choose Edit). It'll look something like this:
player.exe "c:\temp" "c:\temp"
teams.exe "c:\temp" "c:\temp"
schedule.exe "c:\temp" "c:\temp"
pause
The first directory is where the .dat files are that you would like to export. The 2nd directory is the destination where you would like to save the CSV files too. Leave the quotes, and ensure the destination directory exists. Save your changes, exit your editor, and double click on Exporter.bat. It should now generate the CSVs to the destination directory.
***
Step 2 gives you 2 options, a and b, depending on whether this is the first time using the utility for this league or not. I'll focus on a seeing as how you have yet to get it to work.
2ai tells you to press the Change CSVs Path button. Once you do, a popup will appear that allows you to select where CJ's Exporter created your league's CSVs. So if it is c:\temp like CJ's instructions says, then you select drive C and then the temp folder and press ok.
2aii is similar to 2ai except that you now have to select the folder where you want the utility to create the future output file, or archive. Say for example you want it to appear on your desktop and your desktop folder is at d:\desktop (mine is, but yours probably is not), then you select that folder.
2aiii is for you to input what the first year of CSVs you are adding. So if your league is from 2003 to 2012 and you want to add all those years, then here you want 2003 here for every year you add. But say you just want to add years 2008 to 2012, then 2008 is the year you need.
Step 3 just tells you to press the Add New Year button and follow the steps, some of which you may have already done. Once you get familiar with them, you can just press ok without reading them.
Step 4 is to simply wait till all the CSVs close. You are essentially done.
Step 5 is to just check out the archive for whatever info you might be interested in.
Step 6 tells you how to make the archive into html if you want.
I've tested this with a few leagues and other than some minor column width issues that are particular to certain leagues which the user can easily fix, there doesn't seem to be any problems.
Perhaps you can tell me exactly where in the direction steps that this update teams.csv occurs. In the meantime, I would recommend making sure you have CJ's latest exporter (
http://bosi.jpbaseball.com/files/exporter5.zip this says 5 as others do, but there's actually different versions of v5. this link should lead to the latest though) and trying it with that.