Differences

This shows you the differences between two versions of the page.

--- normal_processing_steps [2021/02/02 15:38] – [Troubleshooting] dlm
+++ normal_processing_steps [2021/02/09 10:37] (current) – dlm
@@ Line 1: / Line 1: @@
-====== 'Normal' Processing Steps ======
+[[main_page|NovoMotion Outbound  Menu]]
+====== Suggested Processing Steps ======
 \\
-====Here is a recommendation of steps to follow when a file is to be added to the NovoMotion Outbound process:====
+====Recommended steps to follow when a file is added to the NovoMotion Outbound process:====
   - Create a new schema using either [[novo_motion_novo_gen.schema|NovoMotion NOVO.GEN.SCHEMA ]] or [[novo_motion_schema_editor|NovoMotion Schema Editor]].
@@ Line 20: / Line 23: @@
 | Connection does not exist   | Verify the correct login and password are entered in the SQL Options tab of the [[novo_motion_schema_editor|NovoMotion Schema Editor]]. If they are, verify the datasource is set up. If it is, verify the login has permission to the database on the SQL server. |
 | Invalid Object Name error    | Verify the database name on the SQL options tab of the [[novo_motion_schema_editor|NovoMotion Schema Editor]] is fully qualified i.e dbo.filename |
+====Suggested Ways to Add a Column to a Schema That Already Exists====
+  * In SQL, execute a new query against the main database:
+<code>ALTER TABLE dbo.TABLENAME
+ADD New_field varchar(20) </code>
+This step can also be done by right-clicking on the SQL table and using Design.
+  * In the [[novo_motion_schema_editor|NovoMotion Schema Editor]], add the new column with the exact same name – (New_field in previous step).
+  * Save the schema and generate the code, Uncheck ‘Generate Primary Table’.
+  * On UNIX copy to clipboard, paste into SQL, verify the first thing is [Use…_TRIGGER], and execute on SQL.
+  * On Windows click the "Execute on SQL Server" button.
+  *Verify there are no records in BCI.QUARANTINE that were created between the alter table and schema editor change steps.
+  *[[load_bci.action|LOAD.BCI.ACTION]] for any records that need the new column.
+\\
+[[main_page|NovoMotion Outbound  Menu]]