Page 1 of 2
editing db....

Posted:
Sat Nov 09, 2024 12:20 pm
by dawg1isopen
is there a way to edit db outside of game?
Re: editing db....

Posted:
Sun Nov 10, 2024 6:30 pm
by NCAAhoops
Yes. Use commissioner mode and under the commissioner office you can export the dB then make your edits and then use the commissioner office to import back into the game. I think most people use SQLiteStudio that can be downloaded for free to use as their editor. You can get to commissioner mode by clicking on your coaches name on the left hand side menu.
Re: editing db....

Posted:
Sun Nov 10, 2024 7:35 pm
by dawg1isopen
ok, thanks...ummm, d/l app, exported db, but when i open the db in the sqlite app all the cells are empty...any ideas on what i am doing wrong?
Re: editing db....

Posted:
Mon Nov 11, 2024 2:29 pm
by NCAAhoops
You should be able to see data in the teams.db, coaches.db & players.db. Some will be empty such as as recruits and I think the conference.db will be empty. What db are you trying to edit?
Re: editing db....

Posted:
Mon Nov 11, 2024 4:08 pm
by dawg1isopen
Yeah, not seeing anything but empty cells...I am trying to edit [my league name file edit.db]...
Re: editing db....

Posted:
Mon Nov 11, 2024 6:11 pm
by jlemmen43
dawg1isopen wrote:Yeah, not seeing anything but empty cells...I am trying to edit [my league name file edit.db]...
Have you expanded the database to show the tables? The data is in the tables within the database. From there you should see Teams, Players, Conf and a few other things. You must double click on a table and then go to the 2nd tab at the top of that table (can't remember the name of it off hand)
Re: editing db....

Posted:
Tue Nov 12, 2024 12:26 am
by dawg1isopen
bingo! it is the "data" tab, thanks to the both of you!
Re: editing db....

Posted:
Fri Nov 15, 2024 12:06 am
by jlemmen43
dawg1isopen wrote:bingo! it is the "data" tab, thanks to the both of you!
Woohoo!! Glad we were able to help. Any other questions regarding editing databases, do ask.
Re: editing db....

Posted:
Sat Nov 16, 2024 12:23 pm
by NCAAhoops
Yes, glad we could help you get there. I would back up your association before importing early on until you are comfortable with the edits you are making so you don't corrupt your save or keep your 1st export so you can get back to where you started.
Re: editing db....

Posted:
Sat Nov 16, 2024 12:56 pm
by dawg1isopen
that sounds sound!