davwms' Origin Generator - anyone ever get it to work? - Page 9

gubaru · 05-25-2005, 01:23 PM

Quote:

Originally Posted by Cooleyvol

OK, here's my situation:

In the PC, I change manually some of the origins. Most just show USA.

I don't want the ones I've already edited to change, but would like to change the origins of the players with USA as their origin.

Can someone tell me the steps to do this if its at all possible?

I don't want to change names either..................which program do I need?

* Download the OOTP6_OriginsOnly.zip file from Dave's site.
* The OriginData.zip file on the site has some errors in the non-US origin files; so, use this zip file instead. I corrected the probability numbers for the cities so you'll get cities other than the first listed in the file.
* Unzip both files into the league directory for the Professional Circuit.
* Export the players_general.csv file from the Misc. Setup screen.
* Run OOTP6_OriginsOnly.exe.
* Re-import players_general.csv and you should be all set.

Cooleyvol · 05-25-2005, 01:35 PM

I have a custom historical names file that I've created. I'm looking to just add origins to all my players who I didnt manually edit before.

If you'd like my modified name files, I'd be happy to email them to you.

Cooleyvol · 05-25-2005, 01:42 PM

Quote:

Originally Posted by gubaru

* Download the OOTP6_OriginsOnly.zip file from Dave's site.
* The OriginData.zip file on the site has some errors in the non-US origin files; so, use this zip file instead. I corrected the probability numbers for the cities so you'll get cities other than the first listed in the file.
* Unzip both files into the league directory for the Professional Circuit.
* Export the players_general.csv file from the Misc. Setup screen.
* Run OOTP6_OriginsOnly.exe.
* Re-import players_general.csv and you should be all set.

I did as you said, except I only extracted the US origins dat file.
Its in the OriginData folder in my .lg folder along with the .exe

When I run the .exe program, I get an error 53: file not found error.

gubaru · 05-25-2005, 02:33 PM

The .exe needs to be in the league's root directory. If it's in the origindata directory it's looking for the .dat files in OriginData/OriginData.

Cooleyvol · 05-25-2005, 02:55 PM

both files (the origindata folder and the .exe) are in my .lg folder.

gubaru · 05-25-2005, 03:21 PM

Is there a file called players_general.csv in the .lg folder?

Cooleyvol · 05-25-2005, 03:28 PM

yes, it, the .exe, and the origindata folder are in the .lg directory.

As I said, all I have in the origindata folder is the us origin file.............I didnt want all the other country files in there.

Cooleyvol · 05-25-2005, 03:34 PM

OK, I redownloaded and put all the files in the folder.

Now I get "Run time error 62 Run time past end of file"

I get that upon clicking the 'Execute' button.

gubaru · 05-25-2005, 03:46 PM

Quote:

Originally Posted by Cooleyvol

OK, I redownloaded and put all the files in the folder.

Now I get "Run time error 62 Run time past end of file"

I get that upon clicking the 'Execute' button.

Have you been using commas in the origins that you've manually entered?

Cooleyvol · 05-25-2005, 03:48 PM

yep

gubaru · 05-25-2005, 03:58 PM

That's the problem. The file OotP exports is comma delimited; so, the commas in the entered origins are making the OriginsOnly program think there are extra fields. The only solution is to use Notepad to delete the extra commas and then run the program again.

Cooleyvol · 05-25-2005, 05:03 PM

Oh well, thanks for the help.

Cooleyvol · 05-25-2005, 05:21 PM

Ok, I took out the commas in the origins that I had entered.
Same error.

I'm attaching my csv file...........if you can look at it and tell me what's wrong, I'd appreciate it.

ifspuds · 05-25-2005, 05:37 PM

Are you using the OriginsOnly or the full Originator?

I personally have never gotten OriginsOnly to work and never could figure out why I get the error 62. You might check that there are no blank lines at the end of your name or origin files (open in Notepad, go to the bottom and backspace to the last text line). You might also try exporting the player_general.csv from scratch and trying again.

I always just used the full Originator. The Originator will reset names as well, but there's a way around it: make a copy of your player_general.csv before running it through the Originator, then open the Originated csv and the copy in Excel or your favorite spreadsheet, and copy the old names back to the new names. You'll need to edit the height field to keep it from becoming a date (hurray AutoFormat) -- format the column, select custom format, and enter m-d -- but otherwise that should work.

You can also PM me if you'd like.

gubaru · 05-25-2005, 05:45 PM

Quote:

Originally Posted by Cooleyvol

Ok, I took out the commas in the origins that I had entered.
Same error.

I'm attaching my csv file...........if you can look at it and tell me what's wrong, I'd appreciate it.

You missed the comma in the origin for Bib Walsh. It's still Danville, VA.

gubaru · 05-25-2005, 05:50 PM

Quote:

Originally Posted by ifspuds

I always just used the full Originator. The Originator will reset names as well, but there's a way around it: make a copy of your player_general.csv before running it through the Originator, then open the Originated csv and the copy in Excel or your favorite spreadsheet, and copy the old names back to the new names. You'll need to edit the height field to keep it from becoming a date (hurray AutoFormat) -- format the column, select custom format, and enter m-d -- but otherwise that should work.

Jeff,

That still causes problems with the heights. You lose all the heights of 6' as there is no June 0. If you want to open the file in Excel, change the extension from csv to txt. That way when you open it you have to specify the delimiter and that gives you a chance to change the formatting of all the fields to text.

ifspuds · 05-25-2005, 05:53 PM

Hm. Hadn't thought of that... it worked for me -- as in there were no re-import errors -- when I did it, but I'll remember that for next time.

Cooleyvol · 05-25-2005, 05:56 PM

worked like a charm! Thanks.........I went through there twice checking for commas and didnt see that one.

gubaru · 05-25-2005, 06:19 PM

Quote:

Originally Posted by Cooleyvol

worked like a charm! Thanks.........I went through there twice checking for commas and didnt see that one.

I'm glad it worked! It's really easy to miss those extra commas. I just cleaned up the file for one of my online leagues and I missed a bunch, too.

dcpcarmona · 05-26-2005, 04:55 AM

If I may ask a question, what files are in your .lg folder? The reason I ask is because I want to use the originator and DMs historical name file. Is that even possible?

thanks,

dcc

05-25-2005, 03:28 PM	#167
Cooleyvol Hall Of Famer Join Date: Dec 2001 Location: Union City, TN Posts: 6,383	yes, it, the .exe, and the origindata folder are in the .lg directory. As I said, all I have in the origindata folder is the us origin file.............I didnt want all the other country files in there. Last edited by Cooleyvol; 05-25-2005 at 03:30 PM.

05-25-2005, 05:37 PM	#174
ifspuds Hall Of Famer Join Date: Jun 2003 Location: Spokane WA Posts: 2,117	Are you using the OriginsOnly or the full Originator? I personally have never gotten OriginsOnly to work and never could figure out why I get the error 62. You might check that there are no blank lines at the end of your name or origin files (open in Notepad, go to the bottom and backspace to the last text line). You might also try exporting the player_general.csv from scratch and trying again. I always just used the full Originator. The Originator will reset names as well, but there's a way around it: make a copy of your player_general.csv before running it through the Originator, then open the Originated csv and the copy in Excel or your favorite spreadsheet, and copy the old names back to the new names. You'll need to edit the height field to keep it from becoming a date (hurray AutoFormat) -- format the column, select custom format, and enter m-d -- but otherwise that should work. You can also PM me if you'd like. __________________ Jeff Watson Former dynasty writer and online league player, now mostly retired

05-25-2005, 05:53 PM	#177
ifspuds Hall Of Famer Join Date: Jun 2003 Location: Spokane WA Posts: 2,117	Hm. Hadn't thought of that... it worked for me -- as in there were no re-import errors -- when I did it, but I'll remember that for next time. __________________ Jeff Watson Former dynasty writer and online league player, now mostly retired

05-26-2005, 04:55 AM	#180
dcpcarmona All Star Starter Join Date: Jul 2003 Location: at the New Moon Posts: 1,644	If I may ask a question, what files are in your .lg folder? The reason I ask is because I want to use the originator and DMs historical name file. Is that even possible? thanks, dcc __________________ "People ask me what I do in winter when there's no baseball. I'll tell you what I do. I stare out the window and wait for spring." -Rogers Hornsby Last edited by dcpcarmona; 05-26-2005 at 04:56 AM.

05-25-2005, 01:35 PM	#162
Cooleyvol Hall Of Famer Join Date: Dec 2001 Location: Union City, TN Posts: 6,383	I have a custom historical names file that I've created. I'm looking to just add origins to all my players who I didnt manually edit before. If you'd like my modified name files, I'd be happy to email them to you.

05-25-2005, 02:33 PM	#164
gubaru Major Leagues Join Date: Apr 2004 Location: Camp Hill, PA Posts: 326	The .exe needs to be in the league's root directory. If it's in the origindata directory it's looking for the .dat files in OriginData/OriginData.

05-25-2005, 02:55 PM	#165
Cooleyvol Hall Of Famer Join Date: Dec 2001 Location: Union City, TN Posts: 6,383	both files (the origindata folder and the .exe) are in my .lg folder.

05-25-2005, 03:21 PM	#166
gubaru Major Leagues Join Date: Apr 2004 Location: Camp Hill, PA Posts: 326	Is there a file called players_general.csv in the .lg folder?

05-25-2005, 03:34 PM	#168
Cooleyvol Hall Of Famer Join Date: Dec 2001 Location: Union City, TN Posts: 6,383	OK, I redownloaded and put all the files in the folder. Now I get "Run time error 62 Run time past end of file" I get that upon clicking the 'Execute' button.

05-25-2005, 03:48 PM	#170
Cooleyvol Hall Of Famer Join Date: Dec 2001 Location: Union City, TN Posts: 6,383	yep

05-25-2005, 03:58 PM	#171
gubaru Major Leagues Join Date: Apr 2004 Location: Camp Hill, PA Posts: 326	That's the problem. The file OotP exports is comma delimited; so, the commas in the entered origins are making the OriginsOnly program think there are extra fields. The only solution is to use Notepad to delete the extra commas and then run the program again.

05-25-2005, 05:03 PM	#172
Cooleyvol Hall Of Famer Join Date: Dec 2001 Location: Union City, TN Posts: 6,383	Oh well, thanks for the help.

05-25-2005, 05:56 PM	#178
Cooleyvol Hall Of Famer Join Date: Dec 2001 Location: Union City, TN Posts: 6,383	worked like a charm! Thanks.........I went through there twice checking for commas and didnt see that one.