on 12-17-2013 10:35 AM
Hi,
I am using the standard APPEND package to load fx rates into my rates model. The package has two prompts, one for the default logic and one for the work status, which I always answer in the same way. Would I be correct in assuming that I could disable these by making a few changes in the package?
(INFILES,,"Import file:",)
(TRANSFORMATION,%TRANSFORMATION%,"Transformation file:",,,Import.xls)
(RADIOBUTTON,%RUNLOGIC%,"Select whether to run default logic for stored values after importing",1,{"Yes","No"},{"1","0"})
(RADIOBUTTON,%CHECKLCK%,"Select whether to check work status settings when importing data.",1,{"Yes, check for work status settings before importing","No, do not check work status settings"},{"1","0"})
(KEYDATE,%KEYDATE%,"Key date",0)
(%TEMPNO1%,%INCREASENO%)
(%ACTNO%,%INCREASENO%)
(/CPMB/CONVERT,OUTPUTNO,%TEMPNO1%)
(/CPMB/CONVERT,ACT_FILE_NO,%ACTNO%)
(/CPMB/CONVERT,TRANSFORMATIONFILEPATH,%TRANSFORMATION%)
(/CPMB/CONVERT,SUSER,%USER%)
(/CPMB/CONVERT,SAPPSET,%APPSET%)
(/CPMB/CONVERT,SAPP,%APP%)
(/CPMB/CONVERT,FILE,%FILE%)
(/CPMB/CONVERT,KEYDATE,%KEYDATE%)
(/CPMB/APPEND_LOAD,INPUTNO,%TEMPNO1%)
(/CPMB/APPEND_LOAD,ACT_FILE_NO,%ACTNO%)
(/CPMB/APPEND_LOAD,RUNLOGIC,%RUNLOGIC%)
(/CPMB/APPEND_LOAD,CHECKLCK,%CHECKLCK%)
(/CPMB/APPEND_LOAD,PREPROCESSMODE,0)
(/CPMB/APPEND_LOAD,TARGETMODE,0)
(/CPMB/APPEND_LOAD,KEYDATE,%KEYDATE%)
If I were to disable (delete?) the two lines with the RADIOBUTTON and change these two lines
(/CPMB/APPEND_LOAD,RUNLOGIC,%RUNLOGIC%)
(/CPMB/APPEND_LOAD,CHECKLCK,%CHECKLCK%)
to read
(/CPMB/APPEND_LOAD,RUNLOGIC,1)
(/CPMB/APPEND_LOAD,CHECKLCK,1)
would that always run the default logic and check the work status without asking me for it?
On top, is there a way to not ask the user for the transformation file but instead hardcode this
\ROOT\WEBFOLDERS\ENVIRONMENT\Rate\DATAMANAGER\TRANSFORMATIONFILES\CLIENT\RATES_TRANSFORMATION.xls
file into the package?
Thanks,
Arnold
Hi Arnold,
Yes, you can hardcode values in DM advanced script the way you propose. Just test. You can also use INFO to set some %% variables and use variables later in the code.
B.R. Vadim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
4 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.