Home | Webstore
Latest News: OOTP 25 Available - FHM 10 Available - OOTP Go! Available

Out of the Park Baseball 25 Buy Now!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 25 > OOTP Mods > OOTP Mods - Names and Nations

Reply
 
Thread Tools
Old 06-01-2006, 12:41 AM   #1
cephasjames
Hall Of Famer
 
Join Date: Jun 2004
Posts: 8,729
Blog Entries: 1
Is there a method to the madness of the cities.txt?

I want an all Michigan League with player only coming from Michigan cities. I know I need to erase every city except the Michigan ones to do this (yes, I renamed it before I started changing things). Is there an easy way to do this? Are the cities organized in any way other than alphabetical? Any help would be great.
__________________
5000+ Generic Logos Free for the Taking
FREE: Uniforms and logos for 500+ teams spanning 1871-present
Great Lakes League: 10 Conferences, 100 Teams
Pre-OOTP 23 Custom Cap & Jersey Template v3.0 by Deft and NoPepper (with layers from other various artists) that I use: Caps, Jerseys
cephasjames is offline   Reply With Quote
Old 06-01-2006, 01:23 AM   #2
RBLwebguy
Hall Of Famer
 
RBLwebguy's Avatar
 
Join Date: Jun 2002
Location: Canuckistan
Posts: 5,157
Not sure if you can open the txt file in excel and sort on a specifc column, delete all of those not michigan and bring it back into txt? Maybe?
RBLwebguy is offline   Reply With Quote
Old 06-01-2006, 10:00 AM   #3
battists
Hall Of Famer
 
battists's Avatar
 
Join Date: Jul 2004
Posts: 18,506
Blog Entries: 7
You can definitely do it in Excel, if you're good at that sort of thing.

1. Open the file in Excel
2. Delete every row without a state of Michigan
3. Save the file as a csv file
4. Rename the saved file nations.txt

That's really simplified, assumes you somewhat know what you're doing. Gotta run!

More on this later!
battists is offline   Reply With Quote
Old 06-01-2006, 10:37 AM   #4
cephasjames
Hall Of Famer
 
Join Date: Jun 2004
Posts: 8,729
Blog Entries: 1
Thanks, guys. I'm not too familiar with this but I'm willing to try it.

1. I opened in excel. It said the whole file couldn't load. Does that mean it's too big?

2. I see the columns with Michigan in it. Is there an easy way of isolating the rows that are not Michigan? EDIT: Nevermind... that filter thingy rocks

3. I've saved the file as a csv. That's comma delimited, correct?

4. Rename the file as nations.txt? Not cities.txt? I've seen you explain this before (to me actually) I just don't remember the reason. EDIT: I've just renamed it nations.txt and... wow! it opens in in notepad! That should do it, right?

Thanks again.
__________________
5000+ Generic Logos Free for the Taking
FREE: Uniforms and logos for 500+ teams spanning 1871-present
Great Lakes League: 10 Conferences, 100 Teams
Pre-OOTP 23 Custom Cap & Jersey Template v3.0 by Deft and NoPepper (with layers from other various artists) that I use: Caps, Jerseys

Last edited by cephasjames; 06-01-2006 at 10:51 AM.
cephasjames is offline   Reply With Quote
Old 06-01-2006, 10:56 AM   #5
Raidergoo
Hall Of Famer
 
Raidergoo's Avatar
 
Join Date: Mar 2003
Posts: 9,004
link is borked. . .fixing!

Go to that link, get the US cities only cities.txt

The game included cities.txt cannot be completely opened by excel, it is too big, by about 35,000 lines. It's too comprehensive!

The alternate file is only about ~30,000 lines, and is easily opened in Excel.

Open up the alternate cities.txt, sort by the state row, and delete what you want.

I will have to write this up well later tonight, maybe with screen caps.

Last edited by Raidergoo; 06-01-2006 at 12:09 PM.
Raidergoo is offline   Reply With Quote
Old 06-01-2006, 11:01 AM   #6
battists
Hall Of Famer
 
battists's Avatar
 
Join Date: Jul 2004
Posts: 18,506
Blog Entries: 7
Crap, sorry, I meant "Cities.txt" not "nations.txt"

But you're on the right track. Especially if you backed up first.
battists is offline   Reply With Quote
Old 06-07-2006, 12:04 PM   #7
cephasjames
Hall Of Famer
 
Join Date: Jun 2004
Posts: 8,729
Blog Entries: 1
Quote:
Originally Posted by battists
Crap, sorry, I meant "Cities.txt" not "nations.txt"

But you're on the right track. Especially if you backed up first.
Always back up! I got it figured out. You helped a ton, thanks.
__________________
5000+ Generic Logos Free for the Taking
FREE: Uniforms and logos for 500+ teams spanning 1871-present
Great Lakes League: 10 Conferences, 100 Teams
Pre-OOTP 23 Custom Cap & Jersey Template v3.0 by Deft and NoPepper (with layers from other various artists) that I use: Caps, Jerseys
cephasjames is offline   Reply With Quote
Old 06-07-2006, 12:08 PM   #8
jnshmoo
All Star Starter
 
jnshmoo's Avatar
 
Join Date: Apr 2004
Location: Not Here
Posts: 1,226
Quote:
Originally Posted by Raidergoo
link is borked. . .fixing!

Go to that link, get the US cities only cities.txt

The game included cities.txt cannot be completely opened by excel, it is too big, by about 35,000 lines. It's too comprehensive!

The alternate file is only about ~30,000 lines, and is easily opened in Excel.

Open up the alternate cities.txt, sort by the state row, and delete what you want.

I will have to write this up well later tonight, maybe with screen caps.
It's fully openable with Excel 2007 Beta!
__________________
Beer Snob and Baseball Sim Geek

jnshmoo is offline   Reply With Quote
Old 06-07-2006, 12:18 PM   #9
Raidergoo
Hall Of Famer
 
Raidergoo's Avatar
 
Join Date: Mar 2003
Posts: 9,004
Quote:
Originally Posted by jnshmoo
It's fully openable with Excel 2007 Beta!
That's what I was hoping, but kept forgetting to ask.

Thanks a whole bunch for this data!
Raidergoo is offline   Reply With Quote
Old 06-07-2006, 12:35 PM   #10
johnph77
Minors (Single A)
 
Join Date: Mar 2006
Posts: 67
Quote:
Originally Posted by jnshmoo
It's fully openable with Excel 2007 Beta!
Then they've gone the unlimited route on spreadsheet size ala Corel QuattroPro. That'll make the purchase of the suite worth my while.

Considering that the first spreadsheet I ever owned (Visi-Calc for the Apple II in the late 1970s) was limited to a 64x256 grid, like the commercial says, "You've come a long way, baby!"
johnph77 is offline   Reply With Quote
Old 06-07-2006, 12:42 PM   #11
jnshmoo
All Star Starter
 
jnshmoo's Avatar
 
Join Date: Apr 2004
Location: Not Here
Posts: 1,226
Quote:
Originally Posted by johnph77
Then they've gone the unlimited route on spreadsheet size ala Corel QuattroPro. That'll make the purchase of the suite worth my while.

Considering that the first spreadsheet I ever owned (Visi-Calc for the Apple II in the late 1970s) was limited to a 64x256 grid, like the commercial says, "You've come a long way, baby!"
Not truly unlimited, but I weep for anyone who needs to work with a spreadsheet that taxes the new maximums.

Columns went from 256 to 16,000
Rows went from 64,000 to a cool Million.
__________________
Beer Snob and Baseball Sim Geek

jnshmoo is offline   Reply With Quote
Old 06-07-2006, 12:45 PM   #12
jnshmoo
All Star Starter
 
jnshmoo's Avatar
 
Join Date: Apr 2004
Location: Not Here
Posts: 1,226
Dola,

they really overhauled the interface though. I think I like it, but it's been taking some time getting used to it. It probably doesn't help that I've been going back and forth between 2007 and 2003 throughout the day either.
__________________
Beer Snob and Baseball Sim Geek

jnshmoo is offline   Reply With Quote
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 09:58 AM.

 

Major League and Minor League Baseball trademarks and copyrights are used with permission of Major League Baseball. Visit MLB.com and MiLB.com.

Officially Licensed Product – MLB Players, Inc.

Out of the Park Baseball is a registered trademark of Out of the Park Developments GmbH & Co. KG

Google Play is a trademark of Google Inc.

Apple, iPhone, iPod touch and iPad are trademarks of Apple Inc., registered in the U.S. and other countries.

COPYRIGHT © 2023 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Copyright © 2020 Out of the Park Developments