Use the Excel sort feature to sort the birthdate column so its youngest to oldest. Choose a birthday value and copy and paste it to the first 2000 players. Choose another birthday value and apply it to the next 2000 players so that they're 1 year older. Etc, and so forth. The only tricky part is you have to experiment a bit to figure out which values = which birthday year, because they're written in a 6-digit code.
-
This is a reminder of 3 IMPORTANT RULES:
1- External self-promotion websites or apps are NOT allowed here, like Discord/Twitter/Patreon/etc.
2- Do NOT post in other languages. English-only.
3- Crack/Warez/Piracy talk is NOT allowed.
Breaking any of the above rules will result in your messages being deleted and you will be banned upon repetition.
Please, stop by this thread SoccerGaming Forum Rules And Guidelines and make sure you read and understand our policies.
Thank you!
CM15 and Other Tools
- Thread starter Rinaldo
- Start date
Power-MUFC
Club Supporter
Quick question about File Master
I imported boots using File Master, but I can't find the files. The boot is FOR SURE in the game as it's appeared for different players, but I can't seem to select the boot for any of my own players as it's not listed.
How can I find the file within File Master or how can I import other boots so I can select them in the game?
I've already tried CM15 and it crashes my game unfortunately, unless theres a way to use CM15 without accessing the database.
I imported boots using File Master, but I can't find the files. The boot is FOR SURE in the game as it's appeared for different players, but I can't seem to select the boot for any of my own players as it's not listed.
How can I find the file within File Master or how can I import other boots so I can select them in the game?
I've already tried CM15 and it crashes my game unfortunately, unless theres a way to use CM15 without accessing the database.
mrliioadin
Senior Squad
bangus;3835477 said:
I think I can help clarify this a little further. Excel, SQL, and EA all store dates as an integer which counts from a specific date. Consider Matt McKay (Australian International).
McKay's birthdate is 01/11/1983 (mm/dd/yyyy). Excel starts counting at 1 from 1/1/1990. You'll sometimes notice that if you try to treat dates before 1900 like dates in excel, it can sometimes act a bit funny. There are many reasons for this, but the fact that it goes to 0 and then negative.
You can prove excel's treatment by simply setting three consecutive cells to 1
0
-1
Then highlight those cells and format them as dates.
The first will show 1/1/1900
The second will show 1/0/1900 (the 0th of January?)
The last one just won't process (I think it just shows a set of pound signs).
SQL alternatively starts counting at 0. It can handle negative values. And it considers the value entered to be a datetime.
If you enter the following code in a new sql script:
select convert(datetime,1)
select convert(datetime,0)
select convert(datetime,-1)
It will return 2nd of January 1900 at 00:00:00.000
1st of January 1900 at 00:00:00.000
31st of December 1899 at 00:00:00.000
Any date in either program is just stored as an integer that counts the number of days from their starting point.
EA does exactly the same thing but they add a constant to each birthdate.
For excel the constant is 115859
it's one off for SQL because off the difference in starting positions. In SQL it is just 115860.
So if you want to convert EA birthdates to excel dates, just subtract 115896 from the ea date. If you want to convert it back, just add that same constant to a birthdate stored normally in excel.
If you want to do the same in sql, just add an additional day.
Bangus is right that you can easily do what you're trying to in excel. Just subtract 1826 (I think) from all players dates in EA. 365*5 +1 (I think we've had only one leap year? Right?)
mrliioadin
Senior Squad
CrAzYaLeX;3838817 said:
Try regenerating your BH files. CM15 --> tools --> regen
ankurcshah
Club Supporter
it doesn't work even as an admin! what can we do now?
ankurcshah;3842765 said:
You can quit spamming.
RedDevils86
Senior Squad
I've just got back in the game this week & want to start back making boots but I've had this error coming since the start. I tried adding Kit .pngs but they wouldn't save because of this access denied error. Please help!!
RedDevils86;3844543 said:I've just got back in the game this week & want to start back making boots but I've had this error coming since the start. I tried adding Kit .pngs but they wouldn't save because of this access denied error. Please help!!
Find that xml file and give it read/write properties.
RedDevils86
Senior Squad
regularcat;3844695 said:
Thanks regularcat. That worked BUT....
Since returning this week I've found this FIFA15 game is so sensitive and complex. I know I keep harking back to the glory days of FIFA09-11 when everything was so basic and easy for the most part but S**T man. Gimme a break with this stuff.
Could someone please help me with just a few of the basics? All I want to do in my game is updates kits, boots & squads(pretty much just Man Utd) I don't get hung up on whole leagues, etc. With CM15 I've found every change i make, when I go to save, it freezes and crashes the DB. Thankfully I just use the 1.5 updated DB to fix it but still.
Please help
RedDevils86;3844969 said:
The best advice I can give you when adding records to the any table
in the database is to do it in MS Excel and import back into the database using DBM 15.
It is fool proof.
RedDevils86
Senior Squad
regularcat;3844980 said:
How does this apply to importing kits & boots?
(I know this probably seems like a noob question but I'm so lost on this game. Hopefully FIFA16 is much more easier to deal with in terms of updating this stuff)