StylesC: Created page with " {{#vardefine:System|CTMS}} {{ERHeader |SystemVersion=CTMS 11.0 |ERNumber=ER020-024 }} {{ERTableHeader}} {{ERTableRow |DATA_4_SCH_SOURCE_SYSTEM_3338..."

2016-06-21T11:59:18Z

Created page with " {{#vardefine:System|CTMS}} {{ERHeader |SystemVersion=CTMS 11.0 |ERNumber=ER020-024 }} {{ERTableHeader}} {{ERTableRow |DATA_4_SCH_SOURCE_SYSTEM_3338..."

New page

{{#vardefine:System|CTMS}}
{{ERHeader
|SystemVersion=CTMS 11.0
|ERNumber=ER020-024
}}

{{ERTableHeader}}
{{ERTableRow
|DATA_4_SCH_SOURCE_SYSTEM_333896.sql
|Data Script
|1.1
|333896
|-
|3
|New package DP_INT_XML_MIC2 to handle XML files to and from Microlise.

Database triggers have been amended so that if MIC_SEND_DIRECT registry value set to Yes, outbound microlise files are processed and sent directly to Microlise, using their file format, rather than the standard OBS format.
|Sue Blake
}}
{{ERTableRow
|DATA_3_ADM_LOG_PROG_NAME_333896.sql
|Data Script
|1.1
|"
|"
|"
|"
|"
}}
{{ERTableRow
|DATA_2_ADM_SYSTEM_PARAM_CONFIG_33896.sql
|Data Script
|1.1
|"
|"
|"
|"
|"
}}
{{ERTableRow
|DATA_1_ADM_SYSTEM_PARAM_333896.sql
|Data Script
|1.2
|"
|"
|"
|"
|"
}}
{{ERTableRow
|CT_SEQ_MICD_OUTBOUND_333896.sql
|Create Table Script
|1.1
|"
|"
|"
|"
|"
}}
{{ERTableRow
|DP_INT_XML_MIC2.sql
|
|1.2
|"
|"
|"
|"
|"
}}
{{ERTableRow
|TRG_SCH_TRIP_XML_INT.sql
|Trigger
|5.29
|"
|"
|"
|"
|"
}}
{{ERTableRow
|TRG_SHA_XML.sql
|Trigger
|5.24
|"
|"
|"
|"
|"
}}
{{ERTableRow
|TRG_SOI_XML.sql
|Trigger
|5.17
|"
|"
|"
|"
|"
}}
{{ERTableRow
|TRG_SOL_XML.sql
|Trigger
|5.38
|"
|"
|"
|"
|"
}}
{{ERTableRow
|TRG_STS_XML.sql
|Trigger
|5.20
|"
|"
|"
|"
|"
}}
{{ERTableRow
|PLANNING.fmx
|Planning Form
|1.26
|"
|"
|"
|"
|"
}}

{{ERTableFooter}}

<table border="1px" width="100%">
<tr>
<td colspan="4" bgcolor="silver">'''New Parameters'''</td>
</tr>
<tr>
<td bgcolor="silver">'''Parameter Name'''</td>
<td bgcolor="silver">'''Config Level'''</td>
<td bgcolor="silver">'''Setting Value'''</td>
<td bgcolor="silver">'''Result'''</td>
</tr>

<tr>
<td>MIC_SEND_DIRECT</td>
<td>NSS</td>
<td>Y</td>
<td>Flag to indicate that Direct communication to Microlise required.</td>
</tr>

<tr>
<td>MIC_DIRECT_PATH_OUT</td>
<td>NSS</td>
<td>/webint/nssttst/interface/MICD/OUT</td>
<td>Outbound FTP directory</td>
</tr>

<tr>
<td>MIC_DIRECT_PATH_OUT_ARCH</td>
<td></td>
<td>/webint/nssttst/interface/MICD/OUT/archive</td>
<td>Outbound FTP archive directory</td>
</tr>

<tr>
<td>MIC_DIRECT_PATH_IN</td>
<td></td>
<td>/webint/nssttst/interface/MICD/IN</td>
<td>Inbound files ‘source’ directory</td>
</tr>

<tr>
<td>MIC_DIRECT_PATH_IN_FAIL</td>
<td></td>
<td>/webint/nssttst/interface/MICD/IN/failures</td>
<td>Inbound ‘archive’ directory</td>
</tr>

<tr>
<td>MIC_DIRECT_PATH_IN_ARCH</td>
<td></td>
<td>/webint/nssttst/interface/MICD/IN/archive</td>
<td>Inbound ‘failure’ directory</td>
</tr>

<tr>
<td>MIC_DIRECT_PATH_IN_LIST</td>
<td></td>
<td>MICD_TRIP_FILES.lst</td>
<td></td>
</tr>

<tr>
<td>MIC_DIRECT_PATH_IN_SCRIPT</td>
<td></td>
<td>MICD_TRIP_SCRIPT.ksh</td>
<td></td>
</tr>

<tr>
<td>MIC_DIRECT_DEF_COST</td>
<td></td>
<td>NSS</td>
<td></td>
</tr>

<tr>
<td>MIC_DIRECT_PATH_IN_IDENT</td>
<td></td>
<td>PODPOC*</td>
<td>Expected file name for ‘PODPOC’ files</td>
</tr>

<tr>
<td>MICD_EE_PATH_IN_IDENT</td>
<td></td>
<td>EventExport*</td>
<td>Expected file name for ‘Event’ files</td>
</tr>

<tr>
<td>MICD_JSE_PATH_IN_IDENT</td>
<td></td>
<td>JourneySummaryExport*</td>
<td>Expected file name for ‘Journey Summary’ files</td>
</tr>

<tr>
<td>MIC_DIRECT_FTP_DEST_DIRECTORY</td>
<td></td>
<td>tbc</td>
<td>Outbound destination ftp directory (ctms to Microlise)</td>
</tr>

<tr>
<td>MIC_DIRECT_FTP_DEST_IP_ADDRESS</td>
<td></td>
<td>TBC</td>
<td>Outbound IP address (ctms to Microlise)</td>
</tr>

<tr>
<td>MIC_DIRECT_FTP_DEST_PASSWORD</td>
<td></td>
<td>TBC</td>
<td>Outbound IP login password (ctms to Microlise)</td>
</tr>

<tr>
<td>MIC_DIRECT_FTP_DEST_PORT</td>
<td></td>
<td>TBC</td>
<td>Outbound port (ctms to Microlise)</td>
</tr>

<tr>
<td>MIC_DIRECT_FTP_DEST_USERNAME</td>
<td></td>
<td>TBC</td>
<td>Outbound IP login username (ctms to Microlise)</td>
</tr>
</table>

<noinclude>
[[Category:{{#var:System}} ER]]
</noinclude>

CTMS 11.0 ER020-024 - Revision history

StylesC: Created page with " {{#vardefine:System|CTMS}} {{ERHeader |SystemVersion=CTMS 11.0 |ERNumber=ER020-024 }} {{ERTableHeader}} {{ERTableRow |DATA_4_SCH_SOURCE_SYSTEM_3338..."