Squad Changes & Main DB

[Bubble Gum]

Hi once more! In the How to.. thread no one can help me, so I've decided to create own thread. The question is: what is the way to make changes in main DB from the squad files permanent? Or is there a way to make own changes in squad files format? Hope that the question is clear and someone know the answer. Thanks a lot!

 

[bangus]

Permanent changes are made to the db. When you use that db, it creates a new squads save. If you need to make more permanent changes, you have to edit the db again, then delete your current squads save, and then create a new squads save. You don't ever edit the squads save.

 

[BlackEmperor]

Well... since I don't know how to open a squad file, you'll probably have to look the changes up in the game itself (compare current stats with previous stats on a page like sofifa) and then insert them into the database. A really tough endeavour...

I wanted to do the same, but I'll probably only do it for the Bundesliga at the most.

 

[bangus]

Well... since I don't know how to open a squad file, you'll probably have to look the changes up in the game itself (compare current stats with previous stats on a page like sofifa) and then insert them into the database. A really tough endeavour...

I wanted to do the same, but I'll probably only do it for the Bundesliga at the most.

Oh okay, so he's asking how to make changes in the downloaded squad updates, a permanent part of the db.

No can do, other than editing one player at a time as BE said.

 

[Bubble Gum]

Permanent changes are made to the db. When you use that db, it creates a new squads save. If you need to make more permanent changes, you have to edit the db again, then delete your current squads save, and then create a new squads save. You don't ever edit the squads save.

Yes I know this. But I want to know if there is a way to export changes from the squad update files from EA to the main DB to have edited skills and new players like Del Pierro, Owen and so on in FIFA base. Now if I make some changes I have to remove old squad files and new skills & players will disappear.

As I understand there is no way to do it. Nevertheless thank's a lot.

By the way, squad files can be opened with notepad and there you can find added players surnames.

 

[bangus]

Well... since I don't know how to open a squad file

Okay, I was in fact able to copy data from the squad save file, and paste and save it into my db.

Squad files can be opened using IM 12. I opened a squad save and exported the players table to my desktop. The table wouldn't import into the db without getting an error message. And I couldn't open the table with Excel (says "locked for editing"). But I could open it with Notepad. Using Notepad, I then:

- Opened the players table from the db, and deleted the data inside that file.
- Opened the players table from the squad save, copied the data inside, then pasted the data into the blank players table from the db.
- Saved, then imported this edited players table back into the db. I was also able to now open this edited players table with Excel.

The table imported back into the db and saved with no issues. And I was able to start FIFA 13 and play a game.

If this much worked, it seems to me you could try following this same procedure using any squad save update. You would have to copy the players table info and teamplayerlinks table info from the squads save update file, and paste it into the corresponding db table files. I would try it myself but I don't have any squad updates to test.

 

[bangus]

By the way, squad files can be opened with notepad.

Right, but the editing tool you need to examine and export the various tables is Internal Master 12, download link here:

http://fifa-master.com/downloads/category/44-internal-master-12

 

[Bubble Gum]

Really nice work. I'll test it and describe results in this topic.

 

[Bubble Gum]

Steps 2 and 3 are clear, but I failed to open squad update file with IM. What shoul I do step-by-step? I've used this tool only few times... BTW here is the my last squad update file. http://depositfiles.com/files/4uf35pem7

 

[bangus]

Steps 2 and 3 are clear, but I failed to open squad update file with IM. What shoul I do step-by-step? I've used this tool only few times... BTW here is the my last squad update file. http://depositfiles.com/files/4uf35pem7

I was hoping someone would post a squad update, thanks.

It opens in IM 12 fine BTW. Opening/loading involves two steps: the tool asks for your db meta file from your current db folder, then for your squad save. I paste both on my desktop, makes it easier for me.

 

[Bubble Gum]

Yes, now it works without problems. I'll try to do steps 2 and 3 and see what would happen.

 

[bangus]

I transferred the squads data, edited the players table and teamplayerlinks table, imported into the db, saved, started FIFA 13, all with no problems. But when I went to play a game, it crashed. Could be other tables need updating as well, like the formations table for example. I know from previous editing that the player positional data in the teamplayerlinks table has to match the teams' formation data or the game won't work. I may also need to load my original db and use that, maybe there are conflicts in my edited db. If you can't get it working, I'll maybe try some things later.

 

[Bubble Gum]

I've looked through the tables. I think that we have to export players, teamplayerlinks, teams, formations. Also some new player ID's are connected with player_grudgelove, formupdate and previosteam. DCPLAYERNAMES contains jerseynames for added players. Also we may need playerloans table.

 

[Bubble Gum]

I've exported those tables, but now CM gives an error after selecting of lan.db. An error (wrong value) is in those files:

в System.DateTime.Add(Double value, Int32 scale)
в FifaLibrary13.FifaUtil.ConvertToDate(Int32 gregorian)
в FifaLibrary13.Player.FillFromPlayerloans(Record r)
в FifaLibrary13.PlayerList.FillFromPlayerloans(Table t)
в FifaLibrary13.PlayerList.Load(DbFile fifaDbFile)
в FifaLibrary13.FifaEnvironment.LoadLists(EFifaObjects fifaObjects)
в FifaLibrary13.FifaEnvironment.LoadLists()
в FifaLibrary13.FifaEnvironment.Open(ToolStripStatusLabel statusBar)
в CreationMaster.MainForm.Open()
в CreationMaster.MainForm.openSelectAllToolStripMenuItem_Click(Object sender, EventArgs e)
в System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
в System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)
в System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
в System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
в System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
в System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
в System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
в System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea)
в System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
в System.Windows.Forms.Control.WndProc(Message& m)
в System.Windows.Forms.ScrollableControl.WndProc(Message& m)
в System.Windows.Forms.ToolStrip.WndProc(Message& m)
в System.Windows.Forms.ToolStripDropDown.WndProc(Message& m)
в System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
в System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
в System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

 

[bangus]

I've exported those tables, but now CM gives an error after selecting of lan.db.

You don't select lan.db when opening the db with CM 13. That's not even an option in the latest version. Choose Open - Select all (13).

 

[regularcat]

the squads data is not on the same order as the database data, if you do not copy it to the correct locations the game will crash.

 

[Bubble Gum]

I don't understand you guys . I know how to open DB with CM and I've selected all. I select main fodder of the FIFA, then db-meta, after that ng_db, next lan. db and after that CM crashes.

Reg, I did everything like bangus said but CM still crashes.

And what about you guys? Is everything OK or the game still crashes? We have to find what we are doing wrong.

 

[bangus]

I don't understand you guys . I know how to open DB with CM and I've selected all. I select main fodder of the FIFA, then db-meta, after that ng_db, next lan. db and after that CM crashes.

Reg, I did everything like bangus said but CM still crashes.

And what about you guys? Is everything OK or the game still crashes? We have to find what we are doing wrong.

You use DBM 12 to open the tables. Not sure why you're even using CM 12/13, that tool can't edit what you need to edit here.

Like I said, I was sucessful in transferring the data from tables in the squad save, to the db. After that, I was able to start FIFA 13. It was only when I tried to start a game that it crashed. It's no doubt an issue with more of the tables, but it's not something I'm interested in spending time testing. I never use squad updates, I have my own db I use.

 

[Bubble Gum]

Look, ewerything works nice, I managed to start the game and play match. Hope that after relise of CS or other tool I will be able to use this DB. The problem is that now CM gives an error, so editing is impossible.

Any way, I hope that it will work in future. Thank's for help and good luck in FIFA edeting !

 

[bangus]

Look, ewerything works nice, I managed to start the game and play match.

Which tables from the squad file did you transfer to the db, to get it to work?