NovoRoi Systems DokuWiki

User Tools

Site Tools

Trace:
normal_processing_steps

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
normal_processing_steps [2021/02/02 20:40] – [Troubleshooting] dlmnormal_processing_steps [2021/02/09 15: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]].    - 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:   * 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]]
  
normal_processing_steps.1612298437.txt.gz · Last modified: (external edit)