Ncp_db Troubles!!!

[jastaV]

NCP_DB TROUBLES seem not to have an end.

But the problems I already reported here in past days, (readarding Setup_scenery EVENTS and CITIES sheets) yesterday I met seriuor troubles with MODELS excel template: processing it according to the consolidated routine I got corrupted mdl files for all generals!!!!!

Ex:

UID = 1944
NationTag = FRA
Name = $Model_Name_FRA_Mortier2
Alias = ldr_FRA_Mortier2
ShortName = $Land
Text = symbol_general_2.png
Kind = $colFRAMain
Family = Unit_FRA_Mortier.png
ImageID = Mortier
Sound_FactionTag = 1
Portrait = 1
CbtSignature = 1
OffFire = 1
DefFire = 4
Initiative = 10
Range = 2
ROF = 1
Protection = 1
Hits = 80
MenPerHit = 0
HorsesPerHit = 0
GunsPerHit = 0
Cohesion = 0
DmgDone = $LitFoot
CohDone = 120
AsltDmgDone = 100
AsltCohDone = 100
Move Type = 22
Move Ratio = 22
CohMove = 1
AtrMove = 2
BaseCohLoss = 0
BaseAttrition = 3
DetectLand = 0
DetectSea = 10
Blockade = 0
HideValue = 1
Weight = 30
ProgRate = $ldr_FRA_Mortier3
Patrol = 0
Evasion = 1
TechUpg = 0
TrainUpg = 0
CapturePerc = 0
IsSupport = 0
SupplyUsage = 1
SupplyStore = 0
AmmoUsage = 0
AmmoStore = 0
SupHitPen = $Charismatic
SupMovePen = $HotHead
SupCbtPen = $Master_Driller
Attributes = $Dispersed_Move
Ability0 = $Guard_Commit
Ability15 = 2
Ability16 = 10
POLValue = 100
MoneyCost = 2
Conscriptcost = 21
WarSupplyCost = 3
BuildRate = $Marshal
LeaderRank = 1
MaxRank = Yes
Title = 4
LandLeader = 3
NavalLeader = 2
Defensive =
AIRole_Skirmisher =
AIRole_Raider =
CustomNames =

But the fact NCP gives a mess of errors during the upload, when new mdl files are tested, it's clear from their examinations that data do not match the proper fields.

In the quoted example all but one special ability command lines are misplaced:

SupHitPen = $Charismatic
SupMovePen = $HotHead
SupCbtPen = $Master_Driller
Attributes = $Dispersed_Move
Ability0 = $Guard_Commit

Again I bypassed troubles by manipulating the original NCP instalaltion MDL files, (Model and Unit), and then manually edited mdl_Alias.ini and uni_Alias.ini, but the main problems with NCP_DB are till unfixed and their reason is unknown!

[Pocus]

when you get shifted data, it means you have an empty cell in XLS. No cell should be left empty, at the very least put NULL to fill it.

[jastaV]

when you get shifted data, it means you have an empty cell in XLS. No cell should be left empty, at the very least put NULL to fill it.

I just repetead the routine to get MDL files out of LGE_DB_Models_LGE36b.
Note!!!!!
I DID NOT CHAGED/EDITED ANYWAY LGE_DB_Models_LGE36b file, just processed it: LGE_DB_Models_LGE36b >>>> Models.CSV >>>> "model".MDL files & mdl_Alias file.

Here is Ney_2 mdl file, chosen in a random way:

UID = 1958
NationTag = FRA
Name = $Model_Name_FRA_Ney2
Alias = ldr_FRA_Ney2
ShortName = $Land
Text = symbol_general_2.png
Kind = $colFRAMain
Family = Unit_FRA_Ney.png
ImageID = Ney
Sound_FactionTag = 1
Portrait = 1
CbtSignature = 1
OffFire = 1
DefFire = 4
Initiative = 10
Range = 2
ROF = 1
Protection = 1
Hits = 80
MenPerHit = 0
HorsesPerHit = 0
GunsPerHit = 0
Cohesion = 0
DmgDone = $LitFoot
CohDone = 120
AsltDmgDone = 100
AsltCohDone = 100
Move Type = 22
Move Ratio = 22
CohMove = 1
AtrMove = 2
BaseCohLoss = 0
BaseAttrition = 3
DetectLand = 0
DetectSea = 10
Blockade = 0
HideValue = 1
Weight = 30
ProgRate = $ldr_FRA_Ney3
Patrol = 0
Evasion = 1
TechUpg = 0
TrainUpg = 0
CapturePerc = 0
IsSupport = 0
SupplyUsage = 1
SupplyStore = 0
AmmoUsage = 0
AmmoStore = 0
SupHitPen = $Charismatic
SupMovePen = $Reckless
SupCbtPen = $Screener
Ability15 = 2
Ability16 = 12
POLValue = 100
MoneyCost = 2
Conscriptcost = 22
WarSupplyCost = 3
BuildRate = $Marshal
LeaderRank = 1
MaxRank = Yes
Title = 3
LandLeader = 3
NavalLeader = 3
Defensive =
AIRole_Skirmisher =
AIRole_Raider =
CustomNames =

It's clear most command line values/parameters are misplaced......and it's clear the truobles is with the original NCP_DB files leure: !
.... anyway, at worst, to know how to fix troubles help!
Thanks for this last piece of information!!!!!

[Pocus]

ok, but in the original file you have 'notes columns', starting with a §. Before you convert the XLS in CSV, you should before do a temporary copy of the XLS and then remove all such columns, because I think that some have empty cells.
If you want to clean up that, you can see to fill all the notes with NULL, once and for all.

I'm lacking time, but I think I'll remove these notes in the next official DB release, they are a bit a pain in the rear when we do exports, or at least push them at the end.

[jastaV]

ok, but in the original file you have 'notes columns', starting with a §. Before you convert the XLS in CSV, you should before do a temporary copy of the XLS and then remove all such columns, because I think that some have empty cells.
If you want to clean up that, you can see to fill all the notes with NULL, once and for all......

Okay I have done with Generals/Leaders adding Null where needed!!!!

What's as regard Unit/Regiments?
Have to do the same?
...for example in "§ uniforme" column there are some void cells.....Do I have to fill them with NULL?

JastaV

[Pocus]

yes everywhere please, this will clear the problems.

[jastaV]

yes everywhere please, this will clear the problems.

LGE_DB_Models_LGE36b_mod attached down here could perhaps work.
It's the modded and hopefully correction version of LGE_DB_Models_LGE36b.

Please give it a glance, possibly try it and confirm it works for you too!

BTW, the bright colours enployed to mark different fields are very useful at first glance but are a pity if you have to work over them for a long time. leure:

NOTE: on the very bottom I added Drouot_4 and Mortier_4. The two "Guard Commit ability" generals I used with The Eagle's Return.
I decided to place them there because having not to re-number all the mess of MDL files!!!!!!

[FM WarB]

The NOTES columns at the end of the setup spreadsheet do not have that squiggly character thats not on my keyboard on the column header. There are blanks in these columns.

I find the comments useful. If you (or I) moved these comment columns to the last columns of the spreadsheet, the problem would be solved?

[jastaV]

The NOTES columns at the end of the setup spreadsheet do not have that squiggly character thats not on my keyboard on the column header. There are blanks in these columns.

I find the comments useful. If you (or I) moved these comment columns to the last columns of the spreadsheet, the problem would be solved?

I please you to check LGE_DB_Models_LGE36b_mod.rar:

http://www.ageod-forum.com/attachment.php?attachmentid=3444&d=1216307963

If it works we could assume it as a starting point for future updates.
At present I'm worried to get a trustable set of LGE_DB files!
The Eagle's Return campaign I'm working over is a good playground to test existing LGE_DB files and to find fixes to trouble.
Guess all main troubles related to LGE_DB files are to be resolved before going after the Germany 1813 Grandcampaign.
Given the complexity of this last projects it's opportune to have trustable LGE_DB files to work over.

JastaV

[jastaV]

The NOTES columns at the end of the setup spreadsheet do not have that squiggly character thats not on my keyboard on the column header. There are blanks in these columns.

That's true!
.....and indeed the setup sheet from LGE_Setup_scenar_1815t I worked over to get The Eagle's Return, was the only processed file giving me NO TROUBLES AT ALL!

It's just an idea:...... perhaps, the setup.CVS files are the only capable to sustain void cells in their architecture without having to suffer corruption while processed to NCP game files! ?

[Pocus]

Sorry I won't be able to fire NCP today, a lot of things to finish before going on my (extended) vacation (will be away up to august 8th!).

[jastaV]

Sorry I won't be able to fire NCP today, a lot of things to finish before going on my (extended) vacation (will be away up to august 8th!).

Okay, I will wait.......

In the meanwhile I checked LGE_DB_Units_LGE035 !
In the attached LGE_DB_Units_LGE035_mod I also added Drouot_4 and Mortier_4. The two "Guard Commit ability" generals I used with The Eagle's Return.

Invite anybody with some experience over the subject to give it a glance, hopefully confirming it works!

Most important:.......enjoy your Vacation!!!!!

[jastaV]

Updated copies of the posted files are available here!

http://www.ageod-forum.com/showthread.php?t=9922

It's recommended to overal check them, although I positively processed them to get NCP working files.