Figure 3.23 File Download dialogue box – Figure 3.24 The Import Message. – Common reasons for import errors are: The file is not in comma delimited (CSV) format, There are fields missing, There are fields in the wrong order, Field lengths are wrong, Data formats of fields are wrong, Columns have their headings. Two other possible reasons for the import to fail are detailed in Table 4: PROBLEM SOLUTION Unable to save to database The problem is that the field stdnt_extrnl_xid does If the import with the message of: not match the stdnt_xid field in the database and is causing errors. This can be fixed fairly quickly but Import failed: Unable to save to will require someone with administration access to database ['You have entered a record the On Demand server, e.g., a school technician. that already exists or has been used.' Followed by a series of failures with Log into the On Demand server. Open “Query message: Analyser” and connect to (local) using Windows Import failed: Unable to save to Authentication [On Demand VM, Start -> All database ['Method '~' of object '~' failed' Programs -> Microsoft SQL Server 2012 ->SQL (-2147220991)] Server Management Studio] (see Figure 1) Figure 1 Open SQL Server Management Studio. – Figure 2 Connect to SQL Server. – Click ‘Connect’ Figure 3 Open a Query” – ‘New the following SQL command in the Query window EXACTLY as it appears below. USE AIM UPDATE student
Figure 3.23 – File Download dialogue box Figure 3.24 – The Import Message. Common reasons for import errors are: The file is not in comma delimited (CSV) format, There are fields missing, There are fields in the wrong order, Field lengths are wrong, Data formats of fields are wrong, Columns have their headings. Two other possible reasons for the import to fail are detailed in Table 4: PROBLEM SOLUTION Unable to save to database If the import with the message of: Import failed: Unable to save to database ['You have entered a record that already exists or has been used.' Followed by a series of failures with message: Import failed: Unable to save to database ['Method '~' of object '~' failed' (-2147220991)] The problem is that the field stdnt_extrnl_xid does not match the stdnt_xid field in the database and is causing errors. This can be fixed fairly quickly but will require someone with administration access to the On Demand server, e.g., a school technician. Log into the On Demand server. Open “Query Analyser” and connect to (local) using Windows Authentication [On Demand VM, Start -> All Programs -> Microsoft SQL Server 2012 ->SQL Server Management Studio] (see Figure 1) Figure 1 – Open SQL Server Management Studio. Figure 2 – Connect to SQL Server. Click ‘Connect’ Figure 3 – Open a ‘New Query” the following SQL command in the Query window EXACTLY as it appears below. USE AIM UPDATE student
ondteachertrainingguide.docx