CTMS 11.0 ER020-024

From Calidus HUB


Aptean Logo.png


EMERGENCY RELEASE - CTMS 11.0


RELNOTE ER020-024


Module Program Name Ver Call/Iss Client Ref Pr'ty Remarks Reporter
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
DATA_3_ADM_LOG_PROG_NAME_333896.sql Data Script 1.1 " " " " "
DATA_2_ADM_SYSTEM_PARAM_CONFIG_33896.sql Data Script 1.1 " " " " "
DATA_1_ADM_SYSTEM_PARAM_333896.sql Data Script 1.2 " " " " "
CT_SEQ_MICD_OUTBOUND_333896.sql Create Table Script 1.1 " " " " "
DP_INT_XML_MIC2.sql 1.2 " " " " "
TRG_SCH_TRIP_XML_INT.sql Trigger 5.29 " " " " "
TRG_SHA_XML.sql Trigger 5.24 " " " " "
TRG_SOI_XML.sql Trigger 5.17 " " " " "
TRG_SOL_XML.sql Trigger 5.38 " " " " "
TRG_STS_XML.sql Trigger 5.20 " " " " "
PLANNING.fmx Planning Form 1.26 " " " " "


New Parameters
Parameter Name Config Level Setting Value Result
MIC_SEND_DIRECT NSS Y Flag to indicate that Direct communication to Microlise required.
MIC_DIRECT_PATH_OUT NSS /webint/nssttst/interface/MICD/OUT Outbound FTP directory
MIC_DIRECT_PATH_OUT_ARCH /webint/nssttst/interface/MICD/OUT/archive Outbound FTP archive directory
MIC_DIRECT_PATH_IN /webint/nssttst/interface/MICD/IN Inbound files ‘source’ directory
MIC_DIRECT_PATH_IN_FAIL /webint/nssttst/interface/MICD/IN/failures Inbound ‘archive’ directory
MIC_DIRECT_PATH_IN_ARCH /webint/nssttst/interface/MICD/IN/archive Inbound ‘failure’ directory
MIC_DIRECT_PATH_IN_LIST MICD_TRIP_FILES.lst
MIC_DIRECT_PATH_IN_SCRIPT MICD_TRIP_SCRIPT.ksh
MIC_DIRECT_DEF_COST NSS
MIC_DIRECT_PATH_IN_IDENT PODPOC* Expected file name for ‘PODPOC’ files
MICD_EE_PATH_IN_IDENT EventExport* Expected file name for ‘Event’ files
MICD_JSE_PATH_IN_IDENT JourneySummaryExport* Expected file name for ‘Journey Summary’ files
MIC_DIRECT_FTP_DEST_DIRECTORY tbc Outbound destination ftp directory (ctms to Microlise)
MIC_DIRECT_FTP_DEST_IP_ADDRESS TBC Outbound IP address (ctms to Microlise)
MIC_DIRECT_FTP_DEST_PASSWORD TBC Outbound IP login password (ctms to Microlise)
MIC_DIRECT_FTP_DEST_PORT TBC Outbound port (ctms to Microlise)
MIC_DIRECT_FTP_DEST_USERNAME TBC Outbound IP login username (ctms to Microlise)