magellan & province.csv BUG

[unmerged(10927)]

everytime when i export it using mprovince and editing values in Excel i got this error in importing it back to .eu2map file :

*** Environment Info ***

Date: 2005.04.19 23:09:21
Tool: mprovince, Version=0.99.11.17597, Culture=neutral, PublicKeyToken=null (v0.99.11.17597)
OSVersion: Win32NT - 5.1.2600.0
CurrentDir: C:\MAGELLAN
SystemDir: C:\WINDOWS\system32
CommandLine: C:\MAGELLAN\MPROV.EXE /i w.csv file.eu2map
CLR: 1.1.4322.2032
EU2: (no install)

*** Error Info ***

EU2.Data.ProvinceFormatException: Formatting error in province data (line 50, item 26) ---> System.FormatException: Input string was not in a correct format.
at System.Number.ParseSingle(String s, NumberStyles style, NumberFormatInfo info)
at System.Single.Parse(String s, NumberStyles style, IFormatProvider provider)
at EU2.Data.Province.ReadFromCSV(CSVReader reader, Boolean includeTOTAndHRE)
--- End of inner exception stack trace ---
at EU2.Data.Province.ReadFromCSV(CSVReader reader, Boolean includeTOTAndHRE)
at EU2.Data.ProvinceList.ReadFrom(CSVReader reader)
at MapProvince.Boot.ImportProvince(String source, String target, ExportMode mode)
at MapProvince.Boot.Main(String[] args)


Any ideas what to do?

P.S.
when i edit .csv in notepad it imports back fine also Eu2 itself reads province.csv edited in Excel without errors.....

 

[Inferis]

EU2.Data.ProvinceFormatException: Formatting error in province data (line 50, item 26) ---> System.FormatException: Input string was not in a correct format.
at System.Number.ParseSingle(String s, NumberStyles style, NumberFormatInfo info)

There's an error at line 50, item 26. The lib expects a floating point number, but there's something else and it can't convert that value into a number.

That should be the City XPos for Talahassee, in my file...

 

[unmerged(10927)]

it is only example! it happens often in different strokes... maybe there is a secret how to save it in Excel properly.....

 

[Inferis]

Send me the file (eu2map or province.csv) and I'll look at it.

 

[unmerged(10927)]

Send me the file (eu2map or province.csv) and I'll look at it.

posted private message!

 

[Inferis]

I know. It's just that I've had little time to look at it.

 

[unmerged(10927)]

oki thanks

 

[unmerged(10927)]

any news?

 

[unmerged(10927)]

Excel is still buggy but i foun free CSVed which edits csv perfectly!!! and it is better than notepad