Differences

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

--- normal_processing_steps [2021/02/02 15:40] – [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 25: / Line 28: @@
   * In SQL, execute a new query against the main database:
-::ALTER TABLE dbo.TABLENAME
+<code>ALTER TABLE dbo.TABLENAME
-::ADD New_field varchar(20)
+ADD New_field varchar(20) </code>
-:::(this step can also be done by right-clicking on the SQL table and using Design.)<br /><br />
+This step can also be done by right-clicking on the SQL table and using Design.
-:*In the Novoschema editor, add the new column with the exact same name – (New_field in previous step). <br /><br />
-:*Save the schema and generate the code, Uncheck ‘Generate Primary Table’.  <br /><br />
+  * In the [[novo_motion_schema_editor|NovoMotion Schema Editor]], add the new column with the exact same name – (New_field in previous step).
-:*On UNIX copy to clipboard, paste into SQL, verify the first thing is [Use…_TRIGGER], and execute on SQL. <br /><br />
+  * Save the schema and generate the code, Uncheck ‘Generate Primary Table’.
-:*On Windows click the "Execute on SQL Server" button. <br /><br />
+  * On UNIX copy to clipboard, paste into SQL, verify the first thing is [Use…_TRIGGER], and execute on SQL.
-:*Verify there are no records in BCI.QUARANTINE that were created between the alter table and schema editor change steps. <br /><br />
+  * On Windows click the "Execute on SQL Server" button.
-:*LOAD.BCI.ACTION for any records that need the new column. <br /><br />
+  *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]]