| Find in this manual | ||
| Replace with | ||
helpx_data_export
SQL / CSV Dump
OOTPB offers the ability to export all of your league data to a series of files in one of three formats:
All files created by these processes are placed in the import_export directory in your saved game directory. While the CSV process dumps data, the MS Access and MySQL processes actually dump SQL scripts that can be used to create an MS Access or MySQL database.
Each of these dumps also has a 'configure' option. This option opens a separate window:
These profiles allow you to select the specific tables you wish to include in your data dumps. You can check or uncheck all using the Activate and Deactivate buttons on the left.
There are also a few additional options at the top of the page:
The MS Access, MySQL, and CSV dumps can also be accessed through the Tools action menu on the Database Info page.
Users who are interested in SQL/CSV dumps should also review the Almanac, because of its ability to schedule regular SQL/CSV dumps.
Note: In online leagues, you are required to enter the commissioner password before you can use these tools. This is because these tools export raw data, such as the true ratings for all players.
helpx_data_export.tpl'>
OOTPB offers the ability to export all of your league data to a series of files in one of three formats:
- CSV (comma-separated files; you can also control the delimiter used in the CSV dumps via the Preferences Page
- MS Access
- MySQL
All files created by these processes are placed in the import_export directory in your saved game directory. While the CSV process dumps data, the MS Access and MySQL processes actually dump SQL scripts that can be used to create an MS Access or MySQL database.
Each of these dumps also has a 'configure' option. This option opens a separate window:
These profiles allow you to select the specific tables you wish to include in your data dumps. You can check or uncheck all using the Activate and Deactivate buttons on the left.
There are also a few additional options at the top of the page:
- replace accents - Replaces foreign characters/accents with their standard U.S. English counterparts, to avoid problems with data programs that cannot handle accents
- dump only cities in use - Limits the dump to just cities that are currently in use. Since the OOTPB cities database has over 90,000 entries, this can save a significant amount of unnecessary data.
- dump only nations in use - Limits the dump to just nations that are currently in use. Since the OOTPB nations database has over 200 entries, this can save a significant amount of unnecessary data.
The MS Access, MySQL, and CSV dumps can also be accessed through the Tools action menu on the Database Info page.
Users who are interested in SQL/CSV dumps should also review the Almanac, because of its ability to schedule regular SQL/CSV dumps.
Note: In online leagues, you are required to enter the commissioner password before you can use these tools. This is because these tools export raw data, such as the true ratings for all players.
helpx_data_export.tpl'>