validate on import

[DaleH]

We import grades from a teacher gradebook on a weekly basis. I have defined the teacher number to validate to accept numeric values only. This works on data entry, but when data is imported non-numeric values are allowed. Is there away to validate during or after the import. FM4.0. thanks Hoggie

[IdealData]

If the source file is FMP then you can apply the same validation there.

By the way, what would you do with the data if it failed to validate ?

[DaleH]

Unfortunately the source file generated by the gradebook program is tab separated text file. Is there a script or process to run once the files are imported to force it to validate this field. thanks hoggie

[DaleH]

Thanks for helping me find the Is Valid script step. This will work. Hoggie