Page 1 of 1

"Value error in Column <LCUType>"

Posted: Fri Sep 17, 2004 6:06 pm
by Hrolfr
Hello,

I used the "WitPLoad" of Michael McFarland to export WITP data in csv format and Microsoft Access to modify datas of the 4.0 version of Lemur's scen 15.

When I import the new csv files I always have this message error : "Value error in Column <LCUType>"".

All my infantry unit (type 7) have a LCUType value of 1 or 2.
All the other ground units have a value of 3 (except HQ).

(I don't modify the allied datas)

When I put the value of Engineer Rgts at 1 the problem persist.
When I put the value of HQs at 1 the problem persist.
When I put the value of all units at 0 the problem persist.

Can you help me ?
What is the best value for each kind of unit ?

Hrolfr

RE: "Value error in Column <LCUType>"

Posted: Sat Sep 18, 2004 1:46 am
by michaelm75au
The value of the LCUtype should be 0,1,2 or 3 (as per manual).
The validation test is throwing up an error because it thinks the value to be stored is larger than 255 (maximum value that can be stored in this type of variable in database).
Have you loaded the CSV into Excel and looked at the values in this column?
It is possible that ACCESS has not exported the column/values properly, esp if it thinks the column is empty.

You can bypass validation by using /f on the command line of witpload.
However if it is trying to import "weird" values, the game may misbehave.

If you are still having problems, you can send me the location CSV to look at.
michaelm75@hotmail.com

Michael

RE: "Value error in Column <LCUType>"

Posted: Sat Sep 18, 2004 5:38 am
by Hrolfr
The problem came from the denomination of 2 units (with "," at the end). When Access convert in CSV files the extra "," move foward data one column left.
Since I convert the extra ","in "." the prolem is resolve.

Thank you for you help ! I didn't think to verify data in EXCEL.

Hrolfr