I have a csv list that I want to import, it has four column with the following titles:

FirstName,LastName,Age,YrsMarried

Then I have 700+ fields.

When I import the csv file, the Column Fields are automatically assigned the titles from the csv file and  then the 700+ fields are imported correctly into each column heading.

However, the FmL sets each column type as "Text" and in order to sort the Age and YrsMarried field I need to change that to Integer.

But once I change a the Age field to type Integer I get an error saying:

"You have changed the column type for Age from "Text" to "Integer". Note that this might cause an error, this is an unsupported cast!"

And then nothing shows on the public side.

What am I doing wrong ?

Sorry, forgot to include those details:

DotNetNuke Ver. 05.02.02 (73)

Form and List Ver. 5.1.2

I reinstalled FmL to ver.05.01.01 and the issue still occurs. It just wont let me change the Type to Integer.

I even tried deleting everthing and starting from scratch.

I entered the Field names and their appropiate types, then I imported the data from a new csv field which did not contain the labels, all the data was imported but this time it changed all the field types back to TEXT...aggghhhh