openlab / OGDI-DataLab

Open Government Data Initiative
http://ogdi.codeplex.com
Microsoft Public License
57 stars 17 forks source link

DataLoader - validate table name #16

Closed nikg closed 12 years ago

nikg commented 12 years ago

Data Loader: Before throwing an error "XYZ is not a valid Table Name" after you click "Start", validate that the table name is named correctly:

Table names may contain only alphanumeric characters. Table names cannot begin with a numeric character. Table names are case-insensitive. Table names must be from 3 to 63 characters long.

These rules are also described by the regular expression "^[A-Za-z][A-Za-z0-9]{2,62}$". Table names preserve the case with which they were created, but are case-insensitive when used.