Madden NFL DB Editor 2019
A new DB editor for 2019 brought to you by StingRay68 and yours truly, elguapo. The DB editor works just like previous editors. Suggestions, comments and bug reports are welcomed and any suggested features will be reviewed and added as time allows.
What's New
With version 1.9
You can sort the TABLE names.
Added ability to copy records (rows).
There was a potential issue when editing, sorting, or adding/deleting records not saving correctly. That has been resolved.
With version 1.8
Bug fixed with the Importing of TABLES.
You can now Add/Delete records by right clicking on the datagrid. Click on any cell to Add/Delete a record. To Add/Delete multiple records, select the number of records (rows), right click and select Add/Delete. To use the multi function records you must highlight the entire row and not just a single cell.
You can now Add/Import records to tables that had "UnSupported Field Types", the DB editor will just ignore those unsupported fields types.
New Features
1. You can now use the Datagrid to make changes to the tables.
2. Shortcut Keys added.
Please note that if you make changes to a table, even if you just sort it you will be prompted if you want to save the table (datagrid only). Also when you click on a cell click on the values to show the field properties of that field. When sorting also click on the field name.
Color coded.
Red - You have your typical TABLE and FIELD (columns) sections.
Blue - Information about a particular TABLE, FIELD and DB file.
Yellow - Edit section. Click on a FIELD row, click on a FIELD name, edit the entry and press the "Go" button to make the changes active. (All of the edits are not permanent until you save the file, even if you change tables.)
FEATURES
The main key feature is that edits are done in memory and to do not take affect until you save the file.
Manual editing of FIELDS.
CSV
Export Table - Export current table.
Import Table - Import to current table.
Export All Tables - Exports all the tables in the db file.
Export Fra2Ros Tables - Exports the tables for a ROS file.
Addendum - This is a very specific import option, please use caution. Let's assume you want to add the current win/los records only. You would load the TEAM table and if you have the main 32 teams, bears-vikings then the addendum csv file would have the field names for the win/loss and the win/loss for each team.
OPTIONS
TGID + 1 Once you export the Fra2Ros tables, open a ROS (roster) file, click on the TGID + 1, and import the franchise table into the roster table. Click the TGID + 1 everytime you import a table. The DB editor will recognize which fields to load and increase the TGID value by one.
Some FIELD Types cannot be edited and that is not a DB editor issue, it is how the TDBAccess.dll has it. Be aware of the FIELD size (Bits) as you will encounter an error if you go over its limit. (Unsupported FIELD Types are tdbBinary, tdbVarchar and tdbLongVarchar)
The DB editor can read the rosters, franchise and db files you are accustom too, plus some Madden 19 files like the roster. (Removing the FBChunks section is required before opening the roster in the DB editor.)
Use at your own risk, no "customer support", backup your files.
Testing
Spoiler:
Special Thanks,
To StingRay68 for his insights, direction and for most of the heavy lifting in this project.
