Whew, I got my company to appear! Turns out my problem was that I didn’t have a complete CompanySize table. Somehow I got it into my head earlier that the CompanySize had different amounts of lines for different companies, but that must have been the PrestigeAndReputation table or something. In fact every company gets exactly 961 lines, and if you’re missing some, you will have a problem.
I also skipped some of the tables Zeussy said were deprecated this time around, that’s good to know about! Especially since correctly filling out trim and variant costs would have been a little complicated.
There is one issue that makes it different from competing against a player as I imagine it: I have noticed that it isn’t selling all of the trims all of the time. I assume this is by design, it only produces some of the trims which are available at any time. This is probably based on both the target demographics of the trims, and the size of the company. It also seems fairly deterministic which makes me wonder if some of the trims in the competitors.db are destined to never be used.
In my ideal scenario, I would have every trim from a player’s save file active when it was active in the save file. That might not happen, but I will also have to do some experimentation later on whether the declared target demographic matters. I know a lot of people leave the same target demographic on their trims.
For anyone looking to follow in my footsteps, I have a complete code for SQLite which will allow you to add your save file to the competitors. Back up your competitors.db first. Simply open the competitors.db file, attach your save file under the alias “savegame” and this will work! You may want to change the name of the company whose size and profile is copied.
--Insert companies and car data. CompanySize and CompanyProfile still have to be done after this.
insert into Companies
select * from savegame.Companies;
insert into Models
select * from savegame.Models;
insert into CarProjects
select * from savegame.CarProjects;
insert into Families
select * from savegame.Families;
insert into Variants
select * from savegame.variants;
insert into Trims
select * from savegame.Trims;
insert into TrimResults
select * from savegame.TrimResults;
insert into EngineResults
select * from savegame.EngineResults;
insert into EngineCurves
select * from savegame.EngineCurves;
insert into CarFacelifts
select * from savegame.CarFacelifts;
insert into TrimSlots
select * from savegame.TrimSlots;
insert into TrimEmissions
select * from savegame.TrimEmissions; --Pretty sure this isn't actually used by competitors
insert into CarThumbnails
select * from savegame.CarThumbnails; --This doesn't work right now but I'm leaving it in anyway
--CompanyAwareness, CompanyPrestigeAndReputation are both populated by competitors, but I'm told they're not necessary
--Now we are going to copy CompanySize and CompanyProfile from FamilySmall 3 Fruinia
--Change the two references to "FamilySmall 3 Fruinia" to the name of any other company you can see in the sankey chart if you want. It should affect the number and type of trims produced.
insert into CompanyProfile (CUID, Profile, ColourHex)
Select (select uid from savegame.companies), profile, ColourHex --ColourHex can be a hex color you choose instead
from CompanyProfile
where CUID = (select uid from companies where name = 'FamilySmall 3 Fruinia');
insert into CompanySize (CUID, Year, Size)
Select (select uid from savegame.companies), Year, Size
from CompanySize
where CUID = (select uid from companies where name = 'FamilySmall 3 Fruinia');
As a side note, if you ever wish to disable a company, the most expedient way to do so is probably to remove its entries from CompanySize. This will stop it from appearing in game, and is faster than actually deleting it or its cars because you have to go bottom up in order of dependencies.
Now that I’ve reached this step, I would like to ask for some save files! If I can get several save files which have played the whole timeline, we can playtest what it’s like against human-made cars. Edit: Actually, sandbox companies might be possible to import as well. I’ll have to check if they have projects and facelifts.
Edit 2: The last couple paragraphs will also not work on a sandbox save file without some alterations. The simplest way would be to specify a single company name to copy for at a time, and run that section again if you want to do multiple companies.