Cannot import the EDE Award file
Problem: When trying to import the EDE Award file we keep getting an error.
Possible Solution: When an error occurs importing an EDE Awards file there are usually three reasons why this happens.
When the error occurs you will usually see a generic error and it does not actually tell you what the issue is. It will say something like "A data or business logic error has occurred in this application. ..." You should contact your CAMS Manager and have them check the View Error Log to get the specific information needed to resolve this issue.
This error specifies that more than 1 value was returned. What that signifies is that there is a duplicate award entry for the student. Check the file and resolve any duplicate entries and then retry the import process.
The second error will display something like "Cannot bulk load ... Access is denied. ..." This error specifies that the SQL server does not have read rights to the file. It is always recommended that the file be placed either directly on the SQL server in a shared directory or on the IIS server in a shared directory that is in the same domain as the SQL server. Check the file rights and then retry the import process.
The third error will say something like "Cannot convert a char value to money. ..." This error specifies that the file is not configured correctly. There could be extra characters, lines or some other issue. There could also be a change in the setup of CAMS Enterprise which now does not match what is in the file. Check the file or CAMS Enterprise setup for errors and then retry the import process.