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 > Prior Versions of Our Games > Out of the Park Baseball 20 > OOTP 20 - General Discussions

OOTP 20 - General Discussions Everything about the newest version of Out of the Park Baseball - officially licensed by MLB.com and the MLBPA.

Reply
 
Thread Tools
Old 07-13-2019, 02:25 AM   #1
bwburke94
Hall Of Famer
 
bwburke94's Avatar
 
Join Date: Jun 2008
Location: Belchertown, MA, USA
Posts: 4,440
Easy way to convert world_default.xml to a CSV?

I need lat/long for all cities in the database, and I think the easiest way to do this is to convert the database file that already exists.


Unfortunately, most converters can't handle XML files this large, so I'm not sure how to proceed.
bwburke94 is offline   Reply With Quote
Old 07-13-2019, 12:37 PM   #2
albatross11
All Star Reserve
 
Join Date: Mar 2003
Posts: 907
Quote:
Originally Posted by bwburke94 View Post
I need lat/long for all cities in the database, and I think the easiest way to do this is to convert the database file that already exists.


Unfortunately, most converters can't handle XML files this large, so I'm not sure how to proceed.
Don't know if you've tried any of these, or if they will help you:

https://onlinexmltools.com/
__________________
Peace,

albatross
albatross11 is offline   Reply With Quote
Old 07-13-2019, 07:01 PM   #3
bwburke94
Hall Of Famer
 
bwburke94's Avatar
 
Join Date: Jun 2008
Location: Belchertown, MA, USA
Posts: 4,440
Unfortunately, because of the unusual way world_default.xml is coded, those won't help me.
bwburke94 is offline   Reply With Quote
Old 07-13-2019, 07:34 PM   #4
albatross11
All Star Reserve
 
Join Date: Mar 2003
Posts: 907
Quote:
Originally Posted by bwburke94 View Post
Unfortunately, because of the unusual way world_default.xml is coded, those won't help me.

Sorry. Are you trying to put the exact lat/long data in, or just fill in those fields? Sounds like quite a job if you're going for exact data.
__________________
Peace,

albatross
albatross11 is offline   Reply With Quote
Old 07-13-2019, 09:00 PM   #5
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
many free zip code / city databases come with lat/long. they are available on that internetty thingee.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 07-13-2019, 10:06 PM   #6
albatross11
All Star Reserve
 
Join Date: Mar 2003
Posts: 907
Quote:
Originally Posted by Spritze View Post
many free zip code / city databases come with lat/long. they are available on that internetty thingee.

Lol, right, but you still gotta put em in there.
__________________
Peace,

albatross
albatross11 is offline   Reply With Quote
Old 07-14-2019, 01:02 AM   #7
damoore46
Minors (Rookie Ball)
 
damoore46's Avatar
 
Join Date: Jul 2015
Posts: 48
Quote:
Originally Posted by bwburke94 View Post
I need lat/long for all cities in the database, and I think the easiest way to do this is to convert the database file that already exists.


Unfortunately, most converters can't handle XML files this large, so I'm not sure how to proceed.
If all you want is data from the xml file. And you do not plan on importing it back into OOTP, then you could just import the xml into a spreadsheet. I did something similar to verify cities I added were going to be in the world_default.xml.
__________________
damoore46 is offline   Reply With Quote
Old 07-14-2019, 05:05 PM   #8
NoOne
Hall Of Famer
 
NoOne's Avatar
 
Join Date: Apr 2015
Posts: 7,167
Quote:
Originally Posted by albatross11 View Post
Lol, right, but you still gotta put em in there.
importing a pre-made list reduces work to a few clicks and keyboard strokes.

back to original question...

like damoore said, you should be able to start that import wizard the moment you try to open an xml file in your preferred spreadsheet program - change delimiter to tab or 'special chars' if possible and use xml tags in list. if that doesn't work there's almost certainly a program that can convert the files between the two formats out there.

https://www.google.com/search?client...csv+conversion

looks like a bunch of options to look over / try.
NoOne 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 03:57 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