=======================================================================
=======================================================================
One MFT task that checks Dynasys folder every 10 min from 6.30 pm CET to midnight.
If the file SAFIRZD30.csv exists, then :
1/ MFT catch this file and sends it to BI4
2/ MFT moves this file in the Dynasys archive folder (mandatory action, otherwise MFT will send the same file every 10 min) and renames it by adding a timestamp
| Type | Name | DNS | IP address |
| DEV | WDCWMAD02 | WDCWMAD02.eua.solvay.com | 150.251.113.105 |
| PRE-PROD | WDCWMAV11 | WDCWMAV11.eua.solvay.com | 150.251.113.119 |
| PRE-PROD | WDCWMAV12 | WDCWMAV12.eua.solvay.com | 150.251.113.120 |
| PROD | WDCWMAP11 | WDCWMAP11.eua.solvay.com | 150.251.113.131 |
| PROD | WDCWMAP12 | WDCWMAP12.eua.solvay.com | 150.251.113.132 |
One archive folder exists on Dynasys servers :
| Environment | Server | Directory |
| DEV | WDCDYAD21 | \\wdcdyad21.eua.solvay.com\DynaSys\DEV\ITF\Files\Out\Archives |
| TEST | WDCDYAD21 | \\wdcdyad21.eua.solvay.com\DynaSys\TEST\ITF\Files\Out\Archives |
| PROD | WDCDYAP21 | \\wdcdyap21.eua.solvay.com\DynaSys\ITF\Files\Out\Archives |
Dynasys file loading moved from FTP to MFT
Developper :
Laura Labbadi
Exploitation :
LAURE PICHOT-PLASSE <laure.pichot-plasse@solvay.com>,
"Min(mark) Yu" <min.yu@solvay.com>,
Lei Shen <lei.shen@solvay.com>,
Pablo Prieri <pablo.prieri@solvay.com>,
Olivier Descamps <olivier.descamps@solvay.com>,
Etienne Ribet-ext <etienne.ribet-ext@solvay.com>,
Maggie MA <maggie.ma@solvay.com>
Frequency of export of file SAFIRZD30.CSV from DynaSys : generate the file two times per day:
Contain Forecasts from the current month.
Remark :
The loader loads the SOLD_TO_CUSTOMER on 11 digits in the TMP_GL_FORECAST_APO because of an hidden character at the end of the Dynasys file.
With the SQL from TMP to REC and PROD, we get the substring of 10 first digits of the Sold-To code. So in REC and PROD, the customer code is well back on 10 digits.
==> 