Roster Maker 15 (RM 15) by mrliioadin

mrliioadin

Senior Squad
Welcome everyone!

I'm announcing a new program designed to improve the speed with which we create and import rosters into the game! Essentially this will allow you to more quickly convert online or excel data into content which FIFA can read and understand.

Many of us have rosters or other player/team information saved in Excel files or we quickly download this information using google's table capture or a web crawler program. Currently, you have to input this data by hand one player at a time in CM 15. This does not eliminate the need for CM 15. It simply gives you a better baseline for beginning your edits in CM15.

Installation and initialization of RM15 is actually a bit tricky however. This is a program that will require you to read the readme. You'll need to ensure you have several specific programs for the workflow to work properly.

Setup:

SQL Server Management Studio (2012 express version is fine)
Click here for a 'How To'
The new version should prompt you to install sql server on its own.

CM 15

DBM15

Excel or google sheets may also be helpful.

The rough workflow will be as follows:

YOUR DATA --> Roster Maker 15 --> Database Master 15 --> Creation Master 15 --> Fifa 15

Screens:

Roster Maker turns this:



into this:



These tables are directly imported into DBM for further editing with CM15.


Installation:

Download Roster Maker 15 by mrliioadin here version 0.1

Download Roster Maker 15 by mrliioadin version 2.1 here
The installation for v2.1 is a little different. The InstallCreator exe will launch the installer for the full program. Make sure you leave "Launch after closing" checked at the end. Save it in #my documents#/Roster Maker 15 by mrliioadin. You'll have to uninstall your old version first.

I pulled version 2.0 because of a critical problem. Going to try again with another version.

The readme is contained in the additional files folder. Please follow it CAREFULLY.

Back up all of your data before importing anything from RM 15 or any other program.

How to:

A series of 'how to' videos will be provided to clarify how exactly to use the program.

Disclaimer:

This is quite literally the first program I've ever built and distributed. I am confident that it is stable, but we may run into issues. I beg of you to provide critical feedback but warn you I am in uncharted personal waters!

Videos:

Getting Started

Installing RM15

Restoring the database

Getting your connection string and install path

Selecting Base Tables

Importing data into RM15

Executing RM15

Importing RM15 output into DBM15


----------------------------------------------------------------------------------------------------------------------------------------------------------------------
 

mrliioadin

Senior Squad
SlimOntario2033;3780362 said:
any one tested? :)

I have. Hope more do soon!

There is still a bug when some playernames are duplicated. Particularly if the firstname of one player matches the last name of another. I'm hopeful I can iron that out in next version.
 

mrliioadin

Senior Squad
Released a new version of RM15 which should fix the bug where a player was duplicated many times in the final table. This still needs some test, let me know if you spot any bugs.

Also, in the help files and videos it refers to the two different download files. Luckily, I reduced all of that down to just one now. So, you can ignore most of that content.

Let me know if you have any questions.

For those that are following the every league project, this program is one of the reason's I'm able to build those leagues so quickly. I encourage you to try it out even if there is a little learning curve!

EDIT--

In the new download, the rar contains all of the additional files you need. This includes the sql database that you need to restore.
 

Robbles_Quin

Club Supporter
Hey! I'm getting a error when I attach the Base tables from modded files?

************** Exception Text **************
System.Data.SqlClient.SqlException (0x80131904): String or binary data would be truncated.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Roster_Maker_15.selectBaseTables.runPlayerNames()
at Roster_Maker_15.selectBaseTables.button5_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
ClientConnectionId:354bca14-8584-49c0-9ff7-7148e86b9ba1
Error Number:8152,State:14,Class:16


************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
Roster Maker 15
Assembly Version: 0.1.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Users/jesus/AppData/Local/Apps/2.0/LVMVJ373.Y8M/953PCC48.1E1/rost..tion_8bd03a1ff2103bf1_0002.0000_31251be746e68b27/Roster%20Maker%2015.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Data
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Transactions
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
 

Robbles_Quin

Club Supporter
hmm It seems I cant upload them cause the files exceed 1MB?
BTW it's a fresh install of win10 cause windows 7 didnt even let me import the database in SQL
https://drive.google.com/file/d/0BwYlmpv__S9ASzVKOU9KcDNuZlU/view?usp=sharing
https://drive.google.com/file/d/0BwYlmpv__S9Ac0ZjOTdWdnJ6ams/view?usp=sharing
https://drive.google.com/file/d/0BwYlmpv__S9ALThtMldxT2Z0WGc/view?usp=sharing
https://drive.google.com/file/d/0BwYlmpv__S9AM3V2RHc3Y2g2ek0/view?usp=sharing

does this work? its my first time using google drive lol

But when I use your files I get this error:

************** Exception Text **************
System.Data.SqlClient.SqlException (0x80131904): Cannot insert explicit value for identity column in table 'runningteamplayerlinks' when IDENTITY_INSERT is set to OFF.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Roster_Maker_15.selectBaseTables.runTeamPlayerLinks()
at Roster_Maker_15.selectBaseTables.button5_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
ClientConnectionId:b69291ea-3b7a-49b6-9512-6cee5b923ac6
Error Number:544,State:1,Class:16


************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
Roster Maker 15
Assembly Version: 0.1.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Users/jesus/AppData/Local/Apps/2.0/LVMVJ373.Y8M/953PCC48.1E1/rost..tion_8bd03a1ff2103bf1_0002.0000_31251be746e68b27/Roster%20Maker%2015.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Data
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Transactions
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
Assembly Version: 4.0.0.0
Win32 Version: 4.6.79.0 built by: NETFXREL2
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
 

Robbles_Quin

Club Supporter
that's fine! hey in the mean time can i make a excel for you to add on to those 4 files i sent you? so I can do pretty much all the work and all you need to do is execute them?
 

mrliioadin

Senior Squad
Robbles_Quin;3842464 said:
that's fine! hey in the mean time can i make a excel for you to add on to those 4 files i sent you? so I can do pretty much all the work and all you need to do is execute them?

Yes. Just make sure it is formatted the way I describe in the Every League Project. Also, I'm having surgery tomorrow so if I don't get back to you right away...

Regarding RM15. Did you say you were not able to get the database imported? That is a must. Also, if you're on Windows 10, try using it in compatibility mode for 7. I just tried to recreate the issue on a second PC and am not running into this problem anymore.

Lastly, please send me your connection string.
 

Robbles_Quin

Club Supporter
OH good luck with that!!! yeah its also in the example excel sheet in the RM right?
Umm it didnt work when I was on windows 7 kept denying access but it works here. just executing it is hard. ill try it running in windows 7 mode.
 

Robbles_Quin

Club Supporter
oooooh it won't let me run in win7 mode. just says theres no components for SQL, and when i run RM in 7 mode it says I dont have SQL installed lol
 

Robbles_Quin

Club Supporter
Data Source=RAQ\SQLEXPRESS;Initial Catalog=FIFA15Editing_AzureBackup;Integrated Security=True;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False

C:\Users\jesus\Documents\Roster Maker 15 by mrliioadin\

yes i got them installed in win10
 


Top